Certificate in Financial and Valuation Modeling

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.