Question: Please fill in the blanks. Net Present Value Calculation Year 0 Year 1 Year 2 Year 3 NCO -100000 Annual Cash 20000 25000 30000 Residual
Please fill in the blanks.
| Net Present Value Calculation | ||||
| Year 0 | Year 1 | Year 2 | Year 3 | |
| NCO | -100000 | |||
| Annual Cash | 20000 | 25000 | 30000 | |
| Residual Cash | 70000 | |||
| Required Rtn Cash Flow | 12% | 12% | 12% | |
| Req Rtn, Residual | 15% | |||
| PV Mid-year Factors | 0.57 | 1.62 | 2.68 | |
| Present Values | _____ | _____ | _____ | _____ |
| PV Residual | _____ | |||
| NPV | _____ | |||
| Formula: FV/(1+$TV)^N = PV | ||||
| Internal Rate of Return Calculation | ||||
| Year 0 | Year 1 | Year 2 | Year 3 | |
| NCO | _____ | |||
| Annual Cash | _____ | _____ | _____ | |
| Residual Cash | _____ | |||
| Discount Factor to Zero NPV | ||||
| Trial/Error, Try: | ___% | |||
| PV Mid-year Factors | 0.57 | 1.62 | 2.68 | |
| Annual Cash | _____ | _____ | _____ | _____ |
| Residual Cash | _____ | |||
| NPV | _____ | |||
| IRR | ____% | |||
| Formula: FV/(1+$TV)^N = PV | ||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
