Financial Modelling Masterclass
- What you will learn:
- How to Structure financial models to tell a complete story of 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 an 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.
0 Comments