Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show excel formula A cash flow diagram for a project at BillCo is shown below. Years Initial Cost Salvage Op Costs Benefits Net Cash
please show excel formula
A cash flow diagram for a project at BillCo is shown below. | |||||||
Years | Initial Cost | Salvage | Op Costs | Benefits | Net Cash Flow | ||
0 | $ (311,386.00) | $ (311,386.00) | |||||
1 | $ (54,000.00) | $ 91,000.00 | $ 37,000.00 | ||||
2 | $ (55,566.00) | $ 94,913.00 | $ 39,347.00 | ||||
3 | $ (57,177.41) | $ 98,994.26 | $ 41,816.85 | ||||
4 | $ (58,835.56) | $ 103,251.01 | $ 44,415.45 | ||||
5 | $ (60,541.79) | $ 107,690.81 | $ 47,149.02 | ||||
6 | $ (62,297.50) | $ 112,321.51 | $ 50,024.01 | ||||
7 | $ (64,104.13) | $ 117,151.34 | $ 53,047.21 | ||||
8 | $ 32,420.00 | $ (65,963.15) | $ 122,188.84 | $ 88,645.69 | |||
Use a MARR of 15% | |||||||
3a. Determine the NPW | |||||||
3b. Determine the AW | |||||||
3c. Determine the FW | |||||||
3d. Deterine the IRR | |||||||
3f. Graph the NPW versus MARR | |||||||
3G. Are we making or losing money at 15% MARR? |
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