--- name: amortization-schedules description: Create and manage amortization schedules for loans, intangible assets, deferred costs, and other financial instruments. Handle straight-line, declining-balance, sum-of-years-digits, and effective interest method amortization. Use when users need loan amortization tables, intangible asset amortization plans, deferred revenue recognition schedules, debt amortization tracking, bond premium/discount amortization, or capitalized cost amortization. Triggers on phrases like "amortization schedule", "loan amortization", "intangible asset amortization", "debt amortization", "amortization table", "principal and interest schedule", "deferred cost amortization", "bond amortization", "effective interest method", "capitalized cost write-off", or related amortization queries. --- # Amortization Schedules Create accurate amortization schedules for loans, intangible assets, deferred costs, and financial instruments using appropriate amortization methods aligned with accounting standards and business objectives. ## Workflow 1. **Classify Amortization Type and Select Method** - Determine the correct amortization approach: ``` AMORTIZATION TYPE AND METHOD SELECTION ════════════════════════════════════════ Type 1: Debt / Loan Amortization → Purpose: Track principal and interest payments over loan life → Method: Effective interest method (standard) → Standards: ASC 470, IFRS 9 → Output: Monthly amortization table with principal, interest, balance Type 2: Intangible Asset Amortization → Purpose: Systematically allocate cost of finite-life intangible assets → Method: Straight-line (default) or pattern-of-benefit (if determinable) → Standards: ASC 350, IAS 38 → Output: Annual/monthly amortization expense schedule Type 3: Deferred Cost Amortization → Purpose: Recognize capitalized costs as expense over benefit period → Examples: Deferred financing costs, prepaid expenses, CAC → Method: Straight-line (most common) or proportional → Standards: ASC 340-10, ASC 835-30 Type 4: Bond Premium / Discount Amortization → Purpose: Adjust carrying value of bond to face value at maturity → Method: Effective interest method (required) → Standards: ASC 470-10, IAS 39 → Output: Periodic amortization amount and carrying value Type 5: Deferred Revenue Recognition → Purpose: Recognize revenue over contract performance period → Method: Straight-line or usage-based → Standards: ASC 606, IFRS 15 → Output: Monthly revenue recognition schedule ``` 2. **Build Loan Amortization Schedule** - Create comprehensive loan amortization table: ``` LOAN AMORTIZATION SCHEDULE ════════════════════════════════════════ Loan Parameters: → Principal: $500,000 → Annual Interest Rate: 6.5% → Term: 60 months (5 years) → Payment Frequency: Monthly → First Payment Date: 2025-02-01 Monthly Payment Calculation: → Monthly rate: 6.5% / 12 = 0.5417% → Monthly payment = P × [r(1+r)^n] / [(1+r)^n - 1] → Monthly payment = $500,000 × [0.005417(1.005417)^60] / [(1.005417)^60 - 1] → Monthly payment = $9,764.73 ════════════════════════════════════════ Month | Payment | Principal | Interest | Remaining Balance ──────┼──────────┼───────────┼──────────┼────────────────── 1 | $9,765 | $7,117 | $2,648 | $492,883 2 | $9,765 | $7,155 | $2,610 | $485,728 3 | $9,765 | $7,193 | $2,572 | $478,535 ... | ... | ... | ... | ... 59 | $9,765 | $9,713 | $52 | $9,713 60 | $9,765 | $9,713 | $52 | $0 Totals: → Total payments: $585,884 → Total principal: $500,000 → Total interest: $85,884 → Interest as % of total: 14.66% ``` - Handle special loan features: ``` SPECIAL LOAN FEATURES ════════════════════════════════════════ Balloon Payment: → Regular monthly payment calculated on shorter amortization (e.g., 360 months) → Loan matures in shorter term (e.g., 60 months) → Balloon = Remaining principal at maturity Interest-Only Period: → First N months: Payment = Interest only → After N months: Full amortization on remaining principal → Extend term or recalculate payment Variable Rate (Adjustable Rate Mortgage): → Recalculate payment at each rate adjustment → Cap on periodic and lifetime rate increases → Disclose payment increase scenarios Bi-Weekly Payments: → Payment = Monthly payment / 2 → 26 payments/year = 13 monthly payments worth → Accelerates payoff by ~3-4 years → Reduces total interest by ~20-30% Extra / Prepayments: → Apply to principal (reduces balance) → Recalculate subsequent interest → Track total prepayment amount and interest savings ``` 3. **Build Intangible Asset Amortization Schedule** - Amortize finite-life intangible assets: ``` INTANGIBLE ASSET AMORTIZATION ════════════════════════════════════════ Asset: Customer Relationship (acquired in business combination) → Acquisition cost: $2,000,000 → Useful life: 5 years (based on customer attrition analysis) → Residual value: $0 → Amortization method: Straight-line → Annual amortization: $2,000,000 / 5 = $400,000 → Monthly amortization: $400,000 / 12 = $33,333 Asset: Technology / Patent → Acquisition cost: $800,000 → Useful life: 8 years → Method: Declining balance (2x) — reflects front-loaded economic benefit → Year 1: $800,000 × (2/8) = $200,000 (25%) → Year 2: ($800,000 - $200,000) × 25% = $150,000 → Year 3: ($600,000 - $150,000) × 25% = $112,500 → ... Asset: Tradename / Brand → Acquisition cost: $1,500,000 → Useful life: INDEFINITE (not amortized) → Annual impairment test required (ASC 350) → Amortization: $0 (test for impairment instead) AMORTIZATION CALENDAR (Monthly) ════════════════════════════════════════ Month | Customer Rel | Technology | Total Amortization ─────────┼──────────────┼─────────────┼─────────────────── Jan | $33,333 | $16,667 | $50,000 Feb | $33,333 | $16,667 | $50,000 ... | ... | ... | ... Dec | $33,333 | $16,667 | $50,000 Accumulated Amortization (end of Year 1): $600,000 Net Book Value (end of Year 1): $2,200,000 ``` 4. **Build Deferred Cost Amortization Schedule** - Amortize capitalized costs: ``` DEFERRED COST AMORTIZATION ════════════════════════════════════════ Deferred Financing Costs: → Legal fees, underwriting, arrangement fees: $150,000 → Related loan term: 5 years (60 months) → Amortization method: Effective interest method (align with debt) → Or: Straight-line if not materially different → Monthly: $150,000 / 60 = $2,500 → Present as reduction of interest expense (contra-expense) → Balance sheet: Other assets (current and non-current portions) Capitalized Customer Acquisition Cost (CAC): → Sales commissions capitalized: $500,000 → Customer contract term: 3 years (36 months) → Amortization: $500,000 / 36 = $13,889/month → Standard: ASC 340-40 (revenue contracts) → Amortize over period of benefit (contract term + renewal periods if probable) Prepaid Expenses: → Annual insurance premium: $120,000 (paid Jan 1) → Amortization: $120,000 / 12 = $10,000/month → Balance sheet: Prepaid expense (current asset) Journal Entry (Monthly): DR Amortization Expense $13,889 CR Deferred Cost / Capitalized CAC $13,889 ``` 5. **Build Bond Premium / Discount Amortization** - Amortize bond differences using effective interest method: ``` BOND PREMIUM / DISCOUNT AMORTIZATION ════════════════════════════════════════ Scenario: Company issues $1,000,000 bond at 95 (discount) → Face value: $1,000,000 → Issue price: $950,000 (95% of face) → Coupon rate: 5% (stated rate on bond) → Market rate: 6% (effective rate at issuance) → Term: 5 years, semi-annual payments → Discount to amortize: $50,000 Semi-annual coupon payment: $1,000,000 × 5% × 6/12 = $25,000 ════════════════════════════════════════ Period | Carrying Value | Interest Expense | Cash Paid | Amortization | New CV ───────┼────────────────┼──────────────────┼───────────┼──────────────┼───────── 0 | $950,000 | — | — | — | $950,000 1 | $950,000 | $28,500 | $25,000 | $3,500 | $953,500 2 | $953,500 | $28,605 | $25,000 | $3,605 | $957,105 3 | $957,105 | $28,713 | $25,000 | $3,713 | $960,818 ... | ... | ... | ... | ... | ... 10 | $996,339 | $29,891 | $25,000 | $4,891 | $1,000,000 Interest expense = Carrying value × market rate × period Amortization = Interest expense - Cash paid New CV = Prior CV + Amortization (for discount) At maturity: Carrying value = Face value ($1,000,000) ✓ ``` 6. **Validate and Reconcile Amortization Schedules** - Ensure accuracy and compliance: ``` AMORTIZATION VALIDATION CHECKLIST ════════════════════════════════════════ → Total amortized = Original amount (or original - residual value) → Final balance = $0 (for fully amortized items) or residual value → Monthly/periodic amounts are consistent with selected method → Amortization period aligns with economic life (not arbitrary) → Impairment review performed if carrying value > recoverable amount → Changes in useful life accounted for (prospective adjustment) → Disclosure in financial statement notes: · Gross carrying amount · Accumulated amortization · Amortization expense for the period · Remaining useful life by asset category · Material assumptions in useful life estimation ``` 7. **Handle Mid-Period and Change-in-Circumstance Adjustments** - Manage schedule modifications: ``` MID-PERIOD AND CHANGE ADJUSTMENTS ════════════════════════════════════════ New Asset Mid-Period: → Prorate first month: Full monthly amount × (days remaining / days in month) → Or: Half-year convention (tax) / mid-month convention Early Loan Payoff: → Calculate remaining principal at payoff date → Prepayment penalty (if applicable per loan agreement) → Write off unamortized deferred financing costs → Record gain/loss on extinguishment: Gain/Loss = Carrying value of debt - Payoff amount Change in Useful Life (Intangible Assets): → Prospective adjustment (no restatement) → New monthly amortization = Remaining book value / Remaining months → Document reason for change Impairment of Amortized Asset: → Test: Carrying value > Recoverable amount (higher of FV-costs-to-sell or value-in-use) → If impaired: Write down to recoverable amount → Amortize reduced carrying value over remaining life → Impairment loss is separate from regular amortization ``` ## Integration Points - **ERP/GL**: SAP, Oracle, NetSuite (fixed asset modules, deferred cost tracking) - **Fixed Asset Software**: SAP FM, Oracle FA, Ramco, AssetCloud - **Loan Management Systems**: LoanServ, Caliber, NCR LoanPro - **Treasury Management**: Kyriba, Treasurix, SAP Treasury - **Accounting Systems**: QuickBooks, Xero, Sage - **Financial Modeling**: Excel, Adaptive Insights, Anaplan - **Close Management**: BlackLine, FloQast (amortization reconciliation) ## Edge Cases & Handling ``` EDGE CASES ═══════════════════════════════════════ 1. Indefinite-Life Intangible Assets → NOT amortized (trademarks, goodwill, some patents) → Annual impairment testing required → If life becomes finite: Begin amortization prospectively 2. Loan Restructuring / Modification → Evaluate as troubled debt restructuring (TDR) vs. non-TDR modification → If TDR: Recalculate effective rate, recognize loss → If not TDR: Continue with modified terms, adjust schedule prospectively 3. Multiple Currency Amortization → Amortize in functional currency → Translate at appropriate rate (spot for BS, average for IS) → Record FX gain/loss on monetary items 4. Acquisition-Dated Amortization (Purchase Price Allocation) → Intangibles identified in PPA amortized from acquisition date → Not from original creation date → Useful life based on remaining economic life at acquisition ``` ## Conversation Examples ### Loan Amortization Request ``` User: "We're taking a $2M term loan at 7.25% for 7 years. Can you build the amortization schedule and tell me the payment?" AI: "Here's your loan amortization: Loan Parameters: → Principal: $2,000,000 → Rate: 7.25% annual → Term: 84 months (7 years) → Monthly payment: $28,697 Summary: → Total payments: $2,410,589 → Total interest: $410,589 → Interest as % of total: 17.0% Year-by-Year Breakdown: Year 1: Principal $254,632 | Interest $95,553 | End balance $1,745,368 Year 2: Principal $273,405 | Interest $76,780 | End balance $1,471,963 Year 3: Principal $293,673 | Interest $56,512 | End balance $1,178,290 Year 4: Principal $315,525 | Interest $34,660 | End balance $862,765 Year 5: Principal $339,074 | Interest $11,111 | End balance $523,691 Year 6: Principal $364,478 | Interest ($14,293)* | End balance $159,213 Year 7: Principal $159,213 | Interest ($35,577)* | End balance $0 *Negative interest shown means principal pays down faster than equal-payment baseline Cash flow impact: $28,697/month from operating cash flow Debt service coverage: Need EBITDA > $28,697 × 12 / DSCR requirement (typically 1.25x) → Required annual EBITDA: > $431,000 Want me to model scenarios with balloon payment, bi-weekly, or extra payments?" ``` ### Intangible Asset Amortization ``` User: "We acquired a company and the PPA identified $5M in customer relationships, $2M in technology, and $1M in tradename. How do we amortize these?" AI: "Here's your PPA intangible asset amortization plan: 1. Customer Relationships ($5M): → Useful life: 5-7 years (based on customer attrition analysis) → Method: Straight-line → Annual amortization: ~$714K-$1,000K → DR Amortization Expense, CR Accumulated Amortization 2. Technology / Patents ($2M): → Useful life: 8-10 years (tech lifecycle, legal protection period) → Method: Declining balance (2x) if front-loaded benefit, otherwise straight-line → Annual amortization (SL): $200K-$250K → Accelerated method front-loads expense 3. Tradename / Brand ($1M): → Assessment: Indefinite life vs. finite life → If indefinite: NOT amortized (annual impairment test only) → If finite (e.g., market-specific, declining brand): 10-15 year life → Annual amortization (if 10yr): $100K Impact on P&L: → Year 1 total amortization: $914K-$1,250K (depending on tradename assessment) → This is ABOVE operating income (reduces reported profit) → But it's a non-cash expense (add back for cash flow, EBITDA) Key considerations: → Tax deduction: Amortization is generally tax-deductible (Section 197) → Financial reporting: Disclose useful life assumptions and methodology → Audit: Be prepared to defend useful life estimates with market data Want me to build the detailed monthly amortization schedule?" ```