Certificate in Financial Modelling
In stock
Introduction
The course will incorporate different approaches to modelling structured financing, where the volatility of the cash flow (as opposed to its value) is the key to determine the serviceability of a stressed financing structure. The programs aims to teach delegates the complexities of handling multiple tranches of finance with flexible input variables and the associated interest calculations.
Key business benefits
- Building a cash flow and financial statement forecast model for companies, ensuring that all the drivers are appropriate, that the modeling logic and the accounting treatments are sound, and that modeling best practice is applied;
- Understand how the key input drivers are modeled to both revenues and costs including multiple currencies, inflation and oil price movements;
- Compare different approaches to modeling structured financings, where the volatility of the cash flow (as opposed to its value) is the key to determine serviceability of a stressed financing structure;
- Gain insights about the design and implementation of scenarios, as well as the sensitivity and break-even analysis;
- Practice handling multiple tranches of finance with flexible input variables and the associated interest calculations.
Skills Acquired
- Develop practical solutions to your business problems through superior spreadsheet design;
- Consolidate worksheets from different sources into one workbook;
- Develop efficient techniques for using charts and maps;
- Use spreadsheet skills for advanced financial applications;
- Analyze data accurately using pivot tables.
Learning objectives
- Know the different types of financial models and when each should be applied;
- Be able to design financial models;
- Be able to develop models for their own use, incorporating elements such as risk, sensitivity, optimisation and forecasting;
- Discover hidden short cuts to dramatically reduce the time you spend on spreadsheets;
- Learn how to format quickly and accurately;
- Develop practical solutions to your business problems through superior spreadsheet design;
- Building a cash flow and financial statement forecast model for companies, ensuring that all the drivers are appropriate, that the modeling logic and the accounting treatments are sound, and that modeling best practice is applied;
- Understand how the key input drivers are modeled to both revenues and costs including multiple currencies, inflation and oil price movements;
- Compare different approaches to modeling structured financings, where the volatility of the cash flow (as opposed to its value) is the key to determine serviceability of a stressed financing structure;
- Gain insights about the design and implementation of scenarios, as well as the sensitivity and break-even analysis;
- Practice handling multiple tranches of finance with flexible input variables and the associated interest calculations.
Online Purchasing Instructions
Choose a product and add it to the cart
Add more products or proceed to checkout
Fill in all the information and finalize the order
Check your email for confirmation and details