how do I calculate the gross profit margin, highlighted in yellow. using the information given on the left.

Gene miller Preject sxcel guide _xpr202011) - Formulas Data Review View File Home Insert Page Layout Help IB. Ross Stores, Inc. (NMS: ROST) L + 3 Pro Forma Balance Sheet 4 Report Date Scale 6 Cash & cash equivalents 7 Short-term investments 8 Accounts receivable 9 Merchandise inventory 10 Prepaid expenses & other current assets 11 Deferred income taxes 12 Total current assets 13 Property & equipment, gross 14 Less accumulated depreciation & amortizatior 15 Property & equipment, net 16 Long-term investments 17 other long-term assets 18 Total assets 2018 Thousands 1,412,912 0 96,711 1,750,442 143,954 0 3,404,019 5,256,708 2,781,507 2,475,201 125 194,346 6,073,691 2017 Thousands 1,290,294 512 87,868 1,641,735 130,748 0 3.151,157 4,908,179 2 ,525,715 2,382,464 712 187,718 5,722,051 3 YR Avg o EFL What is average total assets? (current year assets prior year assets)/2 For examples: 2018's Average total assets (2018's total assets+2017's total assets)/2 2016 2015 2017's Average total assets (2017's total assets 2016's total assets)/2 Thousands Thousands 2016's Average total assets (2016's total assets+2015's total assets)/2 T 1,111,599 761,602 o 1,737 75,154 73,627 Ross Stores, Inc. 1,512,886 1,419,104 ANCIAL STATEMENT OF RATIOS 113,410 116, 125 0 0 2018 2017 2016 2,813,049 2,372,195 L Profitability ratios 4,591,254 4,339,909 gross profit margin 2,263,206 1,997,003 operating expense margin 2,328,048 2,342,906 profit margin 1,288 1.331 return on assets 0.27 0.25 0.22 166,966 152,687 return on equity 5,309,351 4,869,119 11. Productivity ratios: 1,021,735 9 45,559 Accounts Receivable Turnover 162.35 173.41 172.96 398, 126 376,522 days sales outstanding 316,492 280,766 Inventory Turnover 16,153 0 Days inventory outstanding 0 0 Accounts Payable turnover 1,752,506 1,602,847 Days payable outstanding 396,493 396,025 Cash Conversion Cycle 290,950 268,168 PPE Turnover 121,385 130,088 2,561,334 2,397,128 III. Coverage ratios: Total liabilities-to-equity 3,919 4,023 Total debt to equity 1,215,715 1,122,329 cash from operations to total debt 6.61 272,846 229,525 Times interest earned 0.25 169.57 1,177,104 431,596 363,035 37,749 20 Accounts payable 21 Accrued expenses & other current liabilities 22 Accrued payroll & benefits 23 Income taxes payable 24 Current portion of long-term debt 25 Total current liabilities 26 Long-term debt 27 Total other long-term liabilities 28 Deferred income taxes 29 Total Liabilities 1,059,844 431,706 349,879 0 84,973 1.926,402 311,994 348,541 85,806 2,672,743 2,009,484 312,440 321,713 124,308 2,767,945 31 common stock 32 Additional paid-in capital 33 Treasury stock 3,682 1,375,965 372,663 3,796 1,292,364 318, 279 ROSS common size ROSS comparative ROSS ratios TJX common size TJX comparaitve TuX ratios Ready Type here to search Auta Savet File Home H D Insert - Page Layout Project eccel guide ,pr202011) Formulas Data Review View Genc miller Help - Commer Share L M N O 3,6823 ,796 1,375,965 1,292,364 372,663 318,279 Total debt to equity Cash from operations to total debt Times interest earned 4. 243 .93 31 Common stock 32 Additional paid in capital 33 Treasury stock 34 Accumulated other comprehensive income 35 Retained earnings (accumulated deficit) 1 36 Total stockholders' equity 1 4.93 3,919 1,215,715 272,846 91 1,801,138 2,748,017 4,023 1,122,129 229,525 182 1,574,982 2,471,991 2,298,762 3,305,746 2,071,400 3,049,308 IV. Liquidity Current ratio lQuick ratio Ross Stores, Inc. (NMS: ROST) Ae 44 Pro Forma Income Statement 45 Report Date 46 Scale 47 Sales 48 Cost of goods sold 49 Gross Profit 50 Selling general & administrative expense 51 Interest expense S2 Earnings (loss) before taxes 53 Provision (benefits) for taxes on earnings 54 Net earnings (loss) 2018 Thousands 14,983,541 10,726,277 4,257,264 2,216,550 10,162 2,050,876 463,419 1,587,457 2017 Thousands 14,134,732 10,042,638 4,092,094 2,043,698 7,676 2,040,720 677,967 1,362,753 2016 Thousands 12,866,757 9,173,705 3,693,052 1,890,408 16,488 1,786,156 668,502 1,117,654 2015 Thousands 11,939,999 8,576,873 3,363,126 1,738,755 12,612 1,611,759 591,098 1,020,661 S. s Ross Stores, Inc. (NMS: ROST) 60 Additional Information 61 Report Date 62 Scale 63 market price per share ROSS common size 2018 2017 2016 Thousands Thousands Thousands 117 89 8025 65.6 ROSS comparative ROSS ratios TX common size 2015 Thousands 53.81 TX comparaite TIX ratios Type here to search Gross Profit 50 Selling, general & administrative expense 51 Interest expense 52 Earnings (loss) before taxes 53 Provision (benefits) for taxes on earnings 54 Net earnings (loss) 2,216,550 - 10,162 2,050,876 463,419 1,587,457 4,092,094 2,043,698 7,676 2,040,720 677,967 1,362,753 3,693,052 1,890,408 16,488 1,786,156 6 68,502 1,117,654 3,363,126 1,738,755 12,612 1,611,759 591,098 1,020,661 58 Ross Stores, Inc. (NMS: ROST) 60 Additional Information: 61 Report Date 62 Scale 63 market price per share 64 Weighted average shares outstanding - basic 65 Weighted average shares outstanding - dilute 66 Year end shares outstanding 67 Net earnings (loss) per share - basic 68 Net earnings (loss) per share - diluted 69 Dividends per common share 2018 Thousands 117.89 369,533 372,678 368,242 4.3 4.26 0.9 2017 Thousands 80.25 381,174 384,329 379,618 3.58 3.55 0.64 2016 Thousands 65.6 392,124 394,958 391,893 2.85 2.83 0.54 2015 Thousands 53.81 403,034 406,405 402,339 2.53 2.51 0.47 70 Net cash flows from operating activties 2,066,677 1,681,278 1,558,851 1,326,252 ROSS rommon Size ROSS comparative ROSS ratios TUX common size TUX comparaitve TJX ratios