Problem:
Feasibility Analysis. Based on the following cost and benefits projections, compute (1) payback period, (2) life time ROI, and (3) Net Present Value of the project. Assume a 10% discount rate.
Year 0: cost - 2000, revenue - 0,
Year 1: cost - 1100, revenue - 2200,
Year 2: cost - 1210, revenue - 2420,
Year 3: cost - 1331, revenue - 2662,
Year 4: cost - 1464.1, revenue - 2928.2,
Please supply in Excel format