Wallstreetsamurai

This is the complete Wall Street Prep Excel Crash Course (2025 edition) with practical exercises, shortcuts, and solutions—perfect for students, analysts, and professionals looking to build Excel proficiency for finance and modeling roles. Topics Covered: Essential Excel shortcuts and navigation techniques Financial modeling functions (INDEX-MATCH, OFFSET, IFs, etc.) Dynamic charts and data tables Number formatting for financial reports Named ranges, auditing, and circular re...

This document covers Advanced Accounting topics with comprehensive notes and fully solved questions, perfect for exam prep, coursework support, or professional certification review. Key topics include: Business combinations and acquisition accounting Consolidated financial statements and elimination entries Equity method vs. cost method Intercompany transactions (inventory, fixed assets, services) Minority interest and non-controlling interest accounting Pushdown accounting ...

This premium exam bundle includes three complete financial modeling exams: DCF Modeling M&A (Merger) Modeling Financial Statement Modeling Each exam contains real-world questions and detailed step-by-step solutions, perfect for mastering core investment banking and private equity modeling skills.

This document provides a complete Accounting Crash Course with clear explanations and solved examples, ideal for beginners and finance professionals needing a fast, practical understanding of accounting fundamentals. Topics covered include: Core financial statements: Income Statement, Balance Sheet, and Cash Flow Statement Accrual vs. Cash Accounting Journal entries and T-accounts GAAP-compliant accounting treatment Depreciation, working capital, and revenue recognition Comm...

This comprehensive document covers the full Mergers & Acquisitions (M&A) Modeling Course—including real exam questions and full solutions. Designed for students and professionals preparing for interviews, financial modeling exams, or roles in investment banking, private equity, and corporate development. You’ll learn how to build a complete merger model from scratch, including: Accretion/dilution analysis Synergy modeling (cost and revenue) Purchase price allocation (PPA) and goo...

his document contains the full Discounted Cash Flow (DCF) Modeling Exam with complete, step-by-step solutions—ideal for anyone preparing for financial modeling certifications, interviews, or job readiness in investment banking, equity research, private equity, and corporate finance. What's included: Full exam questions exactly as seen in professional prep courses Detailed walkthrough of every step: unlevered FCF, WACC, terminal value, and NPV Excel-based logic with explanation of f...

This is the full Wall Street Prep Financial Statement Modeling Exam with real questions and detailed solutions. Perfect for students and professionals preparing for WSP certification or interviews in investment banking, private equity, and corporate finance. Covers all key topics including: 3-statement model integration Income statement, balance sheet, and cash flow forecasting Working capital and depreciation schedules Debt and interest modeling Circular references and error che...