APPLICATION ASSIGNMENT #$4-$ ACCT$305($Chapter $10)$

Students $-$ Please utilize Excel to complete the requirements listed below. Make sure your answers are transferred

to the appropriate blank in the Solutions $($orange tab$)$ worksheet in this workbook. Make sure you are

utilizing Excel functions, formatting, and calculation abilities where applicable. Your worksheets should be

easy to read and labelled properly.

Problem: $($Depreciation$$SL$,$ DDB$,$ SYD$,$ Act.$)$ On January $1$st$,2022,$ Marco Company, a

medium$-$sized manufacturer, acquired the following assets:

Cost Salvage Value Useful Life Units of Production Class Life

Asset #$1$ $$1,250,000$ $$150,0005202260,0005*$ Total units of

$202345,000$ output $=150,000$

$202430,000$

Asset #$2$ $$875,000$ $$25,0007202222,0007*$ Total units of

$202318,000$ output $=75,000$

$202415,000$

Asset #$3$ $$1,000,000$ $$-102022100,00010*$Total units of

$202375,000$ output $=400,000$

$202460,000$

The following depreciation methods will be used: $(1)$ straight$-$line; $(2)$ double$-$declining$-$balance;

$(3)$ sum$-$of$-$the$-$years$-$digits; and $(4)$ units$-$of$-$output.

Instructions: