The question this worksheet answers
How much borrowing is visible when an analyst adds a proportionate share of unconsolidated venture debt to reported consolidated debt? The two views answer different questions. Consolidated statements reflect the accounting perimeter, while a look-through view applies an explicitly chosen economic ownership percentage outside that perimeter. Neither view alone establishes which legal entity must repay a loan. This worksheet deliberately keeps a separate guarantee amount rather than adding every disclosed exposure together.
Formula and synthetic worked example
For each unconsolidated venture, multiply gross JV debt by the confirmed economic ownership percentage divided by 100. Add those contributions to consolidated borrowings. The synthetic example is 800 + (500 × 40%) + (400 × 25%) = 1,100. The two venture contributions are 200 and 100. A separate guarantee of 100 remains a separate disclosure; it does not make the result 1,200. An already-consolidated venture contributes nothing extra because its debt is already inside the starting number.
Which ownership perimeter this number uses
This worksheet starts with 100% of reported consolidated debt, including debt of consolidated ventures where outside investors may own part of the equity. It then adds only the entered economic share of unconsolidated venture debt. The combined result is consolidated debt plus proportionate unconsolidated JV debt; it is not a fully proportionate parent-only debt figure. The expert JV NAV workshop can instead follow a fully proportionate route, applying the parent economic share consistently to relevant asset values, income and debt, or a full consolidation route with the matching outside ownership adjustment. Those routes require a separate reconciliation. Do not replace this worksheet total with a fully proportionate NAV deduction without reconciling the consolidated minority interests, and do not deduct the same outside claim twice. Neither route changes the underlying legal borrowing or guarantee contracts.
Where to find and reconcile the inputs
Read the debt note, investments in unconsolidated entities, consolidation policy and guarantees or commitments disclosures in the same dated filing. Determine whether ownership refers to economic participation, voting rights or a waterfall with differing profit allocations. Match principal with principal or carrying amount with carrying amount; do not silently compare them. Keep currency, monetary scale and as-of date consistent. The notes may disclose only selected venture borrowings, so a known subtotal must not be represented as a complete balance.
How to use the table
Enter CSV rows without a header in the order name,debt,ownership,consolidated,asOf. Ownership uses percentage points: 40 means 40%, while 0.40 means 0.40%. The consolidated flag must be true or false. Blank debt or ownership means unknown and makes the complete total unavailable; an explicit zero remains zero. Each row has its own as-of date. Currency, scale and debt basis are selected once for the entire table: convert and document outside this worksheet if the original sources differ. The parser does not infer exchange rates or ownership.
Why no leverage ratio appears
A proportional debt numerator does not automatically justify dividing by reported consolidated NOI or EBITDA. The denominator must match the ventures, ownership interests, period and definition used in the numerator. This worksheet does not produce that ratio because it does not collect and reconcile a matching operating measure. It also does not determine recourse, joint liability, distribution restrictions, cross-default exposure or contractual guarantee triggers. Those are separate questions for the actual agreements.
Questions readers ask
Does a 40% stake mean a 40% legal payment obligation? No: the proportion is an analytical allocation and contractual obligations can differ. What if the venture is consolidated despite a minority economic stake? Keep it inside the consolidated starting number and mark it already consolidated; do not add its proportional debt again. Can missing ownership be treated as 100% to be conservative? This tool does not make that assumption: it marks the result incomplete. Unknown exposure is information to investigate, not a number to manufacture.
Primary sources, scope and corrections
These sources explain filing structure and security claims; they are not sources for the synthetic numbers above. DFB wrote the example and formulas for education. No issuer dataset or current market data is loaded.
- SEC: How to Read a 10-K — financial statements, notes and liquidity discussion
- Investor.gov: Stocks — common and preferred shareholder claims
Related reading: JV ownership and valuation · Debt maturity analysis · Refinancing modeling · Distribution denominators.
Educational scenarios, not forecasts or personalized investment advice. Editorial standards · Report an error with its page and source. Formula version capital-1.0.3. No rating or safety threshold is assigned.