2020 In Excel, I need to figure out how to do the depreciation schedule using ce

Question

2020

In Excel, I need to figure out how to do the depreciation schedule using cell references and formulas which refer to the data in your input section. Seeing this and or an explanation would be great thank you for your time!

Aque Company Depreciation and Depletion Schedule Delivery Truck Inputs: Original cost $                          68,000 Salvage value $                            4,400 Depreciable cost $                          63,600 Estimated useful life 4 years Depreciation rate 50% Date of acquisition 1-Mar-17 First-year fraction 1/4 Last year fraction 1    Depreciation method Declining balance x2 Calculations: For Year Ending December 31 End of Year Book Value Annual at Beginning Depreciation Depreciation Accumulated Book Year of Year Rate Expense Depreciation Value 2017 2018 2019

2020

In Excel, I need to figure out how to do the depreciation schedule using cell references and formulas which refer to the data in your input section. Seeing this and or an explanation would be great thank you for your time!

Explanation / Answer

If you have any doubts please comment. I will surely help to resolve.

Book Value at The Beginning of the Year Depreciation Rate Depreciation Expenses Accumulated Depreciation Book Value at The end of the year Year 2017               68,000.00 50%          28,333.33             28,333.33               68,000.00 2018               68,000.00 50%          19,833.33             48,166.67               68,000.00 2019               68,000.00 50%            9,916.67             58,083.33               68,000.00 2020               68,000.00 50%            4,958.33             63,041.67               68,000.00

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.