Depreciation Calculator

This Depreciation Calculator spreadsheet was designed to demonstrate how to perform various depreciation calculations for a variety of depreciation methods. It is not intended to be used for official financial or tax reporting purposes.

The workbook contains 3 worksheets:

1. Basic Depreciation Calculator: This calculator uses the same formulas used in the Depreciation Schedule, where depreciation is calculated without using the MACRS half-year, mid-quarter, or mid-month conventions.

2. MACRS Depreciation Rate Calculator: This depreciation calculator uses the approach I discussed in Part 2, where the depreciation rate is calculated instead of looking up the rates in the MACRS tables.

3. MACRS Depreciation Calculator: This calculator uses what I refer to as the "Depreciation Basis Reduction" approach. I wouldn't call it an "official" MACRS depreciation calculator, but it is set up to work as outlined in the IRS publication (see "Figuring the Deduction Without Using the Tables"). It allows adjustments to be made to the depreciation basis due to losses or improvements.

No Installation, No Macros - Just a simple spreadsheet