The Financial Modeling and Forecasting Training Program
Learn Financial Modeling and Financial Forecasting.
The Financial Modeling and Forecasting Training Program will give you with the skills and knowledge to build a projection forecasting model in Excel for a real public operating company.
Financial Modeling and Forecasting Training Program
For Investment Banking, Corporate Finance, Private Equity, Equity Research, Hedge Funds, Asset Management, Sales & Trading, Corporate Law
The Financial Modeling and Forecasting Training Program will give you with the skills and knowledge to build a projection forecasting model in Excel for a real public operating company. Building a forecasting model is an essential part of understanding the finances of a company and its future financial performance. It is also the first step in doing a discounted cash flow valuation analysis. The Training Program will cover all the steps necessary for you to successfully build a forecasting model. You will learn how a forecasting model is built at a Wall Street firm. The methodology used to build the model is the same that you would use at a Wall Street job. It contains over 200 pages of invaluable training material.
The Financial Modeling and Forecasting Training Program is the best way for you to prepare and learn what you need to know to pursue a career on Wall Street. Once you learn the skills to successfully model the future financial performance of a company, you can then move on to valuation. Each Training Program includes completed Excel financial models and supporting documents which are available as downloads or on a CD-ROM. The financial models and supporting documents allow you to build your own financial models just as you would at a Wall Street job.
Valuation modeling is covered in The Wall Street Program Valuation Training Program which is a perfect companion to the Financial Modeling and Forecasting Training Program.
Key Topics (View All Topics-see below)
Introduction to Financial Modeling and Forecasting in Excel
Learn how to construct valuation models to value a real operating company
Learn how to compile historical information on the company using appropriate documents (SEC filings, analyst reports, etc.)
Learn and build each of the core financial statements in the model
Forecast working capital
Learn how to set up a depreciation schedule
Forecast other long term items
Learn how to project shareholder’s equity
Complete a shares outstanding schedule
Learn how to create a debt and interest schedule
Understand how to make sure your model works and how to troubleshoot it
10-K 10-Q 8-K Accounts Payable Accounts Payable as % of Inventory Accounts Receivable Accrued Liabilites as % of COGS Amortization Assumed Current Year EPS Multiple Average Diluted Shares Outstanding Balance Sheet Basic Weighted Average Shares Outstanding Beginning Net PP&E Calculation of Additions to Goodwill Capital Expenditures Cash Cash and equivalents Cash Available after Borrowing/(Pay Down) of Short Term Debt Cash Available for Debt Repayment Cash Flow Available for Financing Activities Cash Flow Statement Check-Model Balance Circular References COGS Growth Commitments and Contingencies Common Stock Compiling Historical Information Completing Debt and Interest Schedule Completing Shares Outstanding Schedule Conversion of preference stock Cost of Sales Costs of Goods Sold (COGS) Current Portion of Long Term Debt Current Year EPS Deferred Taxes Depreciable PP&E, net Depreciation Dividends Drivers Dynamic models Earnings before Interest and Taxes (EBIT) Earnings before Interest, Taxes, Depreciation and Amortization (EBITDA) Effect of Options and Dilutive Securities Ending Net PP&E Estimated Minimum Cash Balance Excel Shortcuts F-1 F-2 F-3 FASB Forecasting Other Long Term Items Forecasting Working Capital Form 10 Form 8-A Free Cash Flow Less Acquisitions Free Cash Flow Less all Investing Activities Free Cash Flow less Investing Activities Gains on Investees' stock Goodwill Gross Income Gross Profit Growth Rates Income from continuing operations before income taxes Income per basic share Income per diluted share Income Statement Income Taxes Individual Subsidiaries Intangibles calculation Interest Expenses Interest Income Inventory Inventory Turn Land Long Term Debt Long Term Debt Balances Making reasonable and defensible assumptions Mid-year convention Minority Interest Modeling Best Practices Net Income Net income per basic share Net income per diluted share Net Long Term Debt Net Working Capital/ (Deficit) Operating Cash Flow Operating Expenses Operating Income (EBIT) Operating Margins Paid-in Capital Plant, Property and Equipment Preferred Stock Pre-tax Income Proceeds from Issuance of Additional Debt Proceeds from Issuance of Long Term Debt Projected Average Share Price Projecting Shareholder's Equity Prospectus Proxy Refinancing, Recapitalization Repurchase of Common Stock Retained Earnings Revenue Rule 462 (b) S-1 S-2 S-3 SEC Edgar Database Selling, General and Administrative (SGA) Setting up a Depreciation Schedule Share Repurchase Assumptions Shareholder's Equity Shares issued Shares purchased Short Term Debt Stock options outstanding and restricted stock Tax Trade names and other intangible items Troubleshooting the Model US GAAP