Image of the Wall Street Prep logo

Student Passport Access: Advanced Financial Modeling

Price: $39/month Order Now

Module Type Access Level
Financial Modeling
Financial Statement Modeling
Unlimited
DCF Modeling
Unlimited
LBO Modeling
Unlimited
M&A Accretion/Dilution Modeling
Unlimited
Trading Comps Modeling
Unlimited
Transaction Comps Modeling
Unlimited
Interview Prep
Acing the "fit" interview
Unlimited
Acing the quantitative interview
Unlimited
Crash Courses
Accounting
Unlimited
Excel
Unlimited
Navigating Financial Reports
Unlimited
Advanced Modeling
Advanced Financial Modeling
Unlimited
Advanced LBO Modeling
Unlimited
There are several areas of finance, accounting, and financial modeling that pose particular challenges. The Advanced Financial Modeling Program specifically addresses many of the less understood and advanced concepts facing financial professionals.

  • Interpreting and modeling minority interests and equity investments
  • Modeling implications of new accounting rules affecting business combinationsUnderstanding and modeling net operating losses (NOLs)
  • Treatment of NOLs in M&A models
  • Non-recurring charges and taxes in building financial models
  • Modeling deferred taxes and three statement models and in M&A and LBO models
  • Modeling and tax consequences of acquisitions structured as stock vs. asset sales
  • Modeling 338(h)(10) election and wholly owned subsidiary acquisitions
  • Calculating the purchase price indifference points between various tax structures for acquisitions.
  • Use as a reference to get ahead on the job and in your career

Benefits

Laptop
Sample Downloads
Advanced Financial Model Template in Excel (Excel file)

Each module is designed to equip trainees with virtual job experience, intuitvely delivering the techincal skill set of investment banking and finance professionals via intensive real-world financial and valuation modeling training. Each module includes the following features:

  • Step-by-step online training with annotated Excel snapshots.
  • Complete and empty excel model templates and all supporting documents required for case studies.
  • Free support upon enrollment

Intuitive, Self-Paced, and Comprehensive

Expect to spend approximately 5 hours to complete Advanced Financial Modeling training. The program uses approximately 50 online pages of tutorial guidance and Excel model templates and introduces students to advanced financial modeling topics in a step-by-step fashion.

Virtual Job Experience

The program utilizes a case study format, as students follow their tutorial guide alongside the Excel model templates, and are directed to the appropriate external documents (SEC filings, research reports, etc.) in order to build comprehensive models the way they would on the job.