Revolving Credit Facility
Originally published: 09/03/2020 10:29
Publication number: ELQ-53538-1
View all versions & Certificate
certified

Revolving Credit Facility

A concise illustration of a Revolving Credit Facility or a "Revolver".

Description
This spreadsheet enables a comprehensive understanding of the Revolving Credit Facility / Revolver which is an integral part of cash flow modelling for businesses.

The Revolving Credit Facility or "Revolver" can be turned "On" or "Off" through a toggle switch. The spreadsheet highlights interest and commitment fee calculations on RCFs and how to avoid model circular errors while writing these calculations. The model also illustrates how the RCF will be repaid as and when cash flow is available.

The model inputs are highlighted in yellow and should be constrained to these cells only. Please do not overwrite any other cells, as this could potentially compromise the model.

The file is succinct and meant for illustrative purposes only - and users are meant to understand the RCF conceptually and apply their understanding to their own models. As such, the model horizon is only 12 months long.

The spreadsheet contains three tabs:
1- Cover,
2- Manual: This tab contains basic instructions and a glossary.
3- Revolver: This tab holds all inputs i.e. the components of Cash Flow from Operations (cash paid by customers, cash paid to suppliers, tax and interest paid etc.), Cash Flow from Investing and Cash Flow from Financing.

Please forward any feedback or questions to our Eloquens account here:
https://www.eloquens.com/channel/model-up
Thank You!

Model Up.

This Best Practice includes
1 Microsoft Excel File

Model Up Consultancy offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

To conceptually illustrate a Revolving Credit Facility.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

Any questions on Revolving Credit Facility?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...