Why do Some Real Estate Syndication Deals Use GP Catch-ups?

In real estate syndication deals, profit distribution between the general partner (GP) and limited partners (LPs) is a critical aspect of the investment structure. A GP catch-up is a provision that allows the GP to receive a disproportionate share of profits after the LPs receive their preferred return, effectively "catching up" to the agreed profit split. Some deals include this mechanism, while others do not. The inclusion or exclusion of a GP catch-up depends on various factors, including negotiation dynamics, market conditions, and the desired alignment of incentives between the GP and LPs.

Preferred Return Model with Optional Split During Preferred Return Phase

SmartHelping / Joint Venture Waterfalls / Excel

Preferred Return Model with an Optional Split During the Preferred Return Phase

Model GP and LP cash flows through three configurable distribution tiers. Split cash during the preferred-return phase, return LP capital and then apply the final profit split in one editable worksheet.

Three distribution tiers Optional split during the pref Arbitrary cash-flow streams GP and LP IRR and MOIC
Preferred return model with optional split during the preferred return phase
$45 One-time purchase / Excel download
Add Preferred Return Model to Cart

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

See the model in action

Follow contributions and distributions through every tier.

The walkthrough shows how the preferred return, unpaid balance, LP equity basis and configurable GP/LP splits work together.

Open the model overview presentation

Use the presentation for a visual tour of the three tiers, preferred-return calculations and GP/LP summaries.

What the template includes

Flexible waterfall logic in a portable one-tab model.

Link the worksheet to capital contributions and distributable cash flow from an existing model, then define the preferred return and distribution rules.

01 / CASH-FLOW STREAMS

Handle contributions and distributions over time

Use arbitrary cash-flow streams rather than relying on one contribution date or one exit distribution.

02 / PREFERRED RETURN

Set the preferred-return rate manually

Define the LP preferred-return rate and track the amount earned, paid and remaining unpaid through time.

03 / COMPOUNDING

Choose whether unpaid returns capitalize

Turn capitalization on when unpaid preferred returns should compound, or leave it off for non-compounding treatment.

04 / ACCRUAL METHOD

Carry unpaid returns or start clean each year

Select whether unpaid preferred returns continue accruing or reset under the structure you are modeling.

05 / EQUITY BASIS

Control how distributions reduce LP capital

Use the optional basis rule to reduce LP equity for distributions paid above the preferred-return amount.

06 / TIER SPLITS

Set the GP and LP split in every tier

Define separate sharing percentages for the preferred-return phase, return-of-capital phase and final profit tier.

07 / PORTABLE LOGIC

Connect the waterfall to a working model

All logic sits on one tab, making it easier to reference capital needs and available cash from another workbook model.

08 / EDITABLE FILE

Adjust formulas and assumptions directly

The workbook is unlocked and editable in Excel and can also be uploaded to Google Sheets.

Three-tier distribution waterfall

Separate the preferred return, capital repayment and final profit split.

This is a preferred-return model: the LP receives priority on its return in Tier 1, but invested capital is not returned until the Tier 2 rules apply.

Tier 1 / Preferred return

Split available cash between the GP and LP using a configurable percentage until the LP has received its full preferred return, including applicable unpaid or accrued amounts. This tier does not return invested capital.

Tier 2 / Return of capital

After Tier 1 is satisfied, split remaining cash using a second GP/LP percentage until the LP has received its full initial investment back.

Tier 3 / Final split

Once the preferred return and LP capital have been fully distributed, apply the final GP/LP split to all remaining available cash.

How to use it

Move from project cash flow to partner distributions.

  1. Enter contributions and available cash

    Input the required capital contributions and the cash available for distribution in each period.

  2. Define the preferred return

    Set the rate, capitalization choice and treatment of unpaid returns over time.

  3. Configure the three splits

    Enter the GP and LP percentages for the preferred-return, return-of-capital and final profit phases.

  4. Review partner outcomes

    Analyze distributions by category and tier alongside GP and LP IRR, MOIC and remaining balances.

Analysis and reporting

See what each partner receives and why.

The summaries separate preferred-return payments, return of capital and profit distributions instead of showing only one total cash-flow line.

01 / DISTRIBUTION TIERS

Trace cash through every phase

Review the contributions and distributions allocated to the GP and LP in each tier.

02 / CASH CLASSIFICATION

Separate return types

Identify cash classified as preferred return, return of capital and profit distributions for each partner.

03 / PARTNER RETURNS

Measure GP and LP performance

Review final IRR and equity multiple outputs for both the GP and LP.

04 / RUNNING BALANCES

Monitor what remains unpaid

Track the outstanding preferred-return balance and LP equity basis as contributions and distributions occur.

Who gets value from it

Built for teams structuring GP and LP economics.

Real estate sponsors

Test a preferred-return structure before adding it to a property acquisition or development model.

Investment managers

Compare how tier splits, accrual rules and capital repayment affect partner outcomes.

Analysts and advisors

Explain the difference between preferred return, return of capital and final profit participation.

Financial model builders

Port the one-tab waterfall into a larger operating, fund or transaction model.

Also available in these bundles

Need more than one waterfall structure?

This preferred-return model is included in the following SmartHelping collections.

Related financial models

Questions before you buy

A few useful details.

Does Tier 1 return the LP's invested capital?

No. Tier 1 gives the LP priority on its preferred return, including applicable unpaid or accrued amounts. Return of the LP's initial investment occurs under Tier 2.

Can cash still be split with the GP during the preferred-return phase?

Yes. Tier 1 lets you define the percentage of available cash distributed to the GP and LP while the LP's preferred-return balance is being satisfied.

Can unpaid preferred returns compound?

Yes. The model includes an option to capitalize unpaid preferred returns so they compound. You can leave that option off when compounding is not part of the deal.

Can the model handle multiple contributions and distributions?

Yes. It supports arbitrary contribution and distribution cash-flow streams over time rather than requiring a single investment and exit.

Can I add this waterfall to another financial model?

Yes. All waterfall logic is contained on one tab. Reference the capital-investment and available-distribution rows from your working model to feed the calculation.

Is the workbook editable?

Yes. The formulas and tabs are unlocked and editable in Excel. You can also upload the workbook to Google Sheets.

Make the GP and LP economics visible

Model the preferred return, capital repayment and final split in one place.

Configure all three tiers and review partner-level distributions, IRR and equity multiples. One-time purchase for $45.

Get the Preferred Return Model

Financial Modeling for a New B2B SaaS startup

I've done many SaaS financial models in Excel over the past decade, with my own guidance and with the guidance of clients. Most of them were for startups, and a some were for existing operations. The main tenants are always true. That is a focus on retention modeling frameworks / customer pattern modeling, opex / burn, fundraising, capital management, pricing, customer acquisition, and churn.

Annual Churn Rate Calculator - Excel Template

SmartHelping / SaaS Churn / Excel

Annual Churn Rate Calculator

Measure annual customer churn with three complementary calculation methods. Use either forward-looking SaaS assumptions or actual customer start and end dates, then compare monthly and annual customer movement, cohort behavior and the resulting retention pattern.

3 annual churn methods Forecast + historical versions Monthly + annual detail Cohort retention pattern
Annual churn rate calculator Excel template
$45 One-time purchase / Excel download
Add Annual Churn Rate Calculator to Cart

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

See the model in action

See the forecast and historical versions in action.

Walk through how new customers, retention patterns and actual customer dates produce monthly movement, annual churn calculations and cohort-level insights.

Open the annual churn rate calculator presentation

Use the presentation for a visual tour of the input structures, customer movement, calculation methods, retention pattern and charts.

What the model includes

A comprehensive view of customer loss and retention.

Compare three annual churn methodologies, forecast future customer movement from retention assumptions, and calculate actual historical results directly from customer start and end dates.

01 / THREE METHODS

Calculate annual churn three different ways

Compare a simple average-customer approach, cohort analysis and a detailed customer-month method within the same Excel framework.

02 / FORWARD MODELING

Forecast churn from customer additions and retention

Enter new customers by month and a retention pattern to model how the customer base develops in future periods.

03 / HISTORICAL ACTUALS

Calculate churn from real customer dates

Enter each customer's start and end date and let the workbook derive the actual activity, churn and retention results.

04 / CUSTOMER MOVEMENT

Follow additions, losses and ending customers

Review monthly and annual detail showing customers added, customers lost and the ending customer balance.

05 / RETENTION PATTERN

Derive observed retention from historical data

Use actual customer behavior to see the retention curve that emerges from the historical start- and end-date records.

06 / COHORT ANALYSIS

Separate churn behavior by customer group

Analyze existing customers and newly acquired cohorts independently to avoid blending materially different retention behavior.

07 / CUSTOMER-MONTHS

Account for exact exposure time

Measure the months or fractions of months each customer was active so the churn denominator reflects the time customers were actually at risk.

08 / UNLOCKED LOGIC & VISUALS

Follow the calculations and communicate the result

Inspect and edit the unlocked formulas, then use the included visualizations to explain customer movement and retention more clearly.

Three annual churn methodologies

Choose the calculation that fits the available data.

The three approaches trade simplicity for precision. Comparing them helps show why annual churn can look different depending on the customer base and denominator used.

Average number of customers

Divide customers lost during the year by the average customer count. This is fast and accessible but can be less precise when the customer base changes materially.

Cohort analysis

Calculate churn separately for customer groups based on when they joined, improving visibility into behavioral differences between existing and new customers.

Total customer-months

Use the exact duration each customer was active to calculate average monthly exposure and align churn more closely with the time customers were at risk.

How to use it

Move from customer data to a defensible annual churn rate.

  1. Choose the forecast or historical version

    Use the forward model to plan customer retention or the actuals model to analyze realized behavior from customer records.

  2. Enter the customer inputs

    Provide monthly new-customer assumptions and a retention curve, or enter the actual start and end date for each customer.

  3. Compare the three annual methods

    Review the average-customer, cohort and customer-month calculations to understand why the resulting churn rates differ.

  4. Review movement and retention

    Analyze customers added, lost and remaining by month and year, then use the retention pattern and charts to communicate the result.

Who gets value from it

Built for teams that need to understand customer stickiness.

SaaS founders and operators

Quantify how customer losses affect the installed base and compare expected retention with actual results.

Finance and planning teams

Use a transparent annual churn calculation to support forecasts, budgets and recurring-revenue analysis.

Customer-success and growth teams

Identify retention differences by cohort and see when customer losses occur across the lifecycle.

Investors, advisors and analysts

Review multiple calculation methods and the underlying customer movement instead of relying on one unexplained churn percentage.

Also available in these bundles

Need a broader modeling library?

The Annual Churn Rate Calculator is also included in the SaaS / Subscription Models and Super Smart bundles.

Related financial models

Questions before you buy

A few useful details.

What are the three annual churn methods?

The workbook compares churn based on average customers, separate customer cohorts and total customer-months. Each method uses a different denominator and level of detail.

What do I enter in the forward-looking version?

Enter new customers by month and the expected retention pattern. The model then projects customers added, lost and remaining over time.

What data does the historical version require?

The historical actuals version uses each customer's start and end date. The customer movement and retention pattern are derived from those records.

Why use the customer-month method?

It accounts for the exact time each customer was active during the year, producing a denominator that more closely reflects actual exposure to churn.

What outputs are included?

The calculator shows monthly and annual customers added, customers lost and ending balances, along with the three annual churn results, historical retention pattern and visualizations.

Is the workbook editable and included in bundles?

Yes. The calculations are unlocked and editable so you can follow the logic. The calculator is also included in the SaaS / Subscription Models and Super Smart bundles.

Make the churn calculation transparent

Understand not only the rate, but how it was calculated.

Compare three annual methods, model future retention and analyze actual customer history in one unlocked Excel calculator. One-time purchase for $45.

Get the Annual Churn Rate Calculator

Activity-Based Costing (ABC) Financial Model Template

SmartHelping / Cost Accounting / Excel

Activity-Based Costing Model

Calculate the true cost of products, services or customers by assigning resource costs to the activities that actually consume them. Build up to 23 activities, map as many as 20 costs to each activity and analyze unit economics across up to 39 products.

Up to 23 activities Up to 39 products Cost + margin analysis Fully editable Excel
Illustrated activity-based costing process with materials, labor and overhead activities
$45 One-time purchase / Excel download
Add Activity-Based Costing Model to Cart

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

See the model in action

See the activity-based costing workflow in Excel.

Walk through the activity setup, cost pools, cost-driver inputs, product usage assumptions and output analysis that converts operational activity into cost per unit and margin insight.

Open the Activity-Based Costing model presentation

Use the presentation for a visual tour of the workbook structure, inputs, cost allocation logic and product-level output analysis.

What the model includes

A transparent framework for tracing costs to products and services.

Define the activities that consume resources, calculate an activity rate from the appropriate cost driver and allocate those costs based on how each product, service or customer uses the activity.

01 / ACTIVITY SETUP

Define up to 23 operating activities

Create the activity pools that reflect how work is actually performed, from purchasing and setup to processing, fulfillment and customer support.

02 / COST POOLS

Assign up to 20 costs to each activity

Build each activity's total cost from the relevant labor, overhead and other resource inputs instead of relying on one broad allocation percentage.

03 / COST DRIVERS

Define the driver units behind each activity

Enter the total cost-driver volume for the period so the model can calculate a transparent rate per order, setup, labor hour, machine hour or other driver.

04 / PRODUCT USAGE

Analyze as many as 39 products or services

Enter how many units of each activity every product, service or customer consumes and let the workbook allocate costs accordingly.

05 / UNIT COST

Calculate the total cost per offering

Combine activity allocations to see the full modeled cost to produce a product, deliver a service or support a specific customer group.

06 / MARGIN ANALYSIS

Compare current and target economics

Review revenue, cost, cost per unit, current gross profit and margin, target margin and the price adjustment implied by the target.

07 / WORKBOOK STRUCTURE

Use three input sheets and one output sheet

Move through a structured five-sheet workbook that includes three input tabs, a consolidated analysis tab and a dedicated instructions tab.

08 / EDITABLE LOGIC

Expand and adapt the unlocked model

Inspect every calculation, change labels and assumptions, or extend the structure around the activities and cost objects used by your organization.

How activity-based costing works

Trace resource costs through activities to the final cost object.

The model replaces broad overhead allocations with a driver-based path that shows what creates the cost and which products, services or customers consume it.

Resources become activity cost pools

Group labor, occupancy, equipment, administration and other relevant costs around the operating activities that consume those resources.

Cost drivers create activity rates

Divide each activity's total cost by its total driver units to calculate a measurable cost per order, setup, hour, transaction or other operational driver.

Usage assigns costs to cost objects

Multiply the activity rate by the driver units consumed by each product, service or customer to reveal total cost, unit cost and the resulting profitability.

How to use it

Move from resource costs to actionable unit economics.

  1. Define the activities

    List the recurring activities required to produce an offering, deliver a service or support a customer and select a practical cost driver for each one.

  2. Build the activity cost pools

    Enter the resource costs associated with each activity and the total number of cost-driver units completed during the period.

  3. Enter product or customer usage

    Specify how many units of each activity are consumed by every product, service, project or customer group being analyzed.

  4. Review cost and margin results

    Compare total cost, unit cost, current pricing and target margin to identify repricing, process improvement or product-mix opportunities.

Who gets value from it

Built for teams that need a clearer view of what drives cost.

Manufacturers and product businesses

Allocate setup, purchasing, production, quality and fulfillment costs according to the activity each product actually requires.

Service businesses and agencies

Measure the cost of serving different clients, projects or customer cohorts and align pricing with target gross margins.

Controllers, accountants and FP&A teams

Replace broad overhead assumptions with auditable cost pools, cost drivers and product-level allocation logic.

Owners and operating managers

Identify low-margin offerings, expensive activities, resource bottlenecks and opportunities to improve pricing or processes.

Also available in these bundles

Need a broader modeling library?

The Activity-Based Costing Model is also included in the Accounting, Manufacturing and Super Smart bundles.

Related accounting and operating models

The source page's accounting-tool links are preserved below as fully clickable cards.

Warehouse Fulfillment Operator

Forecast pallet- or cubic-foot-based fulfillment revenue, labor, capacity, expenses and cash flow.

Explore the fulfillment model

Discount Bond Model

Calculate effective interest income and connect discount-bond accounting to financial statements.

Explore the bond model

Sales and Purchases on Account

Model sales and purchases on account for integrated receivables, payables and three-statement forecasts.

Explore the account helper

13-Week Cash Flow Planner

Build a detailed short-term cash forecast with weekly inflows, outflows and liquidity visibility.

Explore the cash planner

Financial Statement Generator

Produce income statements, balance sheets and cash flow statements using cash or accrual accounting.

Explore the statement generator

FIFO COGS Calculator

Calculate inventory cost of goods sold using the first-in, first-out accounting method.

Explore the FIFO calculator

Cash Conversion Cycle

Track inventory, receivable and payable days to understand the cash tied up in working capital.

Explore the cash-cycle tracker

Accounts Receivable and Payable

Track invoices, aging, cash collections and upcoming payment obligations in one accounting tool.

Explore the AR/AP tracker

Volume Discount Pricing

Test price breaks, unit volume, revenue, cost and profitability across volume-discount tiers.

Explore the pricing calculator

General Loan Amortization

Build dynamic principal, interest and balance schedules for a range of borrowing scenarios.

Explore the loan schedule

Cost Segregation Study

Analyze accelerated depreciation timing and tax benefits for real-estate components.

Explore the cost-segregation model

Budget vs. Actual Planner

Compare monthly actual performance with budgeted revenue, costs, expenses and cash balances.

Explore the variance planner

90-Day Cash Flow Planner

Project daily cash balances from current cash, expected receivables and upcoming payables.

Explore the daily cash planner

WACC Calculator

Calculate a weighted average cost of capital from debt, equity, CAPM and tax assumptions.

Explore the WACC model

3-Statement Startup Model

Build an integrated income statement, balance sheet and cash flow forecast for a startup.

Explore the 3-statement model

Equipment ROI Calculator

Evaluate equipment investment returns, financing, cash flow and sensitivity cases.

Explore the equipment model

Billable Hours Tracker

Track time and activity by client or job to support billing and utilization analysis.

Explore the time tracker

To-Do List Tracker

Manage recurring work, due dates, completion history and workload in Google Sheets.

Explore the task tracker

Job Bidding

Estimate wages, direct costs, fees, price and expected margin when preparing project bids.

Explore the bidding model

Inventory in a 3-Statement Model

Connect inventory purchasing, cost of goods sold and cash timing inside an integrated forecast.

Explore the inventory model

Payroll Calculator and Tracker

Compare payroll budget with actual wages, hours and related employment costs.

Explore the payroll tracker

Real-Time Profit and Loss Tracker

Track income, expenses, profit and cash flow in a live Google Sheets workflow.

Explore the P&L tracker

Break-Even Analysis

Calculate the sales volume needed to cover fixed and variable costs or reach a target profit.

Explore the break-even model

Depreciation Expense Tool

Track monthly and annual depreciation, accumulated depreciation and book value for fixed assets.

Explore the depreciation tool

Depreciation Recapture Calculator

Estimate taxable gain and depreciation recapture when selling depreciable assets.

Explore the recapture model

Expense Tracker

Organize recurring expenses by category and review monthly and annual spending patterns.

Explore the expense tracker

Financial Statement KPIs

Calculate and compare liquidity, leverage, profitability, turnover and other accounting ratios.

Explore the KPI tool

Google Sheets Inventory Tracker

Track inventory balances, activity and locations in a flexible Google Sheets tool.

Explore the Sheets tracker

Inventory Reordering Planner

Estimate reorder timing and quantities from demand, stock levels and replenishment assumptions.

Explore the reorder planner

Inventory Restocking Cash Flow

Forecast inventory purchases and cash needs using sales, lead-time, safety-stock and payment assumptions.

Explore the inventory forecast

Job Costing

Track billed hours, direct costs and job-level value with filters and visual analysis.

Explore the job-costing tool

General Contractor KPI Dashboard

Monitor job-level gross profit, margin and operating performance for a contractor.

Explore the contractor dashboard

Lending Business Model

Forecast loan originations, portfolio balances, interest income, losses and capital needs.

Explore the lending model

Royalty Licensing

Compare fixed and percentage royalty structures, forecast sales and calculate present value.

Explore the royalty model

Project Management Tracker

Organize multiple projects, milestones, due dates, ownership and completion status in Excel.

Explore the project tracker

Questions before you buy

A few useful details.

What is activity-based costing?

Activity-based costing allocates resource and overhead costs to operating activities, calculates a cost per driver unit and assigns those activity costs to products, services or customers based on actual usage.

How many activities and products can I model?

The workbook supports up to 23 activities and up to 39 products, services, projects or customer groups. Each activity can include as many as 20 individual cost inputs.

What can I use as a cost driver?

Use a measurable factor that reasonably causes the activity's cost, such as labor hours, machine hours, purchase orders, production runs, setups, shipments, transactions or service calls.

Can I use it for customer profitability?

Yes. Replace the product slots with customers or customer cohorts, then enter how many units of each service activity they consume to estimate the cost to serve and the gross margin by customer.

What analysis does the output provide?

The output shows total cost, cost per unit, current revenue and gross profit, current margin, target margin and the pricing adjustment indicated by your target economics.

Is the workbook editable and included in bundles?

Yes. The formulas and tabs are unlocked and editable. The model is also included in the Accounting Templates, Manufacturing Models and Super Smart bundles.

Make cost allocation transparent

Understand what each product, service or customer really costs.

Trace resource costs through activities, calculate unit economics and compare current margins with pricing targets in one unlocked Excel model. One-time purchase for $45.

Get the Activity-Based Costing Model