| Problem 1 |
| | A | | B | | C | | D |
| | | | Future | | Future |
| | Present | | Value | | Value | | Future |
| | Value | | Factor | | Factor | | Value |
| a) |
| b) |
| c) |
| d) |
| Problem 2 | A | | B | | C | | D |
| | | | Present | | Present |
| | Future | | Value | | Value | | Present |
| | Value | | Factor | | Factor | | Value |
| a) |
| b) |
| c) |
| d) |
| Problem 3 |
| IRR |
| | Year | Cash Flow | Cummulative Cash Flow |
| | Year 0 |
| | Year 1 |
| | Year 2 |
| | Year 3 |
| | Year 4 |
| | Year 5 |
| IRR= | % |
| Problem 4 |
| | Excel |
| | less the investment |
| | NPV |
| Accept or do not accept the project |
| Problem 5 |
| What is the payback period for problem 3? |
| Payback period = Year before recovery + Year before cummulative cash flow/cash flow for year paid off |
| Payback period (show calculation) = |
| Payback period (show answer)= |
firstnurse
USW1_MMHA_6400_Week10_capitalBudgetTemplate1.xlsx
