Need to calculate discounted pay back period, profitability index, NPV and internal rate of return

also an analysis and decision based on the capital budgeting criteria

59 $ (337,200) $ 63,991.81 $ 60,581.81 $ 57,371.90 $ 54,349.42 $ 153,511.37 (337,200) $ (273,208.19) $ (212,626.38) $ (155,254.48) $ (100,905.06) $ 52,606.31 $ 10.00% 60 Present Value FCF 61 Cummulative Present Value FCF 62 63 Capital Budgeting Criteria 64 65 Discount rate 66 Pay_Back (years) 67 Discounted Pay_Back (years) 68 Profitability Index 69 Net Present Value NPV 70 Internal Rate of Return IRR 71 72 5.50 years years The discount rate of return is the expected or required rate of return for an investment in a project or a business venture. Also known as the cost of capital, it is used to estimate the current value of an investment based on its expected future cash flows. The required rate of return differs from investor to investor. Select your own discount rate. dollars % Rubrick Links Example Final Spreadsheet Analysis and Decision +