Building a Three Statement Financial Model (Part II of II)
Vložit
- čas přidán 9. 07. 2024
- This video will guide you through the process of building a dynamic three statement financial model. The template can be downloaded at ASimpleModel.com. LINKS BELOW:
Download Excel Template:
www.asimplemodel.com/model/72... (available just beneath the video player)
See the Rest of this Video Series:
www.asimplemodel.com/model/2/...
Introduction to Financial Statements:
www.asimplemodel.com/model/1/...
Overview of ASM Financial Modeling Courses:
www.asimplemodel.com/curriculum
Private Equity Training:
www.asimplemodel.com/PrivateE...
Nerdy Updates Sent Directly to Your Inbox:
eepurl.com/b6zdCL
Instagram:
/ asimplemodel
This series cleared up 5 years of confusion in less than an hour.
Excellent, it is as much about what is not included, essentially over-complication, as what is. Clear and very helpful refresher. What a good lad.
Thanks for writing!
Extremely helpful! Very clearly explained. I couldn't have asked for a better tutorial. Thanks a ton.
I watched so many videos for financial modeling, honestly your videos so clear and simple and direct to the point. well done
Thank you for taking the time to write! Really appreciate it!
that was really clear and helpful, I seldomly post any comments, but for this one, you deserve a thumb up and more views.
Thank you for taking the time to post a comment! Always great to hear that the video was helpful.
THANK YOU
Very clearly explained and at easy pace - thank you!
Well-explained and easy to grasp model !
Excellent illustration and explanation. Really helpful. Thank you!
This is really great for me. #Simple and straight to the point👌🏻. Thank you
Awesome Lecture that make clear for me in Investment Excel. Thank you very much.
Glad it helped!
Excellent Video, thanks!
very useful and to the point
Thank you so much 🙏🏽
So glad it helped!
Thank you so much!!!!!
Thanks.Easy and good Explaination of Model..
Glad you found it helpful!
This was great, thank you and I agree that the voice is low.
Awesome! thank you so much
Glad it helped! Thanks for commenting!
very good
great video! thank you
Glad you liked it!
Thank you!!!!
You're welcome!
Very clearly explained. Thank you.
(Have you made a video showing calculations for valuation/ stock price and sensitivity analysis?)
Hi Usman, the LBO video series covers sensitivity analysis (scenario analysis) for an LBO model (www.asimplemodel.com/model/31/leveraged-buyout-model/simple-lbo-data-tables/) and there are a couple templates for public companies on the site, but I am not sure if we have precisely what you are looking for. Search the site for Home Depot or Amazon for templates.
I really don't understand how the cash balances were projected since you did not have the beginning CCE values
Did you ever figure it out? I’m confused too
Sorry for my english. I've been trying to build a financial model for a company that dont exist (yet). In other words, in T0, the company has no operation (sales= 0), but i have a inicial cash from debt and equity to buy equipaments (capex) and raw material.
In T1, the company has operation (sales, cogs, etc 0).
Im trying to build a 3 statment model, but the Cash Flow doesn't makes Sense in T0 and T1, due to changes in Working capital (calculated with DSO, DIO and DPO inputs).
I search a Lot on CZcams, but have not find any content of this situation (Just with companies with historical results, that doesn't apply for me). Could you please consider doing a model tutorial of the situation descriebed above? Thanks
At 12:50, why are you adding the current portion of LTD to LTD net of current maturities? Doesn't this double count the current portion of LTD?
Same question. Did you ever figure it out?
@@mariogotze6588 He's always taking LTD - the current portion of LTD. In other words what youre looking to calculate is your total Debt outstanding in that year to calculate your interest. So for calculating interest on your Debt for that year you need to look at what your Total Debt was. In this case Debt = current portion of LTD + LTD net of current maturities. I hope this helps.
how did you get the Beginning Cash Balance of the other projected years, since you did not have any other Cash Balances on the Balance Sheet?
Hi Noah, please see part one: czcams.com/video/-pws4pPiDFs/video.html
@@ASimpleModel hello there I watched both part one and 2. I go everything right except to the cash balance. When I project it, the values came up as zero.
@@ASimpleModel could you please help with this. At 4:53 the cash balance at 20X3 is 2000 and the other years were 0. At 5:21 you when you projected beginning cash balance, some numbers magically appeared for cash balance. I looked at your document and it appears that those numbers might have been hardcoded. Could you please explain. I would really appreciate it. Everything was clear up until that point.
It's hardcorded x4 Amt is previous amt of ending cash flow
Why have you not included bank account in current assets, though?
Thanks for the question! Cash on the balance sheet is generally held in bank accounts, so that may be where the confusion is coming from. Please see 6:20 in part I. You will see the current assets includes cash: czcams.com/video/-pws4pPiDFs/video.html
@UCnbNPYm93wv5MNZ4R_6Z41w could you please help with this. At 4:53 the cash balance at 20X3 is 2000 and the other years were 0. At 5:21 you when you projected beginning cash balance, some numbers magically appeared for cash balance. I looked at your document and it appears that those numbers might have been hardcoded. Could you please explain. I would really appreciate it. Everything was clear up until that point.
Hi, at 5:21 I am highlighting the formulas in the first column and then expanding the highlighted array to include the projected period. Then by pressing "Ctrl + R" I am pasting those formulas across the projected period. Hope that helps! The Excel for Models series might be helpful if the Excel shortcuts are making it difficult to follow the instruction: www.asimplemodel.com/model/6/excel-for-models/
Hi, how can I add new loan to this model?
Hi, please see this post: www.asimplemodel.com/reference/121/adding-a-loan-to-a-three-statement-model/ It will explain the process and provides a template for download. Hope it's helpful!
great! can you make it louder though?
Thanks! We updated the audio on the site, you can find part 1 of 2 ( www.asimplemodel.com/model/14/integrating-financial-statements/three-statement-model-part-i/ ) and part 2 of 2 ( www.asimplemodel.com/model/72/integrating-financial-statements/three-statement-model-part-ii/ ) both on the website. Unfortunately I don't think I can update audio once posted on CZcams.
Thank you!
Very useful!
However, you either need to speak up or do something with the voice in video.
Thanks for the feedback. I will take a look at audio settings for future videos.