Straight-line and MACRS depreciation schedule calculator for QuickSheet.
depr: 10000 5 straight # $10k asset, 5-year straight-line
depr: 25000 7 macrs # $25k asset, MACRS 7-year class
depr: 50000 5 straight 5000 # With $5k salvage value
Generates a full depreciation schedule with year-by-year breakdown:
| Year | Rate | Expense | Book Value |
|---|---|---|---|
| Yr 1 | 20.00% | $5,000 | $20,000 |
| Yr 2 | 32.00% | $8,000 | $12,000 |
| ... | ... | ... | ... |
- Straight-line — Equal annual depreciation. Supports optional salvage value.
- MACRS — IRS Publication 946 half-year convention tables. Supports 3, 5, 7, 10, 15, and 20-year property classes. Automatically maps non-standard life inputs to the nearest MACRS class.
ext: github:Deskworks/quicksheet-depr-ext
Or manually:
git clone https://github.com/Deskworks/quicksheet-depr-ext- .NET 9 SDK
- Zero NuGet dependencies
- quicksheet-1099-ext — Self-employment tax
- quicksheet-mortgage-ext — Loan amortization
- quicksheet-mileage-ext — IRS mileage deduction
- quicksheet-margin-ext — Break-even & margin
- quicksheet-depr-ext — Depreciation schedules (this extension)
- quicksheet-budget — Budget envelopes
- quicksheet-qtr — Quarterly tax countdown