Financial Modeling for Business (FP&A)

0 (0 Ratings)

Enrolled:270

Level

Beginner
Duration

8 hours 9 minutes
Last Updated

May 1, 2024
Enrollment validity

Enrollment validity: 365 days
Certificate

Certificate of completion

About Course

Welcome to the comprehensive course on Financial Modeling for Business (FP&A). This dynamic program provides a deep dive into the world of financial modeling, equipping you with the essential skills to construct and analyze intricate financial models used in various business contexts. Through a structured curriculum, you will develop an in-depth understanding of the foundational components of financial modeling, beginning with an exploration of the Start Model and its pivotal role. You'll learn how to seamlessly link financial statements, delve into the nuances of Tax modeling, grasp the complexities of Non-Current Assets and Working Capital, and master Equity and Debt Finance modeling. As the course progresses, you'll uncover the key outputs and analytical insights derived from these models, while also honing your abilities in Quality Control and Model Finalization techniques. Culminating in a hands-on Capstone Project, you will synthesize your acquired knowledge to construct a comprehensive financial model, solidifying your expertise in effective financial decision-making and strategic planning for businesses.

Fundamental concepts of financial modeling and its significance in business decision-making.
Link and integrate various financial statements for a holistic view of a company's financial health.
Tax modeling techniques
Non-Current Assets, Working Capital modeling, depreciation, amortization, inventory management, and cash flow projections.
Equity and Debt Finance modeling, understanding capital structure, dividend policies, and debt repayment schedules.
Key financial model outputs and analyses, such as financial ratios, valuation metrics, and performance indicators.
Quality Control in financial models, including error-checking, sensitivity analysis, and scenario planning.
Model Finalization, refining, and presenting models professionally to support strategic decision-making.
Creating a comprehensive financial model that reflects real-world business scenarios.

Course Curriculum

Introduction

Course Outline

02:05
Course Objectives

01:10
Course Prerequisites

01:08
What is a Financial Model

00:34
Uses of Financial Models

01:05

Understanding the Start Model
Locate the accompanying files for the lessons within this module beneath the respective course video.

Setting up Macros (Bonus Module)

How to link the Financial Statement
Locate the accompanying files for the lessons within this module beneath the respective course video.

FS Modeling – Revenue and Operating costs
Locate the accompanying files for the lessons within this module beneath the respective course video.

Escalation

20:33
Revenue Volume

04:52
Revenue – Price

06:14
Operating Revenue Summary

13:38
Raw Material Unit Cost

03:12
Raw Materials Volume

09:14
Raw Material Cost Summary

04:25
Packaging Cost

07:38
Packaging Cost Summary

05:25
Labour Cost

05:42
Direct Production Cost Summary

02:14
Staff Cost

09:17
Overhead Cost

10:06
Operating Cost Summary

03:11

FS Modeling – Tax
Locate the accompanying files for the lessons within this module beneath the respective course video.

FS Modeling – Non-Current Assets and Working Capital
Locate the accompanying files for the lessons within this module beneath the respective course video.

NCA Initial Balance

03:19
Depreciation of NCA

04:15
Capital Expenditure (CAPEX)

04:31
Depreciation of Capex

14:06
Tax Depreciation

05:57
Accounts Receivables

12:10
Account Payables

06:17
Inventory

03:26
Work-in-progress

03:42
Net Movement in Working Capital

09:06
Net Movement in Working Capital MTD2

05:32

FS Modeling – Equity and Debt Finance
Locate the accompanying files for the lessons within this module beneath the respective course video.

Key Outputs / Analysis
Locate the accompanying files for the lessons within this module beneath the respective course video.

Quality Control and Model Finalization
Locate the accompanying files for the lessons within this module beneath the respective course video.

Building Model from Scratch & Time Flags (Bonus Module)

CAPSTONE PROJECT

Student Ratings & Reviews

No Review Yet

Financial Modeling for Business (FP&A)

About Course

What will I learn?

Course Curriculum

Introduction

Course Outline

Course Objectives

Course Prerequisites

What is a Financial Model

Uses of Financial Models

Understanding the Start Model Locate the accompanying files for the lessons within this module beneath the respective course video.

Review of Case Study

Review of Start Model

Review of Input Sheets

Setting up Macros (Bonus Module)

Formatting & Productivity Macros

Setting Up Macros

How to link the Financial Statement Locate the accompanying files for the lessons within this module beneath the respective course video.

Overview of Equity

Modeling Retained Cash and Retained Earnings

FS Modeling – Revenue and Operating costs Locate the accompanying files for the lessons within this module beneath the respective course video.

Escalation

Revenue Volume

Revenue – Price

Operating Revenue Summary

Raw Material Unit Cost

Raw Materials Volume

Raw Material Cost Summary

Packaging Cost

Packaging Cost Summary

Labour Cost

Direct Production Cost Summary

Staff Cost

Overhead Cost

Operating Cost Summary

FS Modeling – Tax Locate the accompanying files for the lessons within this module beneath the respective course video.

Tax Paid and Tax Expense

Deferred Tax Balance

FS Modeling – Non-Current Assets and Working Capital Locate the accompanying files for the lessons within this module beneath the respective course video.

NCA Initial Balance

Depreciation of NCA

Capital Expenditure (CAPEX)

Depreciation of Capex

Tax Depreciation

Accounts Receivables

Account Payables

Inventory

Work-in-progress

Net Movement in Working Capital

Net Movement in Working Capital MTD2

FS Modeling – Equity and Debt Finance Locate the accompanying files for the lessons within this module beneath the respective course video.

Share Capital

Share Premium

Dividend

Unsecured Loan Principal Repayment

Unsecured Loan Interest

Corporate Bond Interest

Key Outputs / Analysis Locate the accompanying files for the lessons within this module beneath the respective course video.

Ratios

Sensitivity and Scenarios

Quality Control and Model Finalization Locate the accompanying files for the lessons within this module beneath the respective course video.

Check and Alerts

Modeling Guide

Building Model from Scratch & Time Flags (Bonus Module)

Model Structure and Time Ruler

Time Flags

Timeline Label

Replicating the Timeline to Other Sheet