Question

Consider the following two mutually exclusive projects:

  

Year	Cash Flow (A)	Cash Flow (B)
0	–$199,954	–$15,324
1	27,800	5,058
2	55,000	8,105
3	56,000	13,036
4	404,000	8,859

  

Whichever project you choose, if any, you require a 6 percent return on your investment.

Required:

(a)	What is the payback period for Project A?
	(Click to select)  2.99 years  3.25 years  3.15 years  3.06 years  3.31 years

   

(b)	What is the payback period for Project B?
	(Click to select)  2.23 years  2.27 years  2.1 years  2.17 years  2.06 years

(c)	What is the discounted payback period for Project A?
	(Click to select)  3.41 years  3.34 years  3.24 years  3.08 years  3.15 years

(d)	What is the discounted payback period for Project B?
	(Click to select)  2.37 years  2.42 years  2.24 years  2.31 years  2.19 years

(e)	What is the NPV for Project A?
	(Click to select)  $254,359.08  $242,246.74  $230,134.4  $234,979.34  $249,514.14

(f)	What is the NPV for Project B ?
	(Click to select)  $13,892.38  $15,354.73  $14,184.85  $14,623.55  $15,062.26

  

(g)	What is the IRR for Project A?
	(Click to select)  35.02%  35.7%  32.98%  32.3%  34%

(h)	What is the IRR for Project B?
	(Click to select)  38%  39.14%  36.1%  39.9%  36.86%

(i)	What is the profitability index for Project A?
	(Click to select)  2.322  2.212  2.278  2.101  2.145

(j)	What is the profitability index for Project B?
	(Click to select)  2.013  2.052  1.857  1.896  1.954

Answer 1

(a)		3.15 Years
(b)		2.17 Years
(c)		3.24 Years
(d)		2.31 Years
(e)		$    2,42,246.74
(f)		$       14,623.55
(g)		34%
(h)		38%
(i)		2.212
(j)		1.954
Working:		Project A			Project B
Year	Discount factor	Cash flow	Cumulative Cash flow	Present value of cash flow	Cumulative Present value of cash flow	Cash flow	Cumulative Cash flow	Present value of cash flow	Cumulative Present value of cash flow
a	b=1.06^-a	c	x	d=b*c	e	f	y	g=b*f	h
0	1.0000	$ -1,99,954.00	$   -1,99,954.00	$     -1,99,954.00	$ -1,99,954.00	$ -15,324.00	$        -15,324.00	$ -15,324.00	$ -15,324.00
1	0.9434	27,800.00	-1,72,154.00	$          26,226.42	-1,73,727.58	5,058.00	-10,266.00	4,771.70	-10,552.30
2	0.8900	55,000.00	-1,17,154.00	$          48,949.80	-1,24,777.78	8,105.00	-2,161.00	7,213.42	-3,338.88
3	0.8396	56,000.00	-61,154.00	$          47,018.68	-77,759.10	13,036.00	10,875.00	10,945.28	7,606.40
4	0.7921	4,04,000.00	3,42,846.00	$       3,20,005.84	2,42,246.74	8,859.00	19,734.00	7,017.16	14,623.55
IRR		=irr(C4:C8)				=irr(G4:G8)
		34.00%				38.00%
Payback of :
Project A	=	3+(61154/404000)	=	3.15
Project B	=	2+(2161/13036)	=	2.17
Discounted payback of:
Project A	=	3+(77759.10/320005.84)	=	3.24
Project B	=	2+(3338.88/10945.28)	=	2.31
Profitability index of:
Project A	=	Present value of cash inflow /Cost of project
	=	(199954+242246.74)/199954
	=	2.212
Project B	=	Present value of cash inflow /Cost of project
	=	(15324+14623.55)/15324
	=	1.954