Depreciation Schedule Template

Please Contact Us For Support and Customization of Templates

View Cart


accounts-receivable-aging-template

Depreciation Schedule Template
$2.95

File Type: Zipped file containing an Excel 2003 2007 spreadsheet
Size: 152 kb
Pages: 2

Add to Cart

There are many situations in which you may need a Depreciation Schedule Template. Depreciation is something you can easily calculate. It will help you prepare your own Profit and Loss statement. There is no need for fancy computer software. Especially if you are interested in knowing your depreciation expenses for book purposes, a straight–line depreciation calculation is often all you will need.

If accelerated depreciation is more appropriate, the two most popular methods used for financial reporting purposes are the declining balance or the sum–of–the–years' digits method.

Depreciation calculation for tax purposes will depend on the tax law you are subject to. In the United States two accelerated methods are used: ACRS and MACRS. This Depreciation Schedule Template uses straight–line depreciation calculation.

For those of you who have not yet made the leap to Office 2007, I have included both Excel 2003 and Excel 2007 versionsin the zipped file.

As is true of all financial templates on this site, support and customization are available.

View Cart


Depreciation Schedule Template – Description

The Desc tab of this Depreciation Schedule Template contains a brief instruction on how to populate the template with your data.

The Depreciation tab contains the actual depreciation calculation. All you will be asked to input will be your asset descriptions, their cost and useful lives. Useful lives are basically prescribed to you by the IRS which requires us to use the Modified Accelerated Cost Recovery System (MACRS). It is the accepted accelerated asset depreciation method required by the United States income tax code.

If you are not sure what period to use for your asset's useful life, you can look them up here: MACRS

More about depreciation here.





Financial Plan Template
Financial Plan Templates for different legal entity structures. Choose from 3 or 5 year templates. Automated with a tab for assumptions, separate personnel and depreciation tabs. Professional presentation with highlights and 4 charts.

Balance Sheet Templates
Balance Sheet templates for simple, one point in time balance sheets, balance sheets with ratios, balance sheets with a depreciation calculation, 3 and 5 year balance sheet projection templates.

Balance Sheet Analysis
Learn how to analyze your balance sheet and determine your company's liquidity, solvency and financial flexibility.


 


Return from Depreciation Schedule Template to Small Business Accounting Services

Sign Up for
Mini E–course
in Small Business Accounting