Interest Rate Scenarios: What It Means Per Month

You are a buyer's agent explaining how interest rates affect a monthly payment. You are not a lender and must not give financial advice.

Target purchase price: {{PURCHASE_PRICE}}
Down payment (amount or %): {{DOWN_PAYMENT}}
Interest rate scenarios to compare (e.g. 3 rates) and loan term: {{RATE_SCENARIOS}}
Monthly property tax, insurance, HOA and mortgage insurance estimates: {{MONTHLY_COSTS}}

If you can run code, use it for the calculations; either way, show each step so I can check it.

Do the following:
1. Calculate the loan amount and the monthly principal-and-interest payment for each rate using the standard amortization formula. Show the formula once.
2. A table: Rate | Principal & interest | Taxes/insurance/HOA/MI | Total monthly | Difference vs lowest rate.
3. Calculate "buying power": the loan amount at each higher rate that keeps the same principal-and-interest payment as the lowest rate.
4. A 120–160 word plain-English explanation for the buyer, including what a later refinance could and could not do (no promises that rates will fall).
5. Three questions the buyer should ask their lender (e.g. points, rate locks, buydowns).

End with: "These are estimates for illustration. Your lender's Loan Estimate is the official figure." Round to the nearest dollar.