Course Prerequisites - BFI School

Course Prerequisites - BFI School

Financial Modeling for Business (FP&A) Course Prerequisites

Financial Modeling for Business (FP&A)

0% Completed

Introduction

Video - 00:2:05 mins

Course Objectives

Video - 00:1:10 mins

Course Prerequisites

Video - 00:1:08 mins

What is a Financial Model

Video - 00:00:34 mins

Uses of Financial Models

Video - 00:1:05 mins

Understanding the Start Model

Review of Case Study

Video - 00:6:07 mins

Review of Start Model

Video - 00:2:21 mins

Review of Input Sheets

Video - 00:4:06 mins

Setting up Macros (Bonus Module)

Formatting & Productivity Macros

Video - 00:7:33 mins

Setting Up Macros

Video - 00:4:42 mins

How to link the Financial Statement

Overview of Equity

Video - 00:5:15 mins

Modeling Retained Cash and Retained Earnings

Video - 00:8:36 mins

FS Modeling – Revenue and Operating costs

Video - 00:20:33 mins

Video - 00:4:52 mins

Revenue - Price

Video - 00:6:14 mins

Operating Revenue Summary

Video - 00:13:38 mins

Raw Material Unit Cost

Video - 00:3:12 mins

Raw Materials Volume

Video - 00:9:14 mins

Raw Material Cost Summary

Video - 00:4:25 mins

Video - 00:7:38 mins

Packaging Cost Summary

Video - 00:5:25 mins

Video - 00:5:42 mins

Direct Production Cost Summary

Video - 00:2:14 mins

Video - 00:9:17 mins

Video - 00:10:06 mins

Operating Cost Summary

Video - 00:3:11 mins

FS Modeling – Tax

Tax Paid and Tax Expense

Video - 00:8:01 mins

Deferred Tax Balance

Video - 00:7:25 mins

FS Modeling – Non-Current Assets and Working Capital

NCA Initial Balance

Video - 00:3:19 mins

Depreciation of NCA

Video - 00:4:15 mins

Capital Expenditure (CAPEX)

Video - 00:4:31 mins

Depreciation of Capex

Video - 00:14:06 mins

Tax Depreciation

Video - 00:5:57 mins

Accounts Receivables

Video - 00:12:10 mins

Account Payables

Video - 00:6:17 mins

Video - 00:3:26 mins

Work-in-progress

Video - 00:3:42 mins

Net Movement in Working Capital

Video - 00:9:06 mins

Net Movement in Working Capital MTD2

Video - 00:5:32 mins

FS Modeling – Equity and Debt Finance

Video - 00:4:13 mins

Video - 00:2:32 mins

Video - 00:5:21 mins

Unsecured Loan Principal Repayment

Video - 00:4:35 mins

Unsecured Loan Interest

Video - 00:8:04 mins

Corporate Bond Interest

Video - 00:10:26 mins

Key Outputs / Analysis

Video - 00:15:43 mins

Sensitivity and Scenarios

Video - 00:11:20 mins

Quality Control and Model Finalization

Check and Alerts

Video - 00:10:36 mins

Video - 00:9:29 mins

Building Model from Scratch & Time Flags (Bonus Module)

Model Structure and Time Ruler

Video - 00:15:22 mins

Video - 00:00:00 mins

Video - 00:00:00 mins

Replicating the Timeline to Other Sheet

Video - 00:00:00 mins

CAPSTONE PROJECT

GoodCare Hospital - Financial Modeling

Announcements Reviews Live Classes Gradebook Certificate Course Info