Latin America and Caribbean swarna
11-29-15 0 Hits

Financial Modeling (FM)
Course Details:
Financial Statement Analysis & Equity Valuations:
• Foundations of Financial Modeling
• Need for Financial Models
• What is Financial Modeling
• Best Practices of EXCEL
• Understanding of Key Financial Statements (Balance Sheet & Income Statement)
• Streamlining of the Financial Statements data gathered from Third Party Sources
• Additional information from Annual Reports
Cash Flow Statements Financial Modeling
Preparation of cash flow statement from Balance sheet & Income Statement
• Analysis based on Cash Flow Statements
• Computation & Interpretation of Cash Flow Ratios
Ratio Analysis
• Profitability Analysis
• Efficiency Analysis
• Liquidity Analysis
• Common size Analysis
• DuPont Analysis
• Altman z-Score
• Reporting on overall Health
• Valuation Ratios
• Working Capital Analysis
• Observe historical trends
• Identify determinants of earnings growth
• Measure strength
• Observe the link between ROE and implied growth
Forecasting Financial Statements
• Using different functions of EXCEL to forecast
• Understanding Macro economic variables having impact on Future Financial Statements
• Impact of GDP, Inflation & other macro economic variables on Equity
• Using Regression to model forecasted Financial Statements
• Understanding the drivers for forecasting
Understanding of Key Components
• Depreciation Schedule
• Debt Schedule
• Shares Outstanding Schedule
5-Year Statement Projection Model
• Forecasting of Geographical and Segment based Revenues and Expenses.
• Forecasting a Company’s Income Statement
• Forecasting Assets and Liabilities on the Balance Sheet
• Projection of Shareholders Equity
• Role of different Ratios during Projection
• Building an Integrated Cash Flow Statement
Supporting Schedules
• Integrating Dividend Payments Schedule into the Model
• Incorporating the Debt Schedule into the Model
• Incorporating a Detailed Depreciation Schedule
Integration and Balancing of Financial Model
• Balancing using debt schedule and debt sweep logic
• Integrating Balance Sheet, Income Statement and the Cash Flow Statement.
• Using cash flow either to bring down debt or build cash.
• Integration of Financial Statements using the interest schedule?
• Circular References in EXCEL and the mode to handle them.
Detailed Business Segment Build-Up
• Understanding the growth Drivers and projecting the key drivers of growth.
• In-depth growth analysis on the Historical Data.
• Project future detailed growth assumptions that roll up into larger projection model
• Digging into deeper layers of growth drivers
Operating & Division Segment Build-Up

Office #402,
Bank Street Building,
Bank Street, Bur Dubai,
Dubai, United Arab Emirates(U.A.E).
(M) : 00971503940459


  Send Message   8008000311

QR code

Related ads

Campus Drive Training with 100% Job Guaranteed||Job Fair Training|Cegonsoft|CBE

ATTN: Freshers and Job hunters With the great success of our last MEGA JOB FAIR and 2 CAMPUS DRIVE'S by placing 47 Students @ Bangalore & Coimbatore From August 2016 to Dec 2016. NEXT JOB FAIR ON 12TH MAY 2017 We are happy to announce our next Campus… chennai (madras)

Searching for answers on how to paint glass? It’s by using Glassprimer™ glass paint!

Painted glass is attractive and elegant. Despite its attractiveness, most people do not know how to paint glass! With Glassprimer™ glass paint, creating painted glass is easy and is well within your budget. With minimal surface preparation and simple… US

Mobile Game and Application Development Services –

With the highly skilled professionals having proven quality work experience, the concept is to assist you in achieving your goals by understanding your customers, working adequately and marketing vigorously while enjoying what we do. Our game development… US

CB Support And Coaching Software

With Clickdesk, I not only could get back to my customers in a split second with the help of the highly relevant templates but also make sure that all our emails always find a place in the primary inbox of our customers. Today, as I look back, I can’t… US

Change Gmail Password On iPhone

Changing Gmail password on your iPhone is very important from time to time. To keep secure your Gmail account you need to change it regularly. There are some few steps to easily change Gmail password, which is described are following: 1. Launch ‘Settings’… US

Report this ad