NNN Triple Net Lease Calculator Excel, Net Lease Investment Analyzer, Commercial Real Estate IRR and Cap Rate, 1031 Exchange Buyer Tool
NowPrice:$47.20
Original Price: $59.00
20% off
Sale ends on December 9
You can only make an offer when buying a single item
Highlights
A net lease looks simple until the tenant leaves. This analyzer shows the base case and the risk case side by side.
INSTANT DIGITAL DOWNLOAD for Microsoft Excel (2016+ / Microsoft 365). No physical item will be shipped.
Enter rent, firm term left, scheduled increases and renewal options, then what a vacancy would cost (downtime, replacement rent, re-leasing and carrying costs). The Summary gives a short answer, a pass/miss scorecard against your IRR, cash-on-cash and DSCR targets, a lease snapshot, sources and uses, a pro-rata split for up to 4 partners, and an exit-cap what-if table. A cap-rate penalty applies at sale when firm term left is short. The sample deal lands just under its cash-on-cash target so you can see the scorecard flag it.
Built by Kyle H, CFA (JENCP LLC). I have 10+ years of experience in finance.
━━━ WHO IT'S FOR ━━━
• 1031 exchange buyers and first-time net lease investors
• Small partnerships buying a single-tenant property
• Brokers who want a clean buyer worksheet with a lease abstract
━━━ WHAT'S INSIDE (6 TABS) ━━━
• Start_Here: quick start, how it works, simplifications, disclaimer, version and license
• Summary: short answer, scorecard, lease snapshot, sources and uses, partner split, exit-cap what-ifs and a chart
• Inputs: property, tenant and guarantee, rent and options, tenant-leaves scenario, landlord costs, financing, exit, partners (with a 100% ownership check) and targets
• Cash_Flow: rent, NOI, debt, cash flow, sale and IRR by year for the base and risk cases
• Lease_Abstract: key lease terms in one place
• Diligence: a net lease diligence checklist with status
━━━ WHAT YOU GET ━━━
• 1 .xlsx workbook (formula cells locked, yellow input cells open; no password)
• Fictional sample data so you can see how it works before entering your own
• 1 PDF preview of the key tabs
━━━ HOW TO OPEN IT ━━━
1. After purchase, go to Etsy › You › Purchases and reviews, and click "Download Files" (you'll also get an email link).
2. Save the .xlsx file to your computer.
3. Open it in Microsoft Excel 2016 or later / Microsoft 365 (desktop recommended).
4. Start on the Start_Here tab, then replace the sample numbers in the yellow cells.
━━━ GOOD TO KNOW ━━━
Annual periods. No income taxes, depreciation, cost segregation or 1031 modeling. Options are treated as firm once exercised. Tenant credit is not scored — use the guarantee and the risk case to judge it.
━━━ LICENSE ━━━
Single-user license: one named user (an individual investor or one seat at a firm), unlimited properties for your own analysis. You may share outputs with lenders, partners and advisers. You may not resell, sublicense, redistribute or publish the workbook or any derivative of it. © 2026 JENCP LLC. All rights reserved.
━━━ REFUNDS ━━━
Because this is a digital download, all sales are final and no refunds, returns or exchanges are offered. If you have trouble opening the file, message me and I'll help.
━━━ DISCLAIMER ━━━
Not investment, legal or tax advice. Educational use only. Results are hypothetical and depend entirely on your inputs. Example figures are fictional. Verify all figures with the lease and property records and consult a licensed broker, lender, attorney and tax professional.
Questions? Send me a message on Etsy.
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
Be the first to review this item
More from this shop
Visit shop-
Digital download
Seller Financing Calculator Spreadsheet, Owner Financing Balloon Payment and Seller Note Amortization Schedule, Excel & Google Sheets
Sale Price $9.60
Original Price $12.00
-
Digital download
NYC Rent Stabilized Building Excel Model, New York Landlord Cash Flow and Breakeven Rent Forecast, Multifamily Pro Forma Spreadsheet
Sale Price $63.20
Original Price $79.00
-
Digital download
Multifamily Underwriting Model Excel, Apartment Building Value Add Pro Forma, 10 Year IRR, Cap Rate and DSCR Real Estate Calculator
Sale Price $71.20
Original Price $89.00
-
Digital download
Real Estate Investor Spreadsheet Bundle, Rental Property Calculator, BRRRR, House Hack and Seller Financing, Excel & Google Sheets
Sale Price $23.19
Original Price $28.99
-
Digital download
Real Estate Investment Profitability Calculator in Excel | Analyze Up to 5 Deals | Digital download
$74.63
-
Digital download
Real Estate Investment Calculator: Excel Spreadsheet, ROE, IRR (Digital Download)
$76.93
-
Digital download
RealEstate Valuation Calculator in Excel | Investment Analysis Tool for Property | Digital download
$63.15
-
Digital download
Rental Property Analyzer | Real Estate Investment Calculator (Excel Model)
$97.60
-
Digital download
Real Estate Investor Spreadsheet Bundle | CPA Deal Analyzer (Excel File)
$43.09
-
Digital download
Real Estate Analysis Tools Bundle: Investment Property Calculators
$95.00
-
Digital download
Rental Real Estate ROI Investment Calculator, Get Full Package Cashflow Analyzer Pro with Deal Instant Analyzer
$75.12
-
Digital download
Deal Instant Analyzer Real Estate Investment Analyzer: ROI Cashflow (Excel/Google Sheets)
$31.29
-
Digital download
All in One - Real Estate Deal Analyzer - Multi Family & Single Family Investments, BRRR Deals, Portfolio Tracker
$54.86
-
Digital download
Multifamily Underwriting Model • Real Estate Excel (Beginner Edition)
$27.00
-
Digital download
Real Estate Loan Approval Investment Analyzer - Maximize Cash Flow
$28.00
-
Digital download
Real Estate Deal Analyzer | Rental Property Calculator for Google Sheets | ROI & Cash Flow Investment Spreadsheet | Airbnb Analysis Template
$27.00
Shoppers with similar taste loved these
-
Digital download
User Acceptance Test (UAT) PowerPoint Template | 25 Clean & Professional Slides for Business Presentations
$5.83
-
Digital download
Project Management Template Multi Project Tracker Google Sheets Excel Gantt Chart Kanban Board Task Tracker Planner Small Business Dashboard
Sale Price $5.00
Original Price $20.00
-
Digital download
Test Case Template Pack (Excel + Notion) | QA Testing Tracker | Test Analyst Toolkit | Manual & Functional Test Case Sheet
$4.03
-
Digital download
Project Management Dashboard | Google Sheets Template | Automatic Dashboard | Timeline | Kanban Board | Planner Spreadsheet
$7.30
-
Digital download
Project Management Template Bundle for Resource Planning and Capacity Planning in PMO Templates Agile Management Excel Template
Sale Price $7.80
Original Price $26.00
-
Digital download
Task Tracker Spreadsheet Template Google Sheets Digital To-Do List Excel Daily Task Priority List Work Organization Team Project Management
Sale Price $6.57
Original Price $13.15
-
Digital download
Bug Report Template for QA | Excel Format | Defect Tracker Sheet | Software Testing Log | QA Analyst Tool | UAT Issue Log
$2.88
-
Digital download
Project Budget Tracker | Project Cost Matrix & Financial Oversight | Excel Version
Sale Price $3.60
Original Price $9.00
-
Digital download
Risk Management | KPI Dashboard & Decision Matrix | Excel Template
Sale Price $3.20
Original Price $8.00
-
Digital download
Maintenance Schedule Register Excel Template: Maintenance Planner, Maintenance Tracker, Maintenance Cost. Bonus calibration register
Sale Price $11.02
Original Price $18.37
-
Digital download
GRC Excel Template Bundle: 5-in-1 Risk Register, Audit, Capa, GDPR & ISO 27001 Compliance Dashboard
$99.50
-
Digital download
ISO 27001 Implementation Toolkit | Policies, Procedures, Forms (Excel & Documents) | Certification Audit | Template package
Sale Price $120.56
Original Price $200.94