I rarely comment on sites, but ive been watching a ton of excel vids on TH-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.
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?
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
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
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?
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.
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.
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?
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.
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.
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?
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, 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
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 th-cam.com/video/xlXDZyZ9azk/w-d-xo.html => E-commerce financial model th-cam.com/video/bsmyakxOPLY/w-d-xo.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, 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
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 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.
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 TH-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. 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 Eric! I have learn a lot from you. Appreciated it!
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?
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!
Hats off to you Eric! You are an amazing teacher, god bless
This is very educative Eric, Thank you
My pleasure
Fantastic! Super helpful, clear and well thought out. Great presentation style. :)
Glad it was helpful! Thank you very much!
Thank you very very much! This video was very helpful. I subscribed immediately!
Amazing thank you so much Soma!!
this is so helpful and so convenient for work purposes.
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!
Great video, you're good at this!
Thanks Eric, this video is really helpful.
you are very welcome!
Great work mate.... Kudos
Great stuff! Just what I needed. U are my hero! 🔥👌
Brilliant video as usual ! Thanks for sharing your knowledge.
A Sharma - really appreciate that. Cheers!
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?
Thank you for this video and your knowledge sharing. Super appreciated!
You are very welcome!!
very helpful and convenient for newbies.
Hi Eric, I really enjoyed this tutorial. Thank you, I will need to watch it a few times though. 👍
You are so great brthr like seriosly you solved my so many issues
Haha happy to hear it Shreya, cheers 👍
@is forecasting of this analysis / Net sales also possible further? And what methods will be most suitable?
Wow!! Thank you. This clarifies a lot of confusion !!
Well that is awesome to hear 😁
Thank you, that was very helpful!
Fantastic mate!
Great Presentation Plus Well Taught 👍
Hi Eric,
Keep post more videos with examples
Will do!
Thank you very much Eric.
Really helpful.
Glad to hear it! Thanks Mohd
Attached spreadsheet format is compatible...please share the other one
Hi Eric, you have the best content!! Thank you for sharing with us so much knowledge!!
came back after one year just to say Thank you Eric for this Video , do you have something for planning ?
Really helpful! Thank you very much! ❤
You are very welcome!
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
Thank you! Thank you! Thank you!
Hi Eric, thanks for the video. is it new and returning customers or unit?
Excellent presentation
Thanks Farhan! Glad it was useful for you 👍👍👍
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
Great effort and it’s really helpful , thank you .
Amar - it's really my pleasure. Thanks for letting me know.
I've waiting for this bruh. U are the awesome.
I really, really appreciate that. Thanks for watching all my videos lately bocobox!
great video however the text in the sample excel file is blurring
Great work ❤
Thanks ✌️
what is the part of forecasting ?
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?
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
how to set the forecast percentage for a group of restaurant company (is it monthly or yearly)
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 th-cam.com/video/LbQdW39eomM/w-d-xo.html
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
Great job!
Thank you! Cheers!
Thank you so much!!!! You’re awesome
Hi Eric, the link to download the template seems to be broken. If you could kindly fix it! Love the video though, great explanation.
You are hero 💫🙏
Thanks a lot for the video.
You got it!
Thanks, Dude; appreciate this.
Glad it helped!
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?
Really helpful and insightful 👌
My pleasure, happy it was helpful!
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.
Excellent
My pleasure Atta! Cheers!
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, could you please make a video on sales forecasts of physical products based on sales cycles? Thanks
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!
Bless you! Great help. Thnx a lot.
My pleasure Ting. Glad it was helpful !!
Thanks Eric.
My pleasure Ngoc!
Hi Eric. Please how can i download the format from you tube
In the description
Eric can you make a video on lbo model and M&A model too
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 👍
Thank you from india🙏
My pleasure Raj! Thanks from the US for watching 🙏
What done first budgeting or forecasting????
They are the exact same thing!!
thanks man!
you're welcome!
Eric Dios lo bendiga ❤️❤️
Y a usted tambien 🙏
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, 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?
.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
We are now married😭😂 Seriously, thank you.
Nice explanation
@Raja sekhar thanks !!
Is this a tutorial for businesses?
Yes
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.
How to prepare company budgets?? Please share a video if u have
What do you mean? This is a video about that
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
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 th-cam.com/video/xlXDZyZ9azk/w-d-xo.html
=> E-commerce financial model
th-cam.com/video/bsmyakxOPLY/w-d-xo.html
Can I get the template sir ? I love your videos much. Thanks
Template is right there in the description for free. Thank you.
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
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
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?
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.
where is the template to download? thanks
Right there in the description 👍
Hi Eric ,how do l get the template .I believe it will assist
Hi Tapiwa - just download it for free right in the description.
thank you
Hey Tarek - glad it was helpful. Appreciate you checking out my stuff 😁
excellent
Damn! This is a gem.
Nikolai - awesome to hear it. Thanks for the comment!
very interesting
Great!
Kindly create this kind of model for manufacturing company with multiple products