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

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
End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
FOX
Tags
Net Present Value, Return On Investment ROI, 5 Year, 1 9 000 0 926 8 334 Year, 2 9 000 0 857 7 713 Year, 3 9 000 0 794 7 146 Year, 4 9 000 0 735 6 615 2 000 0 926 1 852 2 000 0 857 1 714 2 000 0 794 1 588 2 000 0 735 1 470 10 184 Year

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture