CIS 264 Chapter 7 Practtice Task - Return on Investment(ROI Template The formula in cell C17 will calculate ROI when values are entered in cells B8:B14

CIS 264 Chapter 7 Practtice Task - Return on Investment(ROI...

This preview shows page 1 - 3 out of 3 pages.

Return on Investment (ROI) TemplateCell C17 contains formula to calculate ROIYearCostsCumulativeBenefitsCumulativeCostsBenefits013,000 13,000 - 12,000 15,000 9,000 9,000 22,000 17,000 9,000 18,000 32,000 19,000 9,000 27,000 42,000 21,000 9,000 36,000 521,000 36,000 621,000 36,000 21,000 36,000 ROI:71.4%Note:Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefitsThe formula in cell C17 will calculate ROI when values are entered in cells B8:B14 and D8:D14
Net Present Value (NPV) TemplateNote: Cells B12:H12 and B16:H16 contain formulas to multiply discount factors * benefit and cost valuesCells I12 and I16 contain adjusted cost and benefit totalsCell C18 contains the calculation for net present value (NPV)YearYearYearYearYearYearYearTotal0123456Benefits9,000 9,000 9,000 9,000 Factor0.926 0.857 0.794 0.735 PV of Benefits

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture