Financial Models in Excel for the Best Financial Planning and Avoiding Bankruptcy

Financial planning is vital for any startup, particularly one exploring new, innovative business activities. It ensures that scarce capital is allocated responsibly, risk is managed effectively, and the company remains solvent long enough to discover sustainable revenue streams. Below is an overview of why financial planning matters for R&D, acquiring new customers, and a simple framework for avoiding bankruptcy.

Startup Financial Model for a Loan Securitization Platform or Facilitator

SmartHelping / Securitization Platforms / Excel

Loan Securitization Platform Financial Model

Plan a platform that connects loan portfolios with investors. Forecast upfront and servicing fees, deal lead times and operating costs, with an option to include portfolio purchases and resale.

5-year forecast 3 asset classes 3 financial statements 22 charts and KPIs
securitization
$75One-time purchase / Excel download
Add Securitization Platform Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

See the model in action

Walk through the deal economics and platform forecast.

Follow the video to see how fee revenue, direct costs, closing lead times and the principal balance forecast feed the financial statements and capital requirements.

Open the model overview presentation

Use the presentation alongside the video for an overview of the model and the decisions it helps you evaluate.

Template features

Connect each deal to the wider operating plan.

Build the economics of the asset classes, then plan the staffing, software, funding and returns as the platform grows.

01 / FIVE-YEAR FORECAST

Review monthly and annual financial statements

Plan five years of operations with an income statement, balance sheet and cash flow statement at both monthly and annual levels.

02 / THREE ASSET CLASSES

Configure the economics of each deal type

Forecast up to three asset classes, each with its own closed-deal schedule, fee rates, direct costs and expected principal balance over time.

03 / DEAL ASSUMPTIONS SUMMARY

See the financial effect beside the inputs

A full five-year financial summary sits alongside the main deal assumptions so you can see how changes affect profit and other key financial line items. Input cell notes explain the deal assumptions.

04 / EQUITY AND INVESTOR PLANNING

Calculate the startup capital required

The model solves for minimum equity required. Configure inside and outside investor contributions to startup capital and their shares of profits over time.

05 / VALUATION AND RETURNS

Review DCF, IRR and an optional exit

Use the DCF analysis, IRR, executive summary and exit metrics to evaluate the business. Optional exit value is based on trailing 12-month EBITDA at the chosen exit month.

06 / STAFFING THAT SCALES

Connect headcount to deal volume

Set full-time employee requirements based on deals per month, staffing ratios, salaries and payroll taxes or benefits. A separate schedule covers employees whose headcount does not scale with deal activity.

07 / SOFTWARE AND OVERHEAD

Include the cost of building the platform

Plan initial software development as capital expenditure that is capitalized and expensed over time. Add fixed overhead such as marketing, administrative and legal costs, and office rent.

08 / 22 VISUALIZATIONS

Review the forecast through charts and KPIs

Use 22 charts and KPI visualizations alongside the financial statements, executive summary and return analysis to review the operating plan.

Deal assumptions

Configure the fees, costs and timing for each asset class.

Each deal assumption includes a cell note in Excel that explains the input when you hover over it.

01 / DEAL CONFIGURATION

Set deal size, duration and closing lead time

Define the lead time from a new deal to a closed deal, average notional size per deal, annual growth in deal size and average portfolio tenure in months.

02 / REVENUE DRIVERS

Build upfront and recurring fee revenue

Set upfront fee rates, placement or distribution fees, ongoing service or management fees, and fixed annual service or management fees. The principal balance forecast supports the ongoing fee calculations.

03 / RATING AND ADMINISTRATION COSTS

Include the direct costs of each deal

Configure rating agency fees and minimum fees per deal, underwriting or placement fees, annual trustee and administrative fees, fees based on principal, and one-time trustee or administrative setup costs.

04 / ACCOUNTING AND STRUCTURING

Schedule costs before and after closing

Enter accounting or auditing costs and legal or structuring costs, including transaction documents, SPV setup, financial modeling, tax advice and legal opinions. Specify the share paid at deal start and include other direct costs paid before or after closing.

05 / WAREHOUSE BRIDGE FINANCING

Set the optional portfolio funding terms

Define the share of loans requiring bridge financing, the percentage of notional value paid, the share borrowed through the bridge line and the notional amount placed as securities. Include interest expense and closing costs.

06 / PRINCIPAL BALANCE FORECAST

Model defaults and repayments over time

Use separate 60-month schedules for the average percentage of principal defaulted on each month and the percentage repaid each month. These curves drive the expected principal balance used in fee calculations.

Working capital and optional portfolio resale

Plan the cash required before a deal closes.

Choose the activities the platform will undertake and follow their effect on upfront funding, ongoing costs and the cash received at closing.

Fee-only facilitation

Operate as the platform connecting institutions with loan portfolios and investors seeking securitized products. Set portfolio purchase activity to 0% to model an aggregator that earns fees without owning or originating loans or collecting borrower principal and interest.

Optional portfolio resale

Model buying some or all portfolios before placing them with investors. A portfolio bought at a discount and placed at par can generate a resale margin. The purchase requires upfront capital, funded through equity or the optional bridge line.

Time before placement

Deals can take months to close. Account for costs paid before and after closing, financing interest, closing costs and the cash required while a purchased portfolio is waiting to be placed. Deal lead time makes these working capital effects visible in the forecast.

Financial statement treatment

In this model, portfolio purchases are tracked on the balance sheet in a manner similar to inventory. Purchase costs are recognized when the deal closes, with cash flow adjustments capturing the funding and timing. The resale margin appears in gross profit above EBITDA as part of the modeled operating activity.

How to use it

From one deal to a five-year platform forecast.

  1. Start with one deal

    Enter the assumptions for a single deal and follow the formulas through revenue, direct costs and profit or loss. Understand the unit economics before increasing deal volume.

  2. Configure fees, principal and funding

    Set notional value, lead time, fee rates and cost timing. Complete the default and repayment curves, then choose whether to include portfolio purchases and bridge financing.

  3. Scale the platform

    Build the deal schedule for up to three asset classes. Add staffing that scales with deal volume, other employees, fixed overhead and software development costs.

  4. Review capital needs and returns

    Check monthly and annual financial statements, minimum equity required, investor contributions and profit shares. Review the DCF, IRR, optional EBITDA-based exit and the charts and KPIs.

Who gets value from it

Built for the people launching, operating and funding the platform.

Platform founders

Plan the capital, software, staffing and deal activity needed to launch a securitization platform.

Securitization facilitators

Forecast upfront fees, placement fees and the direct costs of connecting institutions with investors.

Servicing and management operators

Connect recurring fee revenue to portfolio tenure and the expected principal balance over time.

Finance teams and investors

Evaluate the operating forecast, working capital needs, investor participation and potential business value.

Also available in these bundles

Need more tools for lending and platform planning?

This securitization platform model is included in the following SmartHelping collections.

Related financial models

Loan Brokerage

Build an operating forecast for a loan brokerage business.

Explore this template

Single Securitization Deal Analyzer

Analyze the economics and structure of an individual loan securitization deal.

Explore this template

Buy Now, Pay Later Firm

Plan the financial performance of a buy now, pay later business.

Explore this template

General Loan Amortization

Model loan balances, interest and scheduled repayment.

Explore this template

Loan Portfolio Analysis

Analyze the performance and cash flow of a loan portfolio.

Explore this template

Discount Bond Model

Evaluate a bond purchased at a discount and its interest calculations.

Explore this template

Seller Financing Amortization

Model seller-financed payments and the resulting amortization schedule.

Explore this template

Interest Rate Swap

Evaluate the cash flow implications of an interest rate swap.

Explore this template

Mortgage Savings Calculator

Compare mortgage repayment scenarios and potential savings.

Explore this template

Pay Off Loans or Invest

Compare using available cash to repay loans or invest.

Explore this template

Multiple Loan Repayment Planner

Plan repayment across several loans and review the payment schedule.

Explore this template

Own vs Rent Calculator

Compare the financial implications of owning and renting.

Explore this template

General Lending Business Startup Model

Build a financial forecast for a direct lending business.

Explore this template

Lending-as-a-Service Platform Startup Model

Plan the operating forecast for a lending-as-a-service platform.

Explore this template

Questions before you choose

A few useful details.

What type of business is this model designed for?

It is designed for a securitization platform, facilitator or servicing operator that connects institutions with loan portfolios to investors seeking securitized products. Revenue comes from upfront and ongoing fees, with an option to include portfolio purchase and resale activity.

How long is the forecast, and how many deal types can I model?

The template includes a five-year monthly and annual forecast with up to three asset classes. Each deal type has its own volume, fee, direct-cost and principal-balance assumptions.

Can I model fee-only operations or portfolio purchases?

Yes. Set portfolio purchase activity to 0% for fee-only facilitation, or include purchases of some or all portfolios before investor placement. The optional purchase activity includes upfront funding, bridge financing terms and resale margin.

How does the model account for working capital?

It includes lead time from a new deal to a closed deal and direct costs paid before or after closing. Optional portfolio purchases add the cash required to acquire and hold portfolios until placement, together with financing interest and closing costs.

How are ongoing management fees forecast?

The model includes ongoing percentage-based and fixed annual service or management fees. Separate 60-month default and repayment curves forecast the remaining principal balance used in the fee calculations.

Can I include investors and an exit?

Yes. The model solves for minimum equity required and lets inside and outside investors contribute startup capital and receive shares of profits. An optional exit uses trailing 12-month EBITDA at the selected exit month, alongside DCF and IRR analysis.

Is the template included in a bundle?

Yes. It is included in the Industry-Specific, SaaS & Recurring Revenue, Accounting, Lending & Credit and Super Smart bundles linked above.

Model deal volume, fees and funding in one place

Build the platform around a clear financial plan.

Purchase the five-year financial model for $75 and receive immediate access to the download.

Get the Model

Business Plan Example for Loan Securitization Firm

Below is an illustrative (and simplified) example of a business plan for a loan securitization venture. The plan sketches out key components such as market opportunity, strategy, operations, unit economics, and a 10-year scale-up timeline. Keep in mind that real-world scenarios can be more complex, and this example is designed to provide a foundational framework.


Here is an interesting loan securitization template to help illustrate some of the underlying mechanics of this industry. And I just finished this model that is for a loan securitization dealmaker (inspired by everything you see below).

General Business Concept
The loan securitization firm earns fees by acting as both an aggregator and a structurer of loan portfolios, transforming relatively illiquid loans into tradable securities. Concretely, it collects loan pools from lenders, conducts credit analysis and due diligence, arranges legal and regulatory documentation, and works with rating agencies to establish credit ratings. In addition, it orchestrates the sale and distribution of the resulting securities to institutional investors, managing all the complexities of the transaction—from compliance and investor relations to servicing oversight—thereby justifying the upfront and ongoing fees.

Potential Risks of Being the Aggregator / Structurer of Loan Portfolios

While a securitization firm often transfers most of the underlying loan default risk to investors, it still faces a number of other significant risks:
  • Reputation and Liability Risk: If loans are misrepresented or improperly vetted, investors could sue the securitizer for breach of representations and warranties. Any high-profile default or improper structuring can also damage the firm’s reputation, jeopardizing future deals.
  • Regulatory and Compliance Risk: Securitization firms must comply with evolving regulations (e.g., risk-retention rules in the U.S. requiring the securitizer to hold a percentage of the deal). Noncompliance, or an oversight in disclosures, can lead to fines or legal action.
  • Warehouse/Bridging Risk: Before a pool of loans is securitized and sold to investors, the firm may have to temporarily hold those loans (often financed through a warehouse line of credit). If market conditions worsen or if they can’t place the securities, the firm could be stuck with these loans or face margin calls on its warehouse line.
  • Operational and Structuring Risk: Errors in structuring (e.g., inaccurate modeling, flawed documentation) can lead to deal failures or legal disputes. Poor servicing oversight or inadequate reporting can also degrade investor confidence.
  • Market and Liquidity Risk: Volatile interest rates or a sudden lack of investor appetite for certain asset classes can halt securitization pipelines, potentially leaving the firm with unsold loans or revenue shortfalls.
1. Executive Summary

Business Concept
Our firm, “Alpha Securitization Partners” (ASP), aims to become a leading aggregator and securitizer of loans across multiple asset classes (e.g., consumer loans, SME loans, or mortgage loans). We will originate relationships with lending institutions (both traditional and alternative lenders), bundle their loans into diversified pools, structure and sell asset-backed securities (ABS) to institutional investors, and manage ongoing securitization trusts.

Market Opportunity

  • Banks and non-bank lenders often look to free up capital by offloading portions of their loan portfolios.

  • Investors seek stable yield opportunities with diverse risk tranches.

  • Securitization transforms relatively illiquid loan portfolios into liquid instruments, aligning with regulators’ and institutions’ balance sheet optimization goals.

Business Model

  • Origination/aggregation: Acquire loans or partner with lenders to bundle them into portfolios.

  • Structuring: Use internal legal, compliance, and financial modeling teams to structure securities.

  • Placement/Distribution: Work with investment banks and broker-dealers to place securities with institutional investors.

  • Servicing/Monitoring: Maintain oversight of the loan pools, payments, and credit performance.

Competitive Advantage

  • Expertise in structuring deals across various loan types.

  • Proprietary analytics platform that evaluates underlying loans for credit quality and return optimization.

  • Strong network of originators and investors from the firm’s leadership experience in investment banking and structured finance.


2. Market Analysis
  1. Industry Landscape

    • The global securitization market has grown significantly post-financial-crisis due to revised regulations (e.g., Dodd-Frank risk retention rules), improving transparency, and a continued need for yield among institutional investors.

    • Growth areas: Consumer debt securitizations (credit cards, personal loans, student loans), residential mortgages (RMBS), and SME loan securitizations (especially from alternative lenders/fintechs).

  2. Target Clients

    • Mid-size banks, credit unions, and fintech lenders with loan portfolios ranging from $50M to $500M who want to offload part of their balance sheet.

    • Institutional investors (pension funds, insurance companies, asset managers, etc.) looking for structured products that provide predictable cash flows and diversified risk.

  3. Competitors

    • Large investment banks with established securitization desks.

    • Specialty finance companies that target niche asset classes.

    • However, many smaller or regional lenders prefer a boutique approach and specialized attention that large IBs often cannot provide, creating an opportunity for a focused securitization boutique.


3. Products & Services
  1. Loan Aggregation

    • Partner with lenders to identify and screen eligible loans for securitization.

    • Develop loan acquisition agreements that define the transfer, collateralization, and servicing processes.

  2. Structuring & Issuance

    • Pool the loans into special purpose vehicles (SPVs).

    • Work with rating agencies for credit enhancement strategies.

    • Coordinate legal counsel, trustee services, and underwriting of securities.

  3. Distribution & Investor Relations

    • Maintain a network of institutional investors seeking different risk-return profiles.

    • Issue multiple tranches of ABS with varying levels of credit enhancement and yield.

  4. Servicing & Reporting

    • Oversee loan servicing performance metrics.

    • Provide ongoing surveillance, performance reporting, and investor updates.


4. Operational Plan & Timeline

Phase 1 (Years 1-2): Setup & First Securitizations

  • Finalize legal structure and compliance framework.

  • Hire key staff: CFO, Head of Structuring, Head of Origination, Legal Counsel.

  • Onboard initial clients (2–3 lenders) and secure first two securitizations.

  • Target annual securitization volume: $100–$200 million in total notional value.

Phase 2 (Years 3-4): Scaling & Process Refinement

  • Expand originator network: banks, credit unions, fintech lenders.

  • Launch proprietary analytics platform to streamline loan assessment.

  • Execute ~5-7 securitizations per year, covering different asset classes.

  • Target annual securitization volume: $500 million–$1 billion.

Phase 3 (Years 5-7): Product & Geographic Expansion

  • Introduce cross-border securitizations if market and regulations permit.

  • Develop specialized verticals (e.g., auto loan securitizations, SME loan securitizations).

  • Target annual securitization volume: $2–$3 billion.

Phase 4 (Years 8-10): Maturity & Market Leadership

  • Mature product offerings with established track record across multiple asset classes.

  • Potential listing or merger/acquisition for growth capital.

  • Target annual securitization volume: $5+ billion.


5. Organizational Structure
  • CEO / Managing Partner: Oversees overall strategy, investor relations, and major client relationships.

  • CFO: Manages financial operations, reporting, and compliance with regulations like SEC/FINRA, IFRS/GAAP, etc.

  • Head of Structuring: Leads deal structuring, credit modeling, relationships with rating agencies.

  • Head of Origination: Sources loan portfolios from partner lenders and negotiates terms.

  • Legal & Compliance: Ensures all securitization structures meet legal and regulatory requirements.

  • Analytics & Research Team: Builds models for credit risk, pool performance, and portfolio optimization.

  • Investor Relations & Marketing: Maintains relationships with institutional investors and coordinates issuance roadshows.

As the company grows, additional junior staff, analysts, and servicing coordinators will be added to support higher deal flow.


6. Unit Economics

While securitization economics can vary widely depending on asset class, credit quality, and market conditions, below is a simplified model for the typical fees and expenses in a single securitization:

  1. Deal Size: $100 million (example)

  2. Revenue Streams:

    • Upfront Structuring Fee: Typically 0.5%–1.0% of the notional amount (e.g., $0.5–$1.0 million).

    • Ongoing Servicing/Management Fee: Typically 0.1%–0.3% per annum on outstanding principal (e.g., $100K–$300K/year).

    • Placement/Distribution Fee: If the firm also handles placement, an additional 0.2%–0.5% can be earned.

  3. Costs:

    • Rating Agency Fees: 0.05%–0.10% of deal size (e.g., $50K–$100K).

    • Legal & Structuring Costs: $200K–$400K for outside counsel and documentation.

    • Underwriting/Distribution: If using third-party underwriters, 0.15%–0.30% of deal size.

    • Operational Overhead: Salaries, software, office space, compliance, etc.

  4. Gross Margin:

    • Upfront margins on each securitization typically hover around 30–50% after direct deal costs (rating, legal, underwriting).

    • Ongoing fees (servicing, monitoring) provide recurring income but are usually smaller percentage-wise.

  5. Breakeven Analysis:

    • Estimate the firm’s annual overhead at $2–$3 million in the first couple of years (staff salaries, office, compliance).

    • With an average $100 million deal generating $700K–$1.5M in fees (before direct costs), the firm would need 2–3 deals per year initially to reach operating breakeven.


7. Financial Projections (Years 1 – 10)

Below is a high-level, hypothetical financial trajectory.

Year 1 – 2

  • Deals: 2 securitizations per year, $100M average each = $200M total.

  • Total Revenues: $1.5M–$2.0M (assuming ~1% average fee & smaller distribution fees).

  • Expenses: $2–$2.5M (staff + operational costs).

  • EBITDA: Breakeven or slightly negative in Year 1; modest profit in Year 2.

Year 3 – 4

  • Deals: 5 securitizations per year, $100M–$200M average each = $500M–$1B total.

  • Total Revenues: $5M–$10M.

  • Expenses: $4–$6M as staffing grows.

  • EBITDA: $1M–$4M (more comfortable profitability).

Year 5 – 7

  • Deals: 8–12 securitizations per year, $200M–$300M average each = $1.6B–$3.6B total.

  • Total Revenues: $12M–$30M (including ongoing servicing fees from prior deals).

  • Expenses: $8–$12M.

  • EBITDA: $4M–$18M.

Year 8 – 10

  • Deals: 15+ securitizations per year, $300M–$400M average each = $4.5B+ total annually.

  • Total Revenues: $30M+ (in addition to growth in recurring servicing fees).

  • Expenses: $15M–$20M.

  • EBITDA: $15M+.

(Note: These figures are illustrative and depend heavily on market conditions, asset quality, deal types, and investor demand.)


8. Risk Factors & Mitigation
  1. Market/Interest Rate Risk

    • Mitigation: Diversify across loan types and maturities; use hedging strategies where feasible.

  2. Credit/Default Risk

    • Mitigation: Robust underwriting standards, conservative credit enhancement, maintain relationships with reliable originators.

  3. Regulatory Risk

    • Mitigation: Dedicated legal/compliance team; stay current with changes in banking and securities laws (e.g., Dodd-Frank, SEC regulations, EU securitization rules, etc.).

  4. Operational Risk

    • Mitigation: Invest in secure IT infrastructure, robust internal controls, backup servicing arrangements.

  5. Liquidity Risk

    • Mitigation: Prudent balance sheet management, credit lines with partner banks, stable cash flow from recurring fees.


9. Growth & Exit Strategy
  • Growth: Expand asset classes (e.g., auto, credit card, small business loans), geographic footprint, and eventually add risk retention vehicles for high-performing portfolios.

  • Exit: Position for acquisition by a larger financial institution or private equity firm, or potentially go public to attract more significant capital for expansion.


10. Conclusion

Alpha Securitization Partners seeks to capitalize on the strong and growing demand for structured finance solutions. By focusing on prudent underwriting, specialized asset-class expertise, and close relationships with both originators and investors, the company aims to build a profitable and sustainable securitization platform over the next decade. The combination of upfront structuring fees and ongoing servicing income provides a balanced revenue stream capable of scaling as ASP gains market presence and diversifies into new asset verticals.


Note:

This plan is only an example outline. Real-world securitization businesses must customize their strategies based on specific asset classes (mortgages, consumer loans, etc.), target geographies, regulatory frameworks, and competitive dynamics. Detailed financial models, legal opinions, and robust operational frameworks would be essential to execute this plan successfully.

You may be interested in more direct lending financial models here. If you need help building a custom financial model, I offer my services here.

You can download SmartHelping's entire library of templates with the Super Smart Bundle.

Article found in Lending.

Net Operating Income (NOI) and Real Estate

 Net Operating Income (NOI) is a key financial metric in real estate that measures the profitability and performance of an income-producing property. It reflects the property’s ability to generate income after all operating expenses are taken into account but before financing costs (mortgage payments), taxes, depreciation, and amortization.


Keep in mind I've had clients who tried to put principal and interest expenses as well as CAPEX before the net operating income line. That would be highly inaccurate and you'll see why below. If you want to utilize some of the best underwriting tools, here's my entire real estate models library.

1. Understanding Net Operating Income

NOI Formula:

NOI=Gross Operating IncomeOperating Expenses
  1. Gross Operating Income (GOI) generally starts with the potential gross rent (the maximum rent you could collect if all units/spaces are fully occupied at market rates) and then subtracts vacancy and credit losses as well as loss-to-lease while adding any other income (e.g., parking fees, laundry, vending, etc.).

Operating Expenses typically include:

  • Property management fees
  • Maintenance and repairs
  • Utilities (if paid by the owner)
  • Insurance
  • Property taxes
  • Advertising and marketing costs
  • Landscaping and other day-to-day operational costs

Important Note: Mortgage payments and other debt service costs, owner’s personal expenses, capital expenditures (major property improvements or major repairs), depreciation, and income taxes are not part of operating expenses and are excluded from the NOI calculation.


2. What NOI Is Used For

  1. Property Valuation

    • Capitalization (Cap) Rate: The most common method to estimate a property’s value is using the cap rate formula:

      Cap Rate=NOIProperty Value​

      Rearranging this formula, you can estimate the property’s value if you know its NOI and a relevant market cap rate:

      Property Value=NOICap Rate​

      Investors and appraisers often rely on this approach to get a quick estimate of a property’s worth based on its income-generating potential.

  2. Comparing Investment Opportunities

    • By standardizing a property’s income and operating expenses (i.e., calculating NOI), investors can compare different properties on an “apples-to-apples” basis regardless of each property’s financing structure or tax situation.

  3. Debt Service Coverage Ratio (DSCR)

    • Lenders often use NOI to calculate the Debt Service Coverage Ratio, which measures how comfortably the property’s income can cover its debt obligations:

      DSCR=NOITotal Debt Service​

      A DSCR above 1.0 indicates the property’s NOI is sufficient to cover its mortgage payments. Lenders typically want to see a DSCR of 1.2 or higher (depending on the property type and risk tolerance).

  4. Measuring Property Performance

    • Tracking changes in NOI over time helps investors and property managers gauge whether operational changes, rent increases, or expense optimizations are effectively improving the bottom line.

  5. Strategic Decision-Making

  • Investors may look for properties with potential to improve NOI by:
    • Reducing operating expenses (e.g., installing energy-efficient systems)
    • Increasing rents or improving occupancy rates
    • Adding amenities that can generate additional income
  • An increased NOI can translate into higher property value and better returns on investment.
  1. Forecasting and Budgeting

    • When creating pro forma statements (financial projections for a property), investors use anticipated NOI to plan for future financing needs, potential distributions, and the overall viability of a project.

  2. Negotiating Property Purchases and Sales

    • Both buyers and sellers typically base their negotiations on the property’s current or pro forma NOI. A well-documented and stable NOI can command a higher sale price, while a lower or inconsistent NOI might reduce a property’s perceived value.


3. Key Takeaways

  • NOI Excludes: Mortgage payments, depreciation, personal expenses, income taxes, and capital expenditures.
  • NOI Focuses: Purely on operating performance—rent and other income minus operating expenses.
  • Uses of NOI: It’s crucial for property valuation, comparing investments, loan underwriting, measuring property performance over time, strategic decision-making, and negotiations in real estate transactions.

In summary, Net Operating Income provides a clear picture of a property’s operating performance and profitability, independent of financing decisions or tax strategies. Real estate investors and lenders rely heavily on NOI (alongside other metrics) to assess a property’s health, market value, and investment potential.

Article found in Real Estate.

Finding an Edge in Multi-Family Real Estate Investing

The largest number of templates I've built for a single industry over my career is multi-family. I've come across people doing work in the billions as well as smaller 10s of millions shops. Everyone has their own thing that they like to use to try and find an edge so lets get into it and a model is just one part. There's a lot that goes into strategy.

Multi-Family Acquisition Model - Includes T12, Joint Venture, and Detailed Forward Assumptions

SmartHelping / Real Estate / Excel

Multifamily Acquisition Financial Model

Underwrite a multifamily acquisition with historical operating data, a 20-unit-type rent roll, monthly value-add assumptions, flexible debt and three joint venture waterfall options. Follow the deal from closing through refinance, exit and investor returns.

10-year acquisition model T12 / T6 / T3 / T1 analysis 20 unit types 3 JV waterfall options
Multifamily acquisition underwriting financial model
$75 One-time purchase / Excel download
Add Multifamily Acquisition Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

See the model in action

Walk through the underwriting structure and outputs.

See how historical property performance, rent roll assumptions, financing, reserves and partnership terms connect to the pro forma and investor returns.

Open the multifamily model overview presentation

Use the presentation for a visual tour of the model's assumptions, underwriting schedules, waterfall options and return outputs.

What the model includes

A complete acquisition, operating and investor-return framework.

Start with the property's historical performance and existing rent roll, build a detailed forward operating plan, then evaluate financing, reserves, exit value and partnership economics.

01 / HISTORICAL ANALYSIS

Review T12, T6, T3 or T1 performance

Drop historical operating results into the model and select the look-back period that best supports the underwriting case and forward assumptions.

02 / RENT ROLL

Model as many as 20 unit types

Compare existing and potential rent by unit type, quantify loss-to-lease and build the revenue opportunity from the actual unit mix.

03 / SOURCES & USES

Build the complete closing requirement

Summarize acquisition funding and costs at both a high level and a granular level, including capital needs that occur in Period 0.

04 / FORWARD OPERATIONS

Adjust the operating plan month by month

Model loss-to-lease, economic vacancy, bad debt, concessions, renovation vacancy, value-add premiums and the timing of other income and expenses.

05 / INCOME & EXPENSE OPTIONS

Use the assumptions that fit the deal

Add as many as 10 ancillary income items and toggle operating expenses between historical T12 values, manual assumptions or T12-plus adjustments.

06 / FLEXIBLE DEBT

Combine acquisition, capex and seller financing

Model separate acquisition, capital expenditure and seller-note debt, then choose whether the seller note is refinanced or remains outstanding through exit.

07 / RESERVE ANALYSIS

Plan for operating burn and cash shortfalls

Forecast reserve needs during softer operating periods so the capital plan reflects potential lease-up pressure, vacancy and timing risk.

08 / JOINT VENTURE WATERFALLS

Toggle among three partnership structures

Compare a simple preferred return, IRR hurdles with optional GP catch-up, or hard preferred equity above a subordinated LP/GP hurdle waterfall.

09 / PRO FORMA & RETURNS

Connect monthly operations to annual results

Review monthly and annual pro formas, T12 and stabilized views, DSCR, cash-on-cash returns, project returns and LP/GP investment outcomes.

10 / FEES, KPIS & COMPARABLES

Bring decision-ready context into the file

Model acquisition, asset-management, debt-placement, guarantor, disposition, setup and construction fees, supported by a comparable tab, KPIs and 21 visualizations.

Joint venture flexibility

Choose the waterfall that matches the capital structure.

Each option includes inputs for LP and GP contributions, distribution splits and applicable return thresholds. Change the selected structure and review the resulting investment, distributions, IRR and equity multiple.

Simple preferred return

Define how cash is shared during the preferred-return phase, during return of capital and after contributed equity has been repaid.

IRR hurdles with optional GP catch-up

Split cash based on the LP reaching defined IRR hurdles. The optional catch-up can direct cash to the GP until its stated catch-up return is achieved.

Hard preferred equity plus IRR hurdles

Place a preferred-equity leg first in priority, with an optional equity kicker, then distribute remaining cash through a three-tier hurdle structure between the subordinated LP and GP.

Project-level alternative

If the acquisition is not a joint venture, use the project-level cash flows and returns without relying on the partnership waterfall outputs.

In-depth overview

Take a deeper look at the acquisition logic.

This extended walkthrough covers the historical analysis, operating assumptions, financing, reserves, outputs and investor return structures in more detail.

How to use it

Move from historical property data to a defensible acquisition case.

  1. Load the property history and rent roll

    Enter historical operating results and the unit mix, then choose the relevant T12, T6, T3 or T1 reference period.

  2. Build the forward operating plan

    Set rents, loss-to-lease, vacancy, concessions, bad debt, value-add premiums, other income, expenses and the timing of operational changes.

  3. Define funding and partnership terms

    Complete sources and uses, enter acquisition and supplemental debt, set refinance assumptions and choose the appropriate JV waterfall.

  4. Review feasibility and stress the deal

    Evaluate the pro formas, reserves, DSCR, cash-on-cash return, LP/GP outcomes, KPIs and exit results as the major assumptions change.

Who gets value from it

Built for the people underwriting and presenting a multifamily deal.

Multifamily sponsors

Translate a rent roll, historical operations and a value-add plan into a connected acquisition and investor-return case.

Acquisition teams

Compare actual property performance with forward assumptions, financing options, reserves and exit outcomes.

Investors and capital partners

Review project-level economics and LP/GP outcomes under several preferred-return and hurdle structures.

Analysts, advisors and consultants

Use a visible, fully editable framework to test assumptions and explain how operating changes affect cash flow and returns.

Also available in these bundles

Need a broader modeling library?

The Multifamily Acquisition Financial Model is also included in the Real Estate and Super Smart bundles.

Related real estate models

Hotel Deal Analysis - Advanced

Underwrite hotel operations, financing, value creation and investment returns.

Explore the hotel model

Fix and Flip Scaling Model

Plan repeated property acquisitions, renovations, sales and business growth.

Explore the fix-and-flip model

Senior Living Underwriting Model

Evaluate senior-living operating assumptions, occupancy, costs and returns.

Explore the senior-living model

Sale-Leaseback Analysis

Compare a sale-leaseback structure with alternative ownership and financing scenarios.

Explore the sale-leaseback model

Retail Construction

Forecast the construction, financing and operating economics of a retail property.

Explore the retail construction model

Lot Development

Model land development, lot release timing, costs, sales and project returns.

Explore the lot-development model

Strip Mall Acquisition Model

Underwrite tenant revenue, operating costs, financing and returns for a strip center.

Explore the strip-mall model

Apartment Building Model

Evaluate apartment-building acquisition assumptions, operations, debt and investment performance.

Explore the apartment model

Single-Tenant Industrial

Model lease income, expenses, financing and exit returns for a single-tenant asset.

Explore the industrial model

Mobile Home Parks

Forecast lot rent, occupancy, operating costs, financing and investor returns.

Explore the mobile-home-park model

Mixed-Use Real Estate

Combine multiple property uses in one leveraged acquisition and operating forecast.

Explore the mixed-use model

Self Storage - Up to 6 Deals

Compare and consolidate the economics of as many as six self-storage investments.

Explore the self-storage model

Rental Property Scaling

Plan the acquisition, operation and financing of a growing rental-property portfolio.

Explore the rental-scaling model

Condo Development

Forecast development costs, unit sales, financing and returns for a condo project.

Explore the condo model

Short-Term Rentals

Model nightly rates, occupancy, operating costs and returns across an STR portfolio.

Explore the STR model

Unit-Based Real Estate Acquisition

Build a 10-year acquisition forecast using units, rent, occupancy and operating assumptions.

Explore the unit-based model

Assisted Living Facility / Nursing Home

Connect resident capacity, occupancy, staffing and operating costs to long-term returns.

Explore the assisted-living model

Short-Term Rental Arbitrage

Evaluate leased-unit economics, occupancy, rates, operating costs and expansion.

Explore the rental-arbitrage model

Hotel Development / Acquisition

Forecast hotel development or purchase assumptions, operations, financing and exit value.

Explore the hotel model

Real Estate IRR Sensitivity Analysis

Test how occupancy and other assumptions affect property-level investment returns.

Explore the sensitivity model

Multifamily Acquisition - Annual Model

Use a streamlined annual-only structure for a multifamily acquisition.

Explore the annual multifamily model

Real Estate Flipping Calculator

Estimate purchase, renovation, holding and sale economics for an individual flip.

Explore the flipping calculator

Property Management Business

Forecast managed units, fee revenue, staffing, overhead and business cash flow.

Explore the property-management model

Real Estate Brokerage

Model transaction volume, commissions, agent splits, operating costs and profitability.

Explore the brokerage model

Real Estate Development

Track development budgets, actual spending, timing and remaining project costs.

Explore the development model

Real Estate Checklist

Organize real estate diligence and project tasks in a structured template.

Explore the real estate checklist

Rental Property ROI Calculator

Estimate cash flow and investment return for a rental-property opportunity.

Explore the rental ROI calculator

Related capital-structure tools

Questions before you buy

A few useful details.

What type of acquisition is this model designed for?

The model is designed for multifamily acquisitions with potentially light renovations where the acquisition and initial sources and uses occur in Period 0. Monthly operating assumptions can then reflect value-add improvements over time.

How much historical information can I analyze?

The historical tab accepts T12 information and can display T12, T6, T3 or T1 analysis so you can compare different recent operating periods.

How many unit types and ancillary-income items can I enter?

The rent roll supports as many as 20 unit types. The model also supports up to 10 ancillary income items, including four high-level items and six driven by unit assumptions.

Which joint venture structures are included?

You can toggle among a simple preferred return, IRR hurdles with an optional GP catch-up, or a hard preferred-equity leg over a subordinated three-tier LP/GP IRR waterfall.

Can the model refinance the acquisition debt?

Yes. The debt structure can include acquisition debt, capex debt and a seller note, with an option to refinance the applicable balances. The seller note can be rolled into the refinance or remain outstanding through exit.

Is the model editable and is it included in a bundle?

Yes. The Excel file is fully unlocked and editable. It is also included in the Real Estate Bundle and the Super Smart Bundle linked above.

Underwrite the property and the partnership together

Build a more defensible multifamily acquisition case.

Connect historical operations, the rent roll, value-add assumptions, financing, reserves, exit value and LP/GP returns in one 10-year Excel model. One-time purchase for $75.

Get the Multifamily Model