Question

In: Accounting

Selected data from the financial statements of Italian Marble Co. and Brazil Stone Products for the...

Selected data from the financial statements of Italian Marble Co. and Brazil Stone Products for the year just ended follow. Assume that for both companies, dividends declared were equal in amount to net earnings during the year, and therefore stockholders' equity did not change. The two companies are in the same line of business.

Italian Marble Co. Brazil Stone Products
Total liabilities $ 200,000 $ 100,000
Total assets 800,000 400,000
Sales (all on credit) 1,850,000 1,060,000
Average inventory 240,000 140,000
Average receivables 200,000 100,000
Gross profit as a percentage of sales 40 % 30 %
Operating expenses as a percentage of sales 36 % 25 %
Net income as a percentage of sales 3 % 5 %

  

a. Compute the net income for each company.

b. Compute the net income as a percentage of stockholders' equity for each company.

c. Compute the accounts receivable turnover for each company.

d. Compute the inventory turnover for each company.

e. Which company is in a stronger financial position?

Compute the net income for each company.

Italian Marble Co. Brazil Stone Products
Net income

Compute the net income as a percentage of stockholders' equity for each company. (Round your answers to the nearest whole number.)

Italian Marble Co. Brazil Stone Products
Net income as a percentage of stockholders' equity 9 % %

Compute the accounts receivable turnover for each company. (Round your answers to the nearest whole number.)

Italian Marble Co. Brazil Stone Products
Accounts receivable turnover 9selected answer correct times
selected answer incorrect
times

Compute the inventory turnover for each company. (Round your answers to 1 decimal place.)

Italian Marble Co. Brazil Stone Products
Inventory turnover
selected answer incorrect
times
selected answer incorrect
times

Solutions

Expert Solution

Solution:

S. No. Particulars Italian Marble Co Brazil Stone Products
a Sales $1,850,000.00 $1,060,000.00
Net Income as percentage of Sales 3% 5%
Net Income(Sales * NI Percentage) $55,500.00 $53,000.00
b Net Income $55,500.00 $53,000.00
Total Assets $800,000.00 $400,000.00
Total Liabilities $200,000.00 $100,000.00
Stock holders equity (Assets - Liabilities) $600,000.00 $300,000.00
Net Income as percentage of stock holder's equity (Net Income / Stockholder equity*100) 9% 18%
c Sales $1,850,000.00 $1,060,000.00
Average Receivables $200,000.00 $100,000.00
Accounts Receivable Turnover (Sales / Average Receivables) 9.25 Times 10.60 Times
d Sales $1,850,000.00 $1,060,000.00
Gross Profit as a percentage of Sales 40% 30%
Gross Profit $740,000.00 $318,000.00
Cost of goods Sold (Sales - Gross Profit) $1,110,000.00 $742,000.00
Average Inventory $240,000.00 $140,000.00
Inventory Turnover Ratio (COGS / Average Inventory) 4.625 Times 5.30 Times

e. Net profit percentage, return on stock holder equity, accounts receivable turnover ratio and inventory turnover ratio of Brazil stone product is much better than Italian marble company. Hence Brazil stone product is in a stronger financial position.


Related Solutions

Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills,...
Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills, Inc., for its fiscal year ended May 25, 2014 ($ millions): Cash and Cash Equivalents $867.3 Net Cash from Operations 2,541.0 Sales 17,909.6 Stockholders' Equity 7,005.4 Cost of Goods Sold 11,539.8 Net Cash from Financing (1,824.1) Total Liabilities 16,140.3 Other Expenses, including income taxes 4,508.5 Noncash Assets 22,278.4 Net Cash from Investing (561.8) Net Income 1,861.3 Effect of exchange rate changes on cash (29.2)...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for its fiscal year ended July 30, 2016 ($ millions). Cash, ending year $7,631    Total liabilities $58,067 Cash from operating activities 13,570    Cash from financing activities (4,699) Sales 49,247    Noncash assets 114,021 Stockholders' equity 63,585    Cash from investing activities (8,117) Cost of goods sold 18,287    Net income 10,739 Total expense (other than cost of goods sold) 20,221    Cash, beginning...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 29, 2016 ($ millions): *Cash from financing activites includes the effects of foreign exhange rate fluctuations. Revenue $16,563.1 Cost of goods sold $10,733.6 Cash from operating activities 2,629.8 Cash, ending year 763.7 Cash, beginning year 334.2 Total liabilities 16,405.2 Stockholders' equity 5,307.1 Cash from investing activities 93.4 Noncash assets 20,948.6 Total expenses (other than cost of goods sold) 4,092.7...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 25, 2003 ($ millions): Revenue $10,506 Cash from operating activities 1,631 Cash, beginning year 975 Stockholders' equity 4,475 Noncash assets 17,524 Cash from financing activities (885) Cost of goods sold 6,109 Total expenses (other than cost of goods sold) 3,480 Cash, ending year 703 Total liabilities 13,752 Cash from investing activities (1,018) Prepare the income statement, the balance sheet,...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 29, 2011 ($ millions): Revenue $ 14,880.2 Cash from operating activities 1,526.8 Cash, beginning year 673.2 Stockholders' equity 6,612.2 Noncash assets 18,054.9 Cash from financing activities* (865.3) Cost of goods sold 8,926.7 Total expenses (other than cost of goods sold) 4,155.2 Cash, ending year 619.6 Total liabilities 12,062.3 Cash from investing activities (715.1) *Cash from financing activities includes the...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on assets for the year, presenting your answer in percentage terms, rounded to two decimal places. e.g. 20.00%. Sales $117,358 Gross profits $51,639 Operating profits (EBIT) $32,879 Earnings before taxes (EBT) $25,389 Net profits $24,739 Tax expense 8,000 Depreciation expense $13,207 Total assets, beg of year $80,302 Total assets, end of year $99,082 Total equity, beg of year $46,237 Total equity, end of year $53,675...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $649,000 Cost of goods sold 363,000 Gross profit $286,000 Selling and administrative expense 100,000 Operating income $186,000 Interest expense 50,000 Income before tax $136,000 Income tax expense (40%) 54,400 Net income $81,600 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $659,000 Cost of goods sold 397,000 Gross profit $262,000 Selling and administrative expense 100,000 Operating income $162,000 Interest expense 50,000 Income before tax $112,000 Income tax expense (40%) 44,800 Net income $67,200 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen Company: Sales revenue $657,000 Cost of goods sold 387,000 Gross profit $270,000 Selling and administrative expense 100,000 Operating income $170,000 Interest expense 50,000 Income before tax $120,000 Income tax expense (40%) 48,000 Net income $72,000 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the gross profit...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the gross profit margin, presenting your answer in percentage terms, rounded to two decimal places. e.g. 20.00%. Sales $107,262 Cost of goods sold $51,727 Operating profits (EBIT) $32,852 Earnings before taxes (EBT) $28,308 Net profits $18,706 Tax expense 8,310 Depreciation expense $14,562 Total assets, beg of year $89,075 Total assets, end of year $83,449 Total equity, beg of year $42,951 Total equity, end of year $40,310 Cash...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT