Debt Covenant Monitor

Model Overview

• Automatically track key financial KPIs

• Highlight the months and KPIs requiring attention

• Linear forecasting for the next 12 months, highlighting future risks

Overall Structure of VC Monitor Model

• Most pages are displayed in the same structure, from left to right are:

Account name → Actual financials → Forecasted Financials

• Some financials are hidden by default, click “+” on the top to reveal.

• Input/adjustable cells are displayed in Blue Font with a Blue background.

Main Features

Covenant Compliance Dashboard

• Covenant Assumptions
• Input your covenant assumption terms by overriding the default values in the Blue Cells.
• Assumptions will flow into the Operating Model automatically.

• Debt Covenant Schedule
• Check for potential covenant breach from “FAIL”.

Financials

• Financial Statements
• AI account grouped 1 page Financial Statement.

Forecast

• Linear Forecasting method
• Override default forecast method and values by inputting your own forecasts in the Blue Cells.