Please refer to the following assumptions and provide your answers to the questions $($Q$1-4)$ in How to calculate on excel.

Assumptions: Your team plans to purchase four machines for lawn care at the stadium. The price per unit is $$100,000.$ The intended useful life of each machine is seven years. The machine will be used for $3,000$ hours in its first year, with an expected decrease of$5\%$ in usage hours each subsequent year compared to the previous year. The estimated salvage value after $7$ years of use is $30\%$ of the initial cost.

Q$1.$ Calculate the annual depreciation using the Straight$-$line method for each year $($from $1$st year to $7$th year$).$

Q$2.$ Calculate the annual depreciation using the Sum$-$of$-$years digits method for each year $($from $1$st year to $7$th year$).$

Q$3.$ Calculate the annual depreciation using the Double$-$declining balance method for each year $($from $1$st year to $7$th year$).$

Q$4.$ Calculate the annual depreciation using the Units of production for each year $($from $1$st year to $7$th year$).$