Conduct financial analysis for Mattel for 2017, 2016, and 2015 using any six of the following financial
Fantastic news! We've Found the answer you've been seeking!
Question:
Conduct financial analysis for Mattel for 2017, 2016, and 2015 using any six of the following financial ratios:
the current ratio, return on equity, operating profit margin, coverage ratio, net profit margin, debt asset ratio, and debt to equity. show your work. tabulate your result.
Transcribed Image Text:
EXHIBIT 3 Net Sales 2017 are presented in Exhibit 3. Mattel, Inc. Consolidated Income Statements 2013-2017 (amounts in thousands of U.S. dollars, except per share, employee and stockholder data) 2017 $ 4,881,951 3,061,122 1,820,829 642,286 Cost of sales Gross profit (loss) Advertising & promotion expenses Other selling & administrative expenses Operating Income (loss) Interest expense Interest income Other non-operating income (expense), net Income (loss) before income I taxes Total deferred Income tax provision (benefit) Provision (benefit) for Income taxes Net Income (loss) Less net income allocable to participating restricted stock units Net Income (loss) applicable to common shares Weighted average shares outstanding-basic Weighted average shares outstanding-diluted Year end shares outstanding Net Income (loss) per share-basic Net Income (loss) per share-diluted Dividends declared per common share Total number of employees Number of common stockholders Source: Mergent Online. 1,521,366 (342,823) 10,5214 7,777 (64,727) (504,987) 436,802 548,849 (1,053,836) $ (1,053,836) 343,564 343,564 343,800 ($3.07) ($3.07) $0.91 28,000 27,000 2016 $5,456,650 2,902,259 2,554,391 634,947 1,400,211 519,233 95,118 9,144 (23,517) 409,742 1,236 91,720 318,022 1,377 $316,645 341,480 344,233 342,400 $0.93 $0.92 $1.52 32,000 28,000 2015 2014 $5,702,613 $6,023,819 2,896,255 2,806,358 717,852 1,547,584 540,922 85,270 7,230 1,033 463,915 4,133 94,499 369,416 3,179 $366,237 339,172 339,748 339,700 $1.08 $1.08 $1.52 31,000 29,000 3,022,797 3,001,022 733,243 1,614,065 653,714 79,271 7,382 5,085 586,910 8,142 88,036 498,874 4,028 $ 494,846 339,016 340,768 338,100 $1.46 $1.45 $1.52 31,000 30,000 2013 $6,484,892 3,006,009 3,478,883 750,205 1,560,575 1,168,103 78,505 5,555 3,975 1,099,128 19,632 195,184 903,944 8,335 $ 895,609 343,394 347,459 339,300 $2.61 $2.58 $1.44 29,000 31,000 EXHIBIT 3 Net Sales 2017 are presented in Exhibit 3. Mattel, Inc. Consolidated Income Statements 2013-2017 (amounts in thousands of U.S. dollars, except per share, employee and stockholder data) 2017 $ 4,881,951 3,061,122 1,820,829 642,286 Cost of sales Gross profit (loss) Advertising & promotion expenses Other selling & administrative expenses Operating Income (loss) Interest expense Interest income Other non-operating income (expense), net Income (loss) before income I taxes Total deferred Income tax provision (benefit) Provision (benefit) for Income taxes Net Income (loss) Less net income allocable to participating restricted stock units Net Income (loss) applicable to common shares Weighted average shares outstanding-basic Weighted average shares outstanding-diluted Year end shares outstanding Net Income (loss) per share-basic Net Income (loss) per share-diluted Dividends declared per common share Total number of employees Number of common stockholders Source: Mergent Online. 1,521,366 (342,823) 10,5214 7,777 (64,727) (504,987) 436,802 548,849 (1,053,836) $ (1,053,836) 343,564 343,564 343,800 ($3.07) ($3.07) $0.91 28,000 27,000 2016 $5,456,650 2,902,259 2,554,391 634,947 1,400,211 519,233 95,118 9,144 (23,517) 409,742 1,236 91,720 318,022 1,377 $316,645 341,480 344,233 342,400 $0.93 $0.92 $1.52 32,000 28,000 2015 2014 $5,702,613 $6,023,819 2,896,255 2,806,358 717,852 1,547,584 540,922 85,270 7,230 1,033 463,915 4,133 94,499 369,416 3,179 $366,237 339,172 339,748 339,700 $1.08 $1.08 $1.52 31,000 29,000 3,022,797 3,001,022 733,243 1,614,065 653,714 79,271 7,382 5,085 586,910 8,142 88,036 498,874 4,028 $ 494,846 339,016 340,768 338,100 $1.46 $1.45 $1.52 31,000 30,000 2013 $6,484,892 3,006,009 3,478,883 750,205 1,560,575 1,168,103 78,505 5,555 3,975 1,099,128 19,632 195,184 903,944 8,335 $ 895,609 343,394 347,459 339,300 $2.61 $2.58 $1.44 29,000 31,000
Expert Answer:
Answer rating: 100% (QA)
To conduct a financial analysis for Mattel for the years 2017 2016 and 2015 we will use the following six financial ratios Current Ratio This ratio measures the companys ability to cover shortterm lia... View the full answer
Related Book For
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen
Posted Date:
Students also viewed these accounting questions
-
Mugs Company Comparative Balance Sheet December 31, 2007 2007 2006 Assets Cash $ 25,000 $ 40,000 Marketable securities 20,000 60,000 Accounts Receivable (net) 40,000 30,000 Inventory 150,000 170,000...
-
Identify each of the following financial ratios as follows: Profitability ratio (P) Asset management ratio (A) Liquidity ratio (L) Solvency ratio (S) ...... a. Inventory turnover ...... b. Debt...
-
Following are Cisco Systems sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its year ended July 31, 2016 ($ millions). Sales $49,247 Net operating profit after tax...
-
Over the last five years, corporation A has been consistently profitable. Its earnings before taxes were as follows: Year 1 2 3 4 5 Earnings $1,300 $3,100 $4,000 $5,300 $4,500 If the corporate tax...
-
In a general equilibrium analysis with two substitute goods, X and Y, explain what would happen to the price in market X if the supply of good Y increased (i.e., if the supply curve for good Y...
-
Sundaram-Clayton Ltd is a member of the TVS group, one of the largest automotive components manufacturing groups in India, with total sales revenue of more than USD 2.5 billion. The group has been...
-
Eastern Engines Ltd has a policy of maintaining a finished goods inventory balance at the end of a month equal to 25% of the sales requirements of the following month. The ending inventory balance on...
-
Brenda Company reported the following information for November and December 2014. Brendas ending inventory at December 31 was destroyed in a fire. Instructions (a) Compute the gross profit rate for...
-
You are a correctional counselor assigned to James, a 17-year-old boy who was charged with robbery after he held up a cab driver while holding a knife to his throat. James was soon apprehended by...
-
One of the shops in hackerMall is offering discount coupons based on a puzzling porblem. There are n tags, where each tag has a value denoted by val [ [ i ] . ] . A customer needs to choose teh tags...
-
Set up the Project Priority Evaluation Form (adapt Fig 2.5 & 2.6) in Excel and make Excel do all of the calculations to determine total weighted scores. (see below for example) Based on the...
-
The news coverage of Ukraine's war with Russia began to garner more viewership in the United States when personal interviews with the victims were telecast. Which important characteristic of...
-
Break down to put into a powerpoint 1.What cultural differences of values and behaviors are most important to be aware of? 2.What basic communication concepts need to be understood to overcome...
-
How might you apply Psychological Disorders learning to your daily life?
-
Complete the following forms for AMI's corporate tax return for 2022: Form 1120: U.S. Corporation Income Tax Return (all six pages) Form 1125-A: Cost of Goods Sold Form 4562: Depreciation and...
-
Is Mountain Man Light feasible for Mountain Man Brewing Company? What is required for Mountain Man Light to break even in one year? In two years? What cannibalization rate is reasonable? Include a...
-
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below:...
-
Perform the indicated operations. In designing a cam for a fire engine pump, the expression is used. Simplify this expression. (3) (3 4 32
-
What is the quickest way to get help while in Excel?
-
Kellys Boutique is contemplating several alternative means of financing an expansion. One alternative is to borrow $425,000 from a local bank; another alternative is to borrow this amount from...
-
How do you add a new series of data to an existing chart?
-
The MINITAB commands will create a normal scores plot from observations that were set in C1. (MINITAB uses a variant of the normal scores, \(m_{i}\), that we defined.) Construct a normal scores plot...
-
With reference to the preceding exercise, find the corresponding distribution function and use it to determine the probabilities that a random variable having this distribution function will take on...
-
Use the computing formula for \(\sigma^{2}\) to rework part (b) of the preceding exercise. Data From Preceding Exercise Determining a joint cumulative distribution function Find the joint cumulative...
Study smarter with the SolutionInn App