Question

Date	Cash Flow
July 13,2008	-1100
Jan 26, 2009	200
March 9, 2010	200
June 25, 2011	700
Sept 18, 2012	800
March 29,2013	200
June 10, 2014	500
July 15, 2015	900
Sept 29,2016	200
Sept 30,2017	-2800

1. Use Solver on EXCEL to determine the Internal Rate of Return(s) associated with this investment.

Show all formulas and on solver please identify the

i. Set Objective (Cell)

ii. To Value

iii. By Changing Variables Cell

iv. Subject to (if used)

Answer 1

Date	Cash Flow	Years
13-Jul-08	-1100	0	-1100	IRR
26-Jan-09	200	0.539726	-903.49278	0.033182
9-Mar-10	200	1.654795	-714.00963
25-Jun-11	700	2.950685	-78.287555
18-Sep-12	800	4.186301	619.53077
29-Mar-13	200	4.712329	791.01536
10-Jun-14	500	5.912329	1203.2582
15-Jul-15	900	7.008219	1919.2197
29-Sep-16	200	8.219178	2072.1557
30-Sep-17	-2800	9.221918	0

IRR = 3.32%

Excel file link: https://1drv.ms/x/s!AkW5WQDSTr7DhnO6mP5y6ezmLT71