Free template

Hold, sell or refinance analyzer

Is your equity working? Compare keeping a property, selling it and doing a cash-out refinance over 1 to 10 years, with the loan payoff, prepayment penalty and taxes counted.

Excel, Sheets, Numbers
Sample property included
6 tabs

Get the template

Inside the workbook

What you get, tab by tab

Tab 1

Dashboard

Recommendation, KPIs, path ranking, ending wealth by exit year, breakevens and plain-English insights.

Tab 2

Paths

Annual cash flows, sale and tax math, ending wealth and IRR flows for Hold, Sell and Refinance.

Tab 3

Debt Schedules

Refinance sizing plus month-by-month schedules for the existing loan (with the maturity refinance) and the new loan.

Owner Summary

A one-page white-label summary for a partner, investor or lender.

Inputs

Property, value, existing loan, refinance terms, taxes, horizon, and capex and prepayment schedules by year.

Built for

Who it is for

Owners who have held a property for years
Partners deciding on an exit
Owners weighing a cash-out refinance

Want a quick number first? Try the Building value estimator.

How to use it

Up and running in five steps

1Enter the property name, analysis date and unit count on the Start Here tab.
2On Inputs, enter current NOI and growth, how to value the property, your existing loan (with its prepayment terms and maturity), planned capex by year and your tax position. The sample values are inputs: overwrite them.
3Set the cash-out refinance terms a lender would quote you today: max LTV, min DSCR, min debt yield, rate, amortization, interest-only months and closing costs.
4Pick the analysis horizon, exit cap rate and the yield you could earn on sale proceeds elsewhere. Turn the 1031 exchange and taxes on or off to see each case.
5Read the Dashboard: the recommendation, ranking, lazy-equity return and breakevens. Check Paths and Debt Schedules for the math behind every number, then print the Owner Summary.

Rather have us run the numbers?

Send us your rent roll and T12 and we will build this for your property and show you what it says.

Talk to us (775) 502-8287

Questions

Hold / Sell / Refinance Analyzer questions

What is lazy equity?

Equity that earns less than it could elsewhere. The workbook divides this year's cash flow by what you would actually walk away with if you sold today, after the loan, penalties, selling costs and taxes.

Does it include taxes and prepayment penalties?

Yes. Prepayment terms, selling costs and your tax position are inputs, and you can turn a 1031 exchange on or off to see each case.

How does it make a recommendation?

Each path runs to a sale at your exit cap rate, and the workbook ranks them on ending wealth and return, with the breakevens behind the call.