Question

Consider a project that has a 10% cost of capital that requires an initial investment of $10,000. The year 1 net cash inflow is $2,450; the year 2 net cash inflow is $2,850; the year 3 net cash inflow is $3,350; the year 4 net cash inflow is $3,750; and the year 5 net cash inflow is $5,250. What is the project's discounted payback? NPV? AND IRR?

Answer 1

a.	Discounted payback		4.10 years
b.	NPV		$     2,920.69
c.	IRR		19.51%
Working:
Calculation of Discounted payback period and Net present value.
Year	Cash flows	Discount factor	Present value of cash flows	Cumulative Present value of cash flows
a	b	c=1.10^-a	d=b*c	e
0	$       -10,000	1.0000	$ -10,000.00	$ -10,000.00
1	2,450	0.9091	2,227.27	-7,772.73
2	2,850	0.8264	2,355.37	-5,417.36
3	3,350	0.7513	2,516.90	-2,900.45
4	3,750	0.6830	2,561.30	-339.15
5	5,250	0.6209	3,259.84	2,920.69
Discounted payback	=	4+(339.15/3259.84)
	=	4.10
Calculation of IRR:
IRR is the rate at which Net Present value is zero.
Year	Cash flows
0	$       -10,000
1	2,450
2	2,850
3	3,350
4	3,750
5	5,250
IRR	=irr(B15:B20)
	19.51%