Answered step by step
Verified Expert Solution
Question
1 Approved Answer
calculate IRR with excel and check NPV. RD-6 Satellite Satellite Life Rate of Return (%) Net CashFlow Total Capital Investment 15.00 0.10 80000000.00 -450000000.00
calculate IRR with excel and check NPV.
| RD-6 Satellite | |||||
| Satellite Life | Rate of Return (%) | Net CashFlow | Total Capital Investment | ||
| 15.00 | 0.10 | 80000000.00 | -450000000.00 | ||
| NPV | IRR | ||||
| 0 | -370000000.00 | *=RATE(.1,-450000000,80000000,0) | |||
| 1 | -377140255.01 | ||||
| 2 | -383643219.50 | ||||
| 3 | -389565773.68 | ||||
| 4 | -394959721.02 | ||||
| 5 | -399872241.36 | ||||
| 6 | -404346303.61 | ||||
| 7 | -408421041.54 | ||||
| 8 | -412132096.12 | ||||
| 9 | -415511927.25 | ||||
| 10 | -418590097.68 | ||||
| 11 | -421393531.58 | ||||
| 12 | -423946750.07 | ||||
| 13 | -426272085.68 | ||||
| 14 | -428389877.67 | ||||
| 15 | -430318649.97 | ||||
| Total NPV | -$ 6,504,503,571.74 |
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
Fundamentals of Financial Management
Authors: Eugene F. Brigham, Joel F. Houston
12th edition
978-0324597714, 324597711, 324597703, 978-8131518571, 8131518574, 978-0324597707
