assignment due on 15th nov

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.