Insights

Determine the Proceeds Required to Achieve a Specific IRR

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

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

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

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

Excel: =IRR() vs. =XIRR() (continued...)

I thought it would be worthwhile to provide a follow up to my original post on this topic. In my conversations with business owners this discrepancy gets a lot of attention on account of the critical role these figures can play in a transaction (as my previous post explains).

Continue Reading