assignment due on 15th nov

profilerkp112156
4A32F8_cost-benefit-analysis-template.xls

Sheet1

Current Year (CY) CY +1 CY +2 CY +3 CY +4 CY +5
Costs Cost Benefit Analysis
Total PV Benefits $ - 0
Total PV Costs $ - 0
NET BENEFIT 0.00
Total Costs (Future Value) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Costs (Present Value) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Benefits
Total Benefits (Future Value) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Benefits (Present Value) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Present Value Discout Rate 2%
PV Denominator 1.00 1.02 1.04 1.06 1.08 1.10
You can edit this column header to be the actual year.
Enter cost amounts as FV expectations. The future value will be automatically converted to PV.
Enter benefit amounts as FV expectations. The FV will automatically be converted to PV.