USING AN EXCEL format, please help with the following

QUESTION 51 Book value and taxes on sale of assets Troy Industries purchased a new machine 5 year(s) ago for $80,000. It is being depreciated under MACRS with a 5-year recovery period using the schedule. Assume 40% ordinary and capital gains tax rates.

a. What is the book value of the machine? _______________

b. Calculate the firm's tax liability if it sold the machine for each of the following amounts: $96,000; $56,000; $4,000; and $2,800. a. The remaining book value is _____. (Round to the nearest dollar.) b. Calculate the firm's tax liability for each case:(Round to the nearest dollar.)

Sale price	Capital Gain	Tax on Capital Gain	Depreciation Recovery	Tax on Recovery	Tax Total
$96,000
$56,000
$4,000
$2,800

Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes
	Percentage by recovery year*
Recovery year	3 years	5 years	7 years	10 years
1	3333%	2020%	1414%	1010%
2	4545%	3232%	2525%	1818%
3	1515%	1919%	1818%	1414%
4	77%	1212%	1212%	1212%
5		1212%	99%	99%
6		55%	99%	88%
7			99%	77%
8			44%	66%
9				66%
10				66%
11				44%
Totals	100100%	100100%	100100%	100100%
*These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%) depreciation using the half-year convention.