$($Use cells A $2$ to B $11$ from the given information above to complete this question. Accumulated depreciation should be presented as a positive $\backslash$table$[[$Sale amount$],[$Less:$],[$Original cost of equipme$],[$Less: Accumulated depre$],[$Book value at end of ye$],[],[($b$)$ Journal Entry for Sale:$]]$

$($Use cells A$2$ to B$11$ from the given information above to complete this question. Hint: A "gain" or "loss" account will auto$-$populate

based on your answer in part $($a$).$ Show all values as positive amounts.$)$

Requirement $4$: Assume Equipment is Retired $($zero proceeds, given in Cell B$11)$

$($a$)$ Calculate Gain or Loss on Retirement:

$($Use cells A$2$ to B$11$ from the given information above to complete this question. Accumulated depreciation should be presented as a

positive amount. Hint: In cell A$86,$ input a conditional IF statement to return the word "Gain" if cell C$86$ is a positive amount or "Loss"

if cell C$86$ is a negative amount.$)$

$($b$)$ Journal Entry for Retirement:

$($Use cells A$2$ to B$11$ from the given information above to complete this question. Hint: A "gain" or "loss" account will auto$-$populate

based on your answer in part $($a$).$ Show all values as positive amounts.$)$

amount. Hint: In cell A$43,$ input a conditional IF statement to return the word "Gain" if cell C$43$ is a positive amount or "Loss" if cell C$43$ is a

negative amount.$)$

$($Use cells A$2$ to B$11$ from the given information above to complete this question. Hint: A "gain" or "loss" account will auto$-$populate

based on your answer in part $($a$).$ Show all values as positive amounts.$)$

Requirement $3$: Assume Equipment is Sold for Amount in Cell B$10$

$($a$)$ Calculate Gain or Loss on Sale:

$($Use cells A$2$ to B$11$ from the given information above to complete this question. Accumulated depreciation should be presented as a

positive amount. Hint: In cell A$65,$ input a conditional IF statement to return the word "Gain" if cell C$65$ is a positive amount or "Loss"

if cell $665$ is a negative amount.$)$