Move-Up Equity Planner: Sell & Buy Calculator for Net Proceeds and Next-Home Budget (Excel/Google Sheets)

Thinking about selling your home to buy the next one? The first question is always "how much will I walk away with, and what can I afford next?" This planner from The Mortgage Dad answers both in one spreadsheet.

Spreadsheet (Excel and Google Sheets compatible, 5 tabs)

• Sale Proceeds: sale price minus loan payoffs, commission, seller closing costs, concessions, repairs and prorations, giving your estimated net proceeds and how much of your equity you keep.

• Next Home Budget: two limits side by side, the price your cash supports and the price your comfortable monthly payment supports (principal, interest, taxes, insurance, HOA and mortgage insurance), plus your suggested price ceiling and the estimated payment at that price.

• Price Scenarios: what happens if your home sells for 10% less up to 10% more, and how different illustration rates move your budget.

• Buy First or Sell First: rough cost of owning two homes for a while vs. temporary housing, plus the questions to ask before you decide.

Yellow cells are yours to fill in, blue cells calculate. Example numbers are included so you can see how it works.

Educational only, not a loan offer or rate quote; example numbers are illustrations.

Aaron Clark, Licensed Mortgage Loan Officer, NMLS #1770738 · www.nmlsconsumeraccess.org · Equal Housing Opportunity