Depreciation Schedule Builder
Accountants, CFOs, and business owners use this prompt when acquiring new equipment, vehicles, or other fixed assets and need an accurate multi-year depreciation schedule for financial reporting, budgeting, and tax planning purposes.
Prompts
You are a fixed asset accounting specialist with expertise in [ACCOUNTING STANDARD] depreciation rules. I need you to build a complete depreciation schedule for the following fixed asset.
Asset details:
- Asset name/description: [ASSET NAME]
- Asset category: [ASSET CATEGORY] (e.g., machinery, vehicle, computer equipment, building improvement, intangible)
- Acquisition cost: [COST] [CURRENCY]
- Acquisition date: [ACQUISITION DATE]
- Useful life: [USEFUL LIFE] years
- Salvage / residual value: [SALVAGE VALUE] [CURRENCY]
- Depreciation method: [METHOD] (straight-line or declining balance)
- Declining balance rate (if applicable): [DECLINING BALANCE RATE]%
- Fiscal year end: [FISCAL YEAR END]
- Partial year convention: [CONVENTION] (half-year, mid-month, or full-year)
Build the depreciation schedule with the following columns for each year:
| Year | Period Start | Period End | Beginning Book Value | Depreciation Expense | Accumulated Depreciation | Ending Book Value |
|------|-------------|------------|---------------------|---------------------|--------------------------|-------------------|
**Calculations to include:**
1. **Year 1 Proration**
- If the asset was acquired mid-year, apply the [CONVENTION] convention to calculate the partial-year depreciation amount
- Show the calculation clearly (e.g., 'Asset placed in service October 1 — Q4 only = 3/12 of annual expense')
2. **Straight-Line Method** (if selected)
- Annual depreciation = (Cost − Salvage Value) / Useful Life
- Show this formula explicitly in your output
3. **Declining Balance Method** (if selected)
- Annual depreciation = Beginning Book Value × Rate
- Switch to straight-line in the year where straight-line produces a higher amount
- Show the crossover year explicitly
4. **Summary Statistics**
- Total depreciation over asset life
- Effective annual depreciation rate
- Year the asset is fully depreciated
- Average book value over the asset life
5. **Journal Entry Template**
- Provide the standard annual journal entry to record depreciation:
Debit: Depreciation Expense — [ASSET CATEGORY]
Credit: Accumulated Depreciation — [ASSET CATEGORY]
6. **Tax vs. Book Note** (if applicable)
- If [ACCOUNTING STANDARD] is GAAP or IFRS, note that tax depreciation (MACRS in the US, CCA in Canada) may differ and recommend consulting a tax advisor for the tax schedule.
Present the schedule as a clean table followed by the summary statistics and journal entry template.Prompt Variables
Replace each placeholder with your specific information:
[ACCOUNTING STANDARD][ASSET NAME][ASSET CATEGORY][COST][CURRENCY][ACQUISITION DATE][USEFUL LIFE][SALVAGE VALUE][METHOD][DECLINING BALANCE RATE][FISCAL YEAR END][CONVENTION]What You'll Get
A year-by-year depreciation table showing beginning book value, annual expense, accumulated depreciation, and ending book value for each period — plus a journal entry template, summary statistics, and a note on tax vs. book differences.
💡 Pro Tip
Run this prompt twice — once for straight-line and once for declining balance — then compare the outputs. The method that produces higher depreciation in early years reduces taxable income sooner, which may have significant cash flow benefits depending on your tax situation.
Compatible AI Tools
Claude
Best for detailed multi-method comparisons and explaining the declining balance crossover logic; Claude will catch common errors like applying declining balance to intangibles where straight-line is required under IFRS.
ChatGPT
Use the Code Interpreter feature to have ChatGPT write and execute the calculations in Python — this produces a downloadable table and is useful for high-value assets where you want to verify every decimal.
Microsoft Copilot
Excellent choice if you work in Excel — Copilot can generate the schedule using Excel formulas (DB, SLN, DDB functions) directly in your spreadsheet, making it easy to update when asset details change.