Paid script
Depreciation and Loan Schedule Python script
Build a fixed-asset depreciation register for many assets at once, and see what extra loan payments save. One file, run on your computer.
Paid script
Depreciation and Loan Schedule Python script
Buy this script on its own for $19, one time. No membership needed. It runs on your own computer and nothing you enter leaves it. Read how it works and the questions below first.
The Financial Suite includes this and 9 more tools for $49. Members get this included. See the membership or sign in. Already bought it? Email me my access link.
How it works
How it works
Depreciation methods are straight line, double declining balance (switching to straight line when that is larger), sum of the years' digits, and the half-year-convention MACRS percentage tables for 5- and 7-year property. The register command reads a CSV of assets and outputs depreciation by asset and by year with totals. The loan command computes the payment, total interest and how much sooner and cheaper an extra payment pays it off. It does not model Section 179, bonus depreciation or other tax elections, which are decisions for you and your tax preparer.
FAQ
About this calculator
Can I use this for tax depreciation?
It includes the standard MACRS percentage tables, but it does not apply Section 179, bonus depreciation, mid-quarter rules or limits on listed property. Use it for planning and bookkeeping schedules, and confirm tax treatment with your tax preparer.
Can it handle a whole list of assets?
Yes. The register command reads a CSV of assets and writes a year-by-year schedule with totals.
Does the loan schedule match my lender's?
It uses standard amortization. Your lender's schedule can differ in day counts, fees and rounding, so check against your loan statement.
Is anything saved?
No. The math runs in your browser and nothing you enter is sent to us.
Is this tax or financial advice?
No. It is a calculator for general information. Check the numbers against your own records, and ask an accountant before you act on them.
Related: roi and payback calculator, debt service coverage ratio calculator. See all free tools. More free tools: Automated Checkbook Register Python script, Debt Payoff Planner Python script, Home and Car Cost Python script, or see all free tools.
Free
Month-End Close Checklist (PDF)
The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.
General information, not tax or legal advice. How we write and check our tools.
Python scripts
Bookkeeper's Python Starter Scripts
Three small, readable Python scripts that do chores bookkeepers repeat by hand, with sample files so you can see each one work before using your own data.