calculate IRR with excel and check NPV. RD-6 Satellite Satellite Life Rate of Return (%) Net
Fantastic news! We've Found the answer you've been seeking!
Question:
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 |
Expert Answer:
Related Book For 
Fundamentals of Financial Management
ISBN: 978-0324597707
12th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
