Please check my work below:

Perform a financial analysis for a project using the format provided on this template. Assume the project costs and benefits for this project are spread over four years as follows: Estimated costs are $100,000 in Year 1 and $20,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $80,000 each year in Year 2, 3, and 4. Use an 8% discount rate. Using the provided template, calculate and highlight in yellow the NPV, ROI and year in which payback occurs. In addition, write a paragraph after any "Assumptions" listed, explaining whether you would recommend investing in this project based on your financial analysis. Use the first tab "NPV-ROI" to write your answers.

Discount rate
	Year				Total	Comments
	1	2	3	4
Costs/Year						For Year 0, there is no discount and the discount factor is 1
Cost Discount factor						Cost Discount Factor = 1/(1+r)^n, wherer is the discount rate, n is the number of years
Discounted costs	$0.00	$0.00	$0.00	$0.00	$0.00	Cost * Discount Factor
Cumulative Costs	$0.00	$0.00	$0.00	$0.00		Total costs upto that year
Benefits						Benefits per year
Discount factor	1.00	1.00	1.00	1.00		Benefit Discount Factor = = 1/(1+r)^n, wherer is the discount rate, n is the number of years
Discounted benefits	$0.00	$0.00	$0.00	$0.00	$0.00	Benefit * Discount Factor
Cumulative Benefits	$0.00	$0.00	$0.00	$0.00		Total benefits upto that year
Cashflow	$0.00	$0.00	$0.00	$0.00		Benefits - Costs (These are the non-discounted benefits and costs)
Discounted benefits - Discounted Costs	$0.00	$0.00	$0.00	$0.00	$0.00	Discounted Benefits - Discounted Costs. The total of this is the Net Present Value for any year.
NPV (Cumulative Benefits - Cumulative Costs)	$0.00	$0.00	$0.00	$0.00		This gives the NPV for each year. NPV turns positive in year 7.
Net Present Value using the EXCEL formula	$0.00	$0.00	$0.00	$0.00	$0.00	NPV(Discount rate, sum of cashflow for that year) Minus Cost of year 0
Return On Investment	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!