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:

$($a$)$ Calculate the annual depreciation for each of the three assets for each of the four depreciation

methods described above. Provide the depreciation expense for years $2022,2023,$ and $2024.$

To complete this, utilize Excel worksheets and tools to create a table that is easy to read, use

formulas and cell references where appropriate, and label the annual depreciation for each year.

Make sure all compenents are included such as depreciable cost, etc.

NOTE: Do not round in calculations but round final solutions to two digits.