This YearLast YearAssets Current assets: Cash$360,000 $310,000 Marketable securities220,000 80,000 Accounts receivable, net775,000 700,000 Inventory925,000 750,000 Other current assets355,000 195,000 Total current assets2,635,000 2,035,000 Plant and eqipment, net1,975,000 1,800,000 Other assets75,000 100,000 Total assets$4,685,000 $3,935,000 Liabilities and Stockholders' Equity Current Liabilities: Accounts payable$250,000 $225,000 Short-term bank loans750,000 600,000 Accrued payables550,000 395,000 Other current liabilities275,000 223,400 Total current liabilities1,825,000 1,443,400 Bonds payable, 10%575,000 400,000 Total liabilities2,400,000 1,843,400 Stockholders' equity: Common stock1,150,000 1,150,000 Retained earnings1,135,000 941,600 Total stockholders' equity2,285,000 2,091,600 Total liabilities and stockholders' equity$4,685,000 $3,935,000 Zimmer, Inc. Income Statement This Year Sales (all on acount)$4,980,000 Cost of goods sold2,988,000 Gross margin1,992,000 Selling and administrative expenses Operating expenses985,500 Depreciation and amortization410,500 General and administrative expenses150,000 Total selling and administrative expenses1,546,000 Net operating income446,000 Interest expense60,000 Net income before taxes386,000 Income taxes 135,100 Net income$250,900 Additional information: Dividend per share paid in current year $1.00 Market price of shares at year end$42.00 Par value of common stock per share$20.00 Number of shares outstanding Required: Compute the following ratios for the current year only: (Use cells B8 to C52 from the given information to complete this question.) Gross margin percentage Current ratio (use the Excel ROUND function rounded to two decimal places) Acid-test ratio (use the Excel ROUND function rounded to two decimal places) Accounts receivable turnover (use the Excel ROUND function rounded to two decimal places) Days' sales uncollected (use the Excel ROUNDUP function rounded to the nearest whole day) Inventory turnover ratio (use the Excel ROUND function rounded to two decimal places) Days' sales in inventory (use the Excel ROUNDUP function rounded to the nearest whole day) Debt-to-equity ratio (use the Excel ROUND function rounded to two decimal places) Times interest earned (use the Excel ROUND function rounded to two decimal places) Book value per share (use the Excel ROUND function rounded to two decimal places) Earnings per share (use the Excel ROUND function rounded to two decimal places) Dividend payout ratio (use the Excel ROUND function rounded to three decimal places) Dividend yield ratio (use the Excel ROUND function rounded to three decimal places) Price-earnings ratio (use the Excel ROUND function rounded to two decimal places)

Since you have posted multiple subparts at a time. As per guidelines I can solve only first three…

Answered: This Year Last Year Assets Current…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question




	This Year	Last Year
Assets
Current assets:
Cash	$360,000	$310,000
Marketable securities	220,000	80,000
Accounts receivable, net	775,000	700,000
Inventory	925,000	750,000
Other current assets	355,000	195,000
Total current assets	2,635,000	2,035,000
Plant and eqipment, net	1,975,000	1,800,000
Other assets	75,000	100,000
Total assets	$4,685,000	$3,935,000
Liabilities and Stockholders' Equity
Current Liabilities:
Accounts payable	$250,000	$225,000
Short-term bank loans	750,000	600,000
Accrued payables	550,000	395,000
Other current liabilities	275,000	223,400
Total current liabilities	1,825,000	1,443,400
Bonds payable, 10%	575,000	400,000
Total liabilities	2,400,000	1,843,400
Stockholders' equity:
Common stock	1,150,000	1,150,000
Retained earnings	1,135,000	941,600
Total stockholders' equity	2,285,000	2,091,600
Total liabilities and stockholders' equity	$4,685,000	$3,935,000

Zimmer, Inc.
Income Statement
	This Year
Sales (all on acount)	$4,980,000
Cost of goods sold	2,988,000
Gross margin	1,992,000
Selling and administrative expenses
Operating expenses	985,500
Depreciation and amortization	410,500
General and administrative expenses	150,000
Total selling and administrative expenses	1,546,000
Net operating income	446,000
Interest expense	60,000
Net income before taxes	386,000
Income taxes	135,100
Net income	$250,900

Additional information:
Dividend per share paid in current year	$1.00
Market price of shares at year end	$42.00
Par value of common stock per share	$20.00

Number of shares outstanding

Required:
Compute the following ratios for the current year only:

(Use cells B8 to C52 from the given information to complete this question.)

Gross margin percentage
Current ratio (use the Excel ROUND function rounded to two decimal places)
Acid-test ratio (use the Excel ROUND function rounded to two decimal places)
Accounts receivable turnover (use the Excel ROUND function rounded to two decimal places)
Days' sales uncollected (use the Excel ROUNDUP function rounded to the nearest whole day)
Inventory turnover ratio (use the Excel ROUND function rounded to two decimal places)
Days' sales in inventory (use the Excel ROUNDUP function rounded to the nearest whole day)
Debt-to-equity ratio (use the Excel ROUND function rounded to two decimal places)
Times interest earned (use the Excel ROUND function rounded to two decimal places)
Book value per share (use the Excel ROUND function rounded to two decimal places)
Earnings per share (use the Excel ROUND function rounded to two decimal places)
Dividend payout ratio (use the Excel ROUND function rounded to three decimal places)
Dividend yield ratio (use the Excel ROUND function rounded to three decimal places)
Price-earnings ratio (use the Excel ROUND function rounded to two decimal places)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.