3 Statement Financial Model | Building From Scratch
We walk through the process of building a 3 statement financial model starting with an empty Excel spreadsheet. Also included is a downloadable template of the model.
✅ Download the Excel template: bit.ly/3stmt_mlchmp
🚀 If you want to master the finance skills & frameworks to successfully scale technology startups, secure your spot in my "Finance for Startups" program, today: www.ericandrewsstartups.com/f...
👉 Check out my courses to help you master Excel in a weekend: www.ericandrewsstartups.com/c...
Communities:
💼 Linkedin: / eric-andrews-1624b656
☑️ Twitter/X: / eric__andrews
🌟 Instagram: / ericandrews_startups
🔥 Discord: bit.ly/discord_eric
💻 Newsletter: bit.ly/joinericnewsletter
🎥 Clips: / @ericandrewsclips7818
Related Financial Modeling Videos:
🚩 Finance Interview Prep Series | Crush Your Interview: bit.ly/fin_intervw_prep
🚩 Startup Fundraising Lifecycle: • Navigating the Startup...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video, we learn how to build a 3 statement financial model in Excel, which includes an integrated Income Statement, Balance Sheet, and Cash Flow Statement - with a balance sheet that balances!
Also included is a link (in the "resources & links" section) where you can download the 3-statement financial model Excel template for free.
In order to successfully build these types of models, you need to really understand that the models are representing the operations of a company. And if you understand the operations and construction of these models, you will be better at building them, and better at fixing them.
So in an effort to make you better at financial modeling (and being analytical), let's zoom out and talk about what these three financial statements represent, and how they work.
Here is a brief explanation of each one.
Income Statement:
The income statement shows the amount of revenue a business generates from providing a service, and the expenses associated with the service, over a window of time. This is why the income statement is considered a flow statement - as it summarizes flows of income over time. This statement, however, doesn't tell us anything about the capital structure of a company (debt, equity, asset purchases, etc).
Balance Sheet:
While the income statement shows us what happened during a period of time, the balance sheet can only show us one precise moment. The balance sheet shows us exactly what a company owns, and owes, on a specific date. But what happens to what we owe / own over periods of time? The balance sheet cannot tell us anything about that.
Cash Flow Statement:
The cash flow statement is a flow statement, similar to the income statement. However, while the income statement is showing us revenues and related costs, the cash flow statement is simply converting the balance sheet into a flow statement by calculating the changes in what we owe / own (on the BS). The cash flow statement doesn't care about what services we provide, it only tracks where the dollars go. Things like debt repayment and changes in working capital show up on the cash flow statement, but not on the income statement.
Sections:
0:15 Overview of income statement, balance sheet, and cash flow statement
1:14 Steps for building a 3-statement financial model
1:55 Income statement: building the assumptions
5:39 Income statement: building the forecasting model
13:25 CAPEX & depreciation schedule
18:57 Balance sheet: historical numbers & concept discussion
21:05 Liabilities + Equity = Assets (in order for the balance sheet to balance)
21:39 Balance sheet: building the assumptions
23:55 Balance sheet: building the forecasting model
25:20 Balance sheet: linking in the Capex model
26:30 Balance sheet: modeling out debt
28:15 Balance sheet: linking net income (P&L) to retained earnings (BS)
29:55 Cash flow statement: structure & discussion
31:15 Cash flow statement: operating cash flow section
33:30 Cash flow statement: investing cash flow & free cash flow
34:00 Cash flow statement: cash flow from financing
35:15 Cash flow statement: net cash flow calculation
35:43 Balancing the balance sheet (linking in net cash flow)
36:32 Troubleshooting checklist - if your balance sheet doesn't balance
I hope that you can now feel confident building a 3-statement financial model in Excel. If you have questions (I'm sure you do) - please leave comments below and I'll try to help. Cheers!
#financialmodel #3statementfinancialmodel
Пікірлер: 787
this 38 minutes better than my whole years in undergraduate degree. Thank you soo much Eric!
@eric_andrews
3 жыл бұрын
Hey Giry, this comment makes me so happy you have no idea. This was the whole point of this channel, I was imagining what lessons would have helped me when I graduated from college. Awesome 😊
@Johnnymemories
3 жыл бұрын
Sadly its true
@Johnnymemories
3 жыл бұрын
Its not only what we learn from this video that teaches us but the frame of mind when handling excel. Thanks a million!
@abdullahal-harbi8108
3 жыл бұрын
@@eric_andrews Thanks a bunch man, you're a hero.
@JMAH10ags
3 жыл бұрын
X2
Now I can easily understand the models and how they link-up together in simple logical explanation, no technical jargon that even hard to spell. Thanks Eric! ..looking forward for more videos.
Oh man...what a presentation. Can't get any better than that. One of the best learning videos i have seen so far. Feels great that i stumbled upon on this video and did justice by spending 38 quality mins of my life. Thanks a ton Eric :) God bless you...
Wow ! This is so good. Thank you so much for the clear explanation. All accounting and finance students/professionals must see this.
most informative video i've seen on 3 statement modelling!!!! thank you Eric, please keep up the amazing work!
This is amazing man, it helps me a lot for my business even though I'm studying CPA, it's so quick and clear with the video. THANK YOU
@eric_andrews
3 жыл бұрын
Stoked to hear it Dan! Thanks for watching. Cheers!
Eric to see you had fun going through it without losing the audience... awesome.
@eric_andrews
3 жыл бұрын
Hey frank....I'm glad you made it through with me! I enjoy this stuff, thanks for the support. Cheers
Wow. Detailed Explanation and very easy to understand. Thank you!
This deserves many many more views. Pure, succinct, free !! My best wishes to you, Eric !
@eric_andrews
3 жыл бұрын
I'm so glad it was valuable for you! My dream is to make information free - like it should be!! Cheers try peace
Great Tutorial for understanding Business with Excel. I need to watch your video over and over before I get the hang of it. Thanks
@eric_andrews
4 жыл бұрын
Awesome! And if you want to look at the Excel file, you can download the template in the description as well. Cheers!
Awesome! A complete and simple explanation of how all 3 FS work together!
This video was phenomenal! Totally simplifies the 3 financial statements and links them. Allows you to clearly see the difference between all 3 statements. As an economic consultant and finance professional, this video has brought me great value! Thank you so much
@eric_andrews
3 жыл бұрын
Appreciate the comments and the feedback Modupe. So glad it was valuable for you. Cheers!
This was by far the best video I’ve seen on 3 statement modeling. I was trying to watch videos by some prep companies a couple months but those went above my head and made me give up for some time. Thanks !
@eric_andrews
3 жыл бұрын
Means a lot to hear it. Really happy it was helpful and more possible to learn this time around. Cheers !! 🙏🙏
This is really incredibly helpful. I haven't built a model on my own before, and I think this really gave me a guide to doing it myself. Thank you so much!
@eric_andrews
2 жыл бұрын
you are very welcome i'm happy to hear it!
I wanted to say that this video is worth of 2 years in finance classes at school but its taken already. Such a great explanation!!!
You just made this feel so seamless. I got everything on point. You are a great Tutor. Thanks very much.
Well done. Your explanations are extremely clear. Thank you!
@eric_andrews
3 жыл бұрын
Happy it was helpful kyle. Cheers
You're amazing! I've watched this three times and it's really helped me with my forecasting. Thank you!
@eric_andrews
3 жыл бұрын
Love to hear it Belinda!!!!! 😎😎😎🙏
Eric, this is great, simplified, and cleared. you re a great teacher. thank you
@eric_andrews
4 жыл бұрын
Really happy it was valuable for you wilfred!
Really this 38 mins is worth a lot more then 4 yrs of my graduation. Hats off to you Eric. Your truly an inspiration for accountants like us. Lots of love and gud wishes for you and your future brother. ❤️❤️
What has been taking me 2 years and counting can literally take me a week or so thank you so so much. New, permanent subscriber here!!!! I'm starting with my financial projections right now @10:30pm.
38 minutes of my life well spent. Great content. Thank you so much for this informative video.
@eric_andrews
3 жыл бұрын
Thank you for watching Jimmy C & Co!! Glad it was valuable
This is extremely useful... beautiful explanation and very lucid presentation of the ideas....great job!
Great video Eric! Thanks for the clear explanation, really helpful!
Great video. Here's a helpful tip for those struggling to balance: if your balance sheet is not balancing, quite often it's because your fixed assets, capex, and depreciation are not in sync across the 3 statements. To test for this, take last year's fixed assets, net of amortization from last year's balance sheet, add capex expenditures from the cash flow statement (which increases net fixed assets), and subtract depreciation shown on the cash flow statement and income statement (which reduces net fixed assets). The result should be the net fixed assets on your current year balance sheet. if it's not, then you're out of sync, and your balance sheet won't balance until you fix it. FA, Deprec, and Capex are a closed loop and must work together.
Just brilliant. Loved your presentation, loved how quickly you put the whole thing together. Very inspiring. thank you!
@eric_andrews
Жыл бұрын
I'm so glad to hear it. Cheers!
Thank you for this video! I found this because I am in the middle of jobs interview and part of the process was a financial modeling test. I studied this video to prepare and I just received the email that I excelled on the test, and I will have the final interview with the CFO. Thanks again!!
@eric_andrews
3 жыл бұрын
That's amazing!!! Congrats ricardo! You don't know how happy that makes me to hear it. These are the kinds of messages that help me keep going creating content
Great Job, Eric! Watching this video actually provided answers to the questions of the three main statements. Well represented.
@eric_andrews
3 жыл бұрын
I'm happy this video cleared it up for you. Thanks for checking it out Tania
Maybe the most useful 38 minutes I've spent this year. Fantastic!
Eric, this is amazing. Thank you so much, so clear so easy to follow.
@eric_andrews
3 жыл бұрын
Glad it was helpful Eloise!
Thank you! Concise, to the point and weel explained.
Amazing ❤️ Best I have ever seen on 3 Statement model.. Great Work !
Thanks, Eric. You did a splendid job there. Your teaching skills make it quite easy to understand. You're doing a great job with these tutorials.
@eric_andrews
3 жыл бұрын
I appreciate that wolf man! Cheers
the last 38mins has been my best understanding of financial modedlling :-) thank you Eric
Such a beautiful and clear explanation, wish I had access to it earlier. Thank you so much!
@eric_andrews
3 жыл бұрын
Thanks for the comment David. Really glad you found it helpful! Let me know if there are any other subjects you'd like to see on the channel 👍
I can't thank you enough Sir, the model you created is informative + fun. Please continue to upload such great stuff. Thank you 😍
@eric_andrews
3 жыл бұрын
Cheers Azhar 😎😎😎 will do!
Great job Eric, very useful! Thank you so much
Cant thank you enough Eric! Your content is incredibly helpful.
@eric_andrews
3 жыл бұрын
I appreciate that! Its my pleasure Rabia
This was really helpful Eric. Thanks and keep up the good work
Awesome video Eric. I've been a Finance manager for a few years and have always been forecasting P&Ls because we're a start up. This will help me take my forecasting skills to the next level. Cheers
@eric_andrews
Жыл бұрын
Awesome to hear thanks for sharing
I really love this...Despite being CPA and having finance bachelor things have never been presented this clearly in my life. Thank you do much 💐😘
@eric_andrews
3 жыл бұрын
😎😎😎 makes me so happy to hear it! Cheers!!
Super glad I found this video! Thank you so much!!!
Love it. Please keep up the great work.
this is just beautiful, simple and very clear. thanks for the content
@eric_andrews
3 жыл бұрын
Ephraim - really appreciate that feedback. It's my pleasure to help. Cheers!
Great explanation, Eric! Thanks a lot!
@eric_andrews
3 жыл бұрын
My pleasure Maryna! Thanks for checking it out
Eric: Thank you for the excellent content, your explanation was so amazing.
@eric_andrews
3 жыл бұрын
Hey Kamesh I'm really glad to hear that
I love your excel & finance knowledge skills, you are awesome
Thank you Eric! I always had problem to tie out the Cash Flow Statement but it is now cleared for me, specifically on the operating activities. I am really enjoying your videos and content, right to the point! Greetings from Panama 🇵🇦!
@eric_andrews
3 жыл бұрын
Cheers Garry, great to hear it. I'll try to include this type of modeling in more of my videos. Saludos amigo! Tal vez un dia un video en español tambien!
Your explanation was great! I have always struggled with basic financial modelling and you made everything appear very simple! Thanks a ton!
@eric_andrews
3 жыл бұрын
Hey shreeya - really glad to hear it. Thanks for letting me know 😁
@cavidbayramov5638
2 жыл бұрын
Y
Thank you Eric! This video is very GOOD!!
This is exactly what I needed !! Thank you so so much Eric!
@eric_andrews
3 жыл бұрын
That's what I love to hear, cheers Swastik
I do appreciate Brother Eric! I have been a practitioner for self teaching on corporate finance..but your vide on build financial statements is reall good..Thank you very very much
Am super super grateful for this man. I have been practicing over a week now. cheers
@eric_andrews
3 жыл бұрын
Wow that's awesome Daramola. Makes me happy you found it so valuable. Good luck with everything - you got this!
Great!!! this video is well explanatory and easy to comprehend. Thank you Eric for this video.
@eric_andrews
3 жыл бұрын
Agboola 🙏🙏👍 cheers
Thank you Eric. This explanation is awesome. Very clear and simple.
@eric_andrews
3 жыл бұрын
Mariam - I love to hear that! Cheers!
Excellent and simple Eric ...
Thank very very much. I was just totally lost, but you came along with your tutorial and made my day. 🙏🙏🙏
This was amazing learnt so much! Thanks Eric
@eric_andrews
4 жыл бұрын
My pleasure I'm glad it was valuable for you.
Great content Erick. Thank you!!
Great Job Eric! Concise and clear explanation - Many thanks!!
@eric_andrews
2 жыл бұрын
My pleasure Konstantinos
This is an amazing stuff! Thank you for sharing
I have to felicitate you!!!!! To do this in 30 minutes, so well explained that a novice excel user can understand it, I am surprise!!!! you are indeed bless. thank you for sharing your teaching blessing in finance!!!! Looking forward to check other lessons.
@eric_andrews
3 жыл бұрын
Hey JR, it is my pleasure to help and I'm so happy that this video helped you learn these complex concepts. Appreciate the comment!!!!
Best ever video on the 3 financial statements. For the first time I was able to complete end to end such model for an ongoing business. Thanks for sharing such insightful video.
@eric_andrews
2 жыл бұрын
Great to hear!
This is so good! Thank you so much man
Amazing. This was super helpful!!
Thank you so much, I agree this is way better than years in undergraduate degree! thank you again
Thank you so much Eric. You helped me understand building the financial models and do my work easily.
@eric_andrews
3 жыл бұрын
My pleasure Daniel 👍
Amazing. Just the right duration too. Thank you so much.
@eric_andrews
3 жыл бұрын
You're very welcome Venkatesh!
3 Statement financial model well elaborated!! You are the best on-line tutor
Great video Eric! That's the most valuable 38 minutes I've ever spent - now I get a deeper understanding of the difference between FCF and FCFF. Nicely done!
@eric_andrews
5 ай бұрын
Glad you enjoyed it!
The interlinkages make way more sense when you are actually working through these statements in a real example case, sure lecture topics help us shape our approach, but without applied examples most of it goes in one ear and out the other! You have a natural talent for teaching, thank you for this content!
@eric_andrews
3 жыл бұрын
I'm really glad to hear that Eric. Yes, I honestly barely learned / understood anything in my university finance classes, so I'm trying to create lectures that are like the "anti-college" and fill those gaps. So glad you understand this stuff now and good luck! More to come!
@ericbecker7624
3 жыл бұрын
@@eric_andrews you are definitely meeting this goal. Always happy to see more!
I watched 2 of your video now back to back. I have always been interested in Excel and financing models but your videos saved me tones of $$$ in planned course fees. Thanks you
@eric_andrews
3 жыл бұрын
You are very welcome and I'm glad to hear it Muhy 👍
Clearly explained, great stuff!!! Keep up the good work!!!
@eric_andrews
3 жыл бұрын
Hey Sanjoy appreciate that, will do !!
One of the best videos on building a financial model I have ever seen. It's very concise and well-explained. Thanks a lot, Eric.
WOW, well explained with basic data . It's really great and huge data can be handled very easily after watching this video . I did less or more in a same way but still got great idea and logic to compile the huge data .
@eric_andrews
3 жыл бұрын
Really really happy to hear that you now feel like you have working knowledge and understanding to do this yourself for companies. To be honest, it was tough getting it all into one video so I'm really glad it was helpful for you! This type of modeling took me a long time to learn because no one could really explain it to me in a coherent way, so my goal was to make it easier.
This was some of the most useful information I’ve ever had the privilege to consume. Am on a job hunt for financial analyst job & need to brush up my skills. Thanks for this !!
@eric_andrews
2 жыл бұрын
Absolutely love to hear it Ahmed, good luck out there!
This is simply the best lecture! No need for expensive database. Just excel spreadsheet. Keep it up
@eric_andrews
3 жыл бұрын
Love to hear it Susuve, cheers!!
very nice tutoring, thank you Eric!
A really great video! Thank you so much because this helped me clear the interview of a boutique Investment Banking firm where the interviewer asked me how to link the Cash flow statement and the balance sheet and I at the back of my mind, I was like 'Thank you so much Eric Andrews'!
@eric_andrews
3 жыл бұрын
Literally one of my favorite comments I've ever received. So glad to be able help you in that situation! Wishing you great success out there!!!
@jayanthchunduru3437
3 жыл бұрын
@@eric_andrews According to you, what would be the most flattering answer to the question, Why Investment Banking?
@eric_andrews
3 жыл бұрын
@@jayanthchunduru3437 You mean, as an interview question? I actually work in startups, as I'm more interested in running companies than buying / selling them! But at the end of the day people sign on for i banking because you can get tons of experience understanding transactions, capital markets and companies in a short period of time. This will leave you with a broad skill set to do many things after a few years. And in terms of societal value, banks help businesses realize the value they've created by facilitating competitive transactions and getting businesses access to liquidity. Those events can change people's lives (employees / founders getting an exit), help companies grow, help the economy grow, etc, which can be very positive. I would focus on those points.
@jayanthchunduru3437
3 жыл бұрын
@@eric_andrews Thank you, Eric!
@amusaazeez4410
2 жыл бұрын
Well done job , please how to prepare financial statement using excel format in very simple way
Love this! Thank you so much:)
What a valuable 38 minutes of learning 😊
In the history of my life I have never commented on KZread!! So this is a big deal! AMAZING!! This was soooooo helpful. You have no idea! Being able to learn this the way you teach with templates and myself putting in the data at the same time while I paused the video was worth more than ALLLL the years i spent learning accounting in high school and college. Seriously thanks. Def. subscribed!
@eric_andrews
3 ай бұрын
Yessss 🚀👏
Literally the best video ever!!! I built the entire model and understood it all. THANK YOU!!
@eric_andrews
2 жыл бұрын
haha, you're welcome
Hey, I love this. I patiently watch this. Needed in my job. My new company has problem in FS. My recently task is Cash Flow. There's a discrepancy. This video of yours I will try this, hopefully can help my employer. Thank you very much. Please create more content about FS or auditing each titles, and taxes. God bless!
Starting a new career and this video really helped me build a strong foundation for financial models. Thanks so much!
@eric_andrews
3 жыл бұрын
Happy to hear it. Good luck Sam!
Thank You Eric, You explained this financial model in such an easy and understandable way.
@eric_andrews
Жыл бұрын
I'm glad to hear it!
This is very explanatory and simple to understand. Thanks Eric for the video.
@eric_andrews
Жыл бұрын
You're very welcome!!
Fabulous Teaching Period. Cleared my concepts like Crystal I swear...
This is awesome Eric, you have made it so simple than when I was in the University
@eric_andrews
3 жыл бұрын
I love to hear that Kayode! Thanks for letting me know
Big thanks for that clear and understandable explanation, all financial accounting course in 38 minutes! just go ahead
@eric_andrews
3 жыл бұрын
I'm very glad to hear it, thanks for the comment Alua!
Nice one. Thanks for sharing.
Easy to learn and understood. Thank you!
@eric_andrews
3 жыл бұрын
Glad to hear it, cheers Yuri!
this video is gold...I am able to understand each and everything related to modelling thanks for being a CA student however i was getting problem in excel cause i am like beginner into it....love from india bro and thx for such excellent lesson
Best video mate... Cheers
Thanks for great lesson
Thank you for this!
Thank you so much, i've learned a lot and will keep watching your videos!
@eric_andrews
Жыл бұрын
Glad to hear it, hope to see you in the comments section on some other videos !!!
Very very helpful, thanks
this was so helpful thank you
Of course I'm subscribing, I'm most grateful for such a great presentation. You are a life saver.... Thank you
@eric_andrews
Жыл бұрын
Thank you so glad it was helpful!