Cost-Benefit Analysis

CBA Template

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