Do you wish you or your staff produced better, more consistent Models?

You've come to the right place.

This course will cover the most important fundamental Excel skills to save you time and energy. The course will also teach you industry standard best-practices related to financial modeling and forecasting.

Learning resources include:

  • 34 instructional videos (ranging between 3 and 8 minutes in length)
  • Downloadable PDF slides and Excel files that are yours to keep

Key skills gained include:

  • Setting up Excel options for ease of use and reduced errors
  • Keyboard shortcuts to save time and energy
  • Building formulas correctly
  • Industry conventions for formatting and layout
  • Audit trails and color coding for increased usability
  • How to build a 3-statement financial forecast model
  • Supplementary calculations to improve auditing and presentation
  • Building a cash flow statement that will balance your balance sheet every time
  • Dealing with circular calculations safely

Course curriculum

  • 1

    Welcome

    • A message from the instructor

    • How to use this course

    • Before we begin...

  • 3

    The modeling process

    • Excel materials to download

    • The modeling process

    • The modeling process review

  • 4

    Forecasting financial statements

    • Excel materials to download

    • Introduction and historical subtotals

    • Historical subtotals review

    • Forecast income statement

    • Forecast income statement review

    • Forecast balance sheet

    • Forecast balance sheet review

    • Forecast cash flow statement

    • Forecast cash flow statement review

    • Completed Excel materials

  • 5

    A more complete example

    • Excel materials to download

    • Introduction and historical subtotals

    • Historical subtotals review

    • Forecast income statement part 1

    • Forecast income statement part 1 review and forecast income statement part 2

    • Forecast income statement part 2 review

    • Forecast balance sheet part 1

    • Forecast balance sheet part 1 review and forecast balance sheet part 2

    • Forecast balance sheet part 2 review

    • Forecast cash flow statement

    • Balancing the balance sheet and dragging right

    • Calculating interest income and expense

    • Interest income and expense review

    • Dealing with circular calculations safely

    • Checking and sharing your work

    • Completed Excel materials

  • 6

    Building a cash flow statement from scratch

    • Excel materials to download

    • Cash flow statement logic

    • Building a cash flow statement from scratch - walkthrough and setup

    • Buidilng the cash flow statement - operating section

    • Building the cash flow statement - investing and financing sections & ending cash

    • Proper presentation of the cash flow statement

  • 7

    Next steps

    • Thank you

    • More resources for you

    • Feedback

Instructor

Trainer

Pete Mazzarese

Pete Mazzarese has been delivering large analyst training programs for the top bulge bracket investment banks in Europe, Asia, and North America since 2010. He also designs and leads smaller groups at banks, law firms, MBA programs, and consulting firms. Peter is a specialist in corporate finance and investment banking. His course range includes: Accounting, Valuation, M&A modeling, and LBO modeling as well as corporate credit analysis, and private equity investing.

Peter has an extensive working knowledge of the North American, European and Asian regions and has delivered technically advanced material to all levels of audiences in Europe, Asia, the Middle East and North America. Peter has actively engaged regularly with top global investment banks in the design of new and tailored class room based courses, webinars and e-learning material. Peter’s ability to simplify and illustrate even the most complex of topics, results in him receiving consistently excellent feedback from participants and corporate clients.

Prior to becoming a financial trainer, Peter worked in banking and finance in the US and London, gaining more than 10 years of experience. He has led a turn-around effort at a technology firm, advised HNW individuals and small corporates on investment strategies, and, after attending London Business School, worked as an analyst at Barclays in London.

Peter holds a Masters in Finance from London Business School and is a CFA Charterholder. Peter has held FINRA series 6, 63, 7, 9 & 10 securities licenses

Reviews

5 star rating

Really useful

Kate L

Really useful content. Thank you!

Really useful content. Thank you!

Read Less