Build a Monthly Budgeting & Forecasting Model in Excel

Make a dynamic monthly budgeting and forecasting model in Excel.

In this video we'll build a monthly budgeting and forecasting model in Excel. This is sometimes referred to as a rolling 12 month forecast as well. First, we'll take the actual operating expenses for each department. Second, we'll forecast those expenses going forward using excel's forecasting tools. Thirdly, we'll create different scenarios for these forecasts, like a best case, base case, and a worst case scenario. And finally, we'll build a full P&L to see how the forecasts affect our profitability, and because the model will be dynamic, we'll even see the impact of the different scenarios. This model is very useful for analysts working in roles such as financial planning & analysis, investment banking, equity research, and more.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Actual Operating Expenses
1:17​ - Forecasting the base case
5:19​ - Scenario Analysis (forecasting the best and worst case)
7:32​ - Income Statement Operating Expenses
13:27​ - Completing the Income Statement
17:15 - Improving the Model
19:11 - Protecting the File

[mohammadshafeeq]

We need more FP&A related videos like this ❤

[sarahusman]

Thanks Kenji...I really appreciate this video.

[Sarahsherine]

I can't thank you enough. Best video I've watched on budgeting & forecasting. Thank you so much.

[OriginalCovfefe]

I can definitely use the first half of this for my work. We dont look at Income Statements, but we certainly look at Revenue Forecasts and assume different scenarios

[nlfhtf]

Very helpful and very well presented 👍🏽 thank you ❤

[rumeeburu]

Yaaay, my video is up. Time to learn!!!

[WebFanNY]

Thanks for the video tutorial ❤, it looks flexible enough to use it as a structure for a little project. Im making an Excel population forecast for a sci fi book. Excel is not just for analysts but helps in writing projects too.

[ahmedsafwan]

i can't find enough words to xpress my gratitude and appreciation god bless you

[Mohaaabdalle]

Finally U uploaded as U promised. Thanks for sharing such a good video. Please continue to upload finance videos using Microsoft excel.

[willemvandenberg]

Good stuff man! Wish I had discovered your channel sooner

[schubertpeter]

You never disappoint Kenji! well done once again!

[cd]

Excellent video as always. One recommendation: you should add some interpretation at the end of the videos. One the budget table has been finished, what actions could be made based on they data.
That would be great

[shivam-hvil]

Make a detailed video on FP&A role . What skills are needed

[bubuA]

learnt two really cool functions here; forecast and choose. I;m going to test to see how much forecast function in excel differs from CAGR. and it also feels like choose could replace lookup functions as well, at least in similar scenarios. really helpful video. thanks!

[alexandrunegru]

You should create one about order import from selling channels import and automatization and if you know something about power automate desktop.thank you

[aayanshff]

how is your font so clear and nice ....i use calibri but it is so faded and un attractive . please help me

[RohitThakur-enqw]

Hey Kenji why you use (Pre Tax income = Operating Income - other income/expenses) it will be Pre Tax income = Operating Income + other income/expenses) instead right?

[simyua.]

Same way we can do for quarter as well by considering last date of quarters ?❤❤

[gopinathsindhe]

Hello, we are not able to see the formula for the January forecast even if we expand to full screen

[sivaprakash]

Please make a inventory management with invoice