Question
EOY Cash Inflows Cash outflows 0 0 2,000,000 1 800,000 350,000 2 816,000 352,500 3 832,320 355,000 4 848,966 357,500 5 865,946 -1,140,000 MARR =
EOY | Cash Inflows | Cash outflows |
0 | 0 | 2,000,000 |
1 | 800,000 | 350,000 |
2 | 816,000 | 352,500 |
3 | 832,320 | 355,000 |
4 | 848,966 | 357,500 |
5 | 865,946 | -1,140,000 |
MARR = 10%
Useful Life = 5 years
Initial Cost = 2,000,000 (Included in Excel)
End of Life Salvage Value = 1,500,000 (Included in Excel)
1. Calculate the Net Future Worth NFW(At EOY5):
2. Calculate the Net Present Worth NPW (At EOY0):
3. Calculate the Annual Equivalent Worth (AEW):
4. Based on the simple payback method, the recovery period (in years) of this project is:
5. Based on the simple payback method, "project balance" after five years is:
6. Based on the discounted payback method, this project's recovery period (in years) is:
7. Based on the discounted payback method, this project's project balance at EOY3 is:
6. What is the benefit/cost (B/C) is:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started