Course Objective - BFI School

Course Objective - BFI School

Financial Modeling for Projects Course Objective

Financial Modeling for Projects

0% Completed

Introduction

Video - 00:2:34 mins

Course Objective

Video - 00:1:21 mins

Course Prerequisite

Video - 00:1:23 mins

What is a Financial Model

Video - 00:00:39 mins

Uses of Financial Model

Video - 00:00:30 mins

Understanding the Start Model

Review of Case Study

Video - 00:7:14 mins

Review of Start Model

Video - 00:3:48 mins

Review of Input Sheets

Video - 00:4:10 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:37 mins

Modeling Retained Cash & Retained Earnings

Video - 00:8:25 mins

Revenue & Operating Costs

Video - 00:13:27 mins

Video - 00:8:12 mins

Operating Revenue

Video - 00:6:37 mins

Video - 00:7:53 mins

Operating Cost Summary

Video - 00:3:12 mins

Financial Statement Modeling – Tax

Tax Expenses and Tax paid

Video - 00:8:16 mins

Tax Losses Carried Forward

Video - 00:6:53 mins

Video - 00:6:24 mins

Non-Current Assets & Working Capital

NCA Initial Balance

Video - 00:4:44 mins

Depreciation of NCA

Video - 00:7:56 mins

Capital Expenditure

Video - 00:6:08 mins

Depreciation of Capex

Video - 00:13:38 mins

Tax Depreciation

Video - 00:7:48 mins

Account Receivables

Video - 00:9:46 mins

Account Payables

Video - 00:4:49 mins

Financial Statement Modeling – Equity & Debt Finance

Video - 00:5:56 mins

Share Capital Redemption

Video - 00:4:13 mins

Video - 00:6:29 mins

Senior Debt Principal Repayment

Video - 00:7:46 mins

Senior Debt Interest Repayment

Video - 00:5:28 mins

Key Outputs / Analysis

Video - 00:17:08 mins

Payback Period - (Bonus Lesson)

Video - 7:17 mins

Video - 00:17:15 mins

Sensitivity & Scenarios

Video - 00:9:56 mins

Model Guide & Review

Video - 00:11:58 mins

Checks & Alerts

Video - 00:11:20 mins

Video - 00:11:03 mins

CAPSTONE PROJECT

AeroLtd - Financial Modeling

Building Model from Scratch & Time Flags (Bonus Module)

Model Structure and Time Ruler

Video - 00:15:22 mins

Video - 00:12:44 mins

Video - 00:9:52 mins

Replicating the Timeline to Other Sheet

Video - 00:4:49 mins

Announcements Reviews Live Classes Gradebook Certificate Course Info