Use the information on the Given Data worksheet to prepare three depreciation schedules using the following methods: straight$-$line, double$-$declining balance, and activity$-$based.

Auburn Car Wash

Straight Line

If you hover your mouse over a cell with a red flag you will see the comment

Auburn Car Wash

Double$-$Declining$-$Balance

If you hover your mouse over a cell with a red flag you will see the comment

Note: for year $5$ you must make the year end book value equal to the Residual Value Therefore you will need to take the beginning book value less the Residual Value

Auburn Car Wash

Activity$-$Based

When you have completed all three schedules answer the following question.

What do you observe about the Book Value at the end of the $5$th year for all three methods?

Type answer here longrightarrow

Pointe Possible: $10$ Use cell references $($linking$)$ and Excel formulas when possible, Save your file with your name In the file name. Submit the file in canvas.

Use the Information on the Given Data worksheet to prepare three depreciation schedules using the following methods: straight$-$line, double$-$doclining balance, and activity$-$based.

Ien Data:

If you hover your mouse over a cell with a ned flag you will see the comment

AUBURN CAR WASH

$\backslash$table$[[$Cost of new car wash machines,$$,800,000],[$Estimated residual value,$$,50,000],[$Machine life in years,,$5],[$Machine life in hours,$10,000,]]$

If you hover your mouse over a cell with a red flag you will see the comment

Actual use per year:

Hours

Note: for year $5$ you must make the year end book value equal to the Rosidual Value Therefore you will need to take the beginning book value loss the Residual Value

When you have completed all three schedules answer the following question. What do you observe about the Book Value at the end of the $5$th year for all three methods? Type answor here longrightarrow