You are the financial analyst for the Glad Its Finally Over Company. The director of capital budgeting has asked you to analyze a proposed capital investment. The project has a cost of $35,000 and the cost of capital is 7.5%. The projects expected net cash flows are as follows:

Year Expected Net Cashflow

0 -35,000

1 14,500

2 11,000

3 11,000

4 5,000

Questions:

1. If the cash inflows are received throughout the year, the payback period given this scenario is _____ years? (round two decimals)

2. If the cash inflows are received throughout the year, the projects discounted payback period is ___ years? (round two decimals)

3. The projects Net Present Value is $_______,? (rounded to 2 decimal places)

4. The projects Internal Rate of Return is ______%, ?(rounded to 2 decimal places)

5. The projects Modified Internal Rate of Return is ______%, ? (rounded to 2 decimal places).

(Please show work in excel if possible)