Stop Confusing Preferred Return (Pref) with IRR Hurdles

 People often confuse the terms "preferred return" and "IRR hurdles" because both concepts are related to the distribution of profits in real estate and private equity investments, and they both aim to ensure investors achieve certain financial benchmarks. However, there are key differences between them that can help clarify their distinct roles:

Strip Mall Real Estate Model - For Acquisitions - Up to 30 Tenants

SmartHelping / Real Estate / Excel

Strip Mall Acquisition Model

Underwrite a strip mall acquisition with up to 30 tenants, detailed lease assumptions, monthly and annual cash flow, renovation planning, four debt options, refinancing, and flexible GP/LP waterfall analysis. Follow the deal from purchase through operations, value creation, and exit.

Up to 10 years Up to 30 tenants NNN and gross leases Debt, JV waterfalls, and DCF

$75 One-time purchase / Excel download

Add Strip Mall Acquisition Model to Cart

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

Watch the walkthrough Explore the features Review tenant assumptions Review debt and waterfalls Review returns and outputs How to use it Included in bundles

See the model in action

Walk through the acquisition, lease, financing, and return analysis.

Watch the walkthrough, then open the screenshots to review the tenant inputs, monthly and annual pro forma, renovation schedule, debt options, refinancing, joint venture waterfalls, sensitivity analysis, and investor outputs.

Open the model screenshots

Review the tenant schedule, property assumptions, financing structures, cash flow, return metrics, and waterfall outputs before purchasing.

What the model includes

A complete strip mall acquisition underwriting framework.

Start with the purchase and existing leases, build the operating plan tenant by tenant, add capital improvements and financing, and evaluate project-level and investor-level returns.

01 / FORECAST HORIZON

Model up to 10 years

Build a long-range property forecast with monthly and annual views so lease timing, renovation spending, debt service, and exit proceeds stay visible.

02 / 30 TENANTS

Underwrite the rent roll tenant by tenant

Define assumptions for as many as 30 existing or future tenants, including current rent, future rent, lease timing, and each tenant's operating structure.

03 / LEASE STRUCTURES

Use NNN or gross terms by tenant

Choose triple-net or gross lease treatment for each tenant and change the structure when a lease expires or a new lease begins.

04 / EXISTING LEASES

Begin with in-place contract terms

Enter leases already in force, then transition tenants into new rent, reimbursement, and start-month assumptions when those agreements expire.

05 / CAPEX SCHEDULE

Plan renovations and improvements through time

Use a straightforward capital expenditure schedule to place renovation and improvement costs in the months when cash is expected to be spent.

06 / PROPERTY CASH FLOW

Drive from revenue to NOI and cash after debt service

See tenant rent and reimbursements flow through property expenses, net operating income, financing costs, and cash available after debt service.

07 / FOUR DEBT OPTIONS

Compare seller debt, traditional financing, a line of credit, and refinancing

Configure the financing approach that fits the deal, including interest-only periods and a future refinance of the property's outstanding debt.

08 / RETURNS AND SENSITIVITY

Review project, GP, and LP economics

Evaluate IRR, equity multiple, ROI, cash-on-cash return, DCF value, DSCR, and purchase-price versus exit-cap-rate sensitivity.

Tenant and lease assumptions

Model the property one tenant and one lease transition at a time.

The rent roll separates existing economics from the forward leasing plan so value-add assumptions can be tested without losing the timing of current contracts.

Existing rent

Enter the starting economics for occupied spaces and the month each existing rent arrangement ends.

New rent and start month

Define the replacement rent and the month it begins for each existing or future tenant.

NNN or gross

Select the lease structure by tenant and change it when the existing lease expires.

Expense reimbursement

Model reimbursement as a fixed amount or as a pro rata share of total property expenses, depending on the applicable lease.

Capital improvements

Schedule renovation and other CAPEX by month to understand when the value-add plan consumes cash.

Monthly and annual visibility

Review the detailed timing monthly and use the annual rollup for high-level underwriting, lender, and investor discussions.

Debt and partnership structure

Test acquisition financing, future refinancing, and GP/LP waterfalls.

Use the capital structure that fits the transaction, then see how financing and partnership terms affect cash flow after debt service and the returns received by each investor.

SELLER FINANCING

Use an interest-only seller loan

Evaluate an acquisition supported by seller financing and reflect its interest expense and payoff in the deal cash flow.

TRADITIONAL DEBT

Add an optional interest-only period

Configure conventional acquisition debt with an initial interest-only phase followed by regular amortizing payments.

LINE OF CREDIT

Include flexible operating liquidity

Use a line of credit alongside the property forecast to support acquisition, renovation, or operating cash requirements.

REFINANCING

Replace existing debt in a future month

Model a refinance after occupancy, NOI, or property value improves and follow the resulting debt balance and cash proceeds.

IRR HURDLE WATERFALL

Allocate cash through performance hurdles

Use an IRR-based waterfall for GP/LP distributions and evaluate the return earned by each side of the partnership.

PREFERRED RETURN

Use a pref-based distribution structure

Compare a preferred-return waterfall and include applicable GP fees when analyzing sponsor and investor economics.

Decision-ready outputs

See the property, financing, and partnership returns separately.

The model keeps property performance visible while showing how leverage, refinance proceeds, fees, and waterfall terms change the outcome for the GP and LP.

NOI and cash after debt service

Follow rent and reimbursements through operating expenses, NOI, debt service, and the cash available to equity.

Project-level returns

Review project IRR, equity multiple, ROI, cash-on-cash return, and the property's minimum equity requirement.

GP and LP returns

Compare contributions and distributions for each side of the joint venture under the selected waterfall structure.

DCF analysis

Evaluate discounted cash flow for the project and for the modeled partnership scenarios.

DSCR

Monitor debt service coverage in the monthly and annual pro forma as operating performance and financing assumptions change.

IRR sensitivity

Test how acquisition price and exit cap rate work together to change the modeled investor return.

How to use it

Move from the rent roll to a complete acquisition decision.

1. 01

   Enter the purchase and current property position

   Set the acquisition assumptions, in-place tenants, existing rents, lease expirations, operating expenses, and opening capital structure.

2. 02

   Build the forward leasing and renovation plan

   Define new rent, start months, NNN or gross treatment, reimbursements, vacancy timing, and scheduled capital improvements.

3. 03

   Configure debt and partnership terms

   Select the applicable debt options, add refinancing assumptions, enter GP fees, and choose an IRR-hurdle or preferred-return waterfall.

4. 04

   Review cash flow, coverage, value, and returns

   Evaluate NOI, cash after debt service, DSCR, DCF value, project and investor returns, and purchase-price versus exit-cap-rate sensitivity.

Who gets value from it

Built for the teams underwriting and operating neighborhood retail.

Real estate investors and buyers

Underwrite the acquisition, existing rent roll, value-add plan, financing, exit, and equity returns in one connected model.

Sponsors and asset managers

Test rent transitions, renovation spending, refinancing, GP fees, and the economics of a joint venture structure.

Lenders and capital partners

Review NOI, monthly and annual debt service, DSCR, leverage, refinance assumptions, and downside sensitivity.

Advisors and financial modelers

Use a detailed, editable framework to analyze offering memoranda, compare structures, and communicate the deal to stakeholders.

Also available in these bundles

Need a broader spreadsheet library?

The Strip Mall Acquisition Model is also included in the Real Estate, Sensitivity Analysis, and Super Smart bundles.

Real Estate Models

Explore acquisition, development, debt, refinancing, operating, exit, and GP/LP return models across property types.

View Real Estate Models

Sensitivity Analysis Models

Compare how changing acquisition, operating, financing, and valuation assumptions affect the modeled outcome.

View Sensitivity Analysis Models

Super Smart Bundle

Get the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.

View Super Smart Bundle

More real estate financial models

Extend the acquisition, development, and exit analysis.

Use these complementary SmartHelping models for other commercial properties, development strategies, and financing decisions.

Hotel Investment Analysis

Underwrite an acquisition, new construction, or a combined hotel and residential strategy with detailed operating, debt, and return assumptions.

Explore the hotel model

Multifamily Acquisition

Use historical operating data, a detailed rent roll, value-add assumptions, flexible debt, refinancing, and three JV waterfall options.

Explore the multifamily model

Sale-Leaseback Analysis

Compare tenant and landlord economics across ownership, sale, lease, financing, and discounted cash-flow alternatives.

Explore the sale-leaseback model

Retail Building Construction

Underwrite the construction, lease-up, financing, operations, and exit of a new retail property.

Explore the retail construction model

Lot Development

Plan land acquisition, site improvements, financing, lot sales, cash flow, and joint venture returns.

Explore the lot development model

Single-Tenant Industrial

Evaluate a single-tenant commercial property with lease, debt, exit, and investor-return assumptions.

Explore the industrial model

Mixed-Use Real Estate

Model multiple property uses, operating revenue, expenses, leverage, exit value, and joint venture options.

Explore the mixed-use model

Custom Financial Model Work

Request modifications to this strip mall model or a custom underwriting framework built around a live property or transaction.

Contact SmartHelping

Questions before you buy

A few useful details.

How long is the forecast?

The model supports up to 10 years and includes monthly and annual views so lease, renovation, debt, and exit timing can be evaluated at the appropriate level of detail.

How many tenants can I model?

You can enter assumptions for as many as 30 tenants, including existing and future rent terms and the month each new rent begins.

Can tenants use different lease structures?

Yes. Each tenant can be modeled as NNN or gross, and that choice can change when the current lease expires. Reimbursement can use a fixed amount or a pro rata percentage of property expenses.

What financing options are included?

The model includes an interest-only seller financing loan, traditional acquisition debt with an optional interest-only period, a line of credit, and a future refinance.

Does the model support a joint venture?

Yes. It includes GP fees, GP/LP return analysis, and two waterfall approaches: IRR hurdles and a preferred-return structure.

Which return and risk outputs are included?

Outputs include project IRR, equity multiple, ROI, cash-on-cash return, GP and LP returns, DCF analysis, DSCR, and IRR sensitivity using purchase price and exit cap rate.

Is it included in any bundles?

Yes. It is included in the Real Estate, Sensitivity Analysis, and Super Smart bundles.

Underwrite the full strip mall investment

Connect every lease, capital improvement, loan, and waterfall to the return.

Build a tenant-level, monthly and annual acquisition forecast with four debt options, refinancing, DSCR, DCF, sensitivity analysis, and GP/LP returns. One-time purchase for $75.

Get the Strip Mall Model

Valuation Multiples for Top 10 Industries in the United States

 Valuation multiples for private companies vary by industry, size, growth prospects, and other factors. Here’s a look at the typical business valuation multiples for private companies in the 10 biggest industries in the United States, along with the major factors impacting their valuation:

Debt Funds and Real Estate

 Debt funds in the real estate industry are investment pools that lend money to real estate developers or owners. Investors put their money into these funds with the expectation of receiving regular interest payments, and eventually, the return of their principal. Here’s a detailed look at how these funds operate, the potential risks involved, and how to model such investments.

Start an Electrical Vehicle Charging Station Business: 10 Year Financial Model Template

SmartHelping / EV Infrastructure / Excel

EV Charging Station Financial Model

Plan a 10-year EV charging rollout across up to three charger types and 120 deployment tranches. Connect deployment timing, vehicle traffic, session demand, kWh usage, one-time and subscription pricing, direct costs, financial statements, valuation, and investor returns.

10-year forecast 3 charger types / 120 tranches Monthly and annual 3 statements DCF, IRR, and equity multiple

$75 One-time purchase / Excel download

Add EV Charging Station Model to Cart

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

Watch the walkthrough Explore the features Review operating drivers Review revenue and returns How to use it Included in bundles

See the model in action

See how charger deployment, usage, pricing, and costs connect.

Watch the walkthrough, then open the screenshots to review the deployment assumptions, one-time and subscription revenue, direct costs, financial statements, valuation, return analysis, and operating visuals.

Open the model screenshots

Use the screenshots with the video to inspect the workbook structure and key assumptions before purchasing.

What the model includes

A connected rollout model for EV charging infrastructure.

Build deployment and utilization from the bottom up, test pay-per-use and subscription economics, and follow the results through a complete financial forecast.

01 / 10-YEAR FORECAST

Model deployment and operations over time

Run a detailed forecast for as many as 10 years and see how rollout timing shapes revenue, cash flow, and returns.

02 / DEPLOYMENT TRANCHES

Scale through as many as 120 tranches

Schedule charger additions in cohorts so installation timing, operating activity, and cash requirements build progressively.

03 / CHARGER TYPES

Configure up to three charger types

Use different deployment cost, pricing, usage, and direct-cost assumptions for the charger formats in the rollout.

04 / USAGE DRIVERS

Connect vehicles, sessions, and kWh demand

Adjust vehicle counts and kWh usage per session by tranche to create a transparent operating-volume forecast.

05 / SUBSCRIPTIONS

Offer four membership pricing tiers

Forecast tier mix, subscriber utilization, available network capacity, and the percentage of monthly kWh limits used.

06 / DIRECT COSTS

Separate fixed and energy-driven costs

Model a fixed cost per charger per month plus a variable cost for each kWh transmitted through the network.

07 / THREE STATEMENTS

Review monthly and annual financials

Follow the operating assumptions through connected Income Statement, Balance Sheet, and Cash Flow Statement views.

08 / VALUE AND RETURNS

Evaluate DCF, IRR, and equity multiple

Review project-, operator-, and investor-level economics, including an optional terminal value based on trailing-12-month EBITDA.

Bottom-up operating framework

Build each deployment cohort around the assumptions that drive station economics.

The tranche structure lets timing, installation economics, demand, usage, pricing, and costs vary across the charger network.

Deployment timing

Schedule when each tranche is installed and begins operating so infrastructure spending and revenue ramp in the intended months.

Deployment cost

Set the capital required for the charger type and cohort instead of relying on one blended network-wide cost.

Vehicle activity

Define the vehicle counts associated with each tranche and use them as the operating base for session demand.

kWh per session

Estimate energy delivered during a charging event and connect session behavior directly to transmitted kWh.

Customer pricing

Set charging prices by tranche and test how pricing changes affect revenue, customer economics, and operator margins.

Energy and fixed costs

Combine cost per kWh transmitted with recurring fixed cost per charger to calculate the direct cost of operating the network.

Revenue, reporting, and returns

Test the business from customer monetization through investor outcomes.

Use flexible revenue assumptions, integrated statements, valuation tools, and visual outputs to understand the network at multiple levels.

PAY-PER-USE

Forecast one-time charging revenue

Link charger activity, kWh usage, and pricing to the revenue generated by non-subscription customers.

FOUR SUBSCRIPTION TIERS

Model recurring membership revenue

Set tier pricing and participation while constraining demand by capacity, subscriber utilization, and monthly kWh allowances.

THREE PERSPECTIVES

Review project, operator, and investor views

Evaluate performance through the operating asset, the network operator, and the capital provider perspectives.

TERMINAL VALUE

Value the business beyond the forecast

Use trailing-12-month EBITDA as the basis for an optional terminal value at the end of the modeled period.

EXECUTIVE SUMMARY

Review annual results in one place

Use the annual executive summary to communicate core operating, financial, and return outputs.

19 VISUALIZATIONS

Track unit economics and performance

Review key statistics including average revenue, cost, and profit per charger per month alongside other operating and financial trends.

How to use it

Move from rollout assumptions to value and returns.

1. 01

   Define charger types and deployment cohorts

   Configure the charger formats, rollout tranches, installation timing, and deployment cost assumptions.

2. 02

   Build customer activity and energy usage

   Enter vehicle counts, session behavior, kWh usage, capacity, and utilization assumptions by tranche.

3. 03

   Set pricing and operating costs

   Model one-time charging fees, four subscription tiers, cost per kWh, and fixed monthly cost per charger.

4. 04

   Review statements, valuation, and returns

   Use the monthly and annual statements, executive summary, DCF, IRR, equity multiple, terminal value, and visualizations to test the plan.

Who gets value from it

Built for teams planning and funding EV charging networks.

EV charging operators

Plan station rollout, utilization, customer pricing, energy throughput, operating costs, and network profitability.

Infrastructure developers

Test site-by-site or cohort-based deployment timing, capital requirements, ramp-up, and long-term value.

Investors and lenders

Review cash requirements, financial statements, DCF value, IRR, equity multiple, and exit economics.

Advisors and financial modelers

Use a detailed, editable framework for feasibility studies, fundraising, scenario analysis, and client planning.

Also available in these bundles

Need a broader spreadsheet library?

The EV Charging Station Financial Model is also included in the Industry-Specific, SaaS / Recurring, Services, and Super Smart collections.

Industry-Specific Models

Access bottom-up financial models designed around the operating drivers of specific business types.

View Industry-Specific Models

SaaS / Recurring Models

Explore subscription, membership, usage-based, and other recurring-revenue financial models.

View SaaS / Recurring Models

Service Business Models

Compare service-business forecasts for staffing, utilization, customer demand, pricing, and profitability.

View Service Business Models

Super Smart Bundle

Get the complete SmartHelping collection for forecasting, valuation, accounting, financing, real estate, and more.

View Super Smart Bundle

Related financial models

Explore adjacent infrastructure, energy, and deployment models.

Use these complementary SmartHelping templates for renewable-energy projects, physical network rollouts, capacity planning, and operating forecasts.

Battery Recycling Plant

Forecast feedstock, processing capacity, recovered materials, costs, financing, and plant returns.

Explore the battery recycling model

Solar Farm

Connect utility-scale solar generation, revenue, costs, financing, valuation, and investor returns.

Explore the solar farm model

Hydropower

Evaluate power generation, construction spending, operating costs, debt, valuation, and returns.

Explore the hydropower model

Wind Farm

Forecast turbine capacity, energy production, revenue, project costs, financing, and returns.

Explore the wind farm model

Biogas

Model feedstock, biomethane production, sales, operating costs, financing, and project economics.

Explore the biogas model

Solar Panel Installer

Forecast installation volume, pricing, crews, equipment, operating costs, and business cash flow.

Explore the solar installer model

Equipment Rental

Plan unit deployment, utilization, rental pricing, direct costs, debt, and asset-level returns.

Explore the equipment rental model

Custom Financial Model Work

Request modifications to this EV charging model or a custom infrastructure forecast for a specific rollout.

Contact SmartHelping

Questions before you buy

A few useful details.

How long is the forecast?

The model supports up to 10 years of EV charger deployment and operation, with detailed monthly assumptions and monthly and annual financial statement views.

How many charger types and deployment tranches can I model?

You can configure up to three charger types and as many as 120 deployment tranches, with operating and economic assumptions defined by tranche.

Can I model both one-time charging and subscriptions?

Yes. The template supports pay-per-use pricing plus four subscription tiers driven by available capacity, subscriber utilization, and the percentage of each monthly kWh allowance used.

Which direct costs are included?

You can enter a fixed cost per charger per month and a variable cost per kWh transmitted, with deployment costs, pricing, vehicle counts, and session usage also configurable by tranche.

Which valuation and return outputs are included?

The model includes DCF analysis, IRR, equity multiple, project-, operator-, and investor-level views, and an optional terminal value based on trailing-12-month EBITDA.

Is it included in any bundles?

Yes. It is included in the Industry-Specific, SaaS / Recurring, Services, and Super Smart collections.

Build the rollout before committing capital

Turn charger deployment and customer usage into cash flow, value, and returns.

Get the fully editable 10-year model with up to three charger types, 120 deployment tranches, one-time and subscription pricing, integrated financial statements, valuation, and return analysis. One-time purchase for $75.

Get the EV Charging Station Model

Revenue Leakage and SaaS: What it Is and How to Minimize

SaaS (Software as a Service) revenue leakage refers to the loss of potential revenue within a SaaS business. This typically happens due to various reasons, such as:

Latest Custom Financial Models Added to SmartHelping Plus - 5/6/2024

 This was a slower tranche of spreadsheet work in the last few weeks, but some very useful modifications were done in the equipment rental and SaaS acquisition space. I was actually considering updating the base equipment rental model with this update, but I've chosen to only add it here for now.

SmartHelping Plus Spreadsheet Update Log

 As I added new financial model templates to the SmartHelping Plus bundle, I'll be doing more in-depth explanations and videos about the customizations done to or the main premise behind the files that get added to this bundle. Here you will see time-stamped logs with a link to the update of each tranche. Usually I will try to do an update log every few weeks or at least monthly to go over all the new additions.

• 6/21/2024 - Condo Development Cost per Sq Ft Override
• 5/6/2024 - Equipment Rental new revenue logic for additional revenue types and SaaS
• 4/16/2024 - Primarily Condo Development Modifications (build and sell version)

Download all these spreadsheets here.