Oceania 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

accounting homework help

 Email me your assignments and I will send you back the solutions. In addition to solving problems I do projects, papers and essays. I offer assistance in the following areas, undergraduate, graduate and post graduate levels: Accounting Accounting concept… Canada

SAP HANA Online Training at BlossomTechnologies

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

Impressive Results with Customized Wordpress Development

As a premier Wordpress development agency based in Australia, PHP Programmers provides absolutely customized solutions for the entire range of relevant web solutions. Our dedicated programming experts aptly use cutting-edge technology to provide just the… sydney

Fedex Express Gurgaon

FedEx F-71, First Floor D-Block, Baani Square, Hilton Garden Inn, Sector 50, Gurgaon, Haryana 122018 M.8010717728 International Courier Services Gurgaon  Asia

PolySupport 3D Printer Filament for Sale

PolySupport is a material designed to solve one of the most intimidating problem in desktop FDM/FFF 3D printing: support. PolySupport generates support structures that can be easily removed by hand. Kindly reach to us by mail… Oceania

Report this ad