Constantine Ventures
Constantine Ventures Home
Home About Us Contact Information
Constantine Ventures
CFO Support SIte

All Products
Back to Category Name


Download Business Tools
Depreciation Calculator
Updated: 11/21/2003


 
$29.00
Format: MS Excel

This program allows you to calculate your depreciation expense utilizing the three most common depreciation methods: Straight-line (SL), 200% Double-declining balance (200DB), and 150% Double-declining balance (150DB)



Software Notes:

Software Notes:

1) This program allows you to calculate your depreciation expense utilizing the three most common depreciation methods: Straight-line (SL), 200% Double-declining balance (200DB), and 150% Double-declining balance (150DB)

2) Please note that eight years of Book and Tax sample depreciation calculation spreadsheets have been set up for your use. Each spreadsheet contains a "generic" business property description as well as the most commonly used depreciation method and recovery period (useful life) for that business property type.

3) Your first step in using this program is to input the description and purchase price of your business property into the spreadsheets named TAX DEPREC YEAR 1 and BOOK DEPREC YEAR 1. If your specific business property matches the generic description already contained in the spreadsheet, replace the generic description with your specific property's name. Be sure to change the purchase price as well.

4) Next determine the appropriate Depreciation Method for Book and Tax purposes and enter them into the spreadsheets. Use the guidelines contained in spreadsheet DEPRECIATION BASICS. As previously mentioned, the spreadsheets are already set up to use the most common methods by business property type.

5) Finally determine the Recovery Period or Useful Life of your business property. Your Tax and Book Recovery Periods do not have to be the same. The sample depreciation calculation spreadsheets utilize the same Recovery Period for Book and Tax. Again, you may use what has already been set up or input your own information.

6) If you changed the Depreciation Method and/or Recovery Period in the sample spreadsheets,be sure to re-point the DEPRECIATION CURRENT YEAR calculation to the appropriate DEPRECIATION TABLE.

7) The tab labeled DEPREC SUMMARY BOOK VS TAX tabulates your depreciation expense by year
for Book and Tax.