Introduction to Financial Modeling

Learn to build a simple integrated financial statement model.
4.5 (921 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
21,807 students enrolled
Instructed by Peter Lynch Business / Finance
Free
Start Learning Now
  • Lectures 8
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2014 English

Course Description

This course will teach you how to use two years of historical income statement data and two years of historical balance sheet data to build a fully integrated financial statement model. It is designed for those new to financial models.

Section 1 will introduce the accounting equation and the three primary financial statements in the context of building a financial model. The content starts with the accounting equation, which is the single most important concept in accounting. The remaining three videos introduce the financial statements one at a time with a focus on the relationships that are important as you build financial models.

All of the material is provided via video-driven instruction with notes in pdf format to help follow along.

Section 2 will walk through integrating the three primary financial statements and creating a five-year projection. The first video provides a quick overview of the process. It is an easier process to grasp if thought of as a series of steps. It will also make it easier to measure progress as you work through the longer video. The video in Lecture 2 will walk you through the process of building the model cell by cell.

Because you are walking through the entire process of building a model, the video in Lecture 2 runs long: 35 minutes total. My advice would be to download the excel template attached to this lecture and build the model as the video progresses. Building the model yourself is the best way to fully understand the process.

In my opinion, if you want to build a strong financial modeling skill set, a thorough understanding of how an integrated financial statement model works is one of the most important things you can learn.

The last video in this section will explain circular references and how to fix broken models. It can be incredibly frustrating to finish a model and realize that it does not "balance." This video will help avoid that frustration.

I hope the content is useful to you! Please feel free to email me (peter@ASimpleModel.com) with any feedback.

Note: The longer video has some white noise in the background that I am having edited out. I hope to have a cleaner audio file up soon. Thanks for your patience!

What are the requirements?

  • Familiarity with excel

What am I going to get from this course?

  • Learn to build a simple financial model.
  • Understand how the three primary financial statements relate to each other.

What is the target audience?

  • Students
  • Investment banking analysts
  • Entrepreneurs

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:31

This video will explain how best to use the content that follows. I do not have an introductory video specific to Udemy, but thought this would be a helpful introduction to the material nonetheless.

Section 2: Introduction to Financial Statements (For Financial Models)
07:59

The accounting equation is the single most important concept in accounting, and it is instrumental in developing a more thorough understanding of financial statements. This video explains how the accounting equation is relevant in building financial models.

Please select the HD setting for the video player.

07:59

This video introduces the balance sheet. The video walks through definitions, and concludes by highlighting relationships between the balance sheet and other financial statements that are important to keep in mind as you build financial models.

Please select the HD setting for the video player.

08:32

This video introduces the income statement. The video walks through definitions, and concludes by highlighting relationships between the income statement and other financial statements that are important to keep in mind as you build financial models.

Please select the HD setting for the video player.

06:27

This video introduces the cash flow statement. The video walks through definitions, and concludes by highlighting relationships between the cash flow statement and other financial statements that are important to keep in mind as you build financial models. This video places greater significance on how the three financial statements relate to one another in a financial model.

Please select the HD setting for the video player.

Section 3: Building an Integrated Financial Statement Model
04:29

This video runs slightly longer than 4 minutes and briefly describes the process of building an integrated financial statement model. It is an easier process to grasp if thought of as a series of steps. Knowing the steps will also provide the benefit of measuring your progress as you watch the longer instructional video and build your own model. All videos are recorded in HD - switch to 720p by clicking on the HD button in the lower right-hand corner of the player.

35:04

This is the first instructional video in the “Integrating Financial Statements” series. The video will guide you through the process of using two years of historical income statement data and balance sheet data to build a fully integrated model. In my opinion this is the most important thing to understand if you want to build a strong model building skill-set. All videos are recorded in HD - switch to 720p by clicking on the HD button in the lower right-hand corner of the player.

04:47

Circular references are frequently responsible for crashing financial models. This video will explain how they work, and how to fix your model by focusing on the most common circular reference error found in financial models: the interest expense circularity. All videos are recorded in HD - switch to 720p by clicking on the HD button in the lower right-hand corner of the player.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Peter Lynch, VP in Private Equity

Vice President at a private equity firm. Previously worked for Rabobank International's Mergers & Acquisitions group in New York, and for JPMorgan in South America.

Peter received his B.A. in economics from the University of Pennsylvania.

On a less formal note: I have been building financial models for the last 8 years, and about a year ago I decided to launch a website dedicated to teaching the subject. I love feedback so please feel free to contact me with any suggestions.

Ready to start learning?
Start Learning Now