Generate a detailed loan amortization schedule showing principal, interest, and balance for every payment period
You are an experienced financial analyst who specializes in loan structuring and debt repayment planning. You have built amortization models for mortgages, auto loans, personal loans, student loans, and commercial financing. You understand the math behind fixed-rate and variable-rate schedules, and you know how to present repayment data in a format that borrowers, lenders, and accountants can all use with confidence. I need you to generate a complete amortization schedule based on the following loan details. Loan type: [LOAN_TYPE:select:Mortgage,Auto Loan,Personal Loan,Student Loan,Business Loan,Home Equity Loan,Other] Total loan amount (principal): [LOAN_AMOUNT] Annual interest rate: [INTEREST_RATE] Loan term: [LOAN_TERM] Payment frequency: [PAYMENT_FREQUENCY:select:Monthly,Biweekly,Weekly,Quarterly,Semi-Annual,Annual] Loan start date: [START_DATE] Interest compounding method: [COMPOUNDING:select:Monthly,Daily,Semi-Annually,Annually,Continuous] Extra payment per period (if any): [EXTRA_PAYMENT?] One-time lump sum payment amount and timing (if any): [LUMP_SUM_PAYMENT?] Currency: [CURRENCY?] Begin by calculating the standard periodic payment. If the periodic interest rate r is zero (a 0% loan), set PMT = P / n where P is the principal and n is the total number of payments. Otherwise use the amortization formula: PMT = P x [r(1+r)^n] / [(1+r)^n - 1], where r is the periodic interest rate. Show P, r, n, which formula branch was used, and the resulting payment clearly so I can verify the amount before reviewing the full schedule. Then produce a period-by-period amortization table. Each row should include the payment number, payment date, total payment amount, the portion applied to interest, the portion applied to principal, any extra payment applied, and the remaining loan balance after that payment. Start with the full [LOAN_AMOUNT] as the opening balance and end when the balance reaches zero. If the schedule exceeds 60 periods, show the first 12 and last 12 periods in full detail with annual summaries for the middle years showing total principal paid, total interest paid, and year-end balance. Note that the complete row-by-row schedule is available on request. After the table, provide a loan summary section that includes the total amount paid over the life of the loan, total interest paid, total principal paid, the effective interest cost as a percentage of the original loan amount, and the final payoff date. If [EXTRA_PAYMENT?] or [LUMP_SUM_PAYMENT?] values were provided, show a comparison between the standard schedule and the accelerated schedule. This comparison should display how many payments were eliminated, how many months or years were saved, the dollar amount of interest saved, and the new payoff date. Include an early payoff analysis that shows the remaining balance at the 25%, 50%, and 75% marks of the loan term. This helps the borrower understand how front-loaded the interest is in the early years versus how quickly principal reduces in the later years of the loan. If the [PAYMENT_FREQUENCY] and the [COMPOUNDING] method differ (for example, monthly payments with daily compounding or biweekly payments with monthly compounding), convert the nominal compounding rate to the effective rate per payment period before calculating each row. Explain the conversion method used so the numbers remain transparent. For the interest allocation in each period, compute interest on the outstanding balance at the start of that period using the periodic interest rate derived from the [INTEREST_RATE] and [COMPOUNDING] method. The principal portion is the difference between the total payment and the interest charge. Ensure the final payment is adjusted if needed so the balance reaches exactly zero without overpayment. Format the amortization table with consistent column widths and right-aligned numbers so dollar amounts and percentages are easy to scan. Round all monetary values to two decimal places. End with a brief interpretation section that explains the interest-to-principal ratio pattern across the life of the loan, when the crossover point occurs where principal payments begin exceeding interest payments, and any observations relevant to the specific [LOAN_TYPE] selected such as typical rate ranges, refinancing considerations, or tax deductibility of interest where applicable.
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessEvery loan comes with a cost beyond the amount you borrow, and an amortization schedule is the clearest way to see exactly where your money goes each payment period. It breaks down every single payment into the portion that reduces your principal balance and the portion that covers interest charges. Early in a loan, most of your payment goes toward interest. As the balance shrinks, the ratio flips and more of each payment chips away at the principal. Understanding this pattern is essential for making informed decisions about extra payments, refinancing, or early payoff.
This amortization schedule template produces a complete period-by-period repayment table for any loan type. Enter your [LOAN_AMOUNT], [INTEREST_RATE], [LOAN_TERM], and [PAYMENT_FREQUENCY] and the AI calculates each payment, interest charge, principal reduction, and remaining balance through the final payoff. It also supports [EXTRA_PAYMENT] and [LUMP_SUM_PAYMENT] inputs so you can instantly compare the standard schedule against an accelerated payoff plan and see exactly how much interest you save.
For a broader view of your financial position, pair this with the budget template to ensure your payment fits comfortably into your monthly plan. If you need to understand how loan obligations appear on your company books, the balance sheet template breaks down liabilities alongside assets and equity. Open this prompt in the Dock Editor to generate your custom amortization schedule and explore different payoff scenarios side by side.
Paste this prompt into ChatGPT, Claude, Gemini, or the Dock Editor. Fill in [LOAN_AMOUNT] with the total borrowed amount, [INTEREST_RATE] with your annual rate, and [LOAN_TERM] with the full duration. Select your [LOAN_TYPE] so the output includes context specific to mortgages, auto loans, or other financing.
Choose your [PAYMENT_FREQUENCY] and [COMPOUNDING] method. Most consumer loans use monthly payments with monthly compounding, but biweekly schedules or daily compounding change the math. The template adjusts automatically for any combination.
Enter an [EXTRA_PAYMENT] amount per period or a [LUMP_SUM_PAYMENT] with its timing. The output will show both the standard and accelerated schedules with a clear comparison of interest saved, payments eliminated, and the new payoff date.
Check the period-by-period table for accuracy against your lender statements. Use the loan summary section to confirm total interest cost and the early payoff analysis to see your balance at the 25%, 50%, and 75% marks of the term.
Change the [INTEREST_RATE] or [LOAN_TERM] and regenerate to compare how rate differences or shorter terms affect total cost. This is especially useful when evaluating refinancing options or choosing between 15-year and 30-year mortgage terms.
Map out every payment on a mortgage to understand total interest cost, compare 15-year versus 30-year terms, and calculate how much extra monthly payments can save over the life of the loan.
Plan cash flow around business loan repayments by generating a clear schedule that shows exactly when each payment is due, how much goes to interest versus principal, and when the debt will be fully retired.
Create client-ready amortization tables for loan comparison presentations, refinancing analysis, and debt payoff strategy sessions without building spreadsheets from scratch each time.
Visualize student loan repayment across different income-driven or standard plans to understand when the principal crossover point occurs and how even small extra payments accelerate the payoff timeline.
Discover more prompts that could help with your workflow.
Track daily and monthly expenses with categorized spending logs, trend analysis, and budget alerts for personal or business finances
Generate pro forma financial statements with revenue projections, expense forecasts, and multi-scenario analysis
Project how your savings grow over time with compound interest, regular contributions, and inflation adjustments
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.