Fixed Asset Depreciation Done Right!

Free Stuff - Excel Templates

The Excel templates on this page are free, compliments of Cellutionware Software.

Click the link below to download the free demo version of our powerful Depreciation Calculator program. Depreciation Calculator is a full-fledged stand-alone program that computes depreciation for federal tax, state tax, and financial statement purposes for numerous assets and companies.

Link: Depreciation Calculator Demo

 You will need Microsoft Excel 2002 or higher to use the templates below.

  1. Excel template to calculate MACRS depreciation, section 179, and first-year bonus depreciation for tangible personal property:
    This Excel template shows how MACRS depreciation is calculated for the first year of an asset's life including first-year bonus depreciation and section 179. It also prepares a depreciation schedule for the complete life of the asset.
    MACRS Personal Property Template

  2. Excel template to calculate MACRS depreciation for real property:
    This Excel template calculates depreciation for commercial and residential real property with lives of 27.5, 31.5, 39 and 40 years and prepares a depreciation schedule for the complete life of the asset.
    MACRS Real Property Template
     

  3. Excel template to calculate straight-line and declining balance depreciation:
    This Excel template calculates depreciation using either the straight-line or declining balance methods, and prepares a depreciation schedule for the complete life of the asset.
    Straight-Line & Declining Balance Template

     

  4. Excel template to calculate depreciation of Luxury Autos for 2012 - 2014:
    This Excel template calculates MACRS depreciation for vehicles subject to the Luxury Auto Limitations for years 2012 - 2014 and compares the calculation to the maximum allowable amount.

    Luxury Autos

  5. Loan Amortization Schedule:
    This Excel template creates a loan amortization schedule.
     Loan Schedule

  6. Auto Trade-In Worksheet:
    This Excel template is a worksheet to calculate the basis of the new auto that is received in a non-taxable exchange (Trade-In) of one auto for another.
    Auto Trade-In Worksheet

    7.    Self-Employment Tax Worksheet:
       
This Excel template computes self-employment tax and the 50% deduction amount.
        Self-Employment Tax Worksheet

Send us your comments regarding these Excel templates: support@cellutionware.com