Wall Street Prep
No Thanks

7 free financial modeling lessons!

Learn Financial Statement Modeling, M&A, LBO, DCF, Comps and essential Excel shortcuts by signing up for Wall Street Prep's free Quicklesson series. We'll email you the first lesson, "A Simple LBO Model," right now.

Calculating SG&A margin in the Colgate case study

Q: As I was adjusting the calculation for SG&A in cell G38 I got a different margin to subtract (0.0028) and I should get 0.0044 according to the solution spreadsheet. Could I please see the detailed calculation of 0.0044 margin.

A: Here is the calculation:

  • Pre-Tax Minority Interest 57.5
  • Pre-Tax Equity in Affiliates (3.4)
  • Net Impact on Expense $54.1
  • Expense as a % of sales   $54.1/12,237.7 = 0.0044 or 0.44%
Share This

Written by The Wall Street Prep Team


Wall Street Prep was established by investment bankers to enhance the competitive profile of students who seek a career in the financial services industry. Our programs are used by thousands of undergraduates, MBAs, investment bankers, and other finance professionals, and are designed to deliver the financial skills that will give you a competitive edge as you pursue your career.

Leave a Comment


The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.