Calculate npv-roi and year in which payback occurs


Perform a financial analysis for a project using the format provided in the attached excel. Assume the projected costs and benefits for this project are spread over four years as follows. Estimated costs are $200,000 in year 1 and $30000 each year in years 2,3 and 4. Estimated benefits are $0 in year 1, $100,000 each year in years 2,3 and 4. Use a 9 % discount rate and round the discount factors to two decimal places. Create a spreadsheet to calculate and clearly display NPV, ROI and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project based on financial analysis.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Calculate npv-roi and year in which payback occurs
Reference No:- TGS084045

Expected delivery within 24 Hours