Problem $7-5$A $($Algo$)$ Determine depreciation under three methods $($LO$7-4)$

$[$The following information applies to the questions displayed below.$]$

University Car Wash purchased new soap dispensing equipment that cost $$249,000$ including installation. The company estimates that the equipment will have a residual value of $$25,500.$ University Car Wash also estimates it will use the machine for six years or about $12,500$ total hours. Actual use per year was as follows:

$\backslash$table$[[$Year$,$Hours Used$],[1,2,900],[2,1,800],[3,1,900],[4,2,100],[5,1,900],[6,1,900]]$

Problem $7-5$A $($Algo$)$ Part $1$

Required:

Prepare a depreciation schedule for six years using the straight$-$line method. $($Do not round your intermediate calculations.$)$

$\backslash$table$[[$UNIVERSITY CAR WASH$],[$Depreciation Schedule$-$Straight$-$Line$],[$End of Year Amounts$],[$Year$,\backslash$table$[[$Depreciation$],[$Expense$]],\backslash$table$[[$Accumulated$],[$Depreciation$]],$Book Value$],[1,,,],[2,,$c$,],[3,=,,],[4,,,],[5,,,],[6,,,],[$Total$,$$$,,]]$