Rental Property Calculator Spreadsheet, Real Estate Investment Analysis for Excel & Google Sheets, Cap Rate, Cash on Cash, DSCR, 1% Rule
NowPrice:$8.00
Original Price: $10.00
20% off
Sale ends on December 9
You can only make an offer when buying a single item
Highlights
Is this rental worth a second look? Find out in about two minutes.
INSTANT DIGITAL DOWNLOAD. A spreadsheet (works in Excel and Google Sheets). No physical item will be shipped.
Enter the purchase price, rent, expenses and loan terms in the yellow cells. The one-tab screener calculates NOI, cap rate, cash-on-cash return, DSCR, the 1% rule and monthly cash flow, then scores the deal PASS or MISS against YOUR targets and tells you the price that would hit your cap-rate goal.
━━━ WHAT'S INSIDE ━━━
• Analyzer tab: inputs on the left, results on the right
• Income & expenses: gross rent, vacancy, taxes, insurance, utilities/HOA, maintenance, management and capex reserve → NOI
• Financing & cash: loan amount, monthly mortgage payment, total cash invested, annual and monthly cash flow, expense ratio, break-even occupancy
• Scorecard: cap rate, cash-on-cash, DSCR, 1% rule and monthly cash flow vs. your targets, with an overall verdict
• Start_Here tab with instructions and a color key
• Fictional sample deal so you can see how it works
━━━ WHO IT'S FOR ━━━
• New and growing rental property investors
• House hackers and first-time landlords
• Agents who want a quick, clean numbers sheet for buyers
━━━ WHAT YOU GET ━━━
1 zip file containing:
• 1 spreadsheet (.xlsx) with real, working formulas (formula cells locked, yellow input cells open; no password)
• 1 quick-start PDF guide
━━━ HOW TO OPEN IT ━━━
1. After purchase, go to Etsy › You › Purchases and reviews and click "Download Files".
2. Unzip the file.
3. Open the .xlsx in Excel, or in Google Sheets with File › Import › Upload.
━━━ READY FOR MORE? ━━━
When a deal passes the screen, take it further with the Multifamily Value-Add Acquisition Model in my shop (10-year pro forma, renovation ramp, IRR and exit what-ifs). Buying net-lease retail? See the NNN Net Lease Deal Analyzer, also in the shop.
━━━ PLEASE NOTE ━━━
• Digital file only; due to the nature of digital downloads, all sales are final. If something isn't working, message me and I'll help.
• Educational screening tool, not investment, lending, tax or legal advice.
• Single-user license. Please do not resell or share the file.
Created by Kyle H, CFA · JENCPTemplates
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
Reviews for this item
Useful and easy to use and clear.
More from this shop
Visit shop-
Digital download
Debt Payoff Planner Spreadsheet, Debt Snowball and Avalanche Calculator, Debt Free Date and Interest Saved, Excel & Google Sheets Tracker
Sale Price $5.60
Original Price $7.00
-
Digital download
Buy a Business Calculator, SBA 7a Loan Quick Screener Spreadsheet, SDE Multiple, DSCR, Max Purchase Price and Red Flag Checklist, Excel
Sale Price $16.00
Original Price $20.00
-
Funny Excel Mug, IFERROR Coffee or Nap Spreadsheet Coffee Cup, Accountant Gift, Data Analyst Coworker Gift, Office Humor 11oz
Sale Price $17.59
Original Price $21.99
-
Digital download
Business Acquisition Model Excel, SBA 7a Loan Calculator for Buying a Business, SDE Valuation, DSCR, Cash on Cash and Payback Spreadsheet
Sale Price $63.20
Original Price $79.00
-
Digital download
Real Estate Investor Bundle | Loan Comparison, DSCR Calculator, Property Analyzer, Multifamily Proforma, and More! | Excel & Google Sheets
$13.99
-
Digital download
Rental Property Calculator Spreadsheet Investment Property Analysis Mortgage Calculator Airbnb Real Estate Excel Google Sheets ROI Cap Rate
Sale Price $8.95
Original Price $12.79
-
Digital download
Rental Property Quick Analysis Tool: Excel Spreadsheet Calculator Template w/ Real Estate Investment ROI, Cap Rate, Cash on Cash, Cash Flow
$12.96
-
Digital download
Rental Property ROI Calculator Excel | Real Estate Investment Analyzer, Cash Flow, Cap Rate, IRR, DSCR, Mortgage Schedule & Dashboard
$19.90
-
Digital download
Rental Property Investment Calculator Spreadsheet Excel Google Sheets With Mortgage Calculator and ROI
Sale Price $9.35
Original Price $17.00
-
Digital download
Property Investment All in One Excel - Rental Property Analysis | Mortgage Calculator | Performance Forecast | Cash Flow, ROI, ROE, Cap Rate
$14.03
-
Digital download
Property Investment All in One Excel w/ Grants - Rental Property Analysis | Mortgage Calculator | Performance Forecast | Cash Flow, Cap Rate
$15.79
-
Digital download
Rental Property - Real Estate Investment Calculator - Microsoft Excel
$14.99
-
Digital download
Rental Property Investment Calculator Spreadsheet Excel Google Sheets With Mortgage Calculator and ROI
Sale Price $9.35
Original Price $17.00
-
Digital download
Rental Property Analyzer Spreadsheet | Single-Family Rental Deal Calculator | Cash Flow, ROI, Amortization, Exit Analysis
$12.99
-
Digital download
Rental Property Calculator | Real Estate Investment Tool | Landlord Spreadsheet | Rental Cashflow Tracker | Google Sheets Template
$14.58
-
Digital download
Investment Property Calculator | Cash Flow & ROI Analysis (Excel + Google Sheets)
$9.99
Shoppers with similar taste loved these
-
Digital download
New Home Expense Tracker: Google Sheets Budget Template (Digital Download)
Sale Price $3.90
Original Price $6.00
-
Digital download
Property Flipping Tracker | House Flip Template | Cost & Profit Analysis Budgeting Scope of Work Worksheets Google Sheets Excel Spreadsheet
$12.99
-
Digital download
House Flip Tracker, House Flip Spreadsheet, Property Flipping, Property Management, Renovation Cost, House Flip Budget, MS Excel
$4.42
-
Digital download
House Flipping Calculator: Real Estate Property Budget Planner Excel & Google Sheets Digital Download
$9.99
-
Digital download
Home Renovation Planner, Home Improvement Planner For DIY Projects, Renovation Checklist, Renovation Budget, Interior Design, House Remodel
Sale Price $4.15
Original Price $6.91
-
Digital download
Annual Investment Property Template for Short and Long Term Rentals, Income & Deductible Expense Tracker, Spreadsheet Dashboard Excel
$10.52
-
Digital download
Airbnb Welcome Book Canva Template: Home Rental Guide (Digital)
Sale Price $2.01
Original Price $2.87
-
Digital download
Property Cashflow Calculator | Investment Property Spreadsheet
$4.88
-
Digital download
Real Estate Canva Website | Real Estate Agent Website | Canva Website Template | Business Website | Real Estate Marketing | Link In Bio
Sale Price $30.55
Original Price $47.00
-
Digital download
Rental Application Form, Landlord Rental Application, Tenant Rental Application, Lease Application, Printable Rental Application, MS Word
$1.89
-
Digital download
House Flipping Calculator And Ebook
$19.99
-
Digital download
Minimalist Rental Home Welcome Sign: Airbnb Host Template (Digital Download)
Sale Price $0.80
Original Price $1.15