Questions? Let me know in the comments happy to discuss. 🚀 Also, if you want to learn how to systematically scale your startup without ending up as one of the 90% of startups that fail, check out my free training webinar ⇒ www.ericandrewsstartups.com/financeforstartups
@pappalardox9 ай бұрын
Great video, thoroughly explained and with some helpful hints for folks that aren't as familiar with Excel. Only thought/question is this: Does a valid (even basic) financial model not make some assumptions regarding an increase in COGS over time? Predicting that those values would hold steady over that length of time seems like a pit fall for this model, even based on hypothetical values.
@pimht3 жыл бұрын
This model literally saved my life. My online course needs models and online instructors don't teach, just grade. I'm essentially paying to teach myself. Took me all week to find this video, but I am GRATEFUL!!!
@eric_andrews3 жыл бұрын
You are welcome and I'm so happy it was exactly what you were looking for !!
@joon3638 Жыл бұрын
As a non eng speaker i really appreciate your clear pronunciation skills! I need to explain a model to the professor tomorrow for an exam & you saved me.
@eric_andrews Жыл бұрын
Happy to help!
@muhammadzakiachsan47503 жыл бұрын
Hi Eric, thanks for making this video! It helps me during my preparation for a Job Interview. I learned financial modeling in my under-graduate, but I wasn't ready yet and I didn't learn much about the subject. This video helps me to remember what I was learned back in university and also adding more finance knowledge to me. Many thanks to you!
@eric_andrews3 жыл бұрын
Really glad it is helping you in your career Muhammad and getting you started financial modeling. Best of luck to you!
@sunriseeternity300 Жыл бұрын
Impressive. Very consise. I feel smarter after watching #excel #financialmodel #profit #enjoylife
@danielavnieli6853 жыл бұрын
You are now the GOAT for financial modeling. Thanks again!
@eric_andrews3 жыл бұрын
Cheers Daniel 🙏🙏🙏
@azhard73993 жыл бұрын
Appreciate how you are giving away all this information for free ❤️. All your videos are very informative. Keep up the good work please !!
@eric_andrews3 жыл бұрын
It's my pleasure Azhar! Lots more coming, thanks for the support 😀
@asadyousafzai29043 жыл бұрын
I hope you continue to provide these kind of learning videos. You are a rockstar!!
@eric_andrews3 жыл бұрын
Thank you, I will Asad!!!! Lots more to come this year.
@brigetfields4490 Жыл бұрын
Great content- an amazing refresher since it's been a long time since I calculated these financials
@eric_andrews Жыл бұрын
Glad it was helpful!
@StayPolishThinkEnglish3 жыл бұрын
Eric, this is extremely useful. You make people walk through it smoothly. I've been looking for something like this. I started from the advanced ones and I was struggling with it (as you said so). Now it's crystal clear. Thank you!
@eric_andrews3 жыл бұрын
Glad to hear it! Thanks for the comment!!
@nickleshmaani2508 Жыл бұрын
Hi Eric, Thanks for making this video, it's very useful.
@eric_andrews Жыл бұрын
My pleasure
@rickylin5561 Жыл бұрын
Financial Modeling is a broad/general concept. It covers from corporate finance, quant model and statistical model (linearity). Really depends on which you need in specific purpose. I think the one you introduced in the video is more like a Corp Finance (FP&A) focused financial model. Correct me If Im wrong, thanks!
@eric_andrews Жыл бұрын
For sure! Any financial thing could be modeled, but this video is for the purposes of projecting financials to run a company (corp finance as you said)
@ngamin52347 ай бұрын
excellent lectured 👍
@eric_andrews7 ай бұрын
Thanks a lot!
@isaacadelugba74446 күн бұрын
Gather here all those who are going for interview on financial modeling
@timestampingarmy3 ай бұрын
0:32 finance and accounting
@ElzbietaOkrasa3 ай бұрын
Wow! This is do well explained!thank you!!
@worapitchaj.10612 жыл бұрын
Eric, Thank you very much for sharing! It's such a great video to start making financial modeling. Simple but informative. Awesome!
@eric_andrews2 жыл бұрын
Glad it was helpful!
@mibusharah8 ай бұрын
Thanks a lot I had no idea about the financial model.
@eric_andrews8 ай бұрын
my pleasure!
@lavenderl97313 жыл бұрын
Amazing clarity. Thank you for sharing the Excel file for free!!! Subscribed!
@eric_andrews3 жыл бұрын
Happy it was helpful Lavender, appreciate the subscribe!!
@ifeoluwaademeso Жыл бұрын
Thank you
@mohsinbaig21952 жыл бұрын
I am so glad that I found your channel. So helpful and amazing. Man I really appreciate! ✨♥️
@maheshramachandran59222 жыл бұрын
Eric good, but how to modify this model for a manufacturing business unit.
@alirazasyed100 Жыл бұрын
Thanks for a great video Eric. It was very helpful!
@eric_andrews Жыл бұрын
Glad it was helpful!
@alpaytok Жыл бұрын
Teşekkürler.
@eric_andrews Жыл бұрын
You are very welcome!
@jitenanand4899 Жыл бұрын
double entry book keeping system is just the old school of SQL language we use today.
@KevinDutton-wo5jp2 ай бұрын
Такие близкие игры самые интересные) кайфово что тебе пришли такие заносы сегодня)
@shrikantbadge397810 ай бұрын
Nicely explained thanks
@eric_andrews10 ай бұрын
Cheers
@michellesinyinliew80623 жыл бұрын
Thank you eric, you are the best. Thank u thank u.
@MrCelcifer2 жыл бұрын
Wow Amazing explanation. Thankyou Sir
@muhammadumad76873 жыл бұрын
Really informative..ERIC
@asmaaljemeli67513 ай бұрын
OMG thank you so much! this is so helpful!!
@eric_andrews2 ай бұрын
Glad to hear it!
@sandipchavan39563 жыл бұрын
Very good and easy explained...thanks
@eric_andrews3 жыл бұрын
My pleasure Sandip! Cheers
@wishudeath41433 жыл бұрын
Thanks Eric Sir
@ManojKumar-ic1iy Жыл бұрын
Thankyou for sharing information
@eric_andrews Жыл бұрын
you are very welcome
@virtuousmama6089 Жыл бұрын
Dude you rock…..you dropped so much value
@eric_andrews Жыл бұрын
Haha thanks, glad it was helpful!
@TasneemJahan-ow7xw Жыл бұрын
Love your content! Thanks .
@eric_andrews Жыл бұрын
Thanks for watching!
@victorynagbi73002 жыл бұрын
Thank you so much, I learnt something new 🤗
@eric_andrews2 жыл бұрын
You are very welcome 😁
@14jabin2 жыл бұрын
Thank you!
@aswinxavierab3223 Жыл бұрын
Really helpful video
@hariadiksa5312 жыл бұрын
Thankful... Give me back lesson... 👍
@eric_andrews2 жыл бұрын
youre welcome!
@tarekalsherif573 жыл бұрын
Thank you Eric
@eric_andrews3 жыл бұрын
You are very welcome Tarek!
@gazals80393 жыл бұрын
Please whole course about financial modeling
@eric_andrews3 жыл бұрын
Don't worry, it is coming!
@gcinapersevervance15048 ай бұрын
Wow! Amazing!
@niiatgroup94512 жыл бұрын
Wow thanks Sir, great explenation. very helpfull
@eric_andrews2 ай бұрын
very welcome!
@sonerguney32253 жыл бұрын
Well done. Thanks for your efforts.
@eric_andrews3 жыл бұрын
My pleasure, glad it was helpful Soner 👍
@NormalDudeInBound3 жыл бұрын
Your KZbin channel is great. Really helps me with my business. Who needs business school, when you have KZbin? :)
@ibrarahmad7952 жыл бұрын
If possible could you please share its use able format please....as the one which was in link, not able to use that format...please
@oussamaoussama63642 жыл бұрын
Thanks a lot, great tutorial
@eric_andrews2 жыл бұрын
Cheers!
@namanpant38953 жыл бұрын
Thank you eric..this help me a alot. Keep it up..👍
@eric_andrews3 жыл бұрын
Cheers Naman happy it was helpful 👍
@gazals80393 жыл бұрын
Please make whole course for financial modeling
@eric_andrews3 жыл бұрын
I am going to at some point Gazal! Thanks for the suggestion 👌
@maggienguyen9583 жыл бұрын
Love your video. Thank you!
@eric_andrews3 жыл бұрын
My pleasure Maggie, glad it was helpful!
@jialu26693 жыл бұрын
Thanks for sharing, very helpful :)
@eric_andrews3 жыл бұрын
My pleasure, glad it was helpful Jia
@josephkiema47672 жыл бұрын
It is great . want to learn more.
@markgreen21703 жыл бұрын
Nice, thanks!
@abelsimonyan48222 жыл бұрын
God bless your parents!
@nayanakumarapanditharathna91672 жыл бұрын
100 present thank you & Tripalgem Bless you!!!
@PatriceMorris.2 жыл бұрын
Eric, so what would be considered in the present? Accounting is past and Financial model is future? What about the here and now?
@eric_andrews2 жыл бұрын
Generally that would be a lot of data around sales and marketing, and also to be approving or considering different investments, etc, but always keeping in mind your financial plan for the month to understand where you are at / if you want to change your plan. Present finance stuff is more tracking your performance and knowing where you are trending relative to plans. Hope that is helpful
@godislove8831Ай бұрын
Hi Eric , i am going to interview for Administrator finance i would like you to help me with questions and duties for this position.
@ClipKingSakuga Жыл бұрын
Should build a business model first, makes identifying this all easy
@enfinite056 ай бұрын
Stupid question.... is only excel used or can you use google sheets? I love google sheets over excel.
@eric_andrews6 ай бұрын
Google sheets is totally fine as well
@michellesinyinliew80623 жыл бұрын
You are the best 🤩🤩🤩🤩
@eric_andrews3 жыл бұрын
Glad it was helpful Michelle!!
@michellesinyinliew80623 жыл бұрын
May i know do you have what if analysis video?
@hadilee6853 жыл бұрын
Thanks, Eric. You have been such a great help. I am trying to set up a light manufacturing financial model. A combination of three statements, DCF, FCF, cap model, sensitivity analysis, dep schedule, LTV/CAC as well.
@eric_andrews3 жыл бұрын
It's my pleasure to help. Sounds like you are on the right track with your model! Good luck Hadi
@ntcuong01ct12 жыл бұрын
Dear Friends, I have 1 question regarding Financial Modeling: 1/ Please tell me the difference between Scenario analysis, sensitivity analysis, stress test?, and the intended use of each?. Thank you.
@ysally32142 жыл бұрын
Hi Eric, may I know how to predict the marketing costs and how to predict the return rate ? thanks a lot
@eric_andrews2 жыл бұрын
Unless the company has no history, you can just look back at the marketing costs in the past as well as the new customers and figure out what the historical numbers have been, and use them as assumptions going forward. Return rate would be the same. If you do not have any historical data, you will need to make assumptions. Cheers
@kimoso8154 Жыл бұрын
Hello, am a student building a farming system profit model. Can I have your guidance kindly
@enquiryenquiry90692 жыл бұрын
Don't understand why your Financial Model Example included talking for several years ie. 4 years Can Financial Model only be 1 year?
@Antonioalvarez-nm5mz3 жыл бұрын
Have you thought about setting up a Discord? Would be interesting to interact with other Startup Founders/Financial Analysts about their modeling approach and information sources. Great videos, thanks so much!
@eric_andrews3 жыл бұрын
It's actually a pretty cool idea. Do you think there would be much interest? I'm open to it
@Antonioalvarez-nm5mz3 жыл бұрын
@@eric_andrews Hard to tell how much engagement would be in the begininig. I think it would be a way to grow the community around your channel. It could have discord channels for you to post some useful resources, suggestions for videos, general questions and a place where your viewers can share what are they doing or what their goals are. For example, a topic like how CAC is calculated across different industries or if anyone had experience of how it evolved through time. Just make sure you moderate it so no promoting is allowed. Anyway, you could ask some viewers in your live stream.
@eric_andrews3 жыл бұрын
@@Antonioalvarez-nm5mz honestly it's an amazing idea. I really appreciate you sharing it. I've been trying to figure out a place where we can all connect, because I imagine we all have similar careers and questions. Sounds like a discord would be a great solution. I'll ask about it in the livestream!!
@eric_andrews3 жыл бұрын
@@Antonioalvarez-nm5mz Hey antonio - I'm setting up a discord, but I don't have a ton of experience. Do you think you could take a quick look and let me know if you think it's ok? It would be a massive help. If you're open to it, could you shoot me an email at ?ericandrewsbusinessinfo@gmail.com
@JayanVarghese Жыл бұрын
Could you build one for a services business in the future? ex: website design company
@eric_andrews Жыл бұрын
Yes it's on my list
@priyankakaran69322 жыл бұрын
How can I learn full course of financial modelling from Eric? And what is the cost? It is urgent please do reply
@eric_andrews2 жыл бұрын
Hi Priyanka - I'm going to be releasing a comprehensive course in November, but for now I just have the youtube. I recommend you watch my 3 statement financial model video next, as that is more than most people learn during their 4 year degree: kzbin.info/www/bejne/rp27dY2vj56UsM0
@priyankakaran69322 жыл бұрын
@@eric_andrews okay thank you so much sir
@enquiryenquiry90692 жыл бұрын
In the video, you only teach us about Financing Model for Income Statement. Is Financing Model only shown income statement? Is Financing Model no need to shown balance sheet? Why?
@SeMTeXSpale3 жыл бұрын
lets say in investment banking you are required to make a financial model how would you get the info for the business?
@eric_andrews3 жыл бұрын
Is it a public or private company ?
@SeMTeXSpale3 жыл бұрын
@@eric_andrews lets say it was jp morgan
@eric_andrews3 жыл бұрын
@@SeMTeXSpale I'm talking about the company that you're modeling not the investment Bank 😅
@harshavardhan57282 жыл бұрын
Hi Eric, I have a assignment with me, that needed for my studies - if you can help me out working these up it would be really helpful for my studies. If you are okay, let me know through what means can I share to you
@bilalmohiuddin6518 Жыл бұрын
Is the term "Predictions" mean same as "Forecasting" ? That's what I've been hearing all my life, and when I hear someone say "Predict the future" , I just wonder how different is it from "Forecasting" ?
@eric_andrews Жыл бұрын
predictions, forecast, budget, and plan all mean the same thing in the context of financial modeling 😅
@miamiwalking3 жыл бұрын
Cool videos. Would it be possible to record in 1080p ?
@peterjohansson7393 жыл бұрын
When will you create a course in financial modeling?
@eric_andrews3 жыл бұрын
Hey Peter - sometime before the end of the year I think 😃
@mustafamohammed27002 жыл бұрын
How can I get the template of the financial modeling?
@eric_andrews2 жыл бұрын
It's right there in the description for free 👍
@mohamedreda57383 жыл бұрын
Hey Eric, I'm trying to Subscribe to your Exchange to download the Workbook, but I don't know how haha, any help, please?
@eric_andrews3 жыл бұрын
No problem. Click the link in the description and go to the download page. Then enter your email and click subscribe. After you do that, you will see a link to download the file!
@mohamedreda57383 жыл бұрын
@@eric_andrews I can't find the option (Place) to add my Email, also the Subscribe button is not there.
@eric_andrews3 жыл бұрын
@@mohamedreda5738 first link in the video description bit.ly/finmodeling_mlchmp
@enquiryenquiry90692 жыл бұрын
Are all Financial Model Figuers predicted only? We don't know the acutal result for sales quantities in future years, don't know the actual payroll figures in futures If the figures are predicted or projected, the final result may be only predicted. I don’t think that predicted financial model is meaningful & useful for board of directors or boss.
@age_of_reason Жыл бұрын
Starts by saying finance is about future forecasting and then says the most common financial model is the Income Statement which is a backwards looking (Accounting) statement. You sir don't know what you're talking about.