Financial Modelling Masterclass

Build and analyze a financial model, understand your business and raise debt from investment and commercial banks

What you'll learn
How to Structure financial models to tell a complete story of a business from input cost to net profit or retained cash
Demonstrate knowledge of, and analyze the main drivers of costs and profitability for a company
Construct a process flow diagram from input, to production, to sale, and analyze each step of the process flow in terms of its impact on profitability
How to construct a summary sheet, which illustrates all the key information and features of a business
Perform stress testing and downside analysis on models via goal seek and data tables
Construct waterfall diagrams assessing the impact of various factors on the profitability of a company
Basic to intermediate Excel techniques for data clean up, financial calculations and data summary
Construct key graphs which display multiple pieces of information clearly and coherently
Understand the difference between analysing accounting statements vs a cashflow model from a banker’s perspective
Drilling deep into a business' cost and revenue structure to uncover bottlenecks or weak spots

Requirements
Have a basic functional knowledge of Microsoft Excel, and be comfortable with working with basic formulas

Description
Congratulations on registering for the mini-course: Financial Modelling Masterclass. This course is a brief overview of how to construct and analyze financial models, and is particularly suited for any business wishing to raise debt funding. I'm confident that you will find the course content engaging, informative and practical.
The course is broken down into twelve chapters, each covering a different aspect of financial modelling. The chapters are best studied sequentially from chapter 1 to chapter 12.
Students would need to download the Financial Model in order to participate in the course. It is recommended that students practice each of the new concepts introduced before moving on to each subsequent chapter. This will help to reinforce learning in an ordered stepwise manner.

Who this course is for:
Beginner to intermediate level professionals looking to understand the principles behind structuring finance solutions for raising debt finance