Revolver (Revolving Credit Line) Excel Model Exercise Template
Originally published: 15/06/2018 09:47
Publication number: ELQ-56316-1
View all versions & Certificate
certified

Revolver (Revolving Credit Line) Excel Model Exercise Template

Excel model tutorial for modeling the revolving credit line ("revolver")

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;

This Best Practice includes
1 excel spreadsheet

Wall Street Prep offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.6 / 5 (10 votes)

please wait...