6008 Assessment 2

profileDarktanion
cf_cost_benefit_analysis_template.xlsx
Home>Nursing homework help>6008 Assessment 2

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