Q:

# How do you create a depreciation schedule worksheet?

A:

Create a depreciation schedule worksheet or template using basic spreadsheet software such as Microsoft Excel. Create columns for the basic information necessary in a deprecation schedule. Decide on the type of depreciation you intend to use and enter that formula in the final column.

## Keep Learning

Start by labeling the columns based on the information you want to include. Basics such as asset name, acquisition date, acquisition cost, estimated useful life, estimated salvage value, and depreciation value are all important to include. Also consider including information such as asset class, description, location, or serial number. In the depreciation value column, enter the depreciation valuation formula. For example, a worksheet using straight-line depreciation has a formula referencing the values in the acquisition cost, salvage value and useful life columns. The formula is the sum of acquisition cost minus estimated salvage value divided by estimated useful life. Use a different formula based on the specific type of depreciation needed.

After structuring the main body of the depreciation schedule, format the worksheet for ease of navigation. Include a heading describing the company and depreciation method utilized. Format each column based on the type of information it contains. For example, the acquisition cost column is formatted for currency while the acquisition date column is in date format. Consider alternating the colors of the rows or bolding the column heading text. Finish the depreciation schedule by saving the spreadsheet.

Sources:

## Related Questions

• A: There are three commonly used formulas for depreciation based on time: declining balance method, straight line method and sum-of-the-years'-digits method. ... Full Answer >
Filed Under:
• A: Car depreciation is the difference between the amount paid for a car and its current value. It is often the biggest expense involved in car ownership.... Full Answer >
Filed Under:
• A: Appliance depreciation refers to the calculation that determines the loss of value of an appliance, usually on an annual basis. Depreciation can be claimed... Full Answer >
Filed Under:
• A: To calculate depreciation using the sum of the years' digits, divide the undepreciated useful life of the asset by the sum of the years' digits, and then m... Full Answer >
Filed Under:
PEOPLE SEARCH FOR