Build a spreadsheet from Figure $4\mathrm{.}2$ in your textbook with all variable calculations shown.

Run the spreadsheet with all variables given.

Copy the worksheet. Change the expected life for $3$ and $7$ years and recalculate.

Copy the worksheet. Calculate the total owning and operating costs for expected life of $3,5,$ and $7$ years with fuel costs of $$4\mathrm{.}00$ per gallon direct cost.

Submit your Excel file with all three worksheets clearly marked with the question number.

After the due date, check back for the answer, which will appear as the next content item in this module.