Part A

Given the following conventional cash flows, find the undiscounted payback, discount payback, net present value, IRR, MIRR, profitability index in Excel. Then, plot the NPV profile using the appropriate graphing function in Excel. If necessary, discount rate is 7.5%, reinvestment rate is 5%.

Years, t	0		1-9	10
Cash flows, $	-1,000		150	1,150

Answers:

Method	Numerical answers (2 decimal places)	Syntax in Excel
Undiscounted payback, in years
Discounted payback, in years
NPV, in $
IRR
MIRR
Profitability index (practitioners)

Submit the above table together with the graph. Domain (x-axis) of the graph to run from 0% through 20% in 1% interval. Put both items (table and graph) in one page.