M7Q1 Redo (Related to Checkpoint 18.1) (Measuring firm liquidity) The following table contains current asset and current liability balances for Deere and Company (DE):a. Measure the liquidity of Deere & Co. for each year using the company's net working capital and current ratio.b. Is the trend in Deere's liquidity improving over this period?a. The company's net working capital for 2011 is $(Enter your answer in thousands of dollars.)... Data table($ thousands)Current assetsCash and cash equivalentsShort-term investmentsNet receivablesInventoryTotal current assetsCurrent liabilitiesAccounts payableShort-term/current long-term debtOther current liabilitiesTotal current liabilities2013Print2,290,40003,949,3003,016,2009,255,9006,546,4008,560,900015,107,3002012Done2,199,7001,589,3003,643,1002,206,5009,638,600(Click on the icon in order to copy its contents into a spreadsheet.)3,098,30010,376,4002,779,70016,254,40020111,625,40003,584,1001,935,4007,144,9004,611,1008,114,200012,725,300-X

Net working capital is a measure of short term liquidity for a company. It is computed as the…

Answered: (Related to Checkpoint 18.1) (Measuring…

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter9: Current Liabilities, Contingencies, And The Time Value Of Money

Section: Chapter Questions

Problem 9.2DC

See similar textbooks

Similar questions

Analyze and compare Zynga, Electronic Arts, and Take-Two Data (in millions) from recent financial statements of Zynga Inc. (ZNGA), Electronic Arts Inc. (EA), and Take-Two Interactive Software, Inc. (TTWO) are as follows: a. Compute the working capital for Year 2 and Year 1 for each company. b. Which company has the largest working capital? c. Compute the current ratio for Year 2 and Year 1 for each company. Round to one decimal place. d. For Year 2, rank the companies from most liquid to least liquid based upon the current ratio.
Mike Sanders is considering the purchase of Kepler Company, a firm specializing in the manufacture of office supplies. To be able to assess the financial capabilities of the company, Mike has been given the companys financial statements for the 2 most recent years. Required: Note: Round all answers to two decimal places. 1. Compute the following for each year: (a) return on assets, (b) return on stockholders equity, (c) earnings per share, (d) price-earnings ratio, (e) dividend yield, and (f ) dividend payout ratio. 2. CONCEPTUAL CONNECTION Based on the analysis in Requirement 1, would you invest in the common stock of Kepler?
As a first step, we need to estimate what percentage of MMMs capital comes from debt, preferred stock, and common equity. This information can be found on the firms latest annual balance sheet. (As of year end 2014, MMM had no preferred stock.) Total debt includes all interest-bearing debt and is the sum of short-term debt and long-term debt. a. Recall that the weights used in the WACC are based on the companys target capital structure. If we assume that the company wants to maintain the same mix of capital that it currently has on its balance sheet, what weights should you use to estimate the WACC for MMM? b. Find MMMs market capitalization, which is the market value of its common equity. Using the sum of its short-term debt and long-term debt from the balance sheet (we assume that the market value of its debt equals its book value) and its market capitalization, recalculate the firms debt and common equity weights to be used in the WACC equation. These weights are approximations of market-value weights. Be sure not to include accruals in the debt calculation.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. You have been asked to prepare a statement of cash flows for Prime Sports Gear for 2013. Review the worksheet called CASHFLOW that has been provided to assist you in preparing the statement. The worksheet has been designed so that as you make entries in columns D and F, column G will be automatically updated. For example, FORMULA1 should be entered as =B17+D17F17. Columns C and E are to be used to enter letter references for each of the debit and credit entries on the worksheet.
The comparative balance sheet of Prime Sports Gear, Inc., at December 31, the end of the fiscal year, is as follows: Additional data obtained from the records of Prime Sports Gear are as follows: a. Net income for 2013 was 121,610. b. Depreciation reported on income statement for 2013 was 46,500. c. Purchased 165,000 of new equipment, putting 90,000 cash down and issuing 75,000 of bonds for the balance. d. Old equipment originally costing 19,500, with accumulated depreciation of 7,950, was sold for 8,000. e. Retired 60,000 of bonds. f. Declared cash dividends of 64,000. g. Issued 1,500 shares of common stock at 27 cash per share. Open the file CASHFLOW from the website for this book at cengagebrain.com. First, enter the formulas. Then, complete the worksheet in the manner described next. According to the problem, cash increased from 39,600 to 67,210 during the year. This is a 27,610 increase. To record this increase on the worksheet, move to row 17. Since this is the first account you are analyzing, enter the letter a in column C. Then enter 27610 in column D (a debit since cash increased). This brings the year-end balance (column G) to 67,210, its proper balance. Now move to the bottom part of the statement where you see the categories Operating Activities, Investing Activities, and so on. The credit side of the entry has to be entered here. The proper space for this cash entry is on row 59. Enter the letter a in cell E59 and 27610 in cell F59. Notice the totals at the bottom of the page (row 60) now agree. The next account balance that changed is accounts receivable. It increased by 9,035. To enter this change on the worksheet, enter the letter b in cell C18 and 9035 in cell D18 (again, a debit since accounts receivable increased). This brings the year-end balance in column G to 121,250, its proper balance. The change in accounts receivable balance is an operating activity adjustment (as explained in your textbook). Enter the credit side of this entry in cells E34 and F34, and enter the explanation Increase in accounts receivable in cell A34. Note: Your textbook probably shows Net income as the first item under Operating Activities. We will get to that later. The sequence in which you enter items on this worksheet is not important. All other balance sheet accounts must be analyzed in the same manner, placing appropriate debit or credit entries in the top part of the worksheet to obtain the proper balances in column G, and then entering the second side of the entry in the appropriate row on the bottom part of the worksheet. You should use letter references to identify all entries. Also, you must enter a description of the entry in column A under the appropriate activity category. Although a sequence of analyzing the balance sheet from top to bottom is suggested here, this order is not necessary. As mentioned earlier, your textbook may specify a different sequence. Also, note that some accounts may have both debit and credit adjustments to them. The worksheet is not a substitute for a statement of cash flows, but it does provide you with all the numbers you need to properly prepare one. You will be done with your analysis when: a. The individual account balances at December 31, 2013, as shown on the worksheet (column G) equal those shown in the given problem data. b. The transaction column totals are equal (cells D60 and F60). c. The sum of the operating, investing, and financing activities (cell G59) equals the change in cash (cell D59 or F59). When you are finished, enter your name in cell A1. Save your completed file as CASHFLOW2. Print the worksheet when done. Also print your formulas. Check figure: Total credits at 12/31/2013 (cell G31), 860,460.
What do the following data, taken from a comparative balance sheet, indicate about the companys ability to borrow additional long-term debt in the current year as compared to the preceding year?
To get an overall picture of each company's capital structure, it is helpful to look at a the Key Ratios screen and then select the Financial Health tab. Common size balance sheet data are provided over a 10-year period. What, if any, are the major trends that emerge when you're looking at those data? Do those companies tend to have relatively high or relatively low levels of debt? Do these companies have significant levels of current liabilities? Have their capital structures changed over time? Use online resources to work on this chapter's questions. Please note that website information changes over time, and these changes may limit your ability to answer some of these questions. This chapter provides an overview of the effects of leverage and describes the process that firms use to determine their optimal capital structure. The chapter also indicates that capital structures tend to vary across industries and across countries. If you are interested in exploring these differences in more detail, the Morningstar website provides information about the capital structures of each of the companies it follows. The following discussion questions demonstrate how we can use this information to evaluate the capital structures for four restaurant companies: Cheesecake Factory (CAKE), Chipotle Mexican Grill (CMG), Ruby Tuesday (RT), and O'Charley's Inc. (CHUX).
To get an overall picture of each companys capital structure, it is helpful to look at a chart that summarizes the companys capital structure over the past decade. To obtain this chart, choose a company to start with and select FINANCIALS. Next, select MORE THOMSON REPORTS CHARTSCAPITAL STRICTURE. This should generate a chart that plots the companys total long-term debt, total common equity, and total current liabilities over the past decade. What, if any, are the major trends that emerge when youre looking at these charts? Do these companies tend to have relatively high or relatively low levels of debt? Do these companies have significant levels of current liabilities? Have their capital structures changed over time?

Recommended textbooks for you

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Entrepreneurial Finance

Finance

ISBN:

9781337635653

Author:

Leach

Publisher:

Cengage

SEE MORE TEXTBOOKS