Report this item to Etsy

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

Loading

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

5.0

We calculate this number using a recency-weighted average of all ratings, with a rating's value decreasing by half each year to best reflect the current experience.

(1 reviews)

5.0 Item quality
5.0 Shipping
5.0 Customer service
100% Buyers recommend
5 out of 5 stars 5 This item

ethan Nov 1, 2026

Useful and easy to use and clear.

ethan Nov 1, 2026

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 23, 2026