Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
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
Finance & Accounting Financial Modeling & Analysis Excel Modeling

Create a 3-Statement Budget Model in Excel

Learn how to build professional 3-statement budget models in Excel
Rating: 4.6 out of 54.6 (37 ratings)
157 students
Created by Dobromir Dikov
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

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

9 sections • 54 lectures • 5h 28m total length

  • Preview01:30
  • About this Course
    02:27
  • Enable the Developer Tab in Excel
    00:26
  • Download Resources
    00:29
  • Preview02:10
  • What is Budgeting?
    05:31
  • Excel Functions Refresher
    08:42
  • Excel Shortcuts
    04:07
  • Discuss Source Files
    04:34
  • Are you ready?
    5 questions

  • Let's get started
    02:01
  • Create the Sales Budget
    11:59
  • Preview06:42
  • 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

  • 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
  • Preview02:37
  • 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

  • Link the Cash Flow Statement
    12:08
  • Cash Flow Statement
    4 questions

  • Dynamic Validation Checks
    09:51
  • Bank Covenants Check
    09:18
  • Improving Our Model
    4 questions

  • Optimizations in Admin and Selling Expenses
    07:42
  • Assumptions and Dynamic Scenarios
    12:45
  • Optimizing Our Model
    3 questions

  • Create a Print-ready Summary Statement
    17:29
  • Group Model Sections
    02:04
  • Save Without Links
    01:34
  • Sharing Our Model
    4 questions

  • Congratulations!
    00:44

  • 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

Instructor

Dobromir Dikov
FCCA, FMVA
Dobromir Dikov
  • 4.2 Instructor Rating
  • 172 Reviews
  • 2,599 Students
  • 3 Courses

For the past ten years, I have been working in the fields of audit, management accounting, financial modeling, budgeting, and reporting. I am excited about delving deep into the specifics of various industries and identifying the best solutions for clients.

The best part about my career has been the opportunity to share my knowledge and pass it on to colleagues and friends. I love creating video tutorials, doing one-on-one coaching, and organizing training sessions for businesses.

In my spare time, I am into video compositing and writing. The time offline I prefer to spend hanging out with friends, hiking, skiing, or reading a nice fantasy book.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.