$33.00 $199.00
Basic Package by Wall Street Prep teaches you the crucial basics to build a 3-statement model from scratch. The best practices and a standard process will be what you can expect through 13 chapters of this course.
Course Overview
Basic Package by Wall Street Prep presents the process of building a 3-statement model from A to Z. Through this course, you can input historical data and assumptions about financial statements to develop an efficient model. It serves as a solid foundation for financial statement modeling.
Course Outline
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
What Will You Learn?
- Effective Excel shortcuts and functions in financial modeling.
- Best practices of Excel settings and formatting in financial models.
- The creation of model plugs via the revolver and cash sweep.
- How to handle circularities in the model.
- How to develop a fully integrated 3-statement model through the established projecting and schedule conventions.
- How to balance the model and insert automatic checks.
- How to conduct powerful sensitivity and scenario analysis.
- How to detect errors, accuracy, and integrity of models.
Who Is This Course For?
Basic Package by Wall Street Prep is for those who are interested in making a financial model for banks and want to build up a strong base of fundamentals.
Wall Street Prep
Please Login/Register if you want to leave us some feedback to help us improve our services and products.
RELATED COURSES
VIEW ALL
-
Micro Futures Formula 2.0 Elite Package – Simpler Trading$109.00$1,097.00Micro Futures Formula 2.0 Elite Package – Simpler TradingUpdate 29 Jun 2022No trader wins all the time. But great traders know how to minimize risks and maximize profits. And they know Micro Futures Formula 2.0 Elite Package – Simpler Trading is the course that can help them achieve it.
Add to wishlist -
Valuation Explained Simply Replays + Materials$40.00$299.00Valuation Explained Simply Replays + MaterialsUpdate 26 Dec 2023Learn the 4 key valuation methods used by professional investors to calculate a company’s value: TAM, multiples, discounted cash flow, and reverse discounted cash flow.
Add to wishlist -
Master Trader Option Strategies Series for Investors and Active Traders – Mastertrader$259.97$2,597.00Master Trader Option Strategies Series for Investors and Active Traders – MastertraderUpdate 29 Jun 2022All LevelsTraders who finish the Master Trader Option Strategies Series for Investors and Active Traders will be able to uncover low-risk, high-odds options opportunities that do not need a significant amount of time – assuming they know what to look for.
Add to wishlist -
Advanced LBO Modeling – Wall Street Prep$67.00$399.00Advanced LBO Modeling – Wall Street PrepUpdate 21 Sep 2022AdvancedAdvanced LBO Modeling by Wall Street Prep presents a complete walkthrough of how to build a complicated LBO model from scratch. It covers the fundamentals and advanced concepts through instructions on the whole process.
Add to wishlist -
Volume Profiling with Strategy Development – Axia Futures$30.00$1,000.00Volume Profiling with Strategy Development – Axia FuturesUpdate 28 Jun 2022The Volume Profiling with Strategy Development course by Axia Futures teaches you how to develop your own unique strategy – how to use advanced methods and tools of volume profile analysis methodologies. You will gain an unfair advantage over other traders in the market with an on-going stream of high quality entry/exit signals accurately based on precise levels of price impact measures.
Add to wishlist -
Tape Reading Small Caps Webinar – Jtrader$29.00$297.00Tape Reading Small Caps Webinar – JtraderUpdate 27 Jun 2022IntermediateTape Reading Small Caps walks you through how to grow your trading accounts with small-cap trading and the technical analysis of reading tapes.
Add to wishlist
Reviews
There are no reviews yet.