Insights

Excel Trick: SumProduct & Double Minus ("--")

  • Peter Lynch

I recently received an email asking if I was aware of a formula that could validate the information in two columns, and return the summed value for all matches. This is easier to grasp in context, which makes the video helpful. I was, admittedly, slightly long-winded in explaining the purpose of the formula. To avoid this lengthy explanation, skip to the two-minute mark once you understand the objective.

Continue Reading

The IRR Formula Explained

  • Peter Lynch

Preface: I originally wrote this explanation of the IRR formula in response to a question asking, “Why is finance hard?”.
Even at the introductory level, finance requires so much new vocabulary that learning can feel like it involves a second language. In my opinion, it should be approached the same way.

Continue Reading

Three-Statement Financial Model for Amazon.com, Inc.

  • Peter Lynch

This three-statement model for Amazon.com, Inc. will be used in the next installment of the Integrating Financial Statements series. While I have not typically posted a work in progress, I believe this will be helpful to ASM visitors in the interim.

Continue Reading

Private Equity / Investment Banking: Getting the Job

  • Peter Lynch

I work as an investment professional at a private equity firm in Dallas, TX, and since 2013 I have also been building a financial modeling and private equity training resource with the intention of making instruction simple and content accessible. I wrote about the experience of maintaining both in an article that was later picked up by Forbes (link), which sheds some light on my experience maintaining a “side hustle.”

Continue Reading

Real Estate Financial Model / Template for Multifamily Property

  • Peter Lynch

In this post you will find a template for the acquisition of a fictional 160 unit multifamily property. The template was developed in collaboration with a couple friends that are real estate professionals.

Continue Reading