Rental Property Portfolio Tracker Spreadsheet, Real Estate Net Worth & Equity Dashboard, Mortgage Balance, Cash Flow, Excel Google Sheets

See your whole rental portfolio – and your net worth – on one page. A rental property portfolio tracker and net worth dashboard for landlords and real estate investors that works in Microsoft Excel AND Google Sheets. Enter each property and each loan once and it works out today's mortgage balances, equity, LTV, cash flow, cap rate and cash-on-cash return, for the US, Canada or anywhere else (the currency is just a label).

Built for up to 15 properties and 30 loans (mortgages, HELOCs, private loans), with US monthly and Canadian semi-annual compounding.

★ WHAT YOU GET
• DASHBOARD – 12 numbers at a glance: portfolio value, total debt, equity, LTV, cash flow per month, NOI, cap rate, cash-on-cash, net worth, borrowing room at your max LTV, principal paid down in the next 12 months and appreciation since purchase. Every property side by side with its next key date, plus a debt-vs-equity chart and a monthly cash flow chart.
• PROPERTIES – one row per property: type, units, purchase price and date, closing costs, improvements, today's value and where it came from, ownership %, rent, vacancy, taxes, insurance, HOA / condo fees, utilities, reserves, management, appreciation %, insurance renewal and property-tax due dates. NOI, cash flow, cap rate, cash-on-cash, equity, LTV and borrowing room are worked out for you.
• LOANS – one row per loan: lender, type, original amount, first payment date, rate, amortization (blank = interest-only HELOC), compounding, renewal / maturity date. Today's balance, payment, payments left, principal and interest for the next 12 months and days to renewal are calculated – or type the balance from your statement and it's used instead. Optional monthly payment override if you pay a different amount.
• 10-YEAR PROJECTION – value, debt, equity, LTV, NOI, loan payments and cash flow year by year, with a debt-and-equity chart.
• NET WORTH – a personal balance sheet: your share of the real estate and property loans comes in automatically; add cash, investment and retirement accounts (401(k), IRA, RRSP, TFSA, Roth IRA), vehicles, business interests, credit cards, car and student loans. Shows debt-to-asset ratio and real estate as a % of assets.
• SCHEDULE OF REAL ESTATE OWNED – the property list mortgage lenders ask for (address, type, units, date acquired, price, value, loan balance, lender, payment, gross rent, taxes / insurance / HOA, net cash flow), ready to print or save as a PDF.
• SNAPSHOTS – copy today's totals once a quarter and watch your net worth and equity grow (change, % change and a chart, up to 40 snapshots).
• KEY DATE ALERTS – loan renewals and maturities (120 days ahead by default), insurance renewals and property-tax due dates (60 days), negative cash flow and LTV above your limit.
• CHECK COLUMNS that flag missing names, duplicate properties, loans for a property that isn't listed, missing rates or dates and text typed into number cells – the Dashboard counts them for you
• START HERE guide with plain-English definitions – set up in about 15 minutes

★ HOW IT WORKS
1. Download the .xlsx file instantly after purchase (Etsy › Purchases › Download Files).
2. Open in Excel – or upload to Google Drive and choose File › Save as Google Sheets.
3. Pick your currency and compounding on Settings, delete the clearly marked SAMPLE data, and add your properties and loans.

★ DETAILS
• Digital download – nothing will be shipped
• File: 1 × .xlsx (Excel 2010+ / Google Sheets; no macros, no add-ons, no subscription)
• Up to 15 properties, 30 loans and 40 snapshots; works with any currency
• Balances and key dates use today's date, or an as-of date you set
• Tested formula-by-formula against an independent payment-by-payment mortgage model, with sample data, cleared data, overrides, paid-off and future loans and edge cases – in LibreOffice and live in Google Sheets
• Not accounting or investment software, and not connected to any bank, lender or valuation service – values are what you enter

★ AI DISCLOSURE
This template was designed by me with the help of AI tools (for drafting formulas, layout and text), then reviewed and tested before listing.

★ IMPORTANT
This is a record-keeping and estimating tool, not financial, investment, lending, tax, legal or accounting advice. Values, balances, projections and borrowing room are estimates based on what you enter – your lender's statement and an appraisal are what count, and borrowing room is not a loan offer. General notes only: Fannie Mae's eligibility matrix allows up to 75% LTV for a cash-out refinance of a 1-unit investment property and 70% for 2–4 units; in Canada, OSFI guideline B-20 limits the revolving HELOC part to 65% of the property value and federally regulated lenders cap uninsured borrowing at 80% in total; and the federal Interest Act requires blended-payment mortgages to state the rate calculated yearly or half-yearly, not in advance (which is why Canadian fixed-rate mortgages are usually compounded semi-annually). Lenders set their own rules and they change – please check with your lender or a qualified professional.

Licence: for your own properties. Please don't resell or share the file. Digital items can't be returned – but if anything doesn't work, message me and I'll fix it.