Financial Modelling
Price:
Rs125
Financial Modelling SOLVED PAPERS AND GUESS
Product Details: PUNE UNIVERSITY Financial Modelling
Format: BOOK
Pub. Date: NEW EDITION APPLICABLE FOR Current EXAM
Publisher: MEHTA SOLUTIONS
Edition Description: 2019-20
RATING OF BOOK: EXCELLENT
ABOUT THE BOOK
FROM THE PUBLISHER
If you find yourself getting fed up and frustrated with other INDRAPRASTHA UNIVERSITY book solutions now mehta solutions brings top solutions for INDRAPRASTHA UNIVERSITY Financial Modelling REPORT book contains previous year solved papers plus faculty important questions and answers specially for INDRAPRASTHA UNIVERSITY .questions and answers are specially design specially for INDRAPRASTHA UNIVERSITY students .
Please note: All products sold on mbabooksindia.com are brand new and 100% genuine
- Case studies solved
- New addition fully solved
- last 5 years solved papers with current year plus guess
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
1. Books by courier
2. Delivery in 5-7 days
3. Courier india only
4. Rating of product : largest selling