1 PAGE Financial Analysis CALCULATIONS SPREADHEET Fiscal XXXXXXXXXXNEEDEDMattel Incorporated...

Question

1 PAGE Financial Analysis CALCULATIONS SPREADHEET Fiscal XXXXXXXXXXNEEDED

Mattel Incorporated Spreadsheet Assignment

Instructions - MGMT 5355

1. Read “Mattel Incorporated in 2019: Hard Times in the Toy Industry” (Case 7 in Textbook).

2. Complete the Mattel Incorporated Spreadsheet with your calculations of the indicated (green boxes) financial ratios. Calculate your financial ratios for the spreadsheet from the PDF files of the company’s Income Statements and Balance Sheets for XXXXXXXXXXMergent Online Financial Statements). NOTE: Use the “Commonly Used Financial Ratios” PDF file formulas for the financial ratio calculations. TIP: Use n=4 in your CAGR calculation. NOTE: Use the Net Income (Loss) per share – diluted as the answer for the EPS (diluted) line on your spreadsheet.

NOTE: Total Debt (Liabilities) can be calculated two ways: (1) Total Current Liabilities line PLUS Total Noncurrent Liabilities line. OR (2) Total Assets line MINUS Total Stockholder’s Equity line.

Submission Instructions: • Upload one file to Blackboard (the completed spreadsheet in .XLS or .XLSX format) on 11/18/2022 by 2pm CST

mattel-incorporated-spreadsheet-px4b02wo.xlsx mattel-incorporated-in-2019-ttzdxkaq.html income-statement-4n0kj1gi.pdf balance-sheet-ghhh5mug.pdf reading-501dbnyf.pdf

Prince · Accepted Answer

Sheet1
		MATTEL INCORPORATED 
		Financial Analysis Fiscal 2015-2019
		Numbers in Thousands, except where indicated
		2015	2016	2017	2018	2019
	INCOME STATEMENT
	Net Sales ($ actual)	$5,702,613,000	$5,456,650,000	$4,881,951,000	$4,510,852,000	$4,504,571,000
	Net Sales (in thousands)	$5,702,613	$5,456,650	$4,881,951	$4,510,852	$4,504,571
	Net Sales (in millions)	$5,703	$5,457	$4,882	$4,511	$4,505
	Net Sales (in billions)	$5.70	$5.46	$4.88	$4.51	$4.50
	Net Sales 1 Year Growth Rate	---	-4.27%	-10.53%	-7.60%	-0.14%
	Net Sales CAGR 2015-2019					-5.73%
	Gross Profit	$2,806,358	$2,554,391	$1,820,829	$1,794,725	$1,980,779
	Gross Margin	49.21%	46.81%	37.30%	39.

1 PAGE Financial Analysis CALCULATIONS SPREADHEET Fiscal XXXXXXXXXXNEEDEDMattel Incorporated Spreadsheet AssignmentInstructions - MGMT 53551. Read “Mattel Incorporated in 2019: Hard Times in the Toy...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment