JV Partner Discovers a Dilution Formula Was Never Built Into the Development Model
Executive Summary
Background¶
This is an illustrative, composite scenario, not a specific real transaction, built to demonstrate a recurring pattern.
Two partners entered a real estate development joint venture, with a financial model built at the venture's outset representing each partner's capital contribution, the project's cash flow, and the JV-level distribution waterfall — see JV Development Model Structure for the general treatment this case illustrates. The joint venture agreement included a standard dilution-on-default provision: if either partner failed to meet a capital call in full, their ownership percentage would be reduced according to a stated penalty-rate formula more punitive than simple pro-rata dilution.
What Happened¶
Partway through construction, a capital call was issued that the majority partner could not fully meet due to an unrelated liquidity constraint elsewhere in its business. The minority partner requested the model's calculation of the resulting ownership dilution, expecting the formula built into the JV agreement to be readily applied.
The model, however, had never actually implemented that formula. At the time the model was originally built, the base case assumed both partners would fund every capital call as committed, and the dilution-on-default provision, while present in the executed JV agreement, had been represented in the model only by a placeholder cell containing a flat, illustrative assumed percentage, never updated to reflect the agreement's actual, more punitive penalty-rate calculation.
How It Was Caught¶
The gap was surfaced directly by the funding shortfall itself: when the minority partner asked for the model's dilution calculation, there was no working formula to produce a reliable figure, only the placeholder value, which both partners recognized did not correspond to the actual agreement terms once they compared it against the JV agreement's text.
Resolution¶
The funding decision was paused while the correct dilution formula, sourced directly from the joint venture agreement, was built into the model and applied to the actual shortfall amount, producing revised ownership percentages both partners could agree reflected the contractual terms. The venture proceeded on this corrected basis once the recalculated percentages were confirmed.
Lessons¶
A dilution-on-default mechanism is a genuine, foreseeable JV risk explicitly anticipated in the underlying legal agreement, not a remote hypothetical. A model that represents it with a placeholder assumption rather than the agreement's actual formula, built in from the outset even though it may never be triggered in the base case, leaves both partners without a reliable, pre-agreed basis to act when the scenario actually arises, precisely at the moment, a genuine funding shortfall, when a reliable calculation matters most.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Checklists¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Is this a real client engagement?
No. This is an illustrative, composite scenario built from patterns commonly observed in financial model audits. It does not describe a specific, identifiable transaction.
Why hadn't the dilution formula been built into the model from the outset?
The model was built at the venture's outset around the base case, in which both partners were expected to fund every capital call as committed. The dilution-on-default provision, while present in the joint venture agreement, was treated as a low-probability contingency and represented only by a placeholder cell containing a flat assumed percentage rather than the agreement's actual formula.
What specifically went wrong when the capital call shortfall occurred?
When the majority partner could not fully meet a capital call, the minority partner requested the model's calculation of the resulting ownership dilution. The model had no working formula to calculate it, only the placeholder figure, which did not reflect the joint venture agreement's actual, more punitive penalty-rate dilution mechanism, leaving both partners without a reliable, agreed calculation to act on.
How was the situation resolved?
The funding decision was paused while the correct dilution formula, sourced directly from the joint venture agreement's text, was built into the model and applied retroactively to calculate the revised ownership percentages resulting from the shortfall, after which the partners proceeded on the corrected basis.
Could this have been identified before the capital call shortfall occurred?
Yes. A structural review of the model against the joint venture agreement at the time the model was first built, specifically checking whether every contractually defined scenario, including dilution on default, was represented by an actual formula rather than a placeholder, would have surfaced the gap well before a live funding shortfall made it urgent.
What is the broader lesson for JV development modelling?
That every mechanism explicitly provided for in a joint venture agreement, including low-probability contingencies like funding default and dilution, should be built into the model as an actual, formula-driven calculation from the outset, since a placeholder assumption discovered only when the scenario materializes leaves both partners without a reliable, pre-agreed basis to act.
Related Articles
JV Development Model Structure
A joint venture development model layers a partner-level capital call, distribution, and dilution structure on top of the underlying development appraisal or income model, and this partner-level layer should be modelled as its own explicit structure distinct from the project-level cash flow it is calculated from. This guide sets out how capital calls, funding default and dilution, and the JV-level waterfall should be represented, building on the development waterfall and promote treatment covered elsewhere in this domain.
Development Waterfall and Promote Structure
A real estate waterfall and promote structure allocates returns between sponsor and investor across defined hurdle rates of return, and should be built as an explicit, tiered calculation, one clearly labelled block per tier, sequenced against actual cash distribution timing, rather than a single blended split formula. This guide sets out how each waterfall tier, including catch-up and clawback mechanics, should be structured and tested.
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.