Please, I need help with the financial ratios tab on the excel spreadsheet. This compares Johnson&Johnson with Kimberly-Clark Corporation. Specifically, I need help with week 2: Submit the Excel worksheet with the calculations discussed in part 2 above. and section 2: Perform the calculations listed on the Excel spreadsheet for both companies.

PROJECT INFORMATION:

You are going to review and analyze the financial statements of Johnson & Johnsonand compare that to a publicly traded corporation.The list of companies to select from is outlined below. Please pick the publicly traded company assigned to your last name as instructed.You will also be using an Excel spreadsheet to perform these calculations Excel Support_to submit(1).xls. The financial statements for Johnson &Johnson as well as your assigned publicly tradedcompany are found on the same Excel spreadsheet that you will use to submit Part 2 of your assignment. Your findings will be presented to the class as if you were presenting the information to a group of investors.

Each student will use Company A: Johnson & Johnson and compare that company to a company found in the Company B list below. You must use the Company B assigned to your last name.

Company B:

If your last name begins with A - F, use Caterpillar, Inc.

If your last name begins with G - K, use Kimberly-Clark Corporation

If your last name begins with L - R, use CostcoWholesale Corporation

If your last name begins with S - Z, use Staples, Inc. and Subsidiaries

Course objectives covered:1, 4, 5, 6

PROJECT REQUIREMENTS:

This project is split into four (4) parts with one (1) part due each week of the course. Based on your readings, use of technology, literature, and other sources, you will incorporate the following into your reports (do not simply list the question and provide an answer; incorporate the information into a well written report or presentation):

1. Go to the SEC.gov website to research the requirements of publicly traded companies relating to financial reporting. Research additionalbackground information on the publicly traded corporation you selected (Company B) - when the corporation began in business, how it came to be, where the corporate headquarters are, where they do business, what their product/service line is, who they offer their product / service to, etc.
2. Perform the calculations listed on the Excel spreadsheet for both companies.
3. Explain your findings (using the SEC.gov website as well as other resources):Does each company appear to be able to pay their current obligations? Why or why not?
4. How are the companies currently financed? This may be with common stock, preferred stock, bonds, leases, or any combination of them.Do you think the financing is appropriate for each company?
5. Which method of depreciation does the publicly traded company use?
6. For the publicly traded company explain how you would improve the distribution or product/service line and to whom you would offer it to, based on the financial health of the company. Stating there are no improvements is not acceptable.
7. Do they have a code of ethics?
8. Which company do you think would be the better investment and why?
9. Present your findings

Writing Activity:

ForWeek 1 and Week 3 you will submit a 1 page report with at least 1 reference from the Keiser University library.

All written documents and sources used are to be submitted in APA format (use the writing center if needed).APA Formatting & Style Guide_2_.pdf

Technology/Collaborative Activity:

You will be presentingand discussing your findings to the class usingthe voice-over feature in PowerPoint or YouTube. Please be sure the audio is clear and the file or link is accessible in the Week 4 Presentation discussion board.

You will be using Excel to create spreadsheets.

Assignment Due Date Schedule:

Week 1:Submit a 1 page report for part 1 above with background information on the publicly traded company you selected.

Week 2:Submit the Excel worksheet with the calculations discussed in part 2 above.

Week 3: Submit a 1 page report for part 3 above explaining your findings as instructed.

Week 4:Present and discuss your findings, including the financial calculations, for part 4 above.

Your Name: Use the additional worksheets as reference for the Financial Statements of Johnson & Johnson as well as your assigned Publicly Traded Company 1. Calculate the following financial ratios : a. $ $ $ Formula $ $ $ Formula $ $ Formula $ $ Formula $ $ Formula $ $ Formula Inventory turnover ratio (Assume that all purchases are on credit unless other information is given.) Cost of goods sold Average inventory Inventory turnover ratio g. $ $ Formula Number of days' sales in receivables or uncollected (Consider 365 days in a year) Current receivable Net sales Number of days f. $ $ Formula Debt-to-equity ratio Total liabilities Total equity Debt-to-equity ratio e. $ $ Formula Return on common stockholders' equity Net income Preferred dividends Average common stockholder's equity Return on common stockholders' equity d. $ $ Formula Profit Margin Ratio Net income Net sales Profit Margin Ratio c. Publicly Traded Company Current ratio Current assets Current liabilities Current ratio b. Johnson & Johnson $ $ Formula $ $ Formula $ $ Formula $ $ Formula Number of days' sales in inventory (Consider 365 days in a year) Merchandise Inventory Cost of good sold Number of days JOHNSON & JOHNSON BALANCE SHEET At December 31, 2015 and December 31, 2014 (Dollars in Millions Except Share and Per Share Amount) Assets Current Assets Cash and cash equivalents Marketable securities Accounts receivable trade, less allowance for doubtful accounts $268 (2014, $275) Inventories Prepaid expenses and other receivables Total current assets Property, plant and equipment, net Intangible assets, net Goodwill Deferred taxes on income Other assets Total assets Liabilities and Shareholders' Equity Current Liabilities Loans and notes payable Accounts payable Accrued liabilities Accrued rebates, returns and promotions Accrued compensation and employee related obligations Accrued taxes on income Total current liabilities Long-term debt Deferred taxes on income Employee related obligations Other liabilities Total liabilities 2015 2014 13,732 24,644 14,523 18,566 $ 10,734 8,053 3,047 60,210 10,985 8,184 3,486 55,744 $ 15,905 25,764 21,629 5,490 4,413 133,411 16,126 27,222 21,832 6,202 3,232 130,358 7,004 6,668 5,411 5,440 2,474 750 27,747 3,638 7,633 6,553 4,010 2,751 446 25,031 12,857 2,562 8,854 10,241 62,261 15,122 2,447 9,972 8,034 60,606 3,120 (13,165) 103,879 93,834 22,684 71,150 133,411 3,120 (10,722) 97,245 89,643 19,891 69,752 130,358 $ $ $ Shareholders' equity Preferred stock - without par value (authorized and unissued 2,000,000 shares) shares) Accumulated other comprehensive income Retained earnings Less: common stock held in treasury, at cost (364,681,000 shares and 336,620,000 shares) Total shareholders' equity Total liabilities and shareholders' equity $ $ Adapted Material Reference: Johnson & Johnson (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml JOHNSON & JOHNSON STATEMENT OF EARNINGS At December 31, 2015 and December 31, 2014 (Dollars in Millions Except Share and Per Share Amounts) Net Sales to Customers Cost of goods sold Gross profit Selling, marketing and administrative expenses Research and development expense In-process research and development Interest income Interest expense, net of portion capitalized Other (income) expense, net Restructuring Earnings before provisions for taxes on income Provision for taxes on income Net income $ $ Net earnings per share Basic Diluted Cash dividends per share Average shares outstanding Basic Diluted Adapted Material Reference: Johnson & Johnson (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml 2015 70,074 21,536 48,538 21,203 2014 74,331 22,746 51,585 21,954 9,046 224 (128) 552 (2,064) 509 19,196 3,787 15,409 8,494 178 (67) 533 (70) 0 20,563 4,240 16,323 5.56 5.48 5.80 5.70 2.95 2.76 2771.80 2812.90 2815.20 2863.90 CATERPILLAR, INC. CONSOLIDATED FINANCIAL POSITION At December 31, 2015 and December 31, 2014 (Dollars in Millions) Assets Current Assets Cash and short-term investments Receivables - trade and other (use for ratio) Receivables - finance Deferred and refundable income taxes Prepaid expenses and other current assets Inventories Total current assets Property, plant and equipment - net Long-term receivables - trade and other Long-term receivables - finance Investments in unconsolidated affiliated companies Noncurrent deferred and refundable income taxes Intangible assets Goodwill Other assets Total assets Liabilities and Shareholders' Equity Current Liabilities Short-term borrowings: Machinery, Energy & Transportation Financial Products Accounts payable Accrued expenses Accrued wages, salaries and employee benefits Customer advances Dividends payable Other current liabilities Long-term debt due within one year: Machinery, Energy & Transportation Financial Products Total current liabilities Long-term debt due after one year: Machinery, Energy & Transportation Financial Products Liability for postemployment benefits Other liabilities Total liabilities 2015 2014 6,460 6,695 7,341 7,737 $ 8,991 1,526 1,046 9,700 34,418 9,027 1,739 818 12,205 38,867 $ 16,090 1,170 13,651 246 1,654 2,821 6,615 1,832 78,497 16,577 1,364 14,644 257 1,404 3,076 6,694 1,798 84,681 9 6,958 5,023 3,116 1,994 1,146 448 1,730 9 4,699 6,515 3,548 2,438 1,697 424 1,754 517 5,362 26,303 510 6,283 27,877 $ 9,004 16,243 8,843 3,219 63,612 9,493 18,291 8,963 3,231 67,855 $ - - $ 5,238 (17,640) 34,208 (6,997) 76 14,885 78,497 5,016 (15,726) 33,887 (6,431) 80 16,826 84,681 $ $ Shareholders' equity Common stock of $1.00 par value: Authorized shares: 2,000,000,000 Issued shares: (2015 and 2014 - 814,894,624 shares) at paid-in amount Treasury stock: (2015 - 232,572,734 shares and 2014 - 208,728,065 shares) at cost Profit employed in the business Accumulated other comprehensive income (loss) Noncontrolling interests Total shareholders' equity Total liabilities and shareholders' equity Adapted Material Reference: Caterpillar, Inc. (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml CATERPILLAR, INC. CONSOLIDATED RESULTS OF OPERATIONS At December 31, 2015 and December 31, 2014 (Dollars in Millions Except Per Share Data) Sales and revenues: Sales of Machinery, Energy & Transportation Revenues of Financial Products Total net sales and revenues Operating costs: Cost of goods sold Selling, general and administrative expenses Research and development expenses Interest expense of Financial Products Other operating (income) expenses Total operating costs Operating profit Interest expense excluding Financial Products Other income (expense) Consolidated profit before taxes Provision (benefit) for income taxes Profit of consolidated companies Equity in profit (loss) of unconsolidated affiliated companies Profit of consolidated and affiliated companies Less: Profit (loss) attributable to noncontrolling interests Net income 2015 2014 44,147 2,864 47,011 22,746 51,585 21,954 33,742 5,199 2,165 587 2,062 43,755 3,256 507 106 2,855 742 2,113 2,113 11 2,102 178 (67) 533 (70) 0 20,563 1,391 0 0 1,391 0 1,391 $ $ Adapted Material Reference: Caterpillar, Inc. (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml 1,391 4,240 (2,849) KIMBERLY-CLARK CORPORATION AND SUBSIDIARIES CONSOLIDATED BALANCE SHEET At December 31, 2015 and December 31, 2014 (Millions of dollars) Assets Current Assets Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Property, plant and equipment, net Investments in Equity Companies Goodwill Other assets Total assets Liabilities and Shareholders' Equity Current Liabilities Debt payable within one year Trade accounts payable Accrued expenses Dividends payable Total current liabilities Long-term debt Noncurrent Employee benefits Deferred income taxes Other liabilities Redeemable Preferred securities of subsidiaries Total liabilities 2015 2014 619 2,281 789 2,223 $ 1,909 617 5,426 1,892 655 5,559 $ 7,104 247 1,446 619 14,842 7,359 257 1,628 723 15,526 1,669 2,612 1,750 318 6,349 1,326 2,616 1,974 310 6,226 6,106 1,137 766 380 64 14,802 5,630 1,693 587 319 72 14,527 0 0 473 609 536 632 (2,972) 4,994 (3,278) (174) 214 40 14,842 (5,597) 8,470 (3,312) 729 270 999 15,526 $ $ $ Shareholders' equity Kimberly-Clark Corporation Preferred stock - no par value - authorized 20.0 million shares, none issued $ Common stock - $1.25 par value - authorized 1.2 billion shares; issued 378.6 and 428.6 million shares at December 31, 2015 and 2014, respectively Additional paid-in capital Common stock held in treasury, at cost - 17.7 and 63.3 million shares at December 31, 2015 and 2014, respectively Retained earnings Accumulated other comprehensive income (loss) Total Kimberly-Clark Corporation Stockholders' Equity (deficit) Noncontrolling interests Total stockholders' equity Total liabilities and equity $ Adapted Material Reference: Kimberly-Clark Corporation and Subsidiaries (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml KIMBERLY-CLARK CORPORATION AND SUBSIDIARIES CONSOLIDATED INCOME STATEMENT At December 31, 2015 and December 31, 2014 (Millions of dollars, Except Per Share Amounts) 2015 18,591 11,967 6,624 3,443 2014 19,724 13,041 6,683 3,709 1,568 1,613 17 (295) 1,335 (418) 917 149 1,066 (53) 1,013 453 2,521 18 (284) 2,255 (856) 1,399 146 1,545 50 1,595 Per Share Basis Net Income attributable to Kimberly-Clark Corporation Basic Continuing operations Discontinued operations Net Income 2.78 0.00 2.78 3.94 0.13 4.07 Diluted Continuing operations Discontinued operations Net Income 2.77 0.00 2.77 3.91 0.13 4.04 Cash dividends declared 3.52 3.36 Net sales Cost of goods sold Gross profit Marketing, research and general expenses Other (income) and expense, net Operating profit Interest income Interest expense Income from continuing operations before income taxes and equity interests Provision for income taxes Income from continuing operations before equity interests Income from discontinued operations, net of income taxes Net income Net income attributable to noncontrolling interests in continuing operations Net income attributable to Kimberly-Clark Corporation $ $ Adapted Material Reference: Kimberly-Clark Corporation and Subsidiaries (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml COSTCO WHOLESALE CORPORATION CONSOLIDATED BALANCE SHEETS At August 30 2015 and August 30, 2014 (Amounts in Millions Except Par Value and Share Data) Assets Current Assets Cash and cash equivalents Short-term investments Receivables, net Merchandise inventories Deferred income taxes and other current assets Total current assets 2015 2014 4,801 1,618 5,738 1,577 $ 1,224 8,908 748 17,299 1,148 8,456 669 17,588 $ 4,961 12,618 5,274 811 23,664 (8,263) 15,401 740 33,440 4,716 12,522 4,845 592 22,675 (7,845) 14,830 606 33,024 9,011 1,283 2,468 813 1,269 1,696 16,540 8,491 0 2,231 773 1,254 1,663 14,412 $ 4,864 1,193 22,597 5,093 1,004 20,509 $ 0 0 $ 2 5,218 (1,121) 6,518 10,617 226 10,843 33,440 2 4,919 (76) 7,458 12,303 212 12,515 33,024 $ Property and Equipment Land Buildings and improvements Equipment and fixtures Construction in progress Less accumulated depreciation and amortization Net property and equipment Other assets Total assets Liabilities and Shareholders' Equity Current Liabilities Accounts payable Current portion of long-term debt Accrued salaries and benefits Accrued member rewards Deferred membership fees Other current liabilities Total current liabilities Long-term debt, excluding current portion Deferred income taxes and other liabilities Total liabilities $ Shareholders' equity Preferred stock $.005 par value; 100,000,000 shares authorized; no shares issued and outstanding Common stock $.005 par value; 900,000,000 shares authorized; 437,952,000 and 437,683,000 shares issued and outstanding Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total Costco stockholders' equity Noncontrolling interests Total equity Total liabilities and equity Adapted Material Reference: Costco Wholesale Corporation (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml COSTCO WHOLESALE CORPORATION CONSOLIDATED STATEMENTS OF INCOME At August 30, 2015 and August 30, 2014 (Amounts in Millions Except Per Share Data) Revenue Net Sales Membership fees Total revenue Operating expenses Merchandise costs Selling, general and administrative Preopening expenses Operating income Other income (expense) Interest expense Interest income and other, net Income before income taxes Provision for income taxes Net income including noncontrolling interests Net income attributable to noncontrolling interests Net income attributable to Costco Net income per common share attributable to Costco Basic Diluted Shares used in calculation (000's) Basic Diluted Cash dividends declared per common share $ $ 2015 2014 113,666 2,533 116,199 110,212 2,428 112,640 101,065 11,445 65 3,624 98,458 10,899 63 3,220 (124) 104 3,604 1,195 2,409 (32) 2,377 (113) 90 3,197 1,109 2,088 (30) 2,058 5.41 5.37 4.69 4.65 439,455 442,716 6.51 438,693 442,485 1.33 Adapted Material Reference: Costco Wholesale Corporation (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml STAPLES, INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS At January 30, 2016 and January 31, 2015 (Dollar amounts in millions, except share data) Assets Current Assets Cash and cash equivalents Receivables, net Merchandise inventories, net Prepaid expenses and other current assets Total current assets Property and equipment: Land and buildings Leasehold improvements Equipment Furniture and fixtures Total property and equipment Less: accumulated depreciation Net property and equipment Intangible assets, net of accumulated amortization Goodwill Other assets Total assets Liabilities and Shareholders' Equity Current Liabilities Accounts payable Accrued expenses and other current liabilities Debt maturing within one year Total current liabilities Long-term debt, net of current maturities Other long-term obligations Total liabilities 2015 2014 825 1,899 627 1,928 $ 2,078 310 5,112 2,144 252 4,951 $ 908 1,184 2,902 967 5,961 4,375 1,586 274 2,653 547 10,172 948 1,231 2,825 1,016 6,020 4,314 1,706 335 2,680 636 10,308 1,894 1,353 17 3,264 1,867 1,330 92 3,289 $ 1,018 506 4,788 1,018 688 4,995 $ - - $ 1 5,010 (1,116) 6,900 (5,419) 5,376 8 5,384 10,172 1 4,935 (1,041) 6,829 (5,419) 5,305 8 5,313 10,308 $ $ Shareholders' equity Preferred stock, $.01 par value, 5,000,000 shares authorized; no shares issued Common stock, $.0006 par value, 2,100,000,000 shares authorized; issued and outstanding 946,964,792 and 645,723,603 shares at January 30, 2016 and 941,561,541 shares and 640,320,352 shares at January 31, 2015, respectively Additional paid-in capital Accumulated other comprehensive loss Retained earnings Less: treasury stock at cost, 301,241,189 shares at January 30, 2016 and January 31, 2015 Total Staples, Inc stockholders' equity Noncontrolling interests Total stockholders' equity Total liabilities and shareholders' equity Adapted Material Reference: Staples, Inc and Subsidiaries (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml STAPLES, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME At January 30, 2016 and January 31, 2015 (Dollars amounts in millions, except share data) 2015 21,059 15,545 5,514 2014 22,492 16,691 5,801 4,600 50 151 67 4,868 (5) 641 4,816 470 171 61 5,518 27 310 3 (139) (13) 492 113 379 3 (49) 4 268 133 135 0 379 0 135 Basic Earnings Per Common Share Continuing operations Discontinued operations Net income 0.59 0.00 0.59 0.21 0.00 0.21 Diluted Earnings per Common Share Continuing operations Discontinued operations Net income 0.59 0.00 0.59 0.21 0.00 0.21 Dividends declared per common share 0.48 0.48 Net sales Cost of goods sold Gross profit Operating expenses Selling, general and administrative expenses Impairment of goodwill and long-lived assets Restructuring charges Amortization of intangibles Total operating expenses (Loss) gain on sale of businesses and assets, net Operating income Other income (expense): Interest income Interest expense Other income (expense), net Income from continuing operations before income taxes Income tax expense Income from continuing operations Discontinued operations Loss from discontinued operations, net of income taxes Net income $ $ Adapted Material Reference: Staples, Inc and Subsidiaries (2015). Form 10-K 2015. Retrieved from SEC EDGAR website http://www.sec.gov/edgar.shtml