Watch these videos by Troy Henikoff (former MD for Techstars Chicago). It will teach you the basics and a powerful way to model. An example model is linked below too. These videos are essential high quality recordings of the session he did for us.

• Introduction to Financial Modeling
• Financial Model Workshop
• Focus on What Matters to Investors
• Financial Model Example: Dollar Cave Club
  • You can follow along on the Sample Model: Dollar Cave Club
• Dive Into the Details
• Building the Model
• Using the Model