A separate schedule is generated for each debt facility in the funding stack. Use it to review drawdown timing, interest accrual, repayment, and whether the facility clears by project end.
Facility Summary
Facility Amount: the total facility limit
Available to Draw: facility amount less funded fees and interest provision
Funded Fees: fees capitalised within the facility
Interest Provision: interest held within the facility, estimated from the Draw Assumption set on the facility
Est. Interest Accrued: interest estimated from the actual draw schedule
Interest Variance: the difference between provision and accrued. Shows as Interest Saving in green or Interest Shortfall in red
Monthly Schedule
Opening Balance, Draws, Fees (Funded), Repayment, Est. Interest and Closing Balance.
Three markers appear across the schedule: Final Draw, the last month a draw is made; First Repayment, the first month a repayment is applied; and Cleared, once the facility is fully repaid.
Capitalised: interest accrues between drawdowns. No interest shows on the first draw. It appears from the second draw onwards, once the outstanding period is known.
Serviced: interest is charged from the first drawdown, with month one calculating a full month.
Using Interest Variance
The Interest Provision set in Funding is an estimate. It is calculated from the Draw Assumption chosen on the facility, not from the project schedule.
Draw Assumption | Estimate applied |
Progressive Drawdown | 55% of the facility drawn, at the midpoint of the term |
Drawn Upfront | 100% of the facility drawn, for the full term |
This schedule calculates interest from actual month-by-month draws instead, so Interest Variance shows whether the provision is adequate.
The provision does not update automatically. To carry the sharper figure into the model, switch the facility to Manual Entry in Funding and enter the updated amount.
