Please explain how to calculate in excel NPV, IRR, MIRR and Profitability Index (PI) for the following:
Fantastic news! We've Found the answer you've been seeking!
Question:
Please explain how to calculate in excel NPV, IRR, MIRR and Profitability Index (PI) for the following:
Discount rate: 12%
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Cash flow -5000 2500 1700 900 700 500 300 200 150 100 60 30 20 10 5 5
Posted Date: