If you are serious about building generational wealth through multifamily real estate, you already know that the difference between a great deal and a costly mistake lives entirely in the numbers. Every assumption — rent growth, vacancy, cap rate, debt structure, renovation budget, waterfall splits — compounds over a 5- or 10-year hold into outcomes that can separate a 22% IRR from a 6% IRR.
The question is not whether you need a rigorous underwriting model. You do. The question is whether yours is comprehensive enough to catch everything — and polished enough to hand to a lender or LP on a Monday morning.
The Princeton Financial Equity Group Multifamily Deal Analyzer was built specifically for this. It is not a basic rent-and-expense template. It is a full institutional-grade workbook covering every dimension of a multifamily acquisition — from the unit mix and rent comps all the way through the waterfall distribution, sponsor economics, CapEx reserves, lender stress tests, and print-ready investor summaries.
What Is the Princeton Financial Deal Analyzer?
It is a single Microsoft Excel workbook with 21 fully integrated, formula-driven tabs. Every number flows. Change the purchase price on the Inputs tab and the IRR, sale price, DSCR, distributions, and lender stress test all update in real time — no manual recalculation, no copying and pasting, no version control headaches.
Who Is This Built For?
Syndicators & GPs
Model your acquisition from capital stack through waterfall, produce LP-ready returns, and generate a lender package — all in one workbook.
Passive LP Investors
Understand exactly what you are investing in. Stress-test any deal a sponsor pitches you using the same professional framework they should be using.
Brokers & Advisors
Run deal analysis for clients in minutes. The built-in comp grid, lender summary, and executive one-pager make you look like a seasoned investment banker.
First-Time Buyers
The step-by-step How to Use tab walks you through every input. If you understand rent, you can use this tool — even without any financial modeling background.
Professional multifamily analysis — from acquisition to exit
How It Works — The Big Picture
The analyzer is organized so that data flows from left to right. You enter your deal assumptions in the input tabs on the left, and every output tab — returns, pro-forma, sensitivity, lender package — updates automatically on the right. Nothing is manual. Nothing is siloed.
Here is the recommended workflow:
Understanding the Color Code
One of the first things you will notice when you open the file is the consistent color coding system. It takes 30 seconds to learn and it will save you hours of confusion:
BLUE ON LIGHT BLUE
Input cells. Only these should be edited. These are your assumptions.
GREEN ON LIGHT GREEN
Auto-linked from another tab. Do not edit — it updates automatically.
DARK ON LIGHT GRAY
Calculated formula. Locked. Changes automatically with your inputs.
GOLD ON DARK NAVY
Section total or key output metric. This is the number you care about.
Inside the Workbook
A complete walkthrough of all 21 tabs and what each one does for you
How to Use
The very first tab is a comprehensive user guide built directly into the workbook. No external manual, no YouTube tutorial required. It covers the complete 11-step workflow in the recommended order, explains every cell color, answers common questions, and includes tips on printing and protection.
If you have never used a financial model before, start here. The tab walks you through exactly which tabs to fill in and in what order. It even tells you which tabs are purely outputs — meaning you never have to touch them at all.
💡 Pro Tip: Before you enter a single number, read this tab. The 5 minutes you spend here will save you 30 minutes of confusion later.
Executive Summary
This is your investor-ready one-pager. Everything a prospective LP or lender needs to evaluate your deal in 60 seconds is on this single landscape-formatted page. It pulls data from every other tab automatically — you only need to fill in two text boxes: Investment Highlights and Risk Factors.
The Executive Summary displays: property name, address, unit count, purchase price, price per unit, going-in cap rate, Year 1 NOI, gross square footage, the complete capital stack, all key return metrics (IRR, equity multiple, cash-on-cash, DSCR), the full 5-year pro-forma summary table, and the Year 5 exit analysis — all in one clean, print-ready layout.
The file is pre-configured for landscape printing. When you’re ready to present, you hit Print — that’s it. No reformatting, no copy-pasting into PowerPoint, no wrestling with page breaks.
✅ Included on this tab:
- Property overview block
- 9 key investor return metrics
- Full capital stack breakdown
- 5-year pro-forma summary table
- Year 5 exit proceeds waterfall
- Editable Investment Highlights box
- Editable Risk Considerations box
- Prepared By / contact block
- Disclaimer footer
📊 Auto-populated metrics:
- IRR — Class A (5-yr exit)
- Equity Multiple
- Cash-on-Cash Year 1
- Average Cash-on-Cash Yrs 1–5
- DSCR Years 1 and 3
- Year 5 estimated sale price
- Net proceeds from sale
- Total Class A returns
Visual Dashboard
The Dashboard is your deal command center — a visual overview of the entire deal in chart form. It includes 7 live charts that all update the instant you change any assumption:
Income & NOI
EGI vs Expenses vs NOI — 10 years
Cash Flow
NOI vs Debt Service vs Net CF
DSCR Trend
With 1.25x minimum threshold
Capital Stack
Debt vs equity donut chart
FMV Trend
Going-in vs exit cap rate
Distributions
Annual waterfall breakdown Yrs 1–5
Rent Growth
GPR and EGI — 10-year trajectory
The top of the Dashboard shows four large KPI gauges: IRR, Equity Multiple, DSCR, and Cap Rate — each with a color-coded indicator that turns green when you hit target thresholds. This makes it immediately obvious whether your deal is performing to institutional standards.
Inputs — The Master Control
The Inputs tab is the heart of the entire model. Everything else is driven by what you enter here. It is organized into clean sections:
Property Information
Property name, address, number of units, purchase price
Capital Stack — Debt
1st mortgage amount and rate, additional loan, amortization period, interest-only years
Equity & Uses
Working capital, acquisition fee %, sponsor cash, preferred equity amount — auto-calculates total equity and LTV
Income Assumptions
Going-in rents, other income, vacancy %, bad debt %, concessions %, all three escalators (rent, other income, expenses)
Waterfall
Class A LP share, preferred return %, acquisition fee %, disposition fee %, asset management fee %
Exit Assumptions
Going-in and exit cap rates, sales costs %, closing costs %
At the bottom of the Inputs tab is a built-in Deal Health Check — 10 automatic validations that flag issues in real time. If your LTV is too high, your preferred return is unusual, or your equity goes negative, you will see a red ✗ before you ever send the file to a lender.
Rent Analysis & Unit Mix
This is where you define your property’s unit makeup and four rent scenarios. The tab supports up to 13 unit types (Studio, 1BR/1BA, 2BR/2BA, 3BR/2BA, and custom “Other” rows you can rename for any unit type):
| Scenario | What It Represents | Used For |
|---|---|---|
| ① Seller In-Place | Current rents the seller is collecting | Baseline / acquisition analysis |
| ② Market Rents | Current comparable market rates | Underwriting benchmarking |
| ③ Your Est. In-Place | Your conservative underwritten rents | Pro-forma conservative base |
| ④ Post-Renovation | Projected rents after improvements | 🏆 Auto-feeds the Pro-Forma GPR |
Below the unit mix table is a Renovation Rent Uplift Analysis — it automatically calculates the monthly rent increase per unit, annual uplift per unit type, and total annual rent increase from your renovation program. This is the number that justifies your renovation budget to investors.
The tab also includes two charts: a clustered bar chart comparing average rents across all four scenarios by unit type, and a unit mix pie chart — both of which update automatically as you add or change unit types.
Rent Comparable Analysis
Lenders and institutional LPs will always ask: “How does your rent assumption compare to the market?” This tab gives you the answer, structured and documented. Enter up to 6 comparable properties side-by-side against your subject property.
For each property you track: year built, unit count, square footage, distance from subject, occupancy rate, rents by unit type (Studio through 3BR), amenities score, condition score, walk score, parking fees, pet fees, and laundry type. The analyzer automatically calculates the average across all comps, your subject’s variance from that average, and ranks your property among all seven.
⚡ Why this matters: A positioning summary at the bottom auto-flags each metric as “▲ Above Market,” “◆ At Market,” or “▼ Below Market.” When an LP asks why you’re underwriting $1,150/mo on 2BR units, you can show them a table proving the market supports $1,200+ and you’re being conservative.
10-Year Pro-Forma
This is the full institutional cash flow model — Year 0 (acquisition) through Year 10. Every line item is formula-driven and escalates at your specified rates. The pro-forma is organized into four sub-views you can toggle between:
Overview
GPR → EGI → Expenses → NOI → Debt Service → Net Cash Flow → DSCR → Cap Rate
Income Detail
GPR → Vacancy → Bad Debt → Concessions → Net Rental Income → Other Income → EGI
Expense Detail
Op Expenses → Property Mgmt → Total → Asset Mgmt → NOI → Expense Ratio → Expense/Unit
Distributions
Preferred equity → Class A preferred return → LP distribution → GP carry → Total Class A by year
The Year 5 column is highlighted in gold — that is your target exit year. The model also shows you FMV (fair market value) at both going-in cap and exit cap for every year, so you can track the theoretical appreciation of the asset alongside the cash flows.
Exit & Returns
The Exit & Returns tab is where the deal’s profitability crystallizes into a single page. It walks through the complete Year 5 sale from gross price down to net proceeds, then shows exactly how the money is distributed.
Below the exit waterfall you will find the complete return metrics for Class A investors, and an IRR cash flow staging area showing you every annual cash flow that feeds the IRR calculation — fully labeled and formatted so you can verify the math yourself.
The Cost Structure Tabs — Where Most Models Fall Short
Most deal analyzers treat operating expenses as a single number. This one breaks everything down to the line item — and then automatically rolls all the totals up into the Pro-Forma. Here is how the five cost structure tabs work together:
Payroll & Taxes
Enter your staffing plan by position (Maintenance, Leasing, Admin, Porter, etc.) with annual rates and headcount. The tab automatically calculates health insurance, payroll taxes (FICA/FUTA at 7.6%), workers compensation, and benefits as percentages of total compensation. Below that, a real estate tax section walks through the assessment formula for any state — with the Florida millage rate method shown as the default example.
The grand total from this tab automatically feeds the Operating Expenses tab and then the Pro-Forma. You never manually copy a number.
Improvements
Itemize your renovation budget at the unit level (13 line items: flooring, countertops, cabinets, appliances, paint, fixtures, etc.) multiplied by your unit count. Below that, a 5-year common area improvement schedule lets you phase spending across years — pool, parking lot, signage, clubhouse, security cameras, and more — with a built-in 5% contingency row. A sources-of-funds section lets you track whether renovation costs are coming from equity, a construction loan, or reserves.
Closing Costs
A complete transaction closing estimate organized by category: buyer-to-seller credits, seller-to-buyer credits (tax prorations, rent prorations, security deposits), lender costs and third-party reports (appraisal, Phase I, title insurance, origination fees, escrows), transaction closing charges (doc stamps, recording fees, legal counsel), and additional operating cash needed at close. Every category flows directly into Sources & Uses.
Sources & Uses
The Sources & Uses is the capital stack reconciliation every lender and LP wants to see. The Uses side automatically pulls from: purchase price, acquisition fee, working capital, unit renovations, common area improvements, closing costs, and transaction charges. The Sources side shows your debt (1st mortgage + add’l loan) and equity (sponsor, preferred, Class A) — all live-linked from the Inputs tab.
A “BALANCED” indicator at the bottom confirms your sources equal your uses. If there is a gap, it shows you the exact dollar amount — so you know exactly how much more equity you need to raise before the deal closes.
Operating Expense Detail
This tab gives you 30+ expense line items organized into 9 categories: Payroll & Personnel, Admin & Office, Real Estate Taxes, Insurance, Repairs & Maintenance, Utilities (common areas), Marketing & Leasing, Contract Services, and Replacement Reserves. Each line shows annual amount, per-unit-per-month, per-unit-per-year, and % of EGI. The grand total flows directly to Inputs!B46 and into the Pro-Forma.
Sponsor Cash Flows
Most deal models only show LP returns. This tab shows the full sponsor economics — separated into two sections:
A. As Class A Member
- Initial equity investment (Year 0)
- Preferred return distributions by year
- LP cash flow distributions by year
- Return of capital upon sale
- Profit on sale (LP share)
B. As Sponsor / GP
- Acquisition fee earned at close
- Annual asset management fees
- Annual carry interest (if any)
- Carry interest from sale
- Disposition fee at exit
The return metrics section at the bottom calculates the sponsor’s total equity multiple, average annual cash-on-cash, and IRR — including all fees. This is the number that LPs look at when evaluating a sponsor’s track record, and it is often a completely different number from the LP’s own IRR.
Analysis Tools — What Every Investor Should Be Running
Sensitivity Analysis
Two sensitivity grids — one for IRR, one for property valuation — using the same two variables that matter most in any multifamily deal: Exit Cap Rate (columns) and Rent Escalator (rows).
| Rent Esc ↓ / Cap → | 4.5% | 5.5% | 6.5% | 7.5% |
|---|---|---|---|---|
| 1.0% | 18.2% | 13.1% | 10.4% | 7.8% |
| 3.0% | 21.5% | 16.3% | 13.1% | 10.2% |
| 5.0% | 24.8% | 19.6% | 16.2% | 12.9% |
Example IRR sensitivity grid (illustrative — your actual numbers will vary). Green = strong, Amber = acceptable, Red = weak.
Stress Test & Break-Even Analysis
This is the tab that separates sophisticated underwriters from the rest. Five stress test scenarios, all live-linked to your inputs:
Break-Even Occupancy
At what occupancy does DSCR fall below 1.25x, 1.0x, and 0x?
Rate Sensitivity
Impact of +50 to +300 bps on debt service, DSCR, and break-even
Rent Decline
Impact of −5% to −25% rent declines on NOI and DSCR
Expense Growth
NOI and DSCR at 8 different expense escalator rates
Combined Stress
Base vs Moderate vs Severe — all variables stressed simultaneously
Every scenario shows a live ✓ OK / ⚠ Watch / ✗ Risk status indicator. You can see at a glance exactly how much room your deal has before it breaks — and where the vulnerabilities are.
Advanced Analysis Tabs
Hold Period Analysis
Should you sell in Year 3, Year 5, Year 7, or Year 10? This tab tests all five exit points simultaneously with their own exit cap rate assumptions. It calculates cumulative distributions, sale proceeds, equity multiple, and IRR for each scenario — then a highlighted banner auto-identifies the optimal hold period by IRR. A line chart visualizes IRR across all hold periods so the optimal exit is instantly obvious.
CapEx Reserve Schedule
A full 16-component capital expenditure schedule — roof, HVAC, water heaters, parking lot, windows, plumbing, electrical, elevator, pool, and more — each with unit cost, quantity, useful life, and current age. The model calculates when each component will need replacement over the 10-year hold and projects a reserve fund balance year by year, showing whether your reserves will be sufficient or whether you will face a shortfall.
This is the information lenders increasingly ask for and that most borrowers are completely unprepared to provide.
Loan Amortization Schedule
A full 360-row (30-year) monthly amortization schedule with: Beginning Balance, Scheduled Payment, Interest Paid, Principal Paid, Ending Balance, Cumulative Interest, and Cumulative Principal. Year-end rows are highlighted in gold for easy reference. An annual summary table with 30 rows feeds two charts: a stacked bar chart showing principal vs interest paid each year, and a line chart showing the classic “crossover point” where cumulative interest exceeds your original loan amount.
Lender Underwriting Summary
This tab mirrors exactly how a bank or agency lender will stress-test your deal before approving a loan. It applies standard lender haircuts: 5% income reduction, 5% expense gross-up, minimum 10% vacancy/credit loss — and calculates stressed DSCR, debt yield, break-even occupancy, and exit LTV. Every metric shows a ✓ Strong / ◆ OK / ✗ Flag status indicator.
A master verdict cell at the bottom auto-generates: “✓ DEAL APPEARS LENDER-READY” or “⚠ ADDRESS FLAGGED ITEMS ABOVE BEFORE LENDER SUBMISSION” — so you know before they do whether your deal will pass underwriting.
What Makes This Different From Every Other Template
Everything Connects
Change one number in Inputs and 5,292 formulas across 21 tabs all update instantly. No manual links, no broken references.
Protected Formula Cells
12,000+ formula cells are locked. Only blue input cells are editable. You cannot accidentally destroy the model.
Print-Ready From Day 1
Executive Summary, Pro-Forma, Exit & Returns, Sources & Uses, and Lender Summary all have pre-configured print areas.
No Add-ins Required
Standard Microsoft Excel. No macros to enable, no third-party plugins. Works on Windows and Mac.
Validated Error-Free
Every formula validated. Zero #REF, #VALUE, or #N/A errors. Zero circular references. The math is clean.
Beginner Friendly
A full How to Use guide is built into the workbook. If you understand rent and expenses, you can use this model.
How It Compares
| Feature | Basic Template | Other Paid Tools | PFEG Analyzer |
|---|---|---|---|
| 10-Year Pro-Forma | ✓ | ✓ | ✓ |
| IRR & Equity Multiple | ✓ | ✓ | ✓ |
| Waterfall Distribution Model | ✗ | Partial | ✓ Full GP/LP |
| 4-Scenario Rent Analysis | ✗ | ✗ | ✓ |
| Itemized Payroll Budget | ✗ | ✗ | ✓ |
| Lender Underwriting Summary | ✗ | ✗ | ✓ |
| Stress Test / Break-Even | ✗ | Limited | ✓ 5 scenarios |
| CapEx Reserve Schedule | ✗ | ✗ | ✓ 16 components |
| Multi-Hold Period Comparison | ✗ | ✗ | ✓ Yrs 3/4/5/7/10 |
| Print-Ready Investor Summary | ✗ | Basic | ✓ Full one-pager |
| 360-Month Amortization Table | ✗ | ✗ | ✓ |
| Legal Disclaimer & Terms | ✗ | ✗ | ✓ 12 sections |
Frequently Asked Questions
Disclaimer: The Princeton Financial Equity Group Multifamily Deal Analyzer is provided for informational and educational purposes only. It does not constitute investment advice, financial advice, or a solicitation to buy or sell any security. All projections and outputs are estimates based on user inputs and assumptions. Actual results will vary. Users are solely responsible for the accuracy of their inputs and should consult qualified financial, legal, and tax professionals before making any investment decision. Princeton Financial Equity Group LLC makes no warranties regarding the completeness, accuracy, or fitness for any particular purpose of this tool. Past performance is not indicative of future results.
Leave a Reply