Call us at:- +91-9958934646
Go

Create a free profile as



Sample Certificate

international-students
Financial_Valuation_Modeling.jpg

Certificate in Financial and Valuation Modeling

Indian : Rs.14900
International : $248
INTRODUCTION

This course will go more in depth into company’s financial historical, financial projections, financial ratios, Debt pay down, depreciation schedule. Then comparison of the various kinds of valuation methods that is used to value the company like DCF, comparable trading analysis, weighted average cost of capital - and building a football chart and on how to analyze them better. Also stock price analysis and pitch book preparation and presentation will be taught in this course.

OBJECTIVE
  • Learn Corporate Finance and Advanced Financial Modeling, Valuation Modeling, Data Research, Financial Ratio Analysis and Company Valuation.
  • Learn to use MS Excel as an Advanced Financial and Valuation Modeling tool.
  • Get exposed to industry case studies and best practices for doing financial modeling taught by a Wall Street Investment Banker and Hedge Fund Analyst.
  • Differentiate from your peers by earning a Certificate in Advanced Financial Modeling skills - critical to Investment Banking and Financial Analyst jobs.
  • Get career assistance by interacting with industry bankers who will guide you with your interviews and job search.
  • Answer interview questions more confidently and be technically proficient.
POTENTIAL CAREER
  • Financial Analyst or Associate in Investment Banking or Corporate Banking divisions of companies such as Goldman Sachs, Morgan Stanley, Credit Suisse, etc.
  • Equity Research Analyst in Brokerage houses s such as Deutsche Bank, Barclays, J.P Morgan etc.
  • Private Equity Analysts in funds such as TPG, Blackstone, KKR etc.
  • Credit Analyst in rating agencies such as S&P and Moody’s.
  • Strategy and Corporate Development Executive in large companies.
  • Business Analyst in Management Consulting firms such as McKinsey, Bain etc.
CONTENT

INTRODUCTION TO INVESTMENT BANKING

  • Lifecycle of a Company
  • Why Corporate Finance

THE COMPANY AND ITS FINANCIAL STATEMENTS

  • Revenue and Gross Margin
  • Operating Expense and Net Income
  • Gross and Net Margin Explained
  • Advanced Income Statement
  • Revenue Recognition
  • Expense Recognition
  • Analyzing Dominos Income Statement – revenue and Margins
  • Analyzing Dominos Income Statement – Debt and Interest
  • Balance Sheet Basics – Assets
  • Balance Sheet Basics – Liabilities and Net Worth
  • Financial Crisis of 00
  • Dominos Pizza’s Balance Sheet
  • Analyzing Dominos Pizza’s Balance Sheet
  • Double Entry Book-keeping
  • Working Capital and Debt/Equity ratio and Return on Net Worth
  • Cash Flow Statement Basics
  • Building a Cash Flow Statement
  • Capex
  • Depreciation and Amortization
  • Taxes
  • Building a  Statement Model
  • Financial projections
  • Financial Projections for a TV channel

THE SHARE AND VALUATION

  • Shares
  • Earnings per Shares
  • Private and Public Companies
  • Book Value and Market Value
  • P/E Ratio
  • Time value of Money
  • Net Present Value
  • Weighted Average Cost of Capital
  • Discounted Cash Flow
  • Comparable Trading Analysis
  • Comparable Acquisition Analysis

RAISING MONEY

  • Raising Money – Early Stage
  • Raising Money – Late Stage
  • Pre and Post Money Valuation
  • Equity Versus Debt
  • IPO
  • IPO Valuation
  • How to raise money using Debt
  • Types of Debt
  • Debt Yield
  • Debt Ratios and Ratings
  • Capitalization Structure
  • Basic M&A with SBC-AT&T Acquisition Example
  • Advanced M&A – Accretion and Dilution
  • Advanced M&A – Goodwill, M&A Arbitrage
  • AT&T – SBC Merger
  • Introduction to Venture Capital and Termsheet
  • Termsheets – Liquidation Preference – Drag Along
  • Advanced Venture Capital and Termsheet

SETTING UP A FINANCIAL MODEL

  • Why Financial Modeling
  • Types of Valuation – Dividend Discount Model
  • Types of Valuation – Discounted Cash Flow
  • Types of Valuation – Residual Income Model, Relative
  • Mergers and Acquisition Deal Cycle
  • Data Sources Used and Formatting
  • Components of a Financial Model
  • Navigating a Financial Model

COMPANY HISTORICAL INFORMATION

  • Company Historical Information – Setup
  • Company Historical Information – Revenue
  • Company Historical Information – Expenses

RATIO ANALYSIS

  • Ratio Analysis – Overview
  • Ratio Analysis – Liquidity Ratio
  • Ratio Analysis – Solvency Ratio

FORECASTING INCOME STATEMENT

  • Forecasting Income Statement – Setup
  • Forecasting Income Statement – Data Sources
  • Forecasting Income Statement – Revenue
  • Forecasting Income Statement – Detailed Revenue Breakdown
  • Forecasting Income Statement – Expenses

FORECASTING BALANCE SHEET

  • Forecasting Balance Sheet – Liabilities
  • Capex and Depreciation Schedule
  • Detailed Capex Breakdown
  • Tax
  • Assets – Equity in Affiliates, Goodwill, Intangibles
  • Assets – Intangibles
  • Assets – PP&E
  • Liabilities – Accounts Payable, Taxes Payable, Accrued Exp.
  • Liabilities – Debt – Short Term, Long Term
  • Equity – Diluted Shares Outstanding
  • Equity – Retained Earnings
  • Equity – Minority Interest

FORECASTING CASHFLOW STATEMENT

  • Cash flow from Operating Activities
  • Purchase of Fixed Assets – Proceeds from sale of fixed assets
  • Purchase of Intangible Assets
  • Common Treasury Stock Dividends

VALUATION

  • Discounted Cash Flow Analysis
  • Comparable Analysis
CONTENT MODE

This is an online course taught using recorded videos - In the videos you will see the faculty teaching and building financial models from scratch using Excel.

REQUIREMENTS

There is no such eligibility criteria required - this course assumes you have no background in finance and starts from the basics of finance and slowly builds into advanced topics.

WHAT AM I ABLE TO GET OUT OF THIS COURSE

The biggest advantage of this course - is you get to interact with world class faculty - just by interacting with them you learn a lot - whenever you have any doubts or need guidance - you can schedule a phone call with the faculty.

ADDITIONAL SUPPORT
  • We provide assistance by connecting you to our expert industry faculty who are investment bankers themselves and have worked for firms like Goldman Sachs, Merrill Lynch and CSFB.
  • You can interact with them and learn about different jobs in detail and they’ll gladly assist you in helping you re write your resume, give you job tips, tell you about current job vacancies, how to apply, take your mock interview etc.
Frequently Asked Questions

Why do I need the DeZyre Certificate in Financial and Valuation Modeling?
Jobs in Financial Services and Business Consulting are extremely competitive. There are thousands of well qualified applicants for every open position. Financial modeling is the most critical skill that the industry looks for. This DeZyre Certification will significantly improve your chances of a successful career since you will learn the exact skills that industry is looking for.
 
Binny Mathews from Credit Suisse Investment Banking, Sharat Potharaju from Bank of America Investment Banking and Priyank Jain - Hedge Fund Analyst, will teach you using real-life industry case studies, current events. At the end of this course you will be able to confidently analyze businesses, identify business challenges, recommend and implement business solutions.

How do I study the advanced financial modeling Online on DeZyre.com?
Step 1 – Enroll and pay for the course by clicking on the “Take this Course” button.
Step 2 - Once you enroll for the course, we will email you a username and password. 
Step 3 - Once you login, you will see all the course modules. Each module is a 20-30 minute video, where you can see the faculty explaining the various concepts using Excel and Powerpoint. The faculty will work-out the various analysis and problems in the video for your easy understanding. 

What is the duration of this financial modeling course?
This course is a 45 hour course. Most of our students finish the course in 6 weeks. You can login whenever you are free and complete a few modules a day. You can finish it faster if you do more modules every day.

What is the format of the financial modeling exam?
Your final score is based on an exam and a project. The exam is an online multiple choice exam and consists of 60 questions that should be completed in 2 hours. The passing score on the examination is 60%. There is no negative marking.

For how long is my DeZyre login and password valid to access my financial modeling course?
Once you have enrolled for the course, there is no validity or end date. You can access your course contents anytime, even after you finish your final exam.

priyank jain.png

Priyank Jain

  • At Avendus, Priyank was part of the team focused on M&A and Private Equity Syndication for companies in Technology and Outsourcing space. As an Equity Research Analyst, Priyank worked on Global and Indian IPO research, which includes fundamental and financial analysis of the companies with the aim of arriving at a fair value by developing earnings and cash flows models. Published reports on various IPOs from different sectors including Metal and Mining, FMCG, IT and Finance. Investment Recommendations, through reports were directly used by the clients for investment purpose. Coverage includes: Bajaj Corp., MakeMyTrip Limited, Fabrinet, Boshiwa International, Pandora Jewelry, and Chicago Board of Option Exchange (CBOE).
  • Priyank graduated with a B.Tech from IIT Kharagpur.

Highlights

  • Investment Banker, Avendus Capital
  • Portfolio Analyst - Thomas White International
  • B.Tech - IIT Kharagpur

Hot Courses

Our Partners