Premium Only Content

Financial Modeling: A Quick Start Guide
About this course
Learn to build a simple integrated financial statement model.
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 skillset, 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 you’ll learn
Learn to build a simple financial model.
Understand how the three primary financial statements relate to each other.
Are there any course requirements or prerequisites?
Familiarity with excel
Who this course is for:
Students
Investment banking analysts
Entrepreneurs
-
UPCOMING
BonginoReport
58 minutes agoMAHA Madness: RFK Jr. vs Newsom - Nightly Scroll w/ Hayley Caronia (Ep.127) - 09/04/2025
881 -
LIVE
Dr. Drew
6 hours agoSalty Cracker: Dr. Drew's Birthday, Sydney Sweeney's Jeans, Rosie's Apology To MAGA & More News From Our Clown World – Ask Dr. Drew
14,296 watching -
1:58:36
Redacted News
2 hours agoUkraine bans Christians, Trump Sends Troops to Chicago, German AFD members being murdered | Redacted
81.9K39 -
LIVE
Michael Franzese
1 hour agoMy Daughters CONFRONTED Me About Being a Mobster Dad
545 watching -
24:02
Kimberly Guilfoyle
4 hours agoCartel Strikes: Breaking News Coverage! | Ep.251
12.5K5 -
LIVE
Sarah Westall
1 hour agoBlackrock & the WEF Collaborate for World Dominance, Free Agency with AI w/ Reinette Senum
225 watching -
3:08
Michael Heaver
12 hours agoOutraged UK Sends EMPHATIC Message
1101 -
1:20:15
vivafrei
3 hours agoRFK Jr. Takes on the Pharma WHOORES! Toddler-Assaulter Granted BAIL? COMPLYE WITH CRIMINALS! & more
94.6K52 -
LIVE
LadyDesireeMusic
2 hours ago $0.80 earnedLive Piano Request - Anti Brain Rot - Support Culture Shift
150 watching -
LIVE
LFA TV
10 hours agoLFA TV ALL DAY STREAM - THURSDAY 9/4/25
1,295 watching