Morgana Film Productions Inc. purchased a copier on Jan $1,2022$ for $$13,700$ with a residual value of $$1300.$

Useful life is $5$ years or $100,000$ copies $12$ Points

Copies produced in $2022$: $12000$ copies; in $2023$: $11,000$ copies

If you find yourself getting stuck trying to complete this problem here is a link to a video of me solving a very similar

problem. $($Ignore any part that refers to My Open Math as these problems are now being done in these Excel

spreadsheets.$)$

 

 

 

Requirement: Using the Straight-Line Method, calculate:

a$)$ The Depreciation Expense in $2022$ & $2023$

Depreciation Expense for $2022$

Depreciation Expense for $2023$

b$)$ Accumulated Depreciation at the end of $2023$

Accumulated Depreciation at the end of $2023$

c$)$ Book Value at the end of $2023$:

Book Value at the end of $2023$

This Excel Worksheet was created by Amy Bohrer, CPA and is licensed under a Creative Commons Attribution $4\mathrm{.}0$ International License.

Answer rating: 100% (QA)

Lets calculate each requirement using the StraightLine Method a Depreciation Expense Dep... View the full answer