Report this item to Etsy

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

Loading

20% off

•

Sale ends on December 9

You can only make an offer when buying a single item

Highlights

  • Designed by JENCPTemplates
  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

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

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 18, 2026