Basic Package – Wall Street Prep

Basic Package Description

Basic Package by Wall Street Prep shows you the most effective way to build a 3-statement model from the ground up and the optimal development of comprehensive financial statement models with multiple supporting schedules. The course demonstrates the detailed process of inputting historical data and projecting financial statements with step-by-step guidance on selecting, locating, and developing suitable projection drivers.

Here are what you will learn in this course:

• Chapter 1: Overview
  • Introduction
  • Excel Settings for Modeling
  • Keyboard Shortcuts
  • The Boost Excel Add-In
• Chapter 2: Financial Modeling Best Practices
  • Formatting Conventions
  • Modeling Best Practices
  • Naming, Linking & Deleting Cells
  • Model Structure
• Chapter 3: Preparing for the Case Study
  • Gathering Documents for Modeling (the “PIB”)
  • Apple Case Study Introduction
• Chapter 4: The Income Statement
  • Modeling the Historical Income Statement, Part 1
  • Modeling the Historical Income Statement, Part 2
  • Introduction to Forecasting
  • Segment-Level Revenue Forecasting
  • Operations Forecasting
• Chapter 5: Forecasting the Balance Sheet: Working Capital
  • Inputting the Historical Balance Sheet
  • Working Capital Forecasting & Roll-Forward Mechanics
  • Accounts Receivable, Part 1
  • Accounts Receivable, Part 2
  • Inventory
  • Accounts Payable
  • Accrued Expenses & Deferred Revenue
• Chapter 6: Long-Term Assets & Liabilities
  • Intangible Assets
  • Modeling Intangible Assets
  • PP&E
  • Modeling PP&E
  • Other Balance Sheet Assets
  • Modeling Other Current Assets
  • Deferred Tax Assets
  • Deferred Tax Liabilities
  • Other Liabilities
  • Modeling Deferred Taxes & Other Balance Sheet Items
• Chapter 7: Debt
  • Debt
  • Modeling Debt
• Chapter 8: Balance Sheet Equity
  • Capital Stock
  • Modeling Capital Stock
  • Treasury Stock
  • Modeling Treasury Stock
  • Retained Earnings and OCI
  • Modeling Retained Earnings
  • Modeling Other Comprehensive Income
  • Linking Schedules Back to the Balance Sheet
• Chapter 9: The Cash Flow Statement
  • Cash Flow Statement Introductions
  • Review: The Cash Flow Statement
  • Cash From Operations
  • Modeling Cash from Operations
  • Cash From Investing & Other Financing Activities
  • Modeling Cash from Investing & Other Financing Activities
  • The Lemonade Stand
• Chapter 10: The Model Plugs: Revolver & Cash
  • Understanding the Role of the Revolver in Financial Models
  • Modeling the Revolver
  • Modeling Interest Income
  • Dealing with Circularities in Financial Models
• Chapter 11: Earnings Per Share
  • EPS
  • Modeling EPS
• Chapter 12: Finishing Touches
  • Integrity Checking & Balancing the Model
  • Sensitivity Analysis Using Data Tables
  • Scenario Analysis
• Chapter 13: Deeper Dives
  • Depreciation Waterfall