Africa 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

Oraclefinancials R12 Online Training at Blossom Technologies

Blossom Technologies software development & leading training center in dilsukhnagar, hyderabad. Oracle Financial R12 training at low cost with certified trainers. The training will a corporate level training . The courses which we are going to cover in… US

Geothermal Heating, Geothermal pool heating

Geothermal heat pumping is a renewable heating technology utilizing the earth as both a heat sink and heat source. Heat pumps are a way of directly tapping into geothermal energy for heating a specific area in a commercial or residential building. The… US

Balboa Island Commercial Awnings

Orange County’s experts in sales, installation custom-made awnings, cabanas, shade sails, slide-on-wire awnings, entrance canopies, drop rolls, and sun screens for homes & businesses. We feature a variety of awning models, beautiful & highly-functional… orange county

Griffin Business centre

A virtual business or business process is not the equivalent of outsourcing. Outsourcing is outsourcing, the act of turning a specific function over to a third party provider to implement and support, for a fee. The virtual business/business process is… Canada

Trabajo Sobre El Modernismo Y Postmodernismo

Obtener la historia notas, ensayos libres y trabajos por tema y otra información útil con respecto al trabajo sobre el modernismo y el posmodernismo y más. US

Report this ad