Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate gross profit margin, operating profit margin and net profit margin for last year, 2 years ago, and 3 years ago. Please provide the formula
Calculate gross profit margin, operating profit margin and net profit margin for last year, 2 years ago, and 3 years ago.
Please provide the formula you used.
ATTACHMENT 1- KELLY COMPANY CASE FINANCIAL AND COMPETITOR INDUSTRY INFORMATION KellyKellyKellyKelly Kelly Kelly Last Percent 2 Years Percent 3 years Percent kt Market Industry Global Global INCOME STATEMENTS Yearof Sales Agof Sales Ago of Sales Leader Leader Average ion ion ion SMillion Revenue Cost of Goods Sold 38.453 79.990 39.292 80.2% 41.786 80.2% 265,152 76.1% Gross Profit 48.127 100.0% 48.992 100.0% 52.102 100.0% 348,650 100.0% $25.00 80.0% 9.674 20.1% 9.700 19.8% 10.316 19.8% 83,498 23.9% 20.0% 7.893 16.4% 8.132 16.6% 7.659 14.7% xxxxxxx xxxxxx xxxxxxx Operating Expense General & Administrative Marketing Operating, Gen. Sell, & Admin. 1.059 686 XXAXxxX XXXKKX XXAXxxX XXXKKX xxxxxxx xxxxx xxxxxxx xxxxx xxxxxxx xxxxx 64,320 18.4% 15.0% 1,529 Interest Expense COGS and Total 0.8% 0.4% 47.983 99.7% 48.548 99.1% 50.695 97.3% 331,001 94.9% 96.6% Net Income Before 0.3% -p.444 0.9% 2.7% 17,649 5.1% 6,365 axes 048 469 0.9% 1.8% % Total 7.9% 1.8% 3.3% % Total 5.5% axes Net Income After 096 936 11,284 2.5% axes % Total % Total BALANCE SHEETS Cash & Equivalents Receivable SMillon Assets SMilln Assets SMillion Assets SMilln Assets 2.421 429 7.694 26.7% 8.155 27.8% 8.582 28.0% 34,375 22.8% 24.6% 1.0% 1.9% 440 469 1.5% 8373 1.4% 3,840 2.5% 2.2% Inventory Total Current Assets Land, Stores, 8.530 29.6% 9.064 30.9% 11.432 37.3% 46,588 30.8% 28.5% Distribution Centers, &Trucks 20.289 70.4% 20.268 69.1% 19.216 62.7% 104,605 69.2% 71.5% Total Assets 28.819 100.0% 29.332 100.0% 30.648 100.0% 151,193 100.0% $13.457 Accounts Payable Other Current Liabilities Total Current Liabilities Long Term Debt Stockholder's Equity Total Liabilities & Stockholder Equity 7.407 25.7% 6.921 23.6% 3.287 10.7% 28,371 18.8% 12.1% 5.043 17.5% 8.151 27.8% 6.554 21.4% 23,363 15.4% 12.450 43.2% 15.072 51.4% 9.831 32.1% 51,734 34.2% 22.2% 4.813 16.7% 2.407 8.2% 3.900 12.7% 37,886 25.1% 39.3% 11.556 40.1% *11.853 40.4% 16.917 55.2% 61,573 40.7% 38.5% 28.819 100.0% 29.332 100.0% 30.648 100.0% 151,193 100.0% $13.457 ear Stock Price Dividends *Equity withdrawal $6.25 0.00 $10.00 $13.13 0.00 in "2 years ago
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started