Calculating SG&A margin in the Colgate case study

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

Read More From: Quick Lessons
The Wall Street Prep Team

Written by The Wall Street Prep Team

info@wallstreetprep.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

You must be logged in to post a comment.