Mortgage Analysis Report
Loan Details
Home Price
$450,000
$
Down Payment?
20%
%
Interest Rate?
6.75%
%
FHA Loan
1.75% upfront MIP + 0.85% annual
Monthly Costs
Property Tax /mo?
$350
$
Homeowners Ins /mo?
$120
$
HOA /mo?
$0
$
PMI Estimate?
Credit Score?
740
MGIC Est: —
%PMI applies when down < 20%.
DTI Analysis? (optional)
Enter income & debts to see your debt-to-income ratio. Both fields are optional — leave blank to skip.
$
$
Include: car payments, student loans, credit card minimums, child support. Exclude: utilities, groceries, insurance.
Payment Breakdown
Loan Summary
Payment Composition
PrincipalInterest
| Month | Payment | Principal | Interest | Balance |
|---|
Income & Debts
Gross Monthly Income
$8,500
$
Monthly Debts
$500
$
Interest Rate
6.75%
%
Property Tax /mo
$350
$
Insurance /mo
$120
$
HOA /mo
$0
$
%
%
You Can Afford
Maximum Purchase Price
—
DTI Analysis
Loan Amount
$400,000
$
Base Rate
7.25%
%
pts
Buydown Scenarios
| Scenario | Yr 1 Rate | Yr 1 Pmt | Yr 2 Rate | Yr 2 Pmt | Yr 3+ Rate | Yr 3+ Pmt | Cost | Break-Even? |
|---|
Year 1 Savings vs. No Buydown
Property & Loan
Purchase Price
$350,000
$
Interest Rate
7.50%
%
%
Income & Expenses
Monthly Rent
$2,800
$
Property Tax /mo
$300
$
Insurance /mo
$150
$
%
%
$
$
DSCR Analysis
Debt Service Coverage Ratio
—
Investment Metrics?
Current Loan
Remaining Balance
$320,000
$
Current Rate
7.50%
%
New Loan
New Rate
6.25%
%
$
Refinance Analysis
Long-Term Comparison
Break-Even Timeline
Sale Details
Sale Price
$550,000
$
Loan Balance
$280,000
$
Selling Costs
%
%
$
$
$
$
Seller's Net Sheet
Equity Summary
Purchase Details
Home Price
$450,000
$
Interest Rate
6.75%
%
Monthly Rent
$2,200
$
%
%
%
%
$
$
%
%
Results
Year-by-Year
| Yr | Buy Equity | Rent Portfolio | Difference |
|---|
Loan Details
Home Price
$450,000
$
Down Payment
20%
%
Interest Rate
6.75%
%
Extra Payment (Optional)
Extra per Payment?
$0
$
Standard vs Bi-Weekly
Your Savings
Payoff Timeline
What's Your Comfortable Payment?
Set your target monthly payment and we'll work backwards to show what you can afford — max home price, required income, and ideal down payment.
Target Monthly Payment (PITI)?
$2,500
$
Loan Assumptions
Interest Rate
6.75%
%
Down Payment
20%
%
Monthly Cost Assumptions
$
$
$
You Can Afford
Maximum Home Price
—
Breakdown
Income Required by DTI
Down Payment Scenarios





