Wall Street Prep
Sat Jan 21 - Sun Jan 22, 2023 (ET)

Accounting and Financial Modeling Boot Camp

Date: Jan 21-Jan 22, 2023
Times: 9a-5p Daily (ET)
This boot camp is full. To be added to the waitlist, please email our university seminar coordinator here.
Hosted by Middlebury College.

Boot Camp Overview

  • Learn Accounting and Financial Statement Modeling in Excel
  • Taught by experienced bankers
  • Includes Excel model templates

Designed for liberal arts students with little to no finance background, our Accounting & Financial Modeling Liberal Arts Boot Camp will bridge the gap between academics and the real world and equip you with the knowledge you need to stand out during the recruiting process and on the job.


Topic 1
Accounting & Financial Statement Analysis

We begin with an analysis of basic accounting rules and the structure and composition of key financial filings like 10Ks and 10Qs. Then, we introduce the income statement, balance sheet, cash flow statement, and thoroughly analyze their important inter-relationships. We conclude with a discussion of ratio analysis.

Topic 2
Financial Statement Modeling

You will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements by selecting, locating, and developing appropriate projection drivers.

Topic 3
DCF Modeling

Participants learn how to value the company step-by-step, including how to estimate the weighted average cost of capital (WACC) in the real world, how to implement commonly used approaches to calculating terminal value, and how to use data tables to analyze a broad range of scenarios given different assumptions.

Pre-Seminar Excel training

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Post-Seminar Online Access

Enrollment includes access to the following online course(s): Accounting & Financial Statement AnalysisFinancial Statement ModelingDCF Modeling

View Full Syllabus
Show More Show Less

What Middlebury College Students are Saying

Boot Camp Details


This boot camp is an intensive training program where trainees learn accounting as well as financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.

What’s Included?

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar.

Experienced Instructors

Our instructors are all practitioners with years of directly relevant real- world experience and have a passion for teaching. They understand the importance of teaching in a way that empowers students to apply the lessons from the classroom directly on the job.

Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

Seminar Location

This boot camp will be held at Middlebury College, classroom TBD. Full location details will be confirmed and emailed to you prior to the course.

Why attend a boot camp?

  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.

  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.

  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.

  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.

  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.

  • Continuing ed & webinars

    Enrollment includes lifetime access to our continuing education online training platform and our popular monthly webinar series.

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685

I agree to the Terms and Privacy Policy