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
20% off
Sale ends on December 9
You can only make an offer when buying a single item
Highlights
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
Be the first to review this item
More from this shop
Visit shop-
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
Net Worth Projection Spreadsheet, 10 Year Wealth Planner Excel, FIRE and Passive Income Calculator, Rental Property Portfolio Tracker
Sale Price $31.20
Original Price $39.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
BRRRR Calculator Spreadsheet, Cash Out Refinance and Rehab Analyzer for Rental Property, Excel & Google Sheets, ARV and Cash Left in Deal
Sale Price $11.20
Original Price $14.00
-
Digital download
Real Estate Investment Calculator: Excel Spreadsheet, ROE, IRR (Digital Download)
$76.88
-
Digital download
RealEstate Valuation Calculator in Excel | Investment Analysis Tool for Property | Digital download
$63.11
-
Digital download
Real Estate Investment Profitability Calculator in Excel | Analyze Up to 5 Deals | Digital download
$74.58
-
Digital download
Airbnb Arbitrage Calculator | STR Real Estate Analysis Spreadsheet Bundle (Digital Download)
$60.00
-
Digital download
Real Estate Analysis Tools Bundle: Investment Property Calculators
$95.00
-
Digital download
Fix & Flip - Real Estate Investment Calculator - Microsoft Excel
$49.99
-
Digital download
Rental Property Analyzer | Real Estate Investment Calculator (Excel Model)
$97.53
-
Digital download
Real Estate Deal Analyzer Spreadsheet - ARV Zillow Scraper BRRRR Calculator 72 Mo Cashflow ROI 47 dollars
$47.00
-
Digital download
Rental Real Estate ROI Investment Calculator, Get Full Package Cashflow Analyzer Pro with Deal Instant Analyzer
Sale Price $45.02
Original Price $75.04
-
Digital download
Real Estate Investment Spreadsheet, Rental Property Analysis Excel, Deal Analyzer ROI IRR NPV Cash Flow Calculator, Compare 5 Properties
$223.75
-
Digital download
Multifamily Underwriting Model • Real Estate Excel (Beginner Edition)
$27.00
-
Digital download
Value Analysis Calculator Sheet – Google Sheets Template for Property Investment, Mortgage & ROI Calculations – Budget Planner and Financial
Sale Price $5.72
Original Price $11.44
Shoppers with similar taste loved these
-
Digital download
Monthly Profit and Loss Dashboard: Income Statement Analysis
$9.99
-
Digital download
Ultimate Excel Forecasting Sales and Demand Template with 7 Forecast Models and 3 Accuracy Metrics - SKU level
$40.16
-
Digital download
Restaurant Financial Model Template, 10-Year Forecast, DCF Valuation & Business Plan Spreadsheet
$159.99
-
Digital download
Etsy Sales Tracker Small Business Products Statistics Customer Tracker Google Sheets Excel Template Metrics Dashboard Competitor Tracker
Sale Price $5.84
Original Price $11.68
-
Digital download
Daily Sales Tracking Template Excel | Sales Dashboard | Daily Monthly Target Tracker | Top Salesperson Report | Multi-Language
$24.00
-
Digital download
Sales & Inventory Dashboard Google Sheets Template Small Business Spreadsheet Digital Template Sale Statistic Online Sale Insight Management
Sale Price $2.25
Original Price $9.00
-
Digital download
Complete Company Valuation Template - DCF, Sensitivity & Relative Analysis | Excel Financial Model Download
$15.35
-
Digital download
HSE Incident Trend Analysis Dashboard Template (Excel)
$20.00
-
Digital download
Marketing Planner Google Sheets Template with Calendar & Timeline
Sale Price $9.62
Original Price $13.75
-
Digital download
Ultimate Annual Budget Spreadsheet Google Sheets Excel Budget Template Monthly Budget Planner Family Weekly Yearly Budget Tracker Dark Mode
Sale Price $9.95
Original Price $14.21
-
Digital download
Investment Property Analysis Spreadsheet | Excel & Google Sheets | Real Estate ROI and Mortgage Calculator | Property ROI Tool
$7.01
-
Digital download
Commercial Real Estate Brochure & Flyer Templates (Digital Download) - Statement Red
$19.97