Formul FM CAPBuD.xlsx - FYI Ordinary Cashflow with one sign change Period 0 1 Cashflow \u20b9-50.00 \u20b9 13.00 PV \u20b9-50.00 \u20b9 11.61 TV \u20b9 25.66 NPV \u20b9

Formul FM CAPBuD.xlsx - FYI Ordinary Cashflow with one sign...

This preview shows page 1 - 2 out of 2 pages.

Ordinary Cashflow: with one sign change Period 0 1 2 3 4 5 Cashflow -50.00 ₹ 13.00 ₹ 13.00 ₹ 13.00 ₹ 13.00 ₹ 13.00 FYI PV -50.00 ₹ 11.61 ₹ 10.36 ₹ 9.25 ₹ 8.26 ₹ 7.38 TV 25.66 ₹ 22.91 ₹ 20.46 ₹ 18.26 ₹ 16.31 NPV 3.45 Cumulative Cashflow -50.00 ₹ -37.00 ₹ -24.00 ₹ -11.00 ₹ 2.00 ₹ 15.00 Payback period - - - - 8.50 ₹ - Rate of interest 12% for MIRR Calculation NPV 3.45 No years 7 IRR 14.40% Terminal Val ₹ 103.60 Profitability Index 1.07 MIRR 10.97% Payback Period = Ordinary Cashflow: with one sign change and different interest rate
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes