L3VLUP
Real estate schedules · in 1 model

REIT capital allocation

Funding deals, the dividend, leverage and the investment spread.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: reit capital allocation.Updated 2 October 2026

Part of real estate models, with the models, labs and guides around it.

What it does

A REIT distributes most of what it earns, so growth is funded from outside: new debt and new shares, sold at whatever the market will pay. That makes the share price an input to the forecast. The schedule funds each year’s net investment at a set mix, issues shares at the net price, pays the dividend on the weighted share count, uses what is left to repay debt, and tracks leverage and interest cover. The test that joins it together is the investment spread: an acquisition adds to AFFO per share only if its yield after recurring capital spending is above the cost of the debt and equity raised to pay for it. Issuing shares below NAV dilutes NAV per share even when that test passes.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

REIT model: FFO, AFFO and NAV
  • Assumptions, rows 8–11: Share price (illustrative input), Shares outstanding, end of FY0, Dividend per share, FY0, Dividend per share growth, % a year
  • Assumptions, rows 35–39: Net debt, end of FY0, Interest rate on net debt, % a year, Share of net investment funded with new debt, Equity issuance costs, % of gross proceeds…
  • Capital, rows 6–10: Net investment, New debt, New equity, net of issue costs, Net issue price per share…
  • Capital, rows 13–15: Shares, opening, Shares, closing, Weighted average shares
  • Capital, rows 18–19: Dividend per share, Dividends paid
  • Capital, rows 22–26: Cash from operations, Cash from investing, Cash retained after capex and dividends, Cash from financing…
  • Capital, rows 29–34: Net debt, opening, Interest expense, Net debt, closing, Net debt / EBITDAre…
  • Valuation, rows 11–14: AFFO payout ratio, Taxable income (approximation), Dividends / taxable income, Minimum distribution test
  • Valuation, rows 17–21: Cost of new equity, Cost of capital raised, AFFO yield on acquisitions, Investment spread…

What a reviewer looks for

  • Issuing shares at the market price with no issue costs.
  • A dividend paid on year-end shares when the new shares arrived mid-year.
  • Calling an acquisition accretive because its cap rate beats the cost of debt alone.

Learn it, then build it

Vocabulary: Real Estate Investment Trust (REIT), Dividend Yield, Leverage Ratio (Debt/EBITDA).

Other real estate schedules