Financial Modelling

7city Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Reviewing relevant financial, maths and spreadsheet concepts
Excels tools, techniques and tricks
Getting to grips with financial concepts
Essential financial maths

Getting off to a solid start
Identifying user needs, current and future
Designing models structures, features and facilities
Model construction, testing and proving
Enhancements that ensure ease of use, ease of maintenance, etc
Tools of documenting models

Building Models for Forecasting Financial Statements
Identifying key drivers and other input variables
Analysing historic data to forecast sales, cost of sales, etc
Building formulas to calculate P&L and balance sheet items
Modelling depreciation, interest, tax and other calculations
Balancing ("plug") numbers, circular references, range items and other issues
Tools of sensitivity analysis: scenarios, data tables, Monte Carlo simulations, etc.
Designing attractive reports and charts

Essential Excel Functions and Tools
General format and use
Financial functions
Lookup and logical functions
Statistical and array functions

Modelling for Project Evaluation
Modelling cost of capital calculations
Modelling sales/costs/cash flows
Determining returns, etc.
Using tools of sensitivity analysis

Modelling for Leasing Applications
Nature of leases and types
Understanding accounting rules and tax treatment
Modelling the lease versus buy decision
...''

Phone:+44(0)20 7496 8600

School Address:

4 Chiswell Street
London
EC1Y 4UP
UK

Jobs & Resumes: London
Houses & Roommates: London

Global Capital Markets
Peak Performance for Traders
MiFID for Compliance and Senior Management
Contemporary Equity Analysis
Equity Markets
Energy Futures Workshop
Exotic Equity Derivatives, Pricing and Hedging
Credit Derivatives
Equity Derivatives
Swaps
Mathematics for Quantitative Finance
Hedge Funds
Investment Management
Wealth Management
Private Client Tax
Real Estate Finance
Real Estate Investment
Real Estate Securities
Treasury Products

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.