needs to be dont like this excel sheet example all values must be filled in and in an excel sheet with formulas.

using the data procided all parameters in the excel table shown have to be calculated that excel sheet image is just an example and have to come up with the sams dable with the data procided in the first table

Perform a financial analysis for a project where the projected costs and benefits are spread over five years with the following data: Estimated costs are $100,000 in Year 1 and $25,000 each for years 2, 3, 4, and 5. Estimated benefits are $0 in Year 1 and $80,000 each for years 2, 3, 4, and 5. Use a discount rate of 8% For layout see example (PDF format) in D2L, in the same module as this assignment. Project 1 Year 1 Year 2 Year 3 Year 4 Year 5 Total Benefits | $ $ 2,000 $ 3,000 $ 4,000 $ 5,000 $ 14,000 $ 1,653 $ 2,254 $ 2,732 $ 3,105 Cumulative benefit $ - $ 1,653 $ 3,907 $ 6,639 $ 9,743 Costs $ 5,000 $ 1,000 $ 1,000 $ 1,000 $ 1,000 $ 9,000 Inpv, costs $ 4,545 $ 826 $ 751 $ 683 $ 621 | Cumulative, costs $ 4,545 $ 5,372 $ 6,123$ 6,806 $ 7,427 Cash flow $ (5,000) $ 1,000 $ 2,000 $ 3,000 $ 4,000 $ 5,000 PV = FV ((1/(1+rate)^t)) Discount rate = (1/(1+ratet) 10% 3141 0.7513148 0.6830135 0.6209213 0.90909091 0.82644628 npv, cash flow cumulative npv NPV $ $ $ (4,545) $ (4,545) $ 2,316 826 $ (3,719) $ 1,503 $ (2,216) $ 2,049 $ (167) $ 2,484 2,316 ROI Payback 31% -0.067375 4.067375 Year 1 Cumulative benefit $ R Cumulative, costs $ 4,545 Year 2 $ 1,653 $ 5,372 Year 3 Year 4 $ 3,907 $ 6,639 $ 6,123$ 6,806 Year 5 $ 9,743 $ 7,427