Basic Package – Wall Street Prep
Salepage link: At HERE. Archive: http://archive.is/h7Fxl
$199 $33 – Basic Package – Wall Street Prep
An abbreviated version of the Premium Package that focuses exclusively on financial statement modeling. Trainees will learn modeling best practices and build a complete financial statement model. Valuation modeling included in the Premium Package.
Course Objective
At completion, trainees will have developed a 3-statement model using various supporting schedules and best practices.
In this course, you will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements using step-by-step instruction on selecting, locating, and developing appropriate projection drivers. At completion, you will have developed a complete and comprehensive three-statement model using various supporting schedules. By the end of the course, trainees will gain skills that lay the foundation for many other modeling methodologies.
What You Will Learn
- Excel shortcuts and functions frequently used in financial modeling
- Excel settings and formatting best practices for financial modeling
- Creating model plugs via the revolver and cash sweep
- Dealing with circularities in the model
- Building a fully integrated 3-statement model using established forecasting and schedule conventions
- Balancing the model and inserting automated checks
- Perform sensitivity & scenario analysis
- How to efficiently check models for errors, accuracy and integrity
Wall Street Prep’s Accounting Crash Course is used at top financial institutions and business schools. 
Full Course Agenda
Chapter 1: Introduction to Accounting open
- Introduction
- Basic Accounting Principles
- Financial Reportings & Important Filings
- Reading the 10K
Chapter 2: The Income Statement open
- Revenue
- Revenue Recognition
- Revenue Manipulation
- COGS & Gross Profit
- Selling, General & Administrative, Research & Development
- Expenses
- Depreciation
- Amortization
- Non-Operating Items & Taxes
- Net Income, EPS & Dividends
- EBIT, EBITDA & Income Statement Summary
- The Lemonade Stand, Part 1
- The Lemonade Stand, Part 2
Chapter 3: The Balance Sheet open
- An Introduction to Assets
- An Introduction to Liabilities
- Double Entry Accounting
- How the Income Statement Connects to the Balance Sheet
- The Lemonade Stand Revisited
- How Assets & Liabilities are Presented
Chapter 4: Assets open
- Cash, Receivables & Prepaid Expenses
- Inventory
- Property, Plant & Equipment, Part 1
- Property, Plant & Equipment, Part 2
- Intangible Assets & Goodwill
Chapter 5: Liabilities & Equity open
- Payable, Accrued Expenses, Deferred Revenue & Debt
- Operating & Capital Leases
- Equity
- The Lemonade Stand, Part 3
Chapter 6: The Cash Flow Statement open
- The Cash Flow Statement
- Cash From Operations
- Cash From Financing & Cash From Investing
- The Lemonade Stand, Part 4
Chapter 7: Financial Statement Analysis open
Financial Statement Analysis
$199 $33 – Basic Package – Wall Street Prep