SmartHelping / Investment Funds / Excel
Preferred Return Investment Fund Tracker
Track preferred equity returns for a fund with up to 30 investors. Set each investor’s dates, investment and hurdle assumptions, then review LP/GP distributions, investor IRRs and the fund’s cash position.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the tracker in action
Follow investor terms through the fund’s distributions.
Watch the walkthrough to see the investor setup, cash flow planner and reporting. Open the screenshots below to preview the workbook.
Individual investor configurations
Give each investor their own terms.
The template models LPs as preferred equity, with the preferred return expressed as an IRR hurdle. LP means investor or limited partner; GP means sponsor, general partner or operator.
Start and end dates
Define a separate participation window for each investor, with up to 15 years tracked per investor within a fund timeline of up to 20 years.
Initial investment
Set the initial investment amount for each investor’s configuration.
Contribution percentage
Define the LP contribution percentage. When it is below 100%, the GP supplies the remaining share of contributions.
Preferred return
Enter the preferred-return hurdle separately for each investor.
Two additional hurdle rates
Define up to two hurdle rates beyond the preferred return for each investor.
LP and GP distribution splits
Set how cash is divided between the LP and GP up to the preferred-return hurdle and for each subsequent hurdle.
Accrual, compounding and participation
Make the timing of each investor’s return explicit.
Investors can have different start dates, end dates, investment amounts and preferred-return assumptions.
Choose the compounding period
Select monthly, quarterly or annual compounding for the preferred-return calculations.
Accrual begins at the start date
Each LP’s preferred return starts accruing from the entered start date. The cash flow planner separately tracks when capital is actually deployed.
Keep distributions within the investor’s dates
Distributions before an investor’s start date or after their end date are not allocated to that investor.
How cash distributions are allocated
Start with active investors, then apply their waterfall terms.
The model combines investor participation dates with investment amounts and hurdle-based distribution splits.
Identify the active investors
For each distribution date, the model determines which investors are within their start and end dates.
Allocate by relative investment
The allocation to each active investor’s configuration is based on that investor’s investment relative to the other active investors.
Apply the LP and GP splits
That allocation is then divided between the investor and GP using the configured distribution percentages and achieved hurdle rates. The applicable split continues until the LP’s hurdle is achieved.
Fund cash flow planner
Track capital deployment, profits and distributions.
Define when the fund deploys capital, earns profits and distributes cash, then review the resulting fund cash position.
Capital deployment
Enter when capital is actually put to work in the fund’s investments.
Profits earned
Enter the resulting profits in the cash flow planner.
Cash distributions
Plan when cash is distributed and let the investor-date and hurdle logic determine the allocations.
Fund cash position
Review total LP and GP contributions, less capital deployed, plus profits earned, less cash distributions.
Investor and fund reporting
Move from one investor’s dashboard to consolidated fund summaries.
Review contributions, distributions and investor returns without losing sight of the fund as a whole.
Single-tab investor selector
Choose an investor on the dashboard to display that investor’s contributions and distributions on monthly and annual bases.
Investor IRR
Review the resulting IRR for the selected investor alongside their contribution and distribution history.
Consolidated monthly summaries
Review monthly summaries covering all investors and the GP.
Consolidated annual summaries
Review the same fund-wide activity on an annual basis across all investors and the GP.
Who this tracker is for
For funds with investors who enter on different terms.
Fund managers and sponsors
Track multiple investors with different dates, investment amounts, preferred returns and distribution splits in one Excel workbook.
Investment analysts
Review how investor participation windows and hurdle assumptions affect distributions, individual investor IRRs and the fund’s cash position.
Also available in these bundles
Need more tools for investment structures and distributions?
This tracker is included in the Joint Venture Waterfall bundle. The Super Smart Bundle includes the complete public SmartHelping template collection.
Joint Venture Waterfall Templates
Explore models for preferred returns, IRR hurdles, equity multiples and partner distributions.
View the Joint Venture bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleComplementary investment analysis
Explore IRR sensitivity for a real estate investment.
Questions before you buy
A few useful details.
How many investors and years can the tracker handle?
The template supports up to 30 investors and is expandable. The overall fund can run for up to 20 years, with up to 15 years tracked for each individual investor.
What compounding periods can I use?
Choose monthly, quarterly or annual compounding.
When does an investor’s preferred return begin accruing?
It begins at the investor’s entered start date. Capital deployment is entered separately in the cash flow planner.
Can investors have different preferred returns and hurdles?
Yes. Each investor can have a separate preferred return, up to two additional hurdle rates, and the corresponding LP/GP distribution splits.
What happens to distributions outside an investor’s dates?
Cash distributed before that investor’s start date or after their end date is not allocated to that investor.
Can the GP contribute capital?
Yes. A contribution percentage below 100% for the LP means the GP contributes the remaining share.
What format do I receive?
This is an Excel template, available to download immediately after purchase.
Bring investor terms and fund cash flows together
Track preferred returns across the fund.
Get the Preferred Return Investment Fund Tracker for $125 and review investor distributions, IRRs and fund cash flow in Excel.
