Learn to build a simple integrated financial statement model.
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.
- Learn to build a simple financial model.
Understand how the three primary financial statements relate to each other.
- 1.5 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
- [Size : 1.16 GB]