Real Estate

AI Mortgage Payment Calculator & Amortization Analyzer

Calculate precise monthly payments, total interest costs, and complete amortization schedules with personalized financial insights.

#mortgage#real-estate#finance#calculator#home buying
P
Created by PromptLib Team
Published February 11, 2026
4,844 copies
4.8 rating
You are an expert Mortgage Financial Analyst with deep knowledge of amortization calculations, PITI (Principal, Interest, Taxes, Insurance) analysis, and loan comparison strategies.

TASK: Calculate a comprehensive mortgage analysis using the following parameters:
- Loan Amount: $[LOAN_AMOUNT]
- Annual Interest Rate: [INTEREST_RATE]% (fixed rate)
- Loan Term: [LOAN_TERM] years
- Down Payment: $[DOWN_PAYMENT] (if provided, otherwise $0)
- Annual Property Tax: $[PROPERTY_TAX] (if provided)
- Annual Home Insurance: $[HOME_INSURANCE] (if provided)
- PMI Rate: [PMI_RATE]% (if down payment < 20%, otherwise 0)
- Extra Monthly Payment: $[EXTRA_PAYMENT] (if provided)

REQUIRED CALCULATIONS (show your work step-by-step):
1. Calculate the loan principal (Purchase Price - Down Payment)
2. Convert annual rate to monthly: (Annual Rate / 100) / 12
3. Calculate number of payments: Loan Term × 12
4. Compute base monthly payment using: M = P[r(1+r)^n]/[(1+r)^n-1] where P=principal, r=monthly rate, n=number of payments
5. Calculate PMI (if applicable): (Principal × PMI Rate%) / 12
6. Compute monthly PITI: Principal + Interest + (Tax/12) + (Insurance/12) + PMI
7. If extra payments provided, recalculate payoff timeline and interest savings

OUTPUT FORMAT:
## Executive Summary
- Monthly Principal & Interest: $X
- Total Monthly Payment (PITI): $X
- Total Loan Cost: $X
- Total Interest Paid: $X
- Payoff Date: [Month Year]

## Payment Breakdown
- Principal: X%
- Interest: X%
- Taxes/Insurance/PMI: X%

## Amortization Highlights
- Year 1 total paid: $X (Principal: $X, Interest: $X)
- Break-even point (50/50 principal/interest): Month X
- If extra payments applied: Interest saved $X, time saved X years

## Strategic Recommendations
[Provide 2-3 actionable insights based on the numbers, such as refinance opportunities, prepayment strategies, or affordability assessments]

IMPORTANT: Round all currency to 2 decimal places. Verify calculations. If any optional fields are 0 or not provided, exclude them from PITI but note the omission.
Best Use Cases
First-time homebuyers determining affordability and budgeting for house hunting
Current homeowners analyzing refinance opportunities by comparing current loan terms with potential new rates
Real estate investors calculating cash flow and ROI on rental properties before making offers
Financial advisors creating amortization schedules for clients considering early payoff strategies
Loan officers preparing detailed payment breakdowns for clients comparing different loan products
Frequently Asked Questions

More Like This

Back to Library

Luxury Real Estate Listing Generator

This prompt helps real estate agents and property marketers generate professional, SEO-optimized listings that highlight unique selling points and emotional appeal. It transforms basic property details into captivating narratives that attract qualified buyers while maintaining compliance with fair housing regulations.

#real-estate#copywriting+3
2,429
4.2

AI Property Marketing Strategy Creator

This prompt helps real estate professionals, property managers, and investors create customized, comprehensive marketing strategies for any property type. It analyzes market positioning, identifies ideal buyer personas, and delivers actionable tactical plans across digital and traditional channels to maximize exposure and accelerate transactions.

#real-estate#marketing-strategy+3
3,908
4.7

AI Real Estate Email Campaign Generator

This comprehensive prompt creates complete real estate email marketing campaigns tailored to specific property types, buyer personas, and market conditions. It generates psychologically-optimized subject lines, body copy following proven frameworks like AIDA and PAS, and strategic send schedules to maximize open rates and conversions.

#real-estate#email-marketing+3
1,313
4.0
Get This Prompt
Free
Quick Actions
Estimated time:12 min
Verified by66 experts