New 3 Statement and Discounted Cash Flow (DCF) Financial Modeling Online Training Videos

 

Looking to break into investment banking? Anxiously preparing for corporate finance interviews? Want to jump start mastering financial modeling so you can hit the ground running in your new job?

The stakes are high, because salaries for entry-level analysts and associates in banking and finance are lucrative — often $110,000 – $230,000 or more annually when combining base and bonus. That’s 2 – 5x the national household median income coming straight out of college or grad school.

Succeeding in finance requires strong analytical skills in analyzing and valuing companies. This demands a strong understanding of the mechanics and business judgment involved in modeling financial statements and discounted cash flows.

The good news is: financial modeling and discounted cash flow (DCF) analysis are highly trainable skills. The bad news is: Wall Street modeling classes can cost thousands for just a one-day class.

That’s where our training videos come in. 

Using a well-known public company as our case study — Chipotle Mexican Grill — our 3 Statement and DCF Modeling Video Training Course provides hands-on, “roll-up-your-sleeves,” step-by-step training — at lower cost than competing courses.

We teach you how to build fully integrated financial and valuation models, just like the live classes. But there’s no risk of “falling behind,” because you can learn at your own pace and watch our examples as many times as you need to master financial modeling.

Our training videos focus on critical tactical knowledge and skills, making it the perfect solution for fast learners with no prior finance experience, or experienced candidates who need a financial modeling refresher.

We will teach you how to:

  • Build a fully integrated 3 statement financial model in Excel
  • Build a DCF analysis using both perpetuity growth and EBITDA multiple methods
  • Build detailed supporting schedules linking back to the 3 statements
  • Analyze a public company 10-K filing to efficiently extract data needed for your model
  • Troubleshoot your model accurately and efficiently when accounts don’t balance or reconcile
  • Understand key concepts related to depreciation, amortization, goodwill, circularity, unlevered vs. levered cash flow, terminal value, weighted average cost of capital, capital asset pricing model, and enterprise vs. equity value
  • Think intuitively about financial statement mechanics, analysis, and corporate valuation
  • Model very efficiently using Excel shortcuts

Check out our course syllabus below and watch the first financial modeling training video here for free! We’ve now also made our second training video free as well.

We also offer DCF + LBO discount combo packages.

 

3-STATEMENT MODELING TUTORIAL VIDEOS (PRO PLAN)

3-statement modeling overview: building a fully integrated 3-statement model of a lemonade stand

  1. Financial statement analysis: overview
  2. Lemonade stand model: income statement template
  3. Lemonade stand model: balance sheet and cash flow statement templates
  4. Lemonade stand model: COGS
  5. Lemonade stand model: building the income statement to the EBITDA line
  6. Lemonade stand model: building the income statement to the EBIT line
  7. Lemonade stand model: building the income statement to the net income line
  8. Lemonade stand model: building the balance sheet
  9. Lemonade stand model: building the cash flow statement
  10. Finishing the lemonade stand model
  11. Lemonade stand model: learning points recap

Plus: Finished 3-statement lemonade stand model in Google Spreadsheets

 

Using Excel like a boss: 

  1. Number formats
  2. Summary of key shortcuts
  3. Excel shortcuts: demo 1
  4. Excel shortcuts: demo 2
  5. Excel shortcuts: demo 3
  6. Excel shortcuts: demo 4
  7. Excel shortcuts: demo 5

Building a fully integrated 3-statement financial model of Chipotle Mexican Grill: 

  1. Overview and learning goals for this course
  2. How the 3 financial statements link together
  3. Building out the core statements: learning goals and steps
  4. Overview of Chipotle’s 10-K
  5. Building the income statement template to the EBITDA line
  6. Building the rest of the income statement template
  7. Building the balance sheet template
  8. Building the cash flow statement template
  9. Bringing in historical financials: overview
  10. Bringing in historical financials to the EBITDA line
  11. Bringing in the rest of the historical financials
  12. Formatting historical financials on the income statement
  13. Calculating historical ratios and drivers on the income statement
  14. Bringing in historical financials onto the balance sheet
  15. Formatting historical financials on the balance sheet
  16. Forecasting ratios and drivers on the income statement
  17. Forecasting the income statement to the EBITDA line
  18. Working capital schedule: overview and steps
  19. Building the working capital schedule template
  20. Bringing in historical data into the working capital schedule
  21. Calculating historical ratios and drivers on the working capital schedule
  22. Forecasting ratios and drivers on the working capital schedule
  23. Forecasting account balances on the working capital schedule
  24. Linking the working capital schedule back to the core statements
  25. Depreciation, amortization, and indefinite-life intangibles
  26. Goodwill
  27. Building the depreciation & amortization schedule template
  28. Bringing in historical data into the depreciation & amortization schedule template
  29. Forecasting the depreciation & amortization schedule
  30. Linking the depreciation & amortization schedule back to the core statements
  31. Other long-term items: overview and steps
  32. Building the other long-term items schedule template
  33. Bringing in historical data into the other long-term items schedule
  34. Calculating ratios and drivers on the other long-term items schedule
  35. Forecasting asset account balances on the other long-term items schedule
  36. Forecasting liability account balances on the other long-term items schedule
  37. Linking the other long-term items schedule back to the core statements
  38. Finishing the income statement logic: overview and steps
  39. Finishing the income statement logic: implementation
  40. Shareholders’ equity & shares outstanding schedule: overview and steps
  41. Building the shareholders’ equity & shares outstanding schedule template
  42. Bringing in historical data into the shareholders’ equity & shares outstanding schedule
  43. Pulling 10-K data into the shareholders’ equity & shares outstanding schedule
  44. Forecasting account balances on the shareholders’ equity & shares outstanding schedule: Part 1
  45. Forecasting account balances on the shareholders’ equity & shares outstanding schedule: Part 2
  46. Forecasting account balances on the shareholders’ equity & shares outstanding schedule: Part 3
  47. Linking the shareholders’ equity & shares outstanding schedule back to the core statements: Part 1
  48. Linking the shareholders’ equity & shares outstanding schedule back to the core statements: Part 2
  49. Preparing for the debt & interest schedule: overview and steps
  50. Preparing for the debt & interest schedule: implementation
  51. Building the debt & interest schedule: overview and steps
  52. Building the debt & interest schedule template
  53. Building the debt & interest schedule waterfall
  54. Building the debt & interest schedule: long-term debt
  55. Building the debt & interest schedule: revolving credit facility
  56. Building the debt & interest schedule: calculating net interest expense
  57. Linking the debt & interest schedule back to the core statements
  58. Dealing with circularity in the model
  59. Why doesn’t it balance? Reconciling the balance sheet: Part 1
  60. Why doesn’t it balance? Reconciling the balance sheet: Part 2
  61. Why doesn’t it balance? Reconciling the balance sheet: Part 3
  62. Why doesn’t it balance? Reconciling the balance sheet: other tips
  63. Finishing the integrated 3-statement model

DCF MODELING TUTORIAL VIDEOS

Layering a DCF analysis on a fully integrated 3-statement financial model of Chipotle Mexican Grill: 

  1. Discounted cash flow analysis: overview
  2. “Free cash flow to the firm” or “free cash flow to equity”?
  3. Terminal value
  4. Weighted average cost of capital
  5. Capital asset pricing model
  6. Present value
  7. Equity value
  8. Building the DCF template
  9. Deriving tax-affected EBIT
  10. Calculating unlevered free cash flow to the firm
  11. Setting up the weighted average cost of capital template
  12. Calculating the component rates of weighted average cost of capital
  13. Finishing the weighted average cost of capital calculation
  14. Calculating terminal value: perpetuity growth method
  15. Calculating terminal value: EBITDA multiple method
  16. Finishing the discounted cash flow analysis

 

 

FREQUENTLY ASKED QUESTIONS

Q. Will these training videos really help me succeed in my banking interviews and help me hit the ground running in my finance job? 

Nailing investment banking and corporate finance interviews and succeeding in a high-pressure finance job from Day 1 requires a strong understanding of key finance, accounting, and corporate valuation principles. Having the technical training and skills to confidently build 3-statement models and DCF valuations and critically analyze and evaluate companies is the key skill set that will distinguish you in interviews and help you excel in the job. This is why it’s critical to develop a rock-solid understanding of how to model and forecast financial statements and value companies accurately and efficiently in Excel.

That’s where our videos come in. We walk you step-by-step through the process of building fully integrated financial and valuation models. With our Pro Plan, we first start with an overview on financial statement analysis and then immediately apply those principles to building a simplified, but fully integrated, 3-statement model of a lemonade stand business. With this simplified example, we cover all the key concepts of interlinking and forecasting the 3 statements, which helps you understand the intuition and logic of how the core financial statements fit together. This provides a strong foundation for us to build a full-fledged 3-statement model using a public company 10-K in the next part of the course. We also show you how to maximize your efficiency in Excel using important shortcuts and techniques.

We then extend the knowledge from our simple 3-statement example and actually build a fully integrated financial model of Chipotle Mexican Grill, complete with detailed supporting schedules that link back into the core statements, as well as a discounted cash flow analysis that evaluates free cash flow using both the perpetuity growth method and the EBITDA multiple method. We do this step-by-step from the ground up starting from a blank Excel sheet, with no custom plugins or macros, so that everyone is on a level playing field. We also provide plenty of visual explanations of key finance concepts to augment your understanding of financial modeling, including deep-dives on depreciation, amortization, goodwill, circularity, unlevered vs. levered cash flow, terminal value, weighted average cost of capital, the capital asset pricing model, and enterprise vs. equity value. And we even provide troubleshooting tips on how to efficiently and accurately diagnose problems in your model when accounts don’t balance or reconciliations don’t tie.

These are key skills you will need to succeed in a high-stakes finance job. And we show you step-by-step exactly how to develop, strengthen, and master those skills so that you are in the best position to nail your finance interviews and hit the ground running in your new job.

 

Q. Is it worth it to pay $200+ for the training videos?

We feel strongly that our training videos offer tremendous value for motivated banking and finance job candidates.

Quite simply, the stakes for success or failure in your finance interviews and job performance are high. Salaries for entry-level banking analysts and associates span anywhere from $110,000 annually on the low-end to $230,000 or more annually on the high-end, when factoring in base and bonus together. That’s 2 – 5x the national household median income — all for a finance job candidate coming straight out of college or grad school. After you’ve been in the job for a few years, moreover, compensation can quickly increase to many hundreds of thousands of dollars annually.

That means your investment in yourself through purchasing our training videos will pay off hundreds of times over in your first year on the job alone, and that only goes up when you evaluate your long-term future earnings after getting your foot in the door.

So the risk of not being totally prepared, either for your interviews or for your first 100 days on the job itself, can be very costly because it could mean blowing an important chance to build a lucrative career in finance — and the large paydays that come with it.

So ask yourself, how much is it worth it to not be totally prepared for your break into the finance field, and potentially messing up a great career opportunity?

By contrast, how much is it worth it to invest in yourself by purchasing our training videos and potentially winning a lucrative banking or finance job? Think about it this way: with your new finance salary, you can earn back your investment in our training videos in just your first DAY on the job — with more than enough left over to buy your friends and family a beer to celebrate!

 

 

Andrew Chen

Andrew Chen received an associate offer, without any formal LBO experience, on his first attempt at applying for private equity investing positions in the competitive San Francisco Bay Area. He worked for Huntsman Gay Global Capital, the Bain Capital spin-out founded by the industrialist Jon Huntsman, former Bain Capital Chairman Bob Gay, former San Francisco 49ers Superbowl quarterback Steve Young, and including former CFO of Citigroup and American Express Gary Crittenden. Andrew was previously a member of the Corporate Finance & Strategy Practice at McKinsey & Company and holds a J.D. from Harvard Law School. You can follow him on Twitter and .

Opt In Image
Get our FREE 10-part email mini-course on how to break into private equity: networking, interviewing, and LBOs
(No spam or BS, ever. Unsubscribe anytime.)