In: Finance
CASH FLOWS OVER PROJECT #1's LIFE | ||||||
Target Rate of Return | 9.229% | |||||
Net Cash Flows At End of Year | ||||||
Year Number | 0 | 1 | 2 | 3 | 4 | |
YEAR | 2019 | 2020 | 2021 | 2022 | 2023 | |
CAPITAL PRODUCT #1 | -$1,461,200 | $411,100 | $474,300 | $640,300 | $819,500 | |
Cumulative cash flows | -$1,461,200 | -$1,050,100 | -$575,800 | $64,500 | $884,000 | |
Discounted cash flows | -$1,461,200 | $376,365 | $397,537 | $491,326 | $575,701 | |
Cumulative discounted cash flows | -$1,461,200 | -$1,084,835 | -$687,298 | -$195,972 | $379,729 |
Calculate using above information:
1) Net Present Value (NPV)
2) Internal Rate of Return (IRR)
3) Profitability Index (PI)
4) Modified Internal Rate of Return (MIRR)
5) Payback Period (PP)
6) Discounted Payback Period (DPP)