FINANCIAL MODELING USING ADVANCE EXCEL
COURSE INTRODUCTION
This training course gives you knowledge of the most useful functions in Excel for financial modeling, a sound understanding of financial modelling and company valuation concepts, and experience in designing solutions to real-world financial modeling challenges. Who Should Attend?
Those who already have Excel financial modelling experience and are looking to consolidate their skills as well as learn some more advanced techniques. It is appropriate for those working in corporate finance, financial planning, financial markets, consulting, and also for general users of Excel for financial applications After completing this course, participants will be able to;
Discover how to use specific Excel functions that can increase your speed by 100%
Create financial models that are easy to maintain so you don't waste precious time tweaking complex models
Discover "hidden" tools in Excel that help you work smarter
Discover how to create effective models from the start so you save time spent on error-checking models
Strengthen your data analysis / decision making skills with spreadsheets
Best practices in building financial models in Excel
Practical Examples
Reusable Excel Templates
Much, much, more
Course Content
Introduction
The Modelling Process
Modelling Best Practices
Separation, Consistency, Integrity, Protection, Colour Coding, Modular technique
Defining Input /Assumptions
Macro-economics
Project Cost
Financing
Estimating the Explicit Forecast period
Revenue
Expenditure
Setting-up Scenarios
Setting-up the Reports
Profit and Loss Statements
Balance Sheet
Cash Flow
Summaries/KPIs
Charts
Forecasting - Detailed build-up of revenues and expenditure using the Modular technique
Revenues
CAPEX
OPEX
Depreciation
Loan Amortization and Interest
CAPM and WACC
Demonstrate inter-relationships between input, calculation modules and reports
Double Entry
Error checks
Financial Ratios and Key Performance Indicators
Liquidity Ratios
Activity Ratios
Coverage Ratios
Investment Appraisal/DCF Valuation
Free Cash Flows
Cost of Capital Fundamentals
DCF Valuation Model
IRR, NPV and Pay-back Analysis
Enterprise Valuation
Equity Valuation
Sensitivity Analysis/Tables
Data Tables
Scenario Analysis
Adding and using Form controls on worksheets
Simulations
Break-Even Analysis
Monte Carlo Simulation
Optimization and Targeting
Goal Seek and Solver