Cash Sweep Concepts Excel Template

Description
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