Report this item to Etsy

Multifamily Underwriting Model Excel, Apartment Building Value Add Pro Forma, 10 Year IRR, Cap Rate and DSCR Real Estate Calculator

NowPrice:$71.20

Original Price: $89.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

Find out whether an apartment deal hits your targets, and what price would make it work, before you make the offer.

INSTANT DIGITAL DOWNLOAD for Microsoft Excel (2016+ / Microsoft 365). No physical item will be shipped.

Enter the unit mix (up to 8 types), current and market rents, a renovation plan, expenses and financing. The loan is sized at the lower of LTV and DSCR. The Summary gives a plain-English short answer, a pass/miss scorecard against your IRR, Year-1 cash-on-cash and DSCR targets, sources and uses, and what-if tables for exit cap and purchase price. The included sample deal deliberately misses its cash-on-cash target, so you can see how the model flags a problem.

Built by Kyle H, CFA (JENCP LLC). I have 10+ years of experience in finance.

━━━ WHO IT'S FOR ━━━
• Individual and syndicate multifamily investors
• Brokers and analysts who need a fast first-pass underwriting
• Value-add buyers planning unit renovations

━━━ WHAT'S INSIDE (4 TABS) ━━━
• Start_Here: quick start, how it works, simplifications, disclaimer, version and license
• Summary: short answer, scorecard, returns and risk, sources and uses, exit-cap and price what-ifs, NOI and cash flow chart
• Inputs: property and hold, financing (LTV/DSCR sizing, IO period), unit mix with renovation program, other income, vacancy, rent growth, expenses, exit and targets, with input checks
• Pro_Forma: every line by year — income, loss-to-lease burn-off, renovation ramp, expenses, NOI, debt, sale, unlevered and levered cash flows, IRR and sensitivities

━━━ 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 or refinancing. Reserves and renovation capital are paid from cash flow. Real estate taxes do not automatically reset on purchase — enter the post-sale tax bill if your jurisdiction reassesses.

━━━ 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 property's 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