FP&A: Building a Company's Budget
bestseller

Name: FP&A Course: Building a Company's Budget
Price: 36 USD

with Antoniya Baltova

4.9/5

(882)

Master Financial Planning and Analysis: Prepare a company’s budget from scratch

4 hours of content 8074 students

Start for Free

What you get:

4 hours of content
34 Interactive exercises
27 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

FP&A: Building a Company's Budget
bestseller

A course by Antoniya Baltova

Start for Free

What you get:

4 hours of content
34 Interactive exercises
27 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

$99.00

Lifetime access

Buy now

Start for Free

What you get:

4 hours of content
34 Interactive exercises
27 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

What You Learn

Gain practical experience in budgeting, forecasting, and measuring financial performance to enhance your technical skills in financial analysis
Build a detailed and professional budget model in Excel
Learn how to model revenue and make various expense predictions (payroll, SG&A, production costs, overhead)
Forecast current and non-current assets and liabilities and seamlessly integrate these items in your budgeting model
Build an integrated 3-statement model in Excel that puts together all financial forecasts
Improve your financial modeling skills by working on real-world examples

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

Financial Planning and Analysis (FP&A) teams play a crucial role in business operations. FP&A analysts help with financial planning, budgeting, and forecasting. They analyze historical financial data and prepare projections under various scenarios to facilitate data-driven decision-making. The Financial Planning and Analysis (FP&A) function is distinct from accounting as it is increasingly forward-looking. It focuses on the drivers of financial results and on what and why is likely to happen in the future. This FP&A course will guide you through the core principles of financial planning and analysis and help you understand the complete budget preparation process. We touch on several topics, including basic accounting transactions, core financial statements, revenue and expense forecasting, working capital planning and estimation, fixed assets roll forward, cash flow calculation, and more. We discuss why firms need to prepare Annual Business Plans (ABP), the difference between budgeting and forecasting, the main techniques used in financial planning, and who is involved in the preparation and sign-off of the ABP. These are crucial skills that help FP&A professionals identify cost-saving, revenue generation, and investment opportunities in the companies and industries they work for. We complete the FP&A course with a practical example of preparing a complete budget model from scratch in Excel. Enhance your finance career by joining the thousands of professionals who have already completed this course. Sign up now to master the art of financial planning and analysis!

Learn for Free

1.1 What Does the Course Cover

3 min

1.2 What is a Budget and Why do we Need it?

6 min

2.1 Major Financial Statements

4 min

2.2 Understanding the Income Statement

8 min

2.4 Understanding the Balance Sheet

7 min

2.5 Understanding the Cash Flow Statement_Part 1

5 min

Curriculum

1. Getting Started with Financial Planning & Analysis

2 Lessons 9 Min

In the introductory lesson of this FP&A course, we present the basic budgeting principles. You will learn why companies need a budget and how to build a personal budget using a standard template.

What Does the Course Cover
3 min
What is a Budget and Why do we Need it?
6 min
2. The Accounting Framework

7 Lessons 42 Min

This section provides the foundational accounting knowledge and skills required to earn a financial planning and analysis certification. We examine the core financial statements that companies prepare—the Income Statement, Balance Sheet, and Cash Flow Statement. Exploring how these interrelate will help us use them in a complete budgeting model later on.

Major Financial Statements
4 min
Understanding the Income Statement
8 min
Understanding the Balance Sheet
7 min
Understanding the Cash Flow Statement_Part 1
5 min
Understanding the Cash Flow Statement_Part 2
7 min
Direct vs. Indirect Cash Flow Statement
6 min
Major Interrelationships between the Financial Statements
5 min
3. Mechanics of The Budgeting Process

9 Lessons 40 Min

In the last theoretical section of this FP&A course, we discuss the importance and mechanics of the budgeting process, the key budget preparation steps, and the difference between short-term and long-term planning. You will also learn the difference between budgeting and forecasting, who is responsible for preparing and updating the budget, and the meaning of a Master Budget.

The Importance of Budgeting
5 min
Key Steps in the Budget Preparation
4 min
The Budget Horizon
7 min
The Budgeting Levels of Detail
3 min
Budgeting Approaches
4 min
Updating the Budget
3 min
Who Prepares the Budget?
5 min
The Master Budget
6 min
The Budget Sign-off
3 min
4. Time for a Case Study: Henry's Hats

15 Lessons 84 Min

In this section, you will have the chance to apply everything you have learned in this FP&A training. Together, we will build a complete budget model in Excel using the historical financial information of a fictitious company called Henry’s Hats. You will learn how to forecast revenue, COGS, various types of expenses, fixed assets, long-term liabilities, and others.

Henry's Hats - Company Overview
5 min
The Bottom-up Approach
8 min
The Top-Down Approach
6 min
Understanding COGS Calculation
3 min
Volume of Production
6 min
Direct Materials and Direct Labor
5 min
Production Overheads
5 min
The COGS Budget
2 min
The Payroll Budget
9 min
The SG&A Budget
5 min
Balance Sheet Items
6 min
The Cash Conversion Cycle
6 min
The Working Capital Budget
6 min
The Fixed Assets Budget
7 min
Loan Repayment Schedule
5 min
5. Putting It All Together

5 Lessons 31 Min

In the final section of the FP&A course, you will prepare Henry’s Hats' budgeted financial statements and learn how companies typically present their budget models. Last but not least, you will prepare a budget model on your own as part of the Course Challenge we created for you!

The Income Statement Budget
6 min
The Balance Sheet Budget
7 min
The Cash Flow Budget
13 min
Presenting the Budget
4 min
Course Challenge
1 min

Topics

Financial AnalysisBudgetingFinancial ModelingForecastingExcelFP&AFinancial AnalysisExcelFinancial Modeling

Tools & Technologies

Course Requirements

Highly recommended to take the Intro to Excel and Accounting and Financial Statement Analysis courses first
You will need Microsoft Excel 2016, 2020, or Microsoft Excel 365

Who Should Take This Course?

Level of difficulty: Beginner

Aspiring financial analysts, FP&A analysts, financial controllers
Existing financial analysts, FP&A analysts, financial controllers who want to improve their financial modeling and forecasting skills
Everyone who wants to work in Corporate Finance

Exams and Certification

A 365 Financial Analyst Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Meet Your Instructor

Antoniya Baltova

Chief Financial Officer at 365

8 Courses

2909 Reviews

30519 Students

Antoniya is a finance professional with vast experience in accounting, auditing, financial management, and multiple high-level finance roles. She holds two master’s degrees—in Finance and in Contemporary Educational Technologies. She has worked as an auditor at PwC, as a financial controller at Atos, as an FP&A Manager and Senior Manager at Coca-Cola, and currently, as a Finance Manager at 365. Her passion for finance and teaching brought her to the 365 Тeam. She has been tutoring on various topics, including accounting, financial reporting, financial planning and analysis, economics, etc. Antoniya’s qualifications and engaging teaching style make the learning process enjoyable, and her courses have helped numerous students progress in their careers.