Canada 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

BRANCH OFFICE
Office #402,
Bank Street Building,
Bank Street, Bur Dubai,
Dubai, United Arab Emirates(U.A.E).
(M) : 00971503940459
letslearn@live.com
http://www.llm-consultancy.com/financial-modeling/c89j

http://www.llm-consultancy.com/financial-modeling/c89j

A.S RAO NAGAR


  Send Message   8008000311


QR code

Related ads

Bangalore Escort Agency

The escort girls are versatile ladies who possess great communication skills, some are even multilingual. These multi faceted high profile models can accompany you to top grade parties and social gatherings; they may serve as your best companion in pubs,… US

zeel international brand for women's clothings

ABOUT ZEEL Zeel provides large collection of women clothes, accessories and related products of latest fashions. It believes that every woman is a celebrity in herself and source of positive energy, inspiration and style. Zeels designs make her more… Canada

Dialer VoIP and Call Center Solutions for Mumbai Centers

We are one of the leading Dialer and telephony Vendor based in Jaipur, Pune, Delhi and Manila for Call Centers and BPO across the globe with 275+ Live Call Centers using our services in 9 countries across 91 cities Fetured Models: Unlimited Dialer VoIP… mumbai

Kitchener Ford

Kitchener Ford is under new ownership and is now part of an experienced, ambitious and growing multidealership group! Proudly serving the greater Kitchener-Waterloo community, we are conveniently located at the corner of Ottawa. Ontario

Top Banquets Halls in borivali west | Book for any occasion through BookEventz & Get Upto 30% Discount

BookEventz is India's first Party Venue and Banquet Booking platform, which provides one stop solution to all event services. Choose from 5000+ venues, caterers, DJ's, Makeup artist, Photographers and other professionals for Birthday parties, Anniversary… Asia



Report this ad