Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Introductory assignment to locate the key financial statements within a company's annual report/Form 10-K FSA Project to find a variety of items and calculate financial

Introductory assignment to locate the key financial statements within a company's annual report/Form 10-K

FSA Project to find a variety of items and calculate financial ratios using a company's annual report/Form 10-K All class members will use the same company, Mattel, Inc., which was used for the introductory assignment. Use Mattel's 2016 annual report/Form 10-K that is available here: http://www.annualreports.com/HostedData/AnnualReports/PDF/NASDAQ_MAT_2016.pdf

Here are the instructions for this project: UPLOADED AS IMAGES

image text in transcribed

image text in transcribed

Complete and submit this DOCUMENT BELOW, after converting it to a PDF document, to obtain full or partial credit for this project. On your answer sheet, use the page numbers of the actual report (not the PDF page numbers).

Here is the document we must put our answers on and submit.

Financial Statement Analysis Project

ANSWER SHEET

Name(s):

No.

Question

Page Number

Determine the average days to collect accounts receivable for Year 3. Do you feel this is reasonable considering your company's operations? Why or why not?

What is the allowance for uncollectible receivables for Year 2 and Year 3? What percent of the gross receivables portfolio is reserved for each of those years? Does this tell you anything about the companys concern for bad debts?

Calculate the inventory turnover for Year 3 and also the average days in inventory ratio. Is this reasonable considering your company's line of business? Explain.

What is the cost of property, plant, and equipment held by your company as of the end of Year 3?

What is the net book value of property, plant, and equipment as of the end of Year 3?

What method of depreciation (e.g., units of production, declining balance, straight line) is used for property, plant and equipment?

What is the amount of intangible assets owned by the company as of the end of Year 3? What kind are they (i.e., identify them)?

Calculate the current ratio for Year 2 and for Year 3. Explain the ratio and what the trend is telling you.

Compute the debt-to-assets ratio for Year 2 and Year 3. Explain whether debt is financing a larger or smaller proportion of the companys assets in Year 3 compared to Year 2. Is the company more or less risky from Year 2 to Year 3? Explain.

Prepare a schedule that reconciles retained earnings at the beginning of Year 3 with retained earnings at the end of Year 3. Use these three captions to reconcile Net Income/(Loss), Dividends, and Other.

What is the par value of the common stock?

How many shares of common stock are authorized at the end of Year 3?

How many shares of common stock are outstanding at the end of Year 3?

What is the total amount of cash dividends declared on common stock during Year 3? What is the total amount of cash dividends paid on common stock during Year 3? [Hint: They may not be the same amount.]

What percentage of net income did the company pay out in cash dividends? If the company did not pay cash dividends, why do you think it did not?

What is the amount of difference between net income and net cash provided (used) by operating activities for Year 3? What one or two items are most responsible for the difference?

How much cash did your company pay to purchase property, plant, and equipment during Year 3?

Did cash and cash equivalents increase or decrease from Year 2 to Year 3? By how much?

Financial Statement Analysis Project INSTRUCTIONS To complete the financial statement analysis project, use the company selected by your instructor, which you also used to complete the FSA introductory assignment. Complete the answer sheet, convert it to a PDF document, and submit it to Canvas There are 35 questions listed on the answer sheet, and because some of these questions may not directly apply to your company or you may not be certain of the answer, you are to select only 30 questions. Type your answer below each question that you select; the cell should expand to accommodate your answer. If you answer more than 30 questions, the first 30 questions that you answer will be the ones that are graded Make certain to follow these additional instructions and requirements 1. The questions refer to Year 1, Year 2, and Year 3. When determining which year to use for your specific company, use Year 3 as the most recent (current) year 2. Your company might include the results of other entities in the consolidated financial statements even though it owns less than 100%. What your company does not own is called noncontrolling interest. To be consistent, use the net income number from the income statement and total equity from the balance sheet that include the noncontrolling interest as shown in the screen captures below for Kellogg Company Net sales Cost of goods sold Selling, general and administrative expense Operating profit Interest expense Other income (expense), net Income before income taxes Income taxes Earnings (loss) from unconsolidated entities Net income Net income (loss) attributable to noncontrolling interests Net income attributable to Kellogg Company $ 14,580 9,517 4,039 $ 1,024 209 10 825 186 $ 633 $ 632 Total Kellogg Company equityX Noncontrolling interests Total equity Total liabilities and equity 2,789 62 2,851 S 15,153 Financial Statement Analysis Project INSTRUCTIONS To complete the financial statement analysis project, use the company selected by your instructor, which you also used to complete the FSA introductory assignment. Complete the answer sheet, convert it to a PDF document, and submit it to Canvas There are 35 questions listed on the answer sheet, and because some of these questions may not directly apply to your company or you may not be certain of the answer, you are to select only 30 questions. Type your answer below each question that you select; the cell should expand to accommodate your answer. If you answer more than 30 questions, the first 30 questions that you answer will be the ones that are graded Make certain to follow these additional instructions and requirements 1. The questions refer to Year 1, Year 2, and Year 3. When determining which year to use for your specific company, use Year 3 as the most recent (current) year 2. Your company might include the results of other entities in the consolidated financial statements even though it owns less than 100%. What your company does not own is called noncontrolling interest. To be consistent, use the net income number from the income statement and total equity from the balance sheet that include the noncontrolling interest as shown in the screen captures below for Kellogg Company Net sales Cost of goods sold Selling, general and administrative expense Operating profit Interest expense Other income (expense), net Income before income taxes Income taxes Earnings (loss) from unconsolidated entities Net income Net income (loss) attributable to noncontrolling interests Net income attributable to Kellogg Company $ 14,580 9,517 4,039 $ 1,024 209 10 825 186 $ 633 $ 632 Total Kellogg Company equityX Noncontrolling interests Total equity Total liabilities and equity 2,789 62 2,851 S 15,153

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing The Ultimate Guide To Performing Internal And External Audits

Authors: Greg Shields

1st Edition

1647483344, 978-1647483340

More Books

Students also viewed these Accounting questions