Loading personalized content...

Project 2: Corporate Acquisition Model

Back to Course

Capstone Module: Real-World Mastery Projects » Project 2: Corporate Acquisition Model

Text Content

For Investment Banking & FP&A Aspirants

Challenge

"A Fortune 500 company wants to acquire a $200M revenue competitor – build the LBO model and synergy analysis."

Requirements

  1. Merger Model

    • Purchase price allocation

    • Debt structure (Term Loan/Revolver)

    • Accretion/dilution analysis

  2. Synergy Dashboard

    • Cost savings visualization

    • Cross-selling revenue projections

  3. Board Presentation

    • Sensitivity tables (IRR drivers)

    • Key risks matrix

Grading Criteria

Weight Aspect Excellence Standard
35% Technical Rigor Correct treatment of deferred tax assets
25% Scenario Analysis 3+ debt structure options modeled
20% Executive Readiness Board slides require <5 min explanation
15% Error Handling All cells protected except inputs
5% Speed Model recalculates in <15 seconds

Sample Dataset:

  • Target company 10-K (Excel conversion)

  • Buyer's cost of capital memo

  • Industry synergy benchmarks

Added on July 08, 2025
Login and enroll to track completion
Module Contents
Course Navigation
Course Overview Module 1: Foundations of Spreadsheet Mastery – Expanded Module 2: Advanced Formulas & Functions – Expanded Module 3: Data Visualization & Business Intelligence – Expanded Module 4: Automation & Efficiency – Expanded Module 5: Financial Modeling – Expanded Module 6: Collaboration & Enterprise – Expanded Capstone Module: Real-World Mastery Projects
Chat with us!
Home Shop Blog Jobs Cart Search
ChuoSmart ChuoSmart Notifications

Stay updated with the latest products, courses, and messages by enabling notifications.