Membership
One membership: every in-depth guide, plus the Deal Workspace. Templates are sold separately and bought once — see below.
Every in-depth guide across Mortgage, Insurance, Investment, Salary, Rent and Budget, plus the Deal Workspace — our per-property case file for tracking a purchase from pre-approval to closing.
- Every in-depth guide, across every category
- Deal Workspace — per-property case file, multi-deal comparison, and buying-journey checklist
- Unlimited saved calculations
- The full article library, always free
Total Investment Template
$24.99All three investment worksheets, each with its own combined Tips & FAQs tab, plus offline versions of both of the site's other investment calculators — nine tabs in one workbook with an index. It follows a property's whole life: cash-to-close tells you what getting in costs, the deal analyzer what one year looks like, the P&L tracker what the year you owned it actually did on Schedule E, the hold-period tab what the whole hold returns, and the roll-up what your portfolio looks like once there is more than one. The two calculator tabs are only available here.
- Index tab
- Rental property deal analyzer, plus a combined Tips & FAQs tab
- Rental P&L / Schedule E tracker, plus a combined Tips & FAQs tab
- Portfolio roll-up, plus a combined Tips & FAQs tab
- Investment cash-to-close calculator
- Hold-period total return calculator
Format: Excel (.xlsx)
Look inside
Preview only — scroll to read it. The file you download is fully editable.
| Total Investment Template | |
| The rental deal analyzer plus offline copies of the cash-to-close and hold-period calculators, in one workbook. Click a name below to jump straight to a tab, or use the tabs along the bottom of the window. Each tab works on its own; nothing here depends on you filling in another tab first. Blue cell… | |
| Worksheets | |
| ƒx | Gross rent through vacancy to NOI, then cap rate, cash flow, cash-on-cash and DSCR — with management charged on collected rent, the mortgage kept out of NOI, and a sanity panel that flags the omissions that flatter a deal. |
| ƒx | The year you actually own it, laid out line for line against IRS Schedule E — including the 27.5-year mid-month depreciation most landlords under-claim and the passive-loss allowance that decides whether you can use a loss at all. |
| ƒx | Ten properties on one page, with portfolio DSCR and loan-to-value — plus the concentration check a single property's page is structurally blind to: how much of you sits in one county, one carrier, or one repricing year. |
| Calculators | |
| Offline versions of the free calculators on calculatorbystate.com. | |
| ƒx | Every dollar you bring to the closing - transfer tax and who customarily pays it, lien recording tax, and the reserves nobody puts on an estimate. |
| ƒx | The whole hold rather than one year: cash flow, the principal your tenant retires, and the sale - with an honest test of whether the deal needs appreciation. |
| The three tabs are meant to be used in order: cash to close tells you what getting in costs, the deal analyzer tells you what one year looks like, and the hold-period tab tells you what the whole hold returns. A deal can pass any one of them and fail another. No tax effects appear anywhere in this… | |
| These worksheets are general planning tools, not financial, tax, or legal advice. Every figure you get out of them depends on the figures you put in — confirm real numbers with your lender, insurer, or advisor. For sourced, state-by-state data, see calculatorbystate.com. |
This template is general information, not financial, legal, or tax advice.