Cash Sweep Concepts Excel Template
Originally published: 20/03/2017 12:56
Publication number: ELQ-96408-1
View all versions & Certificate

Cash Sweep Concepts Excel Template

Understand the four concepts of cash sweeping.

The Cash Sweep is a modelling technique for automatic debt repayments as well as for any debt scheduled repayments.

When the SUMIF and MIN functions are used, we can model 4 types of cash sweeps:
1) Basic
2) Percentage
3) Order
4) Pari Passu

The downloadable file contains all the 4 easy-to-understand cash sweep concepts. You can download it below.

If you wish to deepen the understanding of Cash Sweeping, do read Chapter 13 of “Building Financial Models” written by John Tjia (It comes along with complete models).

-Michael Shane

This Best Practice includes
1 Excel Sheet

Michael Shane offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (18 votes)

please wait...