Revolver (Revolving Credit Line) Excel Model Exercise Template

Description
Excel model template for modeling the Revolving Credit Line in Excel.

The model consists of an exercise tab, in which you can practice modeling the revolving credit line, and also an answer tab, which shows the data you should be left with. As such, you can monitor your progress in modeling against the answer tab.

This model will demonstrate how modeling the revolving credit line can work within a 3 statement model (consisting of Income Statement, Balance Sheet and Cash Flow Statement) as a means of mak_ing sure that projected losses are automatically handled by debt.

Thiswill walk you through two different exercises that can be conducted in the exercises tab and checked in the answer tab. As such, this training model will help and walk you throuighy all the key elements of modeling the revolving credit line within a three statement financial model.

Althoughy fundamentally simple, the modeling skills required to make the different plugs work can be quite tricky. This model and guide combination will walk you through the revolver formula, so, at the end, you will have all the required skills to construct a three statement financial model with revolving credit line;