Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year Cash flow 0 $(650,000,000) 1 $80,000,000 2 $121,000,000 3 $162,000,000 4 $221,000,000 5 $210,000,000 6 $154,000,000 7 $108,000,000 8 $86,000,000 9 $(72,000,000) Required return
Year | Cash flow | |
0 | $(650,000,000) | |
1 | $80,000,000 | |
2 | $121,000,000 | |
3 | $162,000,000 | |
4 | $221,000,000 | |
5 | $210,000,000 | |
6 | $154,000,000 | |
7 | $108,000,000 | |
8 | $86,000,000 | |
9 | $(72,000,000) | |
Required return | 12% |
Payback period | 4.31 | |||
IRR | 13.25% | =IRR(D8:D17) | ||
NPV | $28,451,509.51 | =NPV(D19,D9:D17)+D8 | ||
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