No Thanks

Get 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

September 9th, 2011| Written By The Wall Street Prep Team 0
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 On:

Written by The Wall Street Prep Team

support@wallstreetprep.freshdesk.com

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

X

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.