Question: please help solve For the table given below construct a spreadsheet and compute both the payback and the return on investment Construct the appropriate formulas
please help solve
For the table given below construct a spreadsheet and compute both the payback and the return on investment Construct the appropriate formulas for computing the values. Submit your spreadsheet on this assignment. For the point of payback highlight the row identifying the year in which payback occurs. When you compute ROI be certain to calculate for the year in which payback occurs. Year Cumulative Costs and Benefits Cumulative Costs Benefits Costs 50,000 50,000 3,000 17,000 67,000 28,000 0 Cumulative Benefits 3,000 31,000 62,000 1 N 18,450 85,450 31,000 3 104,450 34,000 96,000 19,000 20,500 4 124,950 37,000 133,000 173,000 5 21,000 145,950 40,000 6 22,000 167,950 43,000 216,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
