Question

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!

Answer 1

	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

Explanation:
Depreciation 2017	68000*50%*10/12
Depreciation 2018	(68000-28333.33)*50%
Depreciation 2019	(68000-48166.67)*50%
Depreciation 2020	(68000-58083.33)*50%

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