Download G: InvIT NDCF Statement (.xlsx)

What it does

Net Distributable Cash Flow at SPV level and at InvIT level, the minimum distribution check (90% in the sample) and the per-unit split into interest, dividend, repayment and other income.

Who it is for

InvIT finance teams, investment managers and analysts.

How to use it

  1. Go to 'Inputs'. Type the period (for example Q2 FY 2026-27), the number of units outstanding and the minimum distribution % that applies to you (the sample uses 90%). All amounts in this file are in ₹ crore.
  2. Go to 'SPV NDCF'. Type each SPV's name across the top (up to five). Down each column, type the figures for the period from that SPV's cash flow statement and books: cash from operations, treasury income, external interest and principal paid, reserves created (DSRA / MMRA) and capex funded from internal cash.
  3. In the lower block of 'SPV NDCF', type what each SPV actually paid up to the InvIT: interest on InvIT loans, repayment of InvIT loans, dividend and any other amount. The sheet shows each SPV's payout % and whether it meets the minimum.
  4. Go to 'InvIT NDCF'. Receipts from SPVs fill in automatically. Type the InvIT's own items: treasury income, trust expenses (investment manager, trustee, audit, listing fees), InvIT-level borrowing costs and reserves.
  5. Type the distribution per unit (DPU) you propose. The sheet gives the total payout, the payout % against NDCF, the amount retained, and the per-unit split by type.
  6. Check the checks at the bottom of 'InvIT NDCF'. All should read OK.

Tabs in the file

TabWhat it holds
InputsPeriod, units outstanding, minimum distribution %.
SPV NDCFNDCF for each SPV and what each SPV paid to the InvIT.
InvIT NDCFTrust-level NDCF, proposed distribution, per-unit split and checks.

For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.