FULLY SOLVED BOOK LASY 5 YEARS PAPERS SOLVED PLUS GUESS

Financial Modelling

1. Excel as a tool in Financial Modelling
Excel concepts - Basic commands; Functions - math’s, logical, look up, date, text and financial; Chart, diagram, picture, background, auto format, conditional formatting, style, filter, sort; Formulas and macros; What if analysis, pivot table, pivot chart, scenario, goal seek, problem solver tool, advanced filter. (11 Hours)
2. Financial Modelling Basic Concepts
Introduction, Advanced functions of MS-Excel as a tool in financial modelling; Components of a financial model, building the template, filling in the historical data, identifying assumptions and drivers, forecasting various schedules and financial statement, building the supporting schedules, various approaches to valuation, key ratios, financial ratios and company analysis, building cases and sensitivity analysis - looking at the probabilistic analysis of the best and worst case scenario.
(10 Hours)
3. Cash Ratios and Non Cash Valuations
Cash Ratio - Structured model with a menu & accounting statements, Calculating key financial ratios, Deriving an international cash flow; Non Cash Flow Valuations - Accounting methods, Dividend discount models, Market-based methods – EPS and multiples, Fundamentals of EV/
EBITDA, EV/Sales, Peer groups. (10 Hours)
4. Forecasting Methods and Initial Valuations
Review of forecasting methods, relationship between company and financial strategy, identifying and forecasting key drivers, linkages and modelling problems, deriving free cash flow; Cost of capital and initial valuation - alternative theories – bonds and arbitrage pricing theory, capital asset pricing model constituents, asset and equity betas, mathematical derivation, methods of adding terminal value, producing an equity valuation, comparison to existing share price