This video explains how to project the cash flow statement in an LBO model built in Excel. The sequence required to project each line item is identical to the sequence laid out in the Integrating Financial Statements video series (which is focused on a three-statement model) and the LBO video series, so we will not explore that in detail. Instead this video will provide shortcuts to move through the process faster when you are working with new financial statements, and visuals to help communicate how the income statement and balance sheet link to the cash flow statement.
Incentive equity compensation helps align investors with the management team running the business. In every control private equity transaction, it is one of the most important variables to get right. This post will explain how equity compensation generally works with visuals that should help cement these concepts.
An unbalanced balance sheet in a three-statement financial model can be a nightmare if you don’t understand the mechanics that would otherwise result in a balanced balance sheet. In this post we will explore how the cash flow statement balances a three-statement model, and we will include common errors that result in a broken model together with instructions on how to fix them.
Adjusted EBITDA is a very common metric that can be found in many investor presentations, which makes understanding EBITDA and acceptable adjustments to this figure important. Unfortunately EBITDA is frequently used as a proxy for cash flow. As the video featured in this post will demonstrate, it is anything but. In businesses that require heavy capital expenditures or those with heavy debt burdens, the discrepancy between EBITDA and cash is vast. Add to this the adjustments investment bankers and management teams will use to embellish or even exaggerate earnings and the metric can become meaningless.