University Endowment Model

The template starts from an opening endowment market value and rolls it forward each year. Additions come from donor-restricted donations and investment returns; the spending payout is subtracted.

• Donations are treated as direct additions to the endowment asset and to net assets with donor restrictions, bypassing the income statement and operating cash flow. The active payout method is selected from four options: simple percentage of opening market value, Yale-Hybrid 80/20, trailing three-year average market value times a rate, and an inflation-plus-corpus-floor rule.
• Each method calculates spending differently, so the same return and donation pattern can produce different long-run corpus paths. The model also separates realised return above payout, which stays in the endowment, from unrealised gains, which affect the endowment asset and restricted net assets but do not flow through the income statement.

Endowment spending is transferred to operations as operating revenue. That payout then flows through net surplus to net assets without donor restrictions.

• On the asset side, the endowment shrinks and operating cash grows. On the equity side, restricted net assets decrease as amounts are released from restriction, while unrestricted net assets increase by the net surplus.
• This linkage means the payout rule directly affects the operating surplus and the composition of net assets, not just the endowment balance. Maintenance capital expenditure is routed entirely to operating costs and does not capitalise or depreciate, while growth capital expenditure is capitalised.

New capital expenditure depreciation uses a half-year convention by default. Interest on debt uses a mid-period convention based on average opening and closing balances, and a commitment fee is applied to undrawn balances.

The model produces an income statement, balance sheet, and cash flow statement, plus dedicated rolls for enrolment, programs, faculty, facilities, debt, and the endowment itself. The endowment roll-forward shows opening balance, donations, realised and unrealised returns, spending, and closing balance.

• The active payout method determines the spending line. Supporting outputs include the spending rate itself, the facilities condition index from the deferred maintenance backlog, days cash on hand, expendable resources relative to operations and debt, debt service coverage ratio, and an implied rating bucket from a nested calculation on debt service coverage.
• Benchmarks compare model year-five values against higher-education medians. Sensitivity tables show how undergraduate intake and discount rate affect net tuition, and how endowment return and spending rate affect the closing endowment.

This template is useful when you need to test whether a given spending rate is sustainable over a 20–30 year horizon without building asset-class-by-asset-class projections. By switching the active payout method, you can compare simple percentage, smoothing rules, and floor-based approaches.

• The endowment output feeds back into the operating statement through the payout, so you can see the trade-off between current spending support and corpus preservation. The tuition dependency memo helps you assess how reliant the operating budget is on tuition versus endowment payout, which matters when enrolment is under pressure.
• Validation checks include thresholds for spending rate, days cash on hand, facilities condition index, and debt service coverage, so you can spot when an assumption set produces a weak or failing profile rather than just a different number.