Question

The Hill Company reported the following results: Year 3 Year 2 Year 1 Income Statement Revenue...

The Hill Company reported the following results:

Year 3 Year 2 Year 1
Income Statement
Revenue 10,972 11,598 10,470
Cost of Goods Sold 8,942 8,767 7,901
Selling, General & Admin. Expenses 2,470 2,611 2,479
Interest expense 76 80 28
Net Income (516) 140 62
Balance Sheet
Assets
Cash 1,354 1,316 1,880
Prepaid expenses 202 522 125
Accounts receivable 375 250 231
Inventory 745 698 455
Property & equipment (net) 20,464 18,810 17,727
Total Assets 23,140 21,596 20,418
Liabilities
Accounts payable 2,824 743 678
Unredeemed gift cards 410 850 636
Notes Payable 15,457 18,048 17,024
Stockholders' Equity
Common Stock 985 545 815
Retained Earnings 3,464 1,410 1,265
Total Liabilities & Equity 23,140 21,596 20,418

1a. What is the company's debt ratio for Year 1? Convert your final answer to a percentage, round to one decimal place and enter without the "%" sign (e.g. a final answer of 0.105678 would be entered as 10.6).

1b.What is the company's gross profit ratio for Year 3? Convert your final answer to a percentage, round to one decimal place and enter without the "%" sign (e.g. a final answer of 0.105678 would be entered as 10.6).

1c.What is the company's net profit ratio for Year 2? Convert your final answer to a percentage, round to one decimal place and enter without the "%" sign (e.g. a final answer of 0.105678 would be entered as 10.6).

1d.What is the company's return on investment ratio for Year 1? Convert your final answer to a percentage, round to one decimal place and enter without the "%" sign (e.g. a final answer of 0.105678 would be entered as 10.6).

1e.Based on the three years of data, has the company's return on investment ratio has improved, worsened, or stayed the same?

Homework Answers

Answer #1

Answer 1a

company's debt ratio for Year 1= total liabilities / total assets = [678+636+17024] / 20418 = 18338/20418 = 0.90 or 89.8%

Answer 1b

Gross Profit % = Gross Profit / Sales

Year 3 = ( 10972 - 8942 ) / 10972 = 18.5%

Answer 1c

Net Profit % = net income / Sales

Year 2 = 140 / 11598 = 1.2%

Answer 1d

Return on Investment ratio year 1 = Net Income / total assets = 62/ 20418 *100 = 0.30%

Answer 1e

Based on the three years of data, the company's return on investment ratio has

b) worsened.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are researching Time Manufacturing and have found the following accounting statement of cash flows for...
You are researching Time Manufacturing and have found the following accounting statement of cash flows for the most recent year. You also know that the company paid $99.7 million in current taxes and had an interest expense of $49.7 million.    TIME MANUFACTURING Statement of Cash Flows ($ in millions) Operations Net income $ 190.0 Depreciation 95.7 Deferred taxes 20.7 Changes in assets and liabilities   Accounts receivable –19.7   Inventories 23.7   Accounts payable 18.7   Accrued expenses –10.7   Other 4.7 Total cash...
You are researching Time Manufacturing and have found the following accounting statement of cash flows for...
You are researching Time Manufacturing and have found the following accounting statement of cash flows for the most recent year. You also know that the company paid $98.2 million in current taxes and had an interest expense of $48.2 million.    TIME MANUFACTURING Statement of Cash Flows ($ in millions) Operations Net income $ 175.0 Depreciation 94.2 Deferred taxes 19.2 Changes in assets and liabilities   Accounts receivable –18.2   Inventories 22.2   Accounts payable 17.2   Accrued expenses –9.2   Other 3.2 Total cash...
Hyrkas Corporation's most recent balance sheet and income statement appear below Balance Sheet December 31, Year...
Hyrkas Corporation's most recent balance sheet and income statement appear below Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: Cash $ 230 $ 350 Accounts receivable, net 380 400 Inventory 350 320 Prepaid expenses 20 20 Total current assets 980 1,090 Plant and equipment, net 1,240 1,380 Total assets $ 2,220 $ 2,470 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 320 $ 350 Accrued liabilities 50...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):              Sales   $   21,800 Variable expenses      12,600 Contribution margin      9,200 Fixed expenses      7,452 Net operating income   $   1,748 1. What is the contribution margin per unit? (Round your answer to 2 decimal places.) 2. What is the contribution margin ratio? (Enter your answer as a percentage...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement:...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement: Sales revenue $ 206,000 $ 171,000 Cost of goods sold 116,000 101,600 Gross profit 90,000 69,400 Operating expenses and interest expense 57,600 53,800 Pretax income 32,400 15,600 Income tax 9,600 4,800 Net income $ 22,800 $ 10,800 Balance sheet: Cash $ 5,600 $ 7,800 Accounts receivable (net) 14,800 18,800 Inventory 41,600 34,800 Property and equipment (net) 47,400 39,600 Total assets $ 109,400 $ 101,000...
[The following information applies to the questions displayed below.] Westerville Company reported the following results from...
[The following information applies to the questions displayed below.] Westerville Company reported the following results from last year’s operations: Sales $ 2,200,000 Variable expenses 660,000 Contribution margin 1,540,000 Fixed expenses 1,100,000 Net operating income $ 440,000 Average operating assets $ 1,375,000 At the beginning of this year, the company has a $275,000 investment opportunity with the following cost and revenue characteristics: Sales $ 440,000 Contribution margin ratio 60 % of sales Fixed expenses $ 220,000 The company’s minimum required rate...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 15% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 75%...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 10% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
Westerville Company reported the following results from last year’s operations:
Westerville Company reported the following results from last year’s operations:Sales$1,400,000Variable expenses510,000Contribution margin890,000Fixed expenses610,000Net operating income$280,000Average operating assets$875,000At the beginning of this year, the company has a $175,000 investment opportunity with the following cost and revenue characteristics:Sales$280,000Contribution margin ratio50% of salesFixed expenses$98,000The company’s minimum required rate of return is 15%.7. If the company pursues the investment opportunity and otherwise performs the same as last year, what margin will it earn this year? (Round your percentage answer to 1 decimal place (i.e.,...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 125 EBT $175 Taxes (40%) 70 Net income $105 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 10% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 70%...