Cost and benefit
nteasley
Costbenefittemplateretry.pdf
COST-BENEFIT ANALYSIS TEMPLATE Step 1: Enter cost amounts as future value (FV) expectations. The future value will be automatically converted to present value (PV). Step 2: Enter benefit amounts as FV expectations. The FV will automatically be converted to PV. Step 3: Subtract the total PV benefits from the total PV costs to get the net benefit.
Costs Current Year
(CY) CY +1 CY +2 CY +3 CY +4 CY +5 Total Costs
Total Costs (Future Value) 0 0 0 0 0 0 Total Costs (Present Value) 0 0 0 0 0 0 0 blank row
Benefits Current Year
(CY) CY +1 CY +2 CY +3 CY +4 CY +5 Total Benefits
Total Benefits (Future Value) 0 0 0 0 0 0 Total Benefits (Present Value) 0 0 0 0 0 0 0 blank row Present Value Discount Rate 2% PV Denominator 1.00 1.02 1.04 1.06 1.08 1.10 Net Benefit 0 End of worksheet
