I rarely comment on sites, but ive been watching a ton of excel vids on UA-cam. Thank you for what you do, the constant reminders of shortcuts like F4 ect. Please don't stop making content. You are the GOAT at this.
Hey Eric, you are a good tutor/teacher. I have a FP&A interview coming up and your video is extremely helpful. I thank youtube, you, god and my luck to come across this video. I usually don't comment on any video. But here I am not only commenting but also about to like and subscribe to your video.
Appreciate the comment, best of luck in your interview. I also have a finance interview prep series here on youtube, I'm sure this would be helpful for you: ua-cam.com/play/PLdoBuNNnCmdXom4YXwTID-W1obBftGEEE.html
Thank you brother ! Just received a job as a jr operations analyst and I start Monday ! Really wanted to brush up on this before starting to have a better understanding! I feel confident going into work now!
Hello. It's been a year since you commented, but can I know your qualifications and skills to get that job? I mean you work only in Excel or any other software?
Thanks a lot for the great video. my question is: for example, I expect you to in JAN to minus returning(churn amount) as $21,250 from new revenue as $25,000 to get the net revenue, while you add it up!! why? what is the point?
Can you show us how to create a forecast budget for department? Like corporate that is not related to sale. I wanted to track our department budget such as budget allocation, operating expenses, payrolls, salary & benefit, non cap equipment, office supplies. Thanks
Account Code Some Department budget items, some are fixed asset e.g. computer , software, chairs, table etc, but not PL Is it no need to do in monthly PL budgeting model?
Hi Eric, after applying the sumif formula on the month of Jan and got the amount of 15,000, when I drag or paste this amount along the rest of the months, I face Zero in these cells instead of their related expenses!!! what's the solution?
I found your content very helpful. however kindly assist, how to convert this, if we have service based business, and there are several activities ( revenue streams) such as in cleaning, we are getting revenue from General Cleaning, Windows cleaning, Carpet cleaning. Kindly assist. Thanks
Hey Diego - yes I'll keep making them. I also have two other lessons about forecasting you can check out: => Building a 3 statement financial model ua-cam.com/video/xlXDZyZ9azk/v-deo.html => E-commerce financial model ua-cam.com/video/bsmyakxOPLY/v-deo.html
Thank you for providing such an informative video. Will this template help me forecast future growth/revenue? As we add additional team members and provide more services I would like to be able to determine what our revenue and profit margins will look like.
Hi Eric, thank you so much for ur efforts, i am havin a new small company , and i need ur advise about the financial issue, since to years the business is not covering the expenses, i want to creat a weekly following up, inorder verify the expenses, orders, profit...etc to avoid seeing big number lost at end of the year😁. Thanks
Hi - thanks for the comment. Happy to give some advice. If the business is losing money, your revenues must be lower than your expenses. You have two options: (1) is to lower your expenses, (2) increase your revenues. Are you able to do either of these things?
Super simplified presentation of Monthly budgeting etc, however, although I owuld like the template to follow through, I do not see any link. Otherwise great and helpful.
bottoms up 100%, top down is more like just putting 20% revenue growth in (without underlying assumptions) and using that style of logic to build everything. bottoms up is forecasting all the underlying details and then adding it all up in the model
COGS are direct costs of a business. It would be completely different with every business but for instance if you had a restaurant the cooks and waiters and ingredients would be COGS (and maybe some other stuff), if you had a summer camp the staff would be COGS, etc. You just have to think about what costs touch the actual product.
Hey Eric! Trying to understand this best because I help operate a fitness facility, and we don't have a ton of "departments" right now. Would I break down my general expenses by different account and leave the department to the 1-2 we have?
Eric, thank you for the information, really informative. How would I be able to get a copy of your worksheet? I clicked in the link below and there is only the waitlist registration button. Please advise. Thank you.
In this model, "returning" means returning customers - customers who are buying again (repeat customers). And above it you see "new" customers, so people buying the first time. Does that help?
Hi Eric, this video was so helpful, thank you for sharing. I am currently dealing with a large data, i.e 20,000 bank transactions, I need to reconcile them all and I find it very difficult. Are you able to help? I am willing to pay cus I know its not easy job. Looking forward to hear from you!
Hey Asla thanks for the comment I'm glad it was helpful. What I think you need is the help of an accountant. Accountants organize historical information into reports, and finance people create future projections, so they are pretty different fields. Cheers
Hi Maisha - yes happy to help. There is no formula, but ultimately you have certain financial goals for the future that you want to hit around revenue and profitability for the entire company. So in real life what you first would need to do is first try to calculate revenue and then you would know how much in expenses you could spend but still hit your profit goals. You could give a certain amount (in budget) to each department as well, but it is up to you to design a process that makes sense. Ultimately you would want to add up all the "proposed" budgets and check to see if the plan makes sense and you hit the goals in your plan that are important.
Hey Daphne - trial balances just mean historical financial statements. Yes, you use the past historical information to create your future projections. Does that help?
Hi! Yes I Imagine you could also use a pivot table but then you would need to do the extra step of creating the pivot table and then linking it into the income statement. It would work if you wanted to do it that way, but I'm not sure if it really makes it easier / faster.
Hi Eric, would this tutorial be the same thing they use for spreadsheet formulae/ or First (database) ? I was just looking at roles for financial paraplanners and that seems to appear in most job description. Thanks
Hi Masato - I'm don't perfectly understand your question, but these are generally the skills of a financial analyst (or any finance roll). Sometimes companies use database software solutions for financial planning. Some of the big ones are Adaptive Insights and Analplan, and there are more. But they aren't very hard to learn, I would just focus on the financial planning concepts!
@@eric_andrews Thanks Eric for the advice and not a problem, I’m not too sure myself regarding ‘spreadsheet formulae/ database’ which I saw on a lot of job adverts for financial planners. And thought it was the same thing as your tutorial. Thanks though
![Business Budget Spreadsheet - Step by Step Instructions [for 2023]](http://i.ytimg.com/vi/FurcRaJFh0E/mqdefault.jpg)
ERIC is the GOAT of my financial career... Thanks Eric for all you do...
Haha you're very welcome 🙌
I rarely comment on sites, but ive been watching a ton of excel vids on UA-cam. Thank you for what you do, the constant reminders of shortcuts like F4 ect. Please don't stop making content. You are the GOAT at this.
🙏
This was so helpful; I am trying to do a budget for my company for the 1st time. You are a great teacher
One of the few channels which I don’t skip ads so I could at least payback the knowledge he provided. Subbed and likedyour videos!!!
🙏🙏🙏 really appreciate the support Crissa thank you !
Thank you Eric. Its been 3 years and the file is still relevant.
Yep this stuff is pretty evergreen, the basic ideas haven't changed in decades
Hey Eric, you are a good tutor/teacher. I have a FP&A interview coming up and your video is extremely helpful. I thank youtube, you, god and my luck to come across this video. I usually don't comment on any video. But here I am not only commenting but also about to like and subscribe to your video.
Appreciate the comment, best of luck in your interview. I also have a finance interview prep series here on youtube, I'm sure this would be helpful for you: ua-cam.com/play/PLdoBuNNnCmdXom4YXwTID-W1obBftGEEE.html
Thank you brother ! Just received a job as a jr operations analyst and I start Monday ! Really wanted to brush up on this before starting to have a better understanding! I feel confident going into work now!
My pleasure, I'm really happy to hear that. good luck!
Hello. It's been a year since you commented, but can I know your qualifications and skills to get that job? I mean you work only in Excel or any other software?
Thank you Eric. These days I am seeing all your tutorials on financial modeling. its really helpful. Thanks
Love from India :)
Wow what a nice compliment. Love from US !! 😁😁😁🙏
Thanks for also mentioning the details of the format and common formulas. The video is really helpful!
You are very welcome glad it was useful Youhui
I just started my company and this worked like a charm thank you so much.
Hey Saana - makes me so happy to hear that. Good luck with your business and its an honor to have helped support you!
I'm doing all 28 Vids, thanks for the courses really helpful! Thanks Eric!!
No way! You are going to learn a ton, good luck!
Omg its my first time to hear a lecture explaning in this marvels easiest & more detailed .. im lucky today to get this lecture thanks 🌹🌹🌹
You are very welcome 🙌
AWESOME!! IT HELPED ME MORE THAN TEACHERS IN COLLEGE
That's my goal Deivid - cheers!
came back after one year just to say Thank you Eric for this Video , do you have something for planning ?
Thanks a lot for the great video. my question is: for example, I expect you to in JAN to minus returning(churn amount) as $21,250 from new revenue as $25,000 to get the net revenue, while you add it up!! why? what is the point?
Can you show us how to create a forecast budget for department? Like corporate that is not related to sale. I wanted to track our department budget such as budget allocation, operating expenses, payrolls, salary & benefit, non cap equipment, office supplies. Thanks
You're probably going to get yourself arrested for putting this out for free! Great job!
They'll never find me !! 😁😁😁 Cheers
Some of us don't have money 💰 to go school he is teaching me ... I pray to God to bless you abundantly since am an orphan and I learn from you
Hi Eric, thanks for the video. is it new and returning customers or unit?
This is very educative Eric, Thank you
My pleasure
Great work mate.... Kudos
Hats off to you Eric! You are an amazing teacher, god bless
@is forecasting of this analysis / Net sales also possible further? And what methods will be most suitable?
this is so helpful and so convenient for work purposes.
Fantastic! Super helpful, clear and well thought out. Great presentation style. :)
Glad it was helpful! Thank you very much!
Fantastic mate!
Hi Eric, the link to download the template seems to be broken. If you could kindly fix it! Love the video though, great explanation.
Great video, you're good at this!
Thanks Eric, this video is really helpful.
you are very welcome!
very helpful and convenient for newbies.
Attached spreadsheet format is compatible...please share the other one
Very good information and really helps. Thank you so much. Eric.
My pleasure to help Yau! Cheers
Very helpful, Eric! Thanks for putting it together for us. I appreciate it.
My pleasure Nidhi!
Hi Eric, could you please make a video on sales forecasts of physical products based on sales cycles? Thanks
Account Code
Some Department budget items, some are fixed asset e.g. computer , software, chairs, table etc, but not PL
Is it no need to do in monthly PL budgeting model?
Great stuff! Just what I needed. U are my hero! 🔥👌
great video however the text in the sample excel file is blurring
Hi Eric, I really enjoyed this tutorial. Thank you, I will need to watch it a few times though. 👍
Great video Eric, However, you mentioned that there is a link for a video on how to lock cells. What is the name of the video?
sure here it is ua-cam.com/video/LbQdW39eomM/v-deo.html
Hi Eric, you have the best content!! Thank you for sharing with us so much knowledge!!
what is the part of forecasting ?
Hi Eric, after applying the sumif formula on the month of Jan and got the amount of 15,000, when I drag or paste this amount along the rest of the months, I face Zero in these cells instead of their related expenses!!! what's the solution?
Great Presentation Plus Well Taught 👍
Wow!! Thank you. This clarifies a lot of confusion !!
Well that is awesome to hear 😁
Brilliant video as usual ! Thanks for sharing your knowledge.
A Sharma - really appreciate that. Cheers!
Thank you very very much! This video was very helpful. I subscribed immediately!
Amazing thank you so much Soma!!
Hi Eric,
Keep post more videos with examples
Will do!
I found your content very helpful. however kindly assist, how to convert this, if we have service based business, and there are several activities ( revenue streams) such as in cleaning, we are getting revenue from General Cleaning, Windows cleaning, Carpet cleaning. Kindly assist. Thanks
Thank you for this video and your knowledge sharing. Super appreciated!
You are very welcome!!
Excellent presentation
Thanks Farhan! Glad it was useful for you 👍👍👍
Thank you! Thank you! Thank you!
You are so great brthr like seriosly you solved my so many issues
Haha happy to hear it Shreya, cheers 👍
Thank you, that was very helpful!
how to set the forecast percentage for a group of restaurant company (is it monthly or yearly)
Thank you for the video! Can you make more videos about budgeting and forecasting?
Hey Diego - yes I'll keep making them. I also have two other lessons about forecasting you can check out:
=> Building a 3 statement financial model ua-cam.com/video/xlXDZyZ9azk/v-deo.html
=> E-commerce financial model
ua-cam.com/video/bsmyakxOPLY/v-deo.html
Thank you very much Eric.
Really helpful.
Glad to hear it! Thanks Mohd
Great work ❤
Thanks ✌️
Thank you for providing such an informative video. Will this template help me forecast future growth/revenue? As we add additional team members and provide more services I would like to be able to determine what our revenue and profit margins will look like.
Free template
Thank you so much!!!! You’re awesome
Hi Eric, thank you so much for ur efforts, i am havin a new small company , and i need ur advise about the financial issue, since to years the business is not covering the expenses, i want to creat a weekly following up, inorder verify the expenses, orders, profit...etc to avoid seeing big number lost at end of the year😁. Thanks
Hi - thanks for the comment. Happy to give some advice. If the business is losing money, your revenues must be lower than your expenses. You have two options: (1) is to lower your expenses, (2) increase your revenues. Are you able to do either of these things?
Great effort and it’s really helpful , thank you .
Amar - it's really my pleasure. Thanks for letting me know.
Super simplified presentation of Monthly budgeting etc, however, although I owuld like the template to follow through, I do not see any link. Otherwise great and helpful.
Download link is right in the description 👍
Would this be considered a bottom up or top down forecast approach?
bottoms up 100%, top down is more like just putting 20% revenue growth in (without underlying assumptions) and using that style of logic to build everything. bottoms up is forecasting all the underlying details and then adding it all up in the model
Really helpful! Thank you very much! ❤
You are very welcome!
Great job!
Thank you! Cheers!
Eric can you make a video on lbo model and M&A model too
Really helpful and insightful 👌
My pleasure, happy it was helpful!
Excellent
My pleasure Atta! Cheers!
Hi Eric, what will COGS in case of a service Industry?
COGS are direct costs of a business. It would be completely different with every business but for instance if you had a restaurant the cooks and waiters and ingredients would be COGS (and maybe some other stuff), if you had a summer camp the staff would be COGS, etc. You just have to think about what costs touch the actual product.
Thanks a lot for the video.
You got it!
Hey Eric! Trying to understand this best because I help operate a fitness facility, and we don't have a ton of "departments" right now. Would I break down my general expenses by different account and leave the department to the 1-2 we have?
Yes exactly! If you only have "1" department (in terms of the model), that's no problem to just list all the expenses under it.
@@eric_andrews Thank you!
I've waiting for this bruh. U are the awesome.
I really, really appreciate that. Thanks for watching all my videos lately bocobox!
Thanks, Dude; appreciate this.
Glad it helped!
You are hero 💫🙏
Eric, thank you for the information, really informative. How would I be able to get a copy of your worksheet? I clicked in the link below and there is only the waitlist registration button. Please advise. Thank you.
You clicked the wrong link. Look a little harder 😎
Hi Eric. Please how can i download the format from you tube
In the description
.It was worth watching, but i have one query, what kind of returing it was, was it sales return or something else as you have added into revenue
In this model, "returning" means returning customers - customers who are buying again (repeat customers). And above it you see "new" customers, so people buying the first time. Does that help?
@@eric_andrews oh great...now got it... thanks for your prompt response
thanks man!
you're welcome!
Thanks Eric.
My pleasure Ngoc!
Hi Eric, this video was so helpful, thank you for sharing.
I am currently dealing with a large data, i.e 20,000 bank transactions, I need to reconcile them all and I find it very difficult. Are you able to help? I am willing to pay cus I know its not easy job. Looking forward to hear from you!
Hey Asla thanks for the comment I'm glad it was helpful. What I think you need is the help of an accountant. Accountants organize historical information into reports, and finance people create future projections, so they are pretty different fields. Cheers
@@eric_andrews we appreciate you, well done job , please best site for preparing account and fixed schedule
We are now married😭😂 Seriously, thank you.
Can I get the template sir ? I love your videos much. Thanks
Template is right there in the description for free. Thank you.
Nice explanation
@Raja sekhar thanks !!
How to prepare company budgets?? Please share a video if u have
What do you mean? This is a video about that
What done first budgeting or forecasting????
They are the exact same thing!!
Eric, my query is in a Excel template how do I give format colours for hardcorde data / inputs???
Hey Sai - good question. You always want to format the hardcoded data in a dark blue. This is standard across all companies, and is a best practice.
So how do we setup budget cost? What is the formula to determine a budget amount for each task?
Hi Maisha - yes happy to help. There is no formula, but ultimately you have certain financial goals for the future that you want to hit around revenue and profitability for the entire company. So in real life what you first would need to do is first try to calculate revenue and then you would know how much in expenses you could spend but still hit your profit goals. You could give a certain amount (in budget) to each department as well, but it is up to you to design a process that makes sense. Ultimately you would want to add up all the "proposed" budgets and check to see if the plan makes sense and you hit the goals in your plan that are important.
Bless you! Great help. Thnx a lot.
My pleasure Ting. Glad it was helpful !!
Kindly create this kind of model for manufacturing company with multiple products
Thank you from india🙏
My pleasure Raj! Thanks from the US for watching 🙏
Eric Dios lo bendiga ❤️❤️
Y a usted tambien 🙏
Sometimes forecasts are made off the Trial Balance. is that the 3 statement model or that's something else entirely?
Hey Daphne - trial balances just mean historical financial statements. Yes, you use the past historical information to create your future projections. Does that help?
Is this a tutorial for businesses?
Yes
very interesting
where is the template to download? thanks
Right there in the description 👍
excellent
6:35
Do you think it was better to use pivot table instead?
Hi! Yes I Imagine you could also use a pivot table but then you would need to do the extra step of creating the pivot table and then linking it into the income statement. It would work if you wanted to do it that way, but I'm not sure if it really makes it easier / faster.
@@eric_andrews If doing Pivot might as well do in Power BI for better visuals.
Hi Eric, would this tutorial be the same thing they use for spreadsheet formulae/ or First (database) ?
I was just looking at roles for financial paraplanners and that seems to appear in most job description. Thanks
Hi Masato - I'm don't perfectly understand your question, but these are generally the skills of a financial analyst (or any finance roll). Sometimes companies use database software solutions for financial planning. Some of the big ones are Adaptive Insights and Analplan, and there are more. But they aren't very hard to learn, I would just focus on the financial planning concepts!
@@eric_andrews
Thanks Eric for the advice and not a problem, I’m not too sure myself regarding ‘spreadsheet formulae/ database’ which I saw on a lot of job adverts for financial planners. And thought it was the same thing as your tutorial. Thanks though
Hi Eric ,how do l get the template .I believe it will assist
Hi Tapiwa - just download it for free right in the description.
Great!
thank you
Hey Tarek - glad it was helpful. Appreciate you checking out my stuff 😁