$1.$ What is the payback period $($to hundredths place$)$ for the proposed investment documented in the attached excel spreadsheet?

$2.$ Your answer must be provided in the form of an Excel Spreadsheet which must include formulas and formatted cells. Label your work as appropriate.

$3.$ The company requires a $7$ year payback period, does this investment meet the company's investment criteria?

$4.$ Document any assumptions you made to complete the calculation within your spreadsheet.

Year Net Income per year

Year $12,144$

Year $23,531$

Year $35,133$

Year $46,113$

Year $510,243$

Year $610,500$

Year $712,546$

Year $812,600$

Year $912,600$

Year $1012,600$

Initial Investment $$155,000$

Life in years $10$