{"product_id":"rental-property-analyzer-cash-flow-cap-rate-cash-on-cash-dscr-rent-comps-5-year-projection-brrrr-refinance-and-deal-compare-excel-google-sheets","title":"Rental Property Analyzer: Cash Flow, Cap Rate, Cash-on-Cash, DSCR, Rent Comps, 5-Year Projection, BRRRR Refinance and Deal Compare (Excel + Google Sheets)","description":"\u003cp\u003eRun the numbers on a rental before you make an offer. Enter the price, rent, costs and loan, and see monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR and gross rent multiplier, plus a 5-year projection, an optional BRRRR refinance, a 4-property compare and what-if tables.\u003c\/p\u003e\u003cp\u003eBuilt for small landlords and people buying their first or next rental (1-4 units).\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWHAT IT DOES\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eProperty Analyzer: year-1 income, vacancy, every operating cost, NOI, loan payment, monthly and yearly cash flow, cash invested, cash-on-cash, cap rate, DSCR, GRM and break-even occupancy. A simple grade (A-F) and pass\/fail against your own targets.\u003c\/li\u003e\n\u003cli\u003eRent Comps: up to 8 nearby rentals. Adjust each for size, bedrooms, bathrooms and condition, switch any comp off, and use the adjusted average, the median or rent per sq ft. Shows the low-high spread and can round the result down.\u003c\/li\u003e\n\u003cli\u003eExpenses: property tax, insurance, HOA, owner-paid utilities, lawn and snow, pest control and other costs, plus vacancy, management, leasing fees, maintenance and a capital reserve. Each by year, by month and as a share of gross income. Leave a percentage blank to use your default, or type your own.\u003c\/li\u003e\n\u003cli\u003eFinancing: cash or loan, down payment, rate, term, points and closing costs. Monthly payment, payment with tax, insurance and HOA, cash to close, year-1 principal and interest, and the loan balance after 5 years.\u003c\/li\u003e\n\u003cli\u003eOptional BRRRR refinance: new loan from the after-repair value and your loan-to-value, refinance costs, cash back, cash left in the deal, new payment and cash flow, and a seasoning check.\u003c\/li\u003e\n\u003cli\u003e5-Year Projection: rent growth, expense growth, appreciation and principal paydown. Cash flow, equity and what you would net if you sold at the end of each year, with total profit, IRR and a simple average yearly return.\u003c\/li\u003e\n\u003cli\u003eDeal Compare: four properties side by side under the same settings, graded and ranked by cash-on-cash.\u003c\/li\u003e\n\u003cli\u003eSensitivity: monthly cash flow as rent and price change, and cash-on-cash as rent and the interest rate change. You pick the step sizes.\u003c\/li\u003e\n\u003cli\u003eThe 1% rule and the 50% rule are shown as quick screens only, next to your real numbers.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eWHAT'S INCLUDED\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e1 .xlsx workbook with 9 tabs: Start Here, Settings, Property Analyzer, Rent Comps, Expenses, Financing, 5-Year Projection, Deal Compare, Sensitivity\u003c\/li\u003e\n\u003cli\u003eA short buyer guide (PDF) with setup steps, plain-English definitions, where to find your inputs and how to open it in Google Sheets\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eIn Settings, set your targets and default percentages for vacancy, management, maintenance and reserves.\u003c\/li\u003e\n\u003cli\u003eAdd rent comps, then enter the price, units, costs and loan.\u003c\/li\u003e\n\u003cli\u003eRead the results, then check the 5-year view, the what-if tables and Deal Compare.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eGOOD TO KNOW\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDigital download. Nothing is shipped.\u003c\/li\u003e\n\u003cli\u003eWorks in Microsoft Excel and Google Sheets (free Google account). Uses standard formulas only, with no macros and no add-ons. No tabs are locked.\u003c\/li\u003e\n\u003cli\u003eEvery default percentage, rate and threshold is an example you can change, not a standard or a recommendation. All addresses in the sample data are fictional.\u003c\/li\u003e\n\u003cli\u003eThe 5-year projection uses the growth rates you choose. It is not a forecast; rents, costs and values can also fall.\u003c\/li\u003e\n\u003cli\u003eIncome taxes and depreciation are not included.\u003c\/li\u003e\n\u003cli\u003eThis is an estimating tool. It is not financial, investment, tax, lending or legal advice, and it can't tell you whether a property will make money. Check your numbers with your lender and a qualified professional.\u003c\/li\u003e\n\u003cli\u003eMade by Expanse Ventures with help from AI tools. Every formula was recalculated and checked against a separate model before listing.\u003c\/li\u003e\n\u003cli\u003eBecause it's a digital file, we can't take returns. If a file doesn't work, message us and we'll fix it.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Expanse Ventures LLC","offers":[{"title":"Default Title","offer_id":50681715785831,"sku":null,"price":24.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0670\/6256\/2919\/files\/01-hero_44964933-75b5-4555-8b7a-20e7667e42fe.png?v=1793054966","url":"https:\/\/shop.expanseventuresllc.com\/products\/rental-property-analyzer-cash-flow-cap-rate-cash-on-cash-dscr-rent-comps-5-year-projection-brrrr-refinance-and-deal-compare-excel-google-sheets","provider":"Expanse Ventures LLC","version":"1.0","type":"link"}