Equations for case study:
INCOME STATEMENT Net Sales (actual) Net Sales (in thousands) Net Sales (in millions) Net Sales CAGR 2014-2018 Revenue 1 Year Growth Rate Total Cost of Sales Gross Profit Gross Margin Operating Income Operating Margin Net Income (NI) NI 1 Year Growth Rate Return on Sales (ROS) Total Assets Total Stockholder Equity Return on Assets (ROA) Return on Equity (ROE) Earnings per Share (EPS) -Diluted MATTEL INCORPORATED FINANCIAL ANALYSIS FISCAL YEAR 2014-2018 $ US Numbers in Thousands, except EPS and where indicated 2014 2015 2016 2017 2018 $6,023,819,000.00 $5,702,613,000.00 $5,456,650,000.00 $4,881,951,000.00 $4,510,852,000.00 $5,702,613.00 $5,456,650.00 $6,023,819.00 $6,024.00 $4,881,951.00 $4,882.00 $4,510,852.00 $4,511.00 $5,703.00 $5,457.00 $3,022,797.00 $3,001,022.00 49.82% $653,714.00 10.85% $498,874.00 NMF* 8.28% $6,722,046.00 $2,949,071.00 7.42% 16.92% $1.45 BALANCE SHEET Current Assets Inventories Current Liabilities Current Ratio Quick Ratio Total Assets Total Stockholder Equity Total Debt Long Term Debt Debt to Asset Ratio (D/A) Long Term Debt to Asset (LTD/A) Debt to Equity Ratio (D/E) Property & Equipment, Net Fixed Asset Turnover (FAT) Total Asset Turnover (TAT) Total Cost of Sales Inventories Inventory Turnover *NMF = Not Meaningful | 2014 $3,185,951.00 $562,047.00 $1,088,949.00 2.93 2.41 $6,722,046.00 $2,949,071.00 $3,772,975.00 $2,100,000.00 56.13% 31.24% 127.94% $737,869.00 8.16 0.90 $3,022,797.00 $562,047.00 5.38 2015 2016 2017 2018 INCOME STATEMENT Net Sales (actual) Net Sales (in thousands) Net Sales (in millions) Net Sales CAGR 2014-2018 Revenue 1 Year Growth Rate Total Cost of Sales Gross Profit Gross Margin Operating Income Operating Margin Net Income (NI) NI 1 Year Growth Rate Return on Sales (ROS) Total Assets Total Stockholder Equity Return on Assets (ROA) Return on Equity (ROE) Earnings per Share (EPS) -Diluted MATTEL INCORPORATED FINANCIAL ANALYSIS FISCAL YEAR 2014-2018 $ US Numbers in Thousands, except EPS and where indicated 2014 2015 2016 2017 2018 $6,023,819,000.00 $5,702,613,000.00 $5,456,650,000.00 $4,881,951,000.00 $4,510,852,000.00 $5,702,613.00 $5,456,650.00 $6,023,819.00 $6,024.00 $4,881,951.00 $4,882.00 $4,510,852.00 $4,511.00 $5,703.00 $5,457.00 $3,022,797.00 $3,001,022.00 49.82% $653,714.00 10.85% $498,874.00 NMF* 8.28% $6,722,046.00 $2,949,071.00 7.42% 16.92% $1.45 BALANCE SHEET Current Assets Inventories Current Liabilities Current Ratio Quick Ratio Total Assets Total Stockholder Equity Total Debt Long Term Debt Debt to Asset Ratio (D/A) Long Term Debt to Asset (LTD/A) Debt to Equity Ratio (D/E) Property & Equipment, Net Fixed Asset Turnover (FAT) Total Asset Turnover (TAT) Total Cost of Sales Inventories Inventory Turnover *NMF = Not Meaningful | 2014 $3,185,951.00 $562,047.00 $1,088,949.00 2.93 2.41 $6,722,046.00 $2,949,071.00 $3,772,975.00 $2,100,000.00 56.13% 31.24% 127.94% $737,869.00 8.16 0.90 $3,022,797.00 $562,047.00 5.38 2015 2016 2017 2018
