A sound financial model is essential to understand the drivers and implications of business decisions. PwC's Academy three day Advanced Excel and Financial Modeling course covers the fundamental skills needed to utilise Excel to the best effect and then illustrates these skills in the context of developing best practice financial models.
In this three day course, delivered by subject matter experts with practical industry and training experience, participants will learn key tools of Excel useful for business analysis and practice how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
This course adopts a case study approach and minimising the level of classroom-style learning allowing participants to feel more empowered and comfortable in applying skills and techniques developed during the course in their day to day work.
The course is suitable for professionals working or aspiring to work in the field of investment banking, project consultancy, private equity, corporate finance, asset valuation and equity research. It is of particular benefit to corporate and project financiers, finance managers, accountants and bankers.
Improving efficiency by using Basic excel tools and shortcuts
Excel fundamentals refresher
Customising Excel
Useful tools in Excel for financial modelling such as:
- IF
- AND OR
- OFFSET
- Named ranges
- MAX
- MIN
- ABS
Basic structure of a model
Financial statements refresher
Model design and consideration of inputs
orecasting EBITDA
Integrity of financial model
Including checks and balances
Forecasting working capital
Forecasting capex and depreciation
Forecasting financing flows
Trouble shooting circularity problems
The camera function
Sensitivity analysis
Charting the results
Creating impressive output
There are no scheduled dates for this course. Fill out the form to check future dates or deliver the course in-house