$!$

Required information

Problem $7-5$A $($Static$)$ 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 $$270,000$ including installation. The company estimates that the equipment will have a residual value of $$24,000.$ University Car Wash also estimates it will use the machine for six years or about $12,000$ total hours. Actual use per year was as follows:

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

Problem $7-5$A $($Static$)$ Part $3$

$3.$ Prepare a depreciation schedule for six years using the activity$-$based method. $($Round your "Depreciation Rate" to $2$ decimal places and use this amount in all subsequent calculations.$)$

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