Corporate Financial Modelling Building Forecasts and Cash Flows Course

Course Overvew:

The training program on Corporate Financial Modelling: Building Forecasts and Cash Flows equips the participants with practical knowledge on how to design and operate financial models aimed at predicting and controlling cash flows.

Upon successful completion of this course, participants will be familiar with many techniques for forecasting, will implement ratio analysis of the ability of a company to generate cash flows, and will design the structures of cash flow forecasts in a way that repayment periods will be optimally scheduled.

They will also gain the ability to build flexible models for different scenarios, utilizing various Excel tools for data analysis and accurate forecasting. This course is well suited for those individuals working in the field of corporate finance and other distinct financial institutions and want to upgrade their forecasting and modelling skills.

Course Objectives:

At the end of this Corporate Financial Modelling Building Forecasts and Cash Flows Course will enable you to:

• Understand the different forecasting methods available to you in Excel and apply them to your own data
• Use ratio analysis to produce a forecast
• Use cash flows to assess the impact of company strategy on the ability of the company to generate cash flows going forward;
• Use the base case and downside cash flow forecasts to structure a company’s optimum repayment schedule given the anticipated challenges of its future operating environment;
• Use the cash flow forecasts and the financial modelling in the context of drafting the term sheet for the loan document;
• Generate expectations of future performance and provide forecasted statements and cash flows
• Create a flexible model which can be used to review different scenarios, where inputs can be quickly changed, and results quickly accessed

Who Should Attend?

This Corporate Financial Modelling Building Forecasts and Cash Flows Course is ideal for:

• Professionals incorporate financial institutions that need to create useful and robust financial models, Forecasts and Cash Flows.

Course Outlines:

Forecasting

• What are the forecasting basics?
• What causes forecasting errors?
• What types of charts should we use?
• How do we review forecasts?
• How can we appraise accuracy?
• How do we analyze data in Excel?

Forecasting methods

• How can we identify patterns?
• What is the simple percentage plus method?
• How do we use compound annual growth rate?
• How are trends useful?
• What is smoothing?
• How do we look at seasons?
• How do we use regression?
• What is the inflation problem?

Ratios

• What factors can affect cash flow?
• What are the core ratios?
• What are the profitability ratios?
• What ratios measure operating efficiency?
• What ratios can help with financial structure?
• Is growth sustainable?
• What are the market ratios?
• What error functions and units should be considered?
• What checks are required?

Forecast drivers

• What assumptions can we make?
• How do we generate the income statement?
• How are balance sheet assets generated?
• What about balance sheet liabilities?
• Why are the workings sheets important?
• How do we deal with divisions?

Accounting statements

• What is the structure of the balance sheet?
• How do we model the income statement?
• How do we model the balance sheet?
• What are the mechanics of cash flow?
• What are the cash flow ratios?
• Can we avoid common mistakes?
• How should we deal with iteration?
• What further checks are needed?

see more: Corporate Governance in Islamic Banking and Finance Course