Create a 3-Statement Budget Model in Excel
4.7 (18 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
64 students enrolled

Create a 3-Statement Budget Model in Excel

Learn how to build professional 3-statement budget models in Excel
4.7 (18 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
64 students enrolled
Created by Dobromir Dikov
Last updated 5/2020
English
English [Auto]
Current price: $83.99 Original price: $119.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 1 article
  • 60 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Know how to organize models in Excel
  • Be able to budget the business performance
  • Know how to model financial statements
  • Understand how the financial statements are linked together
  • Enhance your current Excel files
  • Format spreadsheets in a professional way
  • Know how to forecast sales and expenses
  • Understand the key assumptions that drive a budget
Requirements
  • Microsoft Excel 2010 or later
  • Comfortable with Basic Excel Functionality
  • Knоwledge on Fundamental Accounting Principles
Description

If you are currently working in an FP&A role, or anywhere between accounting and finance, there’s a high chance you’ll probably face the challenge of preparing a budget statement. It would be great if you are ready to tackle such a challenge with confidence and promptly.

And this is the course to prepare you for that!

You will start with an empty Excel spreadsheet and build a complete dynamic model for a 3-statement budget in Excel!

What you’ll get out of this course?

Create a 3-statement Budget Model in Excel course will guide you through the actual practical process of creating a budget model in Excel, step by step. We will define a clear structure and build a robust dynamic model, which you can reuse over and over again. I will help you understand the flow of information between different parts of a budget model. You will gain knowledge on how to forecast sales, production cost and other expenses. We will define a consistent framework of formatting our model, to make it easier to read and understand, even after time has passed.

I will show you some ways to tremendously improve the value of your budget by adding validation checks, dynamic scenarios, and sensitivity analysis. We will take it to the end and prepare a summary sheet that is ready to print and share with stakeholders.

For this course, I anonymized a real set of company data so that you will see a real-life example.

After you take the Create a 3-statement Budget Model in Excel course, you will have the confidence to prepare your complex models and bring value to any budget you have to work on.

What should you know to take the course?

This course is aimed at an intermediate level of students. We will go over the main shortcuts and formulas that we use in the model, and you will have to become familiar with those, to be able to follow along. I expect you to have solid fundamental knowledge on Excel, be able to use formulas, link to cells in other sheets, know how the standard formatting tools and the ribbons work. If you are entirely new to Excel, this course will be hard to take. Please, take a look at some of the excellent introductory courses here on Udemy, and come back after you’ve mastered the fundamentals of Excel.

To fully understand the model, you will need some basic accounting knowledge. I explain everything whenever we go into specifics. Still, I expect you to be familiar with an Income Statement, Balance Sheet, and Cash Flow Statement, have a general idea of how these are linked together. I would also expect you to understand words like Depreciation and Amortization, Interest, Cash Flows, and other similar terms.

It would still be possible to follow along and learn a lot from the course, even without basic accounting knowledge, but I would suggest you get yourself familiar with that first, and then take the Create a 3-statement Budget Model in Excel course.

Who is this course for?

I made the Create a 3-statement Budget Model in Excel course to serve as a practical guide on how to build high-quality budgets in real companies. The course is most suitable for:

  • Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process;

  • Business owners and entrepreneurs who want to understand how budgeting works in practice;

  • Managers in start-ups where no finance professionals are available;

  • Students in Finance and Economics majors who wish to get a head start.

I hope you are ready to upgrade yourself, learn how to build a 3-statement budget model in Excel, and propel in your career!

Are you excited to start?

Then enroll in the course, and I’ll see you in class!

Who this course is for:
  • Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process
  • Business owners and entrepreneurs who want to understand how budgeting works in practice
  • Managers in start-ups where no finance professionals are available
  • Students in Finance and Economics majors
Course content
Expand all 54 lectures 05:28:31
+ Getting Ready
9 lectures 29:56
About this Course
02:27
Enable the Developer Tab in Excel
00:26
Download Resources
00:29
What is Budgeting?
05:31
Excel Functions Refresher
08:42
Excel Shortcuts
04:07
Discuss Source Files
04:34

Test your knowledge before diving deep into excel modeling.

Are you ready?
5 questions
+ Income Statement
18 lectures 01:41:36
Let's get started
02:01
Create the Sales Budget
11:59
Forecasting Performance Part 2
08:33
Starting the Income Statement
04:09
Direct Material Costs
04:49
Production Staff Cost
10:49
Production Overheads
07:09
Quiz 2 - Shaping the Income Statement
3 questions
Issues with linked files
01:00
Mapping the Expenses Budget
02:44
Administrative Expenses
04:54
Selling Expenses
04:17
Expense on Spare Parts
04:23
Depreciation Expense and PPE Schedule
06:37
Amortization Expense and Intangibles Schedule
02:45
Interest Expense and Investment Loan Schedule
09:08
Interest Expense and Working Capital Loan
07:03
Other Expenses
02:34
Finishing the Income Statement
3 questions
+ Balance Sheet
13 lectures 55:20
Starting the Balance Sheet
02:24
PPE, Intangibles and Deferred Tax Assets
01:31
Cash Conversion Cycle Historical Review
05:38
Working Capital - Annualized Sales and Cost of Goods Sold
07:06
Working Capital - Inventory
05:57
Working Capital - Payables
01:49
Working Capital and Cash Conversion Cycle
3 questions
Intercompany Receivables
06:07
Other Receivables
06:48
Investment and Working Capital Loans
01:04
Other Payables
05:18
Retained Earnings & Pre-tax Profit
06:45
Share Capital and Reserves
02:16
Finishing the Balance Sheet
3 questions
+ Cash Flow Statement
1 lecture 12:08
Link the Cash Flow Statement
12:08
Cash Flow Statement
4 questions
+ Improving Our Model
2 lectures 19:09
Dynamic Validation Checks
09:51
Bank Covenants Check
09:18
Improving Our Model
4 questions
+ Optimizing Our Model
2 lectures 20:27
Optimizations in Admin and Selling Expenses
07:42
Assumptions and Dynamic Scenarios
12:45
Optimizing Our Model
3 questions
+ Sharing Our Model
3 lectures 21:07
Create a Print-ready Summary Statement
17:29
Group Model Sections
02:04
Save Without Links
01:34
Sharing Our Model
4 questions
+ Conclusion
1 lecture 00:44
Congratulations!
00:44
+ Additional Lectures and Learning Materials
5 lectures 01:08:04
Running a Monte Carlo Simulation in Excel
18:43
Mapping a Trial Balance to Create Financial Statements
12:36
Sensitivity Analysis in Excel Models
07:02
Pareto Analysis in Excel (80/20 Rule)
08:06
Create a Dynamic Sales Dashboard to Visualize Data
21:37