Natalie is also thinking of buying a van that will be used only for business. The cost of the van is estimated at $38,500. Natalie would spend an additional $2,500 to have the van painted. In addition, she wants the back seat of the van removed so that she will have lots of room to transport her mixer inventory as well as her baking supplies. The cost of taking out the back seat and installing shelving units is estimated at $1,500. She expects the van to last her about 5 years, and she expects to drive it for 100,000 miles. The annual cost of vehicle insurance will be $2,400. Natalie estimates that at the end of the 5-year useful life the van will sell for $6,500. Assume that she will buy the van on August 15, 2021, and it will be ready for use on September 1, 2021. Natalie is concerned about the impact of the vans cost on her income statement and balance sheet. She has come to you for advice on calculating the vans depreciation.

Prepare a depreciation table for straight-line depreciation. Recall that Cookie Creations has a December 31 fiscal year-end, so annual depreciation depreciation will have to be prorated for the portion of the year the van is used in 2021 and 2026.

						End of Year
Year		Depreciable Cost		Annual Depreciation Expense		Accumulated Depreciation		Book Value
								$enter a dollar amount
2021		$enter a dollar amount		$enter a dollar amount		$enter a dollar amount		enter a dollar amount
2022		enter a dollar amount		enter a dollar amount		enter a dollar amount		enter a dollar amount
2023		enter a dollar amount		enter a dollar amount		enter a dollar amount		enter a dollar amount
2024		enter a dollar amount		enter a dollar amount		enter a dollar amount		enter a dollar amount
2025		enter a dollar amount		enter a dollar amount		enter a dollar amount		enter a dollar amount
2026		enter a dollar amount		enter a dollar amount		enter a dollar amount		enter a dollar amount