Certificate in Financial and Valuation Modeling

Rapid Skillz

Chiedi il prezzo

Informazioni importanti

  • Short course
  • Beginner
  • Online
  • 45 ore di studio
  • Durata:
  • Quando:

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.

Informazioni importanti
Quali sono gli obiettivi della formazione?

The course aims to enable understudies to: 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.

Requisiti: 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.


Dove e quando

Inizio Luogo

Cosa impari in questo corso?

Cash Flow
Cost of Capital
Balance Sheet
Financial Training


This Course Consist of the following contents- 1.INTRODUCTION TO INVESTMENT BANKING -Lifecycle of a Company, Why Corporate Finance. 2.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. 3.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. 4.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. 5.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. 6.COMPANY HISTORICAL INFORMATION -Company Historical Information – Setup, Company Historical Information – Revenue, Company Historical Information – Expenses. 7.RATIO ANALYSIS -Ratio Analysis – Overview, Ratio Analysis – Liquidity Ratio, Ratio Analysis – Solvency Ratio. 8.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. 9.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. 10.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. 11.VALUATION -Discounted Cash Flow Analysis, Comparable Analysis.

Ulteriori informazioni

This Course is made for Students and 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.