SmartHelping / Real Estate / Joint Ventures
Joint Venture Real Estate Financial Model
Analyze a real estate investment from acquisition and operations through financing and sale. Compare sponsor and investor cash flows, adjust the equity split, and see how a project-IRR-based promote changes each party's returns.
Build a 2- to 30-year analysis with monthly detail, annual summaries, financing and depreciation schedules, and discounted cash flow analysis for the project and each party.
Includes the joint venture waterfall and annual multifamily acquisition templates at no extra charge.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Model walkthroughs
See the IRR calculation and explore the workbook.
Review the real estate model's IRR calculation update, browse the screenshots, and watch the overview of the additional joint venture waterfall model included with your purchase.
Real estate model: IRR calculation update
Included joint venture waterfall model
Inside the real estate model
Connect property performance with each party's returns.
Set the operating assumptions, debt terms, exit assumptions, and promote structure, then review the resulting cash flows and return measures.
Flexible holding period and exit
Choose an analysis period from 2 to 30 years and adjust the property sale timing. Model the sale using a terminal capitalization rate or annual appreciation assumptions.
Revenue, vacancy, and expenses
Build the operating cash flow from property revenue, vacancy, and expenses. Revenue and expense growth assumptions can change up to three times over the 30-year period.
Financing and amortization
Include financing when needed, calculate debt service, and bring the remaining loan balance into the sale calculation when the property is sold before the loan is repaid.
Editable equity splits and promote
Set the base investor and sponsor equity split, then adjust IRR hurdles and sponsor promote percentages in a single table.
Monthly and annual cash flow views
Review property operations, financing, sale proceeds, and the investor and sponsor cash flow allocations in monthly detail and an annual summary.
Returns with and without promote
Compare total returns with and without the IRR-based promote, review cash-on-cash return percentages, and use the chart to compare sponsor and investor results.
Project and partner DCF analysis
Review discounted cash flow analysis for the overall project and separately for the investor and sponsor.
Sale costs and depreciation
Include closing fees as a percentage assumption, a capital gains tax assumption at sale, and a depreciation schedule.
Investor unit assumptions
Enter the total number of investor units available as part of the investment structure.
Unlocked formulas and summary inputs
Change key inputs and see the resulting cash flows on the main summary. All formulas are unlocked so you can inspect and adapt the workbook.
Project IRR and sponsor promote
See how the overall deal result changes the cash flow split.
This real estate model uses a pro-rata approach in which the final project IRR determines the final cash flow splits between the sponsor and investor. Your hurdle and promote assumptions control how that split changes with project performance.
Start with the base equity split, enter the IRR hurdles and promote percentages, and compare the resulting party-level cash flows with the results without a promote. Changes to operating performance, financing, sale value, or sale timing flow through the project analysis.
The additional joint venture waterfall template included with this purchase is a separate workbook. Its overview and product card are provided here so you can review its distribution structure alongside the real estate model.
How to use the model
Build the property cash flow, then evaluate the partnership.
-
Set the property assumptions
Enter the initial costs, analysis period, revenue, vacancy, operating expenses, and growth assumptions.
-
Define financing and the exit
Add financing if needed, choose the sale timing, and set the sale valuation, closing fee, and capital gains tax assumptions.
-
Configure the deal structure
Set the investor and sponsor equity split, investor units, IRR hurdles, and promote percentages.
-
Compare the results
Review monthly and annual cash flows, the effect of the promote, party-level return comparisons, and project and partner DCF analysis.
Two included extras
Get these additional models at no extra charge.
The $45 purchase includes the Joint Venture Waterfall Models and the Multifamily Acquisition Model below as separate workbooks.
Joint Venture Waterfall Models — Included
Explore included monthly cash-flow waterfall templates with IRR hurdles, sensitivity scenarios, and investor/sponsor return summaries.
View included model →Multifamily Acquisition Model — Included
Underwrite up to four property acquisitions with annual pro formas, refinancing, and optional investor/sponsor IRR waterfalls.
View included model →Also included in these bundles
Explore broader joint-venture and real estate collections.
The Joint Venture Real Estate Model is included in both bundles below.
Real Estate Financial Models Bundle
Explore financial models for property acquisitions, development, operations, debt, refinancing, and investor returns.
Explore the bundle →Joint Venture Waterfall Templates Bundle
Explore models for preferred returns, preferred equity, IRR and MOIC hurdles, GP catch-ups, and partner distributions.
Explore the bundle →Property-related operating businesses
Plan the business around the property.
Explore financial models for assisted living, rental arbitrage, property management, and real estate brokerage.
Assisted Living Financial Model
Connect room types, care tiers, occupancy, staffing, development costs, and financing to ten-year financial statements and investor returns.
View template details →Airbnb Arbitrage Financial Model
Forecast booking revenue, lease costs, operating expenses, funding needs, and returns for up to 100 rental-arbitrage properties over ten years.
View template details →Property Management Business Financial Model
Forecast customer growth, units under management, management fees, operating costs, financial statements, and investment returns.
View template details →Real Estate Brokerage Financial Model
Forecast deal volume, agent productivity, commissions, operating costs, financial statements, and investment returns over up to ten years.
View template details →Financing and investor distributions
Explore other financing and waterfall structures.
Compare separate seller-financing, preferred-return, preferred-equity, and cash-flow waterfall templates.
Cash Flow Waterfall: Three IRR Hurdles
Allocate investment cash flow between limited and general partners using three IRR hurdles and review partner-level DCF and NPV results.
View template details →Seller Financing Model and Tax Calculator
Model buying an asset and reselling it with seller financing, including repayment schedules, seller cash flow, IRR, and estimated tax effects.
View template details →IRR Waterfall with GP Catch-up
Allocate annual LP and GP cash flow through three IRR hurdles and an optional GP catch-up, with separate partner return analysis.
View template details →Preferred Equity Model with Common Equity Waterfall
Model preferred distributions, capital repayment, an optional profit kicker, and a subordinate common-equity waterfall over up to ten years.
View template details →Preferred Return Model
Model investor preferred returns and sponsor profit sharing, with configurable unpaid-return accrual and participant return metrics over up to ten years.
View template details →Seller Financing Portfolio Model
Test a portfolio acquisition using seller financing and refinancing proceeds, including both loans' debt service, rental cash flow, and coverage ratios.
View template details →Supporting analysis and tracking tools
Test assumptions and organize the financial details.
Explore tools for discounted cash flow, investment returns, expenses, tax-benefit estimates, and transaction tasks.
DCF Analysis with Sensitivity Tables
Compare cash-flow NPV across six discount rates and up to four scenarios, alongside IRR results and charts.
View template details →Expense Tracker
Organize spending into up to 250 categories and compare three years of monthly and annual expense reports with budget.
View template details →IRR Target Investment Analysis
Calculate the final distribution needed to reach a target IRR after accounting for investments and interim distributions.
View template details →Real Estate IRR Sensitivity Template
Test how vacancy, exit cap rate, leverage, and interest rates affect real estate IRR alongside monthly and annual cash flow.
View template details →Real Estate Flipping Calculator
Connect purchase costs, unit-level renovation budgets, financing, and resale value to pre-tax profit, ROI, and equity multiple.
View template details →Real Estate Checklist Template
Organize transaction tasks across five editable buyer, seller, agent, and document checklists, with notes and completion tracking in Google Sheets.
View template details →Rental Property ROI Calculator
Analyze a single rental property for up to thirty years, comparing financed and all-cash returns, cash flow, and purchase-price sensitivity.
View template details →Cost Segregation Study Template
Compare baseline and cost-segregation depreciation schedules, estimated first-year tax savings, and present-value benefits in Google Sheets.
View template details →Common questions
Before you model the property and partnership.
What analysis period does the model support?
You can select an analysis period from 2 to 30 years. The sale timing can be adjusted from Year 1 through Year 30.
How does the sponsor promote work?
The real estate model uses the final project IRR to determine the final pro-rata cash flow splits between the sponsor and investor. You set the base equity split, IRR hurdles, and promote percentages, and can compare the results with and without the promote.
Does it include monthly and annual analysis?
Yes. The model includes monthly cash flow detail and annual summaries for reviewing the property and investor and sponsor results.
Can I model debt and a property sale?
Yes. Financing assumptions feed an amortization schedule, and the remaining loan balance affects the sale cash flow. Exit inputs include sale timing, terminal capitalization rate or annual appreciation, closing fees, and a capital gains tax assumption.
Is discounted cash flow analysis included?
Yes. DCF analysis is included for the overall project and for the sponsor and investor separately.
What else comes with the $45 purchase?
The joint venture waterfall model and annual multifamily acquisition model linked above are included at no extra charge. These are additional templates provided with the real estate model.
Can I inspect and change the formulas?
Yes. The Excel workbook's formulas are unlocked, so you can review the calculations and adapt the model to your needs.
When is the download available?
The templates are available to download immediately after purchase. This real estate model is also included in the Joint Venture and Real Estate template bundles linked above.
Evaluate the property and the partnership
Make investor and sponsor economics easier to compare.
Connect operating assumptions, financing, exit value, and the promote structure in one real estate analysis. Need a tailored model? Contact Jason.
Disclaimer: I am not a financial advisor and am not liable for the effects this financial model might have on your money. Please use at your own risk and fully understand what is going on before using.
