Insights

Texas A&M University-Commerce Feedback

  • Peter Lynch

In early 2016 a professor of finance at Texas A&M University-Commerce used ASimpleModel.com to introduce 120 graduate students to financial modeling. At the conclusion of the class he required each student to write a review of the website. Positive or negative, it did not matter, students were free to respond openly.

Continue Reading

Determine the Proceeds Required to Achieve a Specific IRR

  • Peter Lynch

Q: “I have a case study interview next Monday; I will be asked to calculate the cash flows necessary to meet a certain IRR hurdle rate. Can you please provide me with instructions as to how to do so – cant seem to find a succinct answer online!”

Continue Reading

Exclude Zeros When Taking an Average in Excel

  • Peter Lynch

I have received this question via email a few times, so I thought it might be helpful to write a short post on this topic. To take an average and exclude all zeros in a selection use the following formula:

Continue Reading

Building a Financial Model for a Startup: A Live Experiment

  • Peter Lynch

The Business Development video series on this website uses real data to build a financial model for ASM, which effectively makes the series a startup financial model tutorial. When I launched this website in July of 2013, my professional experience analyzing companies was limited to large public or private businesses. I did not have any prior exposure to startups, but that started to change rapidly as I began contemplating this project. Since ASM went live, I have found myself interacting with entrepreneurs and VC investors more frequently. It’s been a terrific experience to gain this new perspective.

Continue Reading

Integrating Financial Statements Video Transcribed

  • Peter Lynch

As the site grows it has been fantastic to watch the user base expand across the globe. Recently I have received a few requests from Spanish and French speaking users of the website for a transcription of one of the longer videos: Integrating Financial Statements.

Continue Reading