Monthly Budgeting & Forecasting Model [Template Included]

In this lesson, we build a corporate monthly budgeting & forecasting template in Excel, creating internal department-level budgets that we integrate into the income statement, with a downloadable template included.

RESOURCES & LINKS:
____________________________________________
► Monthly Budgeting Template Download: https://bit.ly/mthlybdgt_mlchmp

► Apply for non-dilutive financing with Clearco & save $500 using my link: http://investor.clear.co/l/1ERICANDREW33/

My Communities:
► Join my Discord: https://discord.gg/gHghhVcW3S
► Subscribe to my email newsletter: http://bit.ly/joinericnewsletter

My Courses:
► Become an Excel Power User in 2.5 Hours (85% discount): http://bit.ly/excelpwrusr5-21
► Master Excel Keyboard Shortcuts (85% discount): http://bit.ly/shortcuts5-21

Related Financial Modeling Videos:
► Build a 3 Statement Financial Model: https://youtu.be/xlXDZyZ9azk
► Finance Interview Prep Series | Crush Your Interview: http://bit.ly/fin_intervw_prep
► How to Evaluate Marketing Performance: https://youtu.be/zMlwttUGr8M
► Financial Model for Selling on Amazon: https://youtu.be/hpA99kDb73g
____________________________________________

In this video we first build a monthly budgeting Excel template that we can send out to department heads at the company (for them to build budgets). Then we receive the budgets and integrate them back into our financial model. Finally we build out the full income statement model to see our monthly financial plan for the full year.

Also included is a link (in "resources & links" section) where you can download the monthly budgeting template for free.

When working in a small company, it's very important to have a straightforward budgeting process so that your department leaders can submit to you their financial plans (assuming you are on the finance team).

For that reason, you need to have a well constructed model that can pull in and integrate their internal budgets straight into your P&L.

One other important part is that you should also always first build the revenue model & COGS so that you have a good idea of what your gross profit will be. Keeping that number in mind, you will have an easier time giving guidance to the company on how much money they have for their budgets.

Sections:
0:26 Create internal budget template for departments
1:49 Create drop down lists using data validation
5:16 Integrating budget data back into the forecasting model
9:40 Building the full budgeting & forecasting income model
11:56 Building customer acquisition & revenue assumptions off the advertising spend
15:39 Building assumptions for cost of goods sold
16:45 Writing the formulas for the monthly forecasting model
21:15 Formatting financial models

I hope that you can now feel confident building a corporate budgeting model in Excel. If you have questions (I'm sure you do) - please leave comments below and I'll try to help. Cheers!

#financialmodel #budget #forecasting #startups

Видео Monthly Budgeting & Forecasting Model [Template Included] канала Eric Andrews