Best Practice Financial Modelling (in-person)
- Durée totale
- Localisation
- A cet endroit
- Date et lieu de début
Best Practice Financial Modelling (in-person)
Note du fournisseur:
starstarstarstarstar
Diederik de Jonge Best Practice Financial Modelling (in-person)
"De basis van financieel modelleren wordt zeer goed uitgelegd in deze cursus. De docent is zeer ervaren en legt helder en enthousiast uit. Voor beginners in finance en/of excel is deze cursus zeer geschikt alswel voor een gevorderde financiële analist die "FAST" wilt gaan werken. " - 13/11/2020 07:15
"De basis van financieel modelleren wordt zeer goed uitgelegd in deze cursus. De docent is zeer ervaren en legt helder en enthousiast uit. Vo… lire plus - 13/11/2020 07:15
Dates et lieux de début
placeLondon 12 fév. 2026 jusqu'au 13 fév. 2026voir détails event 12 février 2026, 09:15-05:30, London, Day 1 event 13 février 2026, 09:30-05:30, London, Day 2 |
Description
Best practice financial modeling taught using the FAST Standard
This course teaches the core financial model design and construction techniques that every professional should know. It is designed for those working with financial models in the corporate, business modelling, banking, treasury, financial advisory, government and infrastructure sectors.
In-person participants will receive post-course access to the online version of the course. Online access and post-course support is ongoing.
Course Agenda:
Revenue
- price
- demand / volume drivers
- flags / placeholder flags
Operating costs
- fixed costs
- variable costs
Inflation
- real growth vs inflation / indexation / escalation
- data…
Foire aux questions (FAQ)
Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.
Best practice financial modeling taught using the FAST Standard
This course teaches the core financial model design and construction techniques that every professional should know. It is designed for those working with financial models in the corporate, business modelling, banking, treasury, financial advisory, government and infrastructure sectors.
In-person participants will receive post-course access to the online version of the course. Online access and post-course support is ongoing.
Course Agenda:
Revenue
- price
- demand / volume drivers
- flags / placeholder flags
Operating costs
- fixed costs
- variable costs
Inflation
- real growth vs inflation / indexation / escalation
- data pick-up functions: VLOOKUP, INDEX / MATCH, LOOKUP /
SUMIF
Building the primary financial statements
- tracking retained cash and retained earnings
Non-current assets
- balances: initial, BEG and END
- corkscrews
- accounting depreciation
Working capital
- accounts receivable
- accounts payable
Equity finance
- share capital
- dividends
Debt finance
- simple scenario selection: nested IF vs CHOOSE vs OFFSET vs
INDEX
- debt principal repayment
- debt interest
Key outputs / analysis
- sensitivities and scenario managers
- equity valuation: NPV vs XPNV
- equity returns: IRR vs XIRR
Quality control
- track sheets
- checks and alerts
starstarstarstarstar
Diederik de Jonge Best Practice Financial Modelling (in-person)
"De basis van financieel modelleren wordt zeer goed uitgelegd in deze cursus. De docent is zeer ervaren en legt helder en enthousiast uit. Voor beginners in finance en/of excel is deze cursus zeer geschikt alswel voor een gevorderde financiële analist die "FAST" wilt gaan werken. " - 13/11/2020 07:15
"De basis van financieel modelleren wordt zeer goed uitgelegd in deze cursus. De docent is zeer ervaren en legt helder en enthousiast uit. Vo… lire plus - 13/11/2020 07:15
Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.