The objective of this program is to equip delegates with the knowledge and skills to forecast financial statements for a public or private company using Excel tools.
Learning objectives Learn and apply excel tools useful in financial forecasting Understand and design the layout of a flexible model Forecast financial statements of a public or private company Apply scenario analysis to the forecasted financial statements Prepare charts for data presentation Who should attend Financial accountants, finance controllers, corporate bankers Professionals and graduate students working or aspiring to work in the field of: Asset management Investment banking Sovereign wealth funds Private equity Corporate finance Portfolio management Equity research Day 1 Overview of Financial Modeling Excel tools used in financial modeling Basic Math Functions: SUM AVERAGE MAX MIN SUMIF COUNTIF LARGE SMALL and many more Logical Functions: Date functions: Absolute and Relative cell referencing Cell styles and quick access tool bars Introducing the case study company Model design and structure for the case study company Know the key model outputs and their drivers Understand the requisite inputs Developing cell styles for model transparency and review Incorporating historical financial statements of the subject company Building Balance Sheet error check in the model Day 2 Forecasting financial statements: Forecasting revenue Forecasting key operating expenses and margins Projecting key schedules: debt & interest capex & depreciation Working capital and more Stepwise projection of income statement, balance sheet and cash flows Incorporating scenario analysis Charting to present the forecasted data: Different chart types – Single axis and combo charts Using dynamic chart titles and data labels Case Study: Developing the model from scratch using an interactive case study
Currently there are no public classes/sessions scheduled for this course yet. For any in-house or private training, please contact us.
Your browser does not support JavaScript! Please enable it for maximum experience. Thank you.
