Insights

Working Capital Defined for the Working Capital Peg

  • Peter Lynch

To better understand how the working capital adjustment works in a control private equity transaction, we first need to distinguish between the accounting definition of working capital and the definition of working capital for the purposes of a transaction.

Continue Reading

Dynamic Excel Table

  • Peter Lynch

In this video we are going to learn how to use the =INDIRECT function to create flexible inputs for dynamic Excel Table formulas.

Continue Reading

The Money Illusion

  • Peter Lynch

I have had a surprising number of people admit that they disproportionately hold cash because investments make them uncomfortable. Ironically, whether or not you choose to invest doesn’t matter. If you have wealth, you are invested. And cash can be comforting, for reasons outlined below. But there are reasons it shouldn’t be, for reasons (also) outlined below.

Continue Reading

Introduction to Excel Tables

  • Peter Lynch

Excel Tables help organize your data and they are packed with useful features that facilitate analyzing information. In this lesson we will start with a small subset of data to demonstrate how Excel Tables function.

Continue Reading

Data Analysis in Excel: Spotting Red Flags

  • Peter Lynch

The value of data analysis in Excel when working in private equity. Sometimes you need to look beyond the LBO model.

Continue Reading