[PDF] Modeling Structured Finance Cash Flows with Microsoft Excel – Download

Summary
Here on this page, we have provided the latest download link for Modeling Structured Finance Cash Flows with Microsoft Excel PDF. Please feel free to download it on your computer/mobile. For further reference, you can go to wiley.com

Modeling Structured Finance Cash Flows with Microsoft Excel Book

One of the most fundamental tests is to make sure that whatever cash has gone into the deal has come out. This can be reworded in a more important manner: to make sure that whatever cash is used in the deal was funded by cash coming into the transaction. Essentially, a cash flow model has a finite amount of money from the assets.

The liabilities can only draw from this finite amount. A critical error that sometimes occurs is when a model is modified and cells are not linked correctly cash is created or used from a nonexistent source. To make sure this does not occur the cash that comes into a deal should be tracked and compared against the cash that flows out of the deal.