a) Modelling Best Practices

b) Excel Best Practices, incluing common "shortcut" keys and efficiency tips special function

c) Excel Foundations & steps for formulating projections

d) Fundamentals of formats including alignments & custom number formats including "text" with custom formatting

a) Core Statements--Forecasting Income Statement

b) Core Statements--Forecasting Balance Sheet

c) Core Statements--Forecasting Cash Flows

d) Concepts of Operating and Financial Leverage and Working Capital Schedule

a) Depreciation Schedule (PP&E table utilizing waterfall projections)

b) Amortization Schedule (def. life tangibles utilizingwaterfall projections)

c) Equity Schedule and Shares Outstanding Schedule

d) Preparing the model for forecasting debt and interest

e) Modelling cash sweeps using a revolver and Corporate liquidity, borrowing bases and debt waterfall schedule

a) Balancing a model, Sensitivity Analysis, including one an two-way data tables

b) Swtiches and Scenarios: IF, CHOOSE, VLOOKUP, OFFSET Statements

c) Overview of quarterly forecasting --Key Consideration vs Annual Modeling

a) Calculating and interpreting key financial ratios--Profitability , margins and growth

b) Interpreting key balance sheet measures--Company credit statistics--Interest Coverage, Capitalization, leverage

c) Evaluation of Indicative Credit Ratings, Overview of Bank Deb and High Yield and Investment Grade Bonds

d) Discussion of Subordination--Structural vs Contractual Subrodination

e) Discussion of Collateral, credit ratings and covenants

a) Overview of the LBO market transaction and key financial parameters involved

b) Effects of Financing on a Company's Cap Structure

a) Impact of Equity Issuance, Dividends and Share Buy Backs on Financial Statements

b) Impact of Debt Issuance and accounting mechanisms

a) Conceptual overview of DCF analysis and the WACC formula

b) Effects of Leverage on Intrinsic Value: a.) Levered (FCFE) vs. Un-Levered cash flows (FCFF)

c) Estimating the terminal value (exit multiple vs. perpetuity growth rate), equity value and equity value per share