You will compare three projects. The following table lists each projects initial outlay (price of the project) in year 0 (zero). The following years are the cash inflows. All projects receive the same total cash inflows. They differ on when the cash flows occur and the amount of the annual cash flow You will show your work in a Word document or Excel spreadsheet. You must submit your backup in Excel or other supporting documentation showing how answers were reached. Use the formula and the financial calculator or Excel to determine:

Given three projects with the following cash flows:

Project A Project B Project C
Year Cash Flow Cash Flow Cash Flow
0 -1000 -1000 -1000
1 200 500 350
2 300 400 350
3 400 300 350
4 500 200 350

1. Find the NPV, IRR and MIRR of each the projects with a cost of capital of 5%, 10%, and 12%.

3. Determine the acceptance of the projects if you have a capital budget of $3000, $2000. and $1000.

4. Compare the timing of the cash flows of each project relative to its NPV.

5. Compare how the timing and size of the cash flows change the net present value.

Solution Summary

This solution determines the NPV, IRR and MIRR for each project for the varying cost of capital rates. Similarly, payback period and project acceptance are calculated and discussed. The projects are compared whereby the earlier the cash inflows occur, the more time value of money those cash inflows have, thus creating a higher net present value. This solution is detailed in the attached Excel file.

... Solution describes the steps in calculating NPV of ... We will calculate Present Value of Each Cash flow for ... the help of above formula Net present Value is sum of ...

Please calculate the net present value (NPV) for the coffee ... The solution assists with calculating the net present value... PV factor at 5% has been calculated as 1 ...

...Calculate the Internal Rate of Return of each of the following potential investments and ... The expert calculates the net present value, internal rate of ...

...Calculating for IRR is a trial and error procedure ... You calculate correctly ... NPV is calculated by finding the present value of each cash flow, including both cash ...

... Alternatively, we can use Excel function IRR to calculate IRR. ... a capital budgeting problem and calculates Net present value, payback, IRR, and accounting ...

... cost of funds is 8%, determine Net Present Value (NPV) of ... we can use PVIFA factor to calculate NPV PVIFA ... It can be read from tables or calculated using the ...

... It can be read from tables or calculated using the ... b. Calculate the internal rate of return of the investment ... For calculating IRR we will find NPV at two rates ...

...Calculate the following methods for this case a. Simple ... is 2 years or less b. Net present value (NPV): approval ... The solution is presented in a Word document. ...

... (When calculating DCF on a ... Payback cannot be calculated if the positive cash inflows do not eventually ... FINAL COMMENTS Calculate and compare across companies. ...