Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I please get hep with the calculations in the excel spreadsheet. Your Name: Use the additional worksheets as reference for the Financial Statements of

Can I please get hep with the calculations in the excel spreadsheet.

image text in transcribed Your Name: Use the additional worksheets as reference for the Financial Statements of Johnson & Johnson as well as your assigned Publicly Trad 1. Calculate the following financial ratios : a. Current ratio Current assets Current liabilities Current ratio b. Profit Margin Ratio Net income Net sales Profit Margin Ratio c. Return on common stockholders' equity Net income Preferred dividends Average common stockholder's equity Return on common stockholders' equity d. Debt-to-equity ratio Total liabilities Total equity Debt-to-equity ratio e. Number of days' sales in receivables or uncollected (Consider 365 days in a year) Current receivable Net sales Number of days f. 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. Number of days' sales in inventory (Consider 365 days in a year) Merchandise Inventory Cost of good sold Number of days nson as well as your assigned Publicly Traded Company Johnson & Johnson Publicly Traded Company $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ Formula Formula $ $ $ $ Formula Formula sider 365 days in a year) $ $ $ $ Formula Formula 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 $ Shareholders' equity Preferred stock - without par value (authorized and unissued 2,000,000 shares) $ Common stock - par value $1.00 per share (authorized 4,320,000,000 shares; issued 3,119,843,000 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 $ 2015 2014 13,732 14,523 24,644 18,566 10,734 10,985 8,053 8,184 3,047 3,486 60,210 55,744 15,905 16,126 25,764 27,222 21,629 21,832 5,490 6,202 4,413 3,232 133,411 130,358 7,004 3,638 6,668 7,633 5,411 6,553 5,440 4,010 2,474 2,751 750 446 27,747 25,031 12,857 15,122 2,562 2,447 8,854 9,972 10,241 8,034 62,261 60,606 - - 3,120 3,120 -13,165 -10,722 103,879 97,245 93,834 89,643 22,684 19,891 71,150 69,752 133,411 130,358 2015 Net Sales to Customers $ 70,074 Cost of goods sold 21,536 Gross profit 48,538 Selling, marketing and administrative expenses 21,203 Research and development expense 9,046 In-process research and development 224 Interest income -128 Interest expense, net of portion capitalized 552 Other (income) expense, net -2,064 Restructuring 509 Earnings before provisions for taxes on income 19,196 Provision for taxes on income Net income 3,787 $ 15,409 Net earnings per share Basic 5.56 Diluted 5.48 Cash dividends per share 2.95 Average shares outstanding Basic 2771.8 Diluted 2812.9 2014 74,331 22,746 51,585 21,954 8,494 178 -67 533 -70 0 20,563 4,240 16,323 5.8 5.7 2.76 2815.2 2863.9 2015 Assets Current Assets Cash and short-term investments $ 6,460 Receivables - trade and other (use for ratio) 6,695 Receivables - finance 8,991 Deferred and refundable income taxes 1,526 Prepaid expenses and other current assets 1,046 Inventories 9,700 Total current assets Property, plant and equipment - net Long-term receivables - trade and other Long-term receivables - finance Investments in unconsolidated affiliated companies $ 34,418 16,090 1,170 13,651 246 Noncurrent deferred and refundable income taxes 1,654 Intangible assets 2,821 Goodwill 6,615 Other assets 1,832 Total assets $ 78,497 Liabilities and Shareholders' Equity Current Liabilities Short-term borrowings: Machinery, Energy & Transportation $ 9 Financial Products 6,958 Accounts payable 5,023 Accrued expenses 3,116 Accrued wages, salaries and employee benefits 1,994 Customer advances 1,146 Dividends payable Other current liabilities 448 1,730 Long-term debt due within one year: Machinery, Energy & Transportation Financial Products Total current liabilities 517 5,362 26,303 Long-term debt due after one year: Machinery, Energy & Transportation 9,004 Financial Products 16,243 Liability for postemployment benefits 8,843 Other liabilities 3,219 Total liabilities $ 63,612 $ - 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 5,238 -17,640 34,208 Accumulated other comprehensive income (loss) -6,997 Noncontrolling interests 76 Total shareholders' equity Total liabilities and shareholders' equity 14,885 $ 78,497 2014 7,341 7,737 9,027 1,739 818 12,205 38,867 16,577 1,364 14,644 257 1,404 3,076 6,694 1,798 84,681 9 4,699 6,515 3,548 2,438 1,697 424 1,754 510 6,283 27,877 9,493 18,291 8,963 3,231 67,855 - 5,016 -15,726 33,887 -6,431 80 16,826 84,681 Sales and revenues: $ Sales of Machinery, Energy & Transportation 44,147 Revenues of Financial Products 2,864 Total net sales and revenues 47,011 Operating costs: Cost of goods sold 33,742 Selling, general and administrative expenses 5,199 Research and development expenses 2,165 Interest expense of Financial Products 587 Other operating (income) expenses 2,062 Total operating costs 43,755 Operating profit 3,256 Interest expense excluding Financial Products 507 Other income (expense) 106 Consolidated profit before taxes 2,855 Provision (benefit) for income taxes 742 Profit of consolidated companies 2,113 Equity in profit (loss) of unconsolidated affiliated companies - Profit of consolidated and affiliated companies 2,113 Less: Profit (loss) attributable to noncontrolling interests Net income 11 $ 2,102 22,746 51,585 21,954 178 -67 533 -70 0 20,563 4,240 16,323

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

Step: 3

blur-text-image

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

Mastering 21st Century Enterprise Risk Management

Authors: Gregory M Carroll

1st Edition

1483510441, 9781483510446

More Books

Students also viewed these Accounting questions

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago