Business, 22.02.2020 01:27 emmaline11

Long-term debt ratio 0.3
Times interest earned 10.0
Current ratio 1.2
Quick ratio 1.0
Cash ratio 0.4
Inventory turnover 3.0
Average collection period 73 days
Use the above information from the tables to work out the following missing entries, and then calculate the company’s return on equity. Note: Turnover and the average collection period are calculated using start-of-year, not average, values. (Enter your answers in millions. Round intermediate calculations and final answers to 2 decimal places.)

INCOME STATEMENT
(Figures in $ millions)
Net sales $
Cost of goods sold
Selling, general, and administrative expenses 20.00
Depreciation 30.00
Earnings before interest and taxes (EBIT) $
Interest expense
Income before tax $
Tax (35% of income before tax)
Net income $
BALANCE SHEET
(Figures in $ millions)
This Year Last Year
Assets
Cash and marketable securities $ $ 30
Accounts receivable 44
Inventories 36
Total current assets $ $ 110
Net property, plant, and equipment 35
Total assets $ $145
Liabilities and shareholders’ equity
Accounts payable $35.00 $ 30
Notes payable 40.00 45
Total current liabilities 75
Long-term debt 26
Shareholders’ equity 44
Total liabilities and shareholders’ equity $195.00 $145
Please show all workings so i can see how you arrive at your answers.

Answers: 1

Show answers

Answers

Answer from: neather

Explanation:

Since the cash ratio = Cash & Marketable Securities / Current liabilities

We can find the value of Cash & Marketable Securities for the current year using the cash ratio and amount of liabilities provided to us

0.4 = Cash & Marketable securities / 75

Cash & Marketable Securities = 75 x 0.4 = 30 million

Quick ratio = (Cash & Marketable Securities + Accounts Receivable) / Current liabilities

1 = (30+X) / 75, where Accounts receivable are X that is to be determined

75 = 30 + X

X = 75 - 30 = 45 million

Current ratio = Current assets / Current liabilities

1.2 = Current assets / 75

Current assets = 75 x 1.2 = 90 million

Now current assets = Cash & Marketable Securities + Accounts receivable + Inventory

90 = 30 + 45 + X, where X is the amount of inventory

X = 90 - 75 = 15 million

Since the total liabilities and equity are equal to 195 million, the amount of total assets should also be 195 million.

If the total assets are 195 and Current assets are 90, the value of the fixed assets (Net propertyu, plant and equipment should be

195-90 = 105 million

The long term debt ratio = Long term debt / Total assets

0.3 = Long term debt / 105

Long term debt = 105 x 0.3 = 31.5 million

Current liabilities + Long term debt + Equity = Total liabilities and equity

75 +31.5 + X = 195, here X is the unknown amount of equity

X = 195 - 75 -31.5 = 88.5 million

This completes our Balance Sheet!

Average collection period is 73 days

Average collection period = 365/Receivable turnover

Receivable turnover = 365/73 = 5

Receivable turnover = Sales/Average Receivables

Average Receivables = (Receivables last + Receivables current year)/2

Average Receivables = (44+45)/2 = 89/2 = 44.5

Plugging in the values in the receivable turnover ratio formula we can find the amount for Sales

5 = Sales/44.5

Sales = 44.5 x 5 = 222.5 million

Inventory turnover = Cost of good sold/ Average inventory

Average inventory = (Inventory last year + Inventory this year)/2

Average inventory = (36+15)/2 = 51/2 = 25.5

Using the inventory turnover formula, we can find the amount for Cost of goods sold as under

3 = Cost of goods sold / 25.5

Cost of goods sold = 25.5 x 3 = 76.5 million

The gross profit = Sales - Cost of goods sold

Gross profit = 222.5 - 76.5 = 146 million

Earning before interest and taxes = Gross profit - Selling, General and Administrative expense - Depreciation

EBIT = 146 -20 -30 = 96

Times interest earned = EBIT/Interest expense

10 = 96/Interest expense

Interest expense= 96/10 = 9.6 million

Income before tax = EBIT - Interest expense

Income before tax = 96 - 9.6 = 86.4 million

Tax is 35 percent of income before tax and should be

86.4 x 0.35 = 30.24 million

Subtracting taxes from income before tax provides us the amount of net income

Net income = 86.4 - 30.24 = 56.16 million

And this completes the income statement

Also see the excel file attached here

Answer from: Quest

Technicians are. they a lot

Answer from: Quest

almost done 23 out of 25

Other questions on the subject: Business

Business, 21.06.2019 21:30, anonymous1813

Balance sheet baggett company's balance sheet accounts and amounts as of december 31, 2016, are shown in random order as follows: account debit (credit) account debit (credit) income taxes payable $(3,800) additional paid-in capital on preferred prepaid items 1,800 stock $(7,900) additional paid-in capital on common stock (9,300) allowance for doubtful accounts (1,600) land 12,200 bonds payable (due 2020) (23,000) notes payable (due 2019) (6,000) buildings 57,400 notes receivable (due 2018) 16,400 sinking fund to retire bonds payable 5,000 accounts receivable 12,600 advances from customers (long-term) (2,600) premium on bonds payable (1,400) cash 4,300 accounts payable (13,100) accumulated depreciation: equipment (9,700) inventory 7,400 retained earnings (18,300) accumulated depreciation: buildings (21,000) preferred stock, $100 par (18,600) patents (net) 4,600 wages payable (1,400) equipment 28,700 common stock, $10 par (12,700) required: 1. prepare a december 31, 2016 balance sheet for the baggett. baggett company balance sheet december 31, 2016 assets current assets: $ $ $ long-term investments: $ property, plant, and equipment: $ $ $ intangible assets: liabilities current liabilities: $ $ long-term liabilities: $ $ other liabilities: shareholders' equity contributed capital: $ $ $ $ 2. compute the debt-to-assets ratio. round to one decimal place. do not enter a percent sign (%) as part of your answer. %

Answers: 1

continue

Business, 22.06.2019 11:30, jacky852

On average, someone with a bachelor's degree is estimated to earn times more than someone with a high school diploma. a)1.2 b)1.4 c)1.6 d)1.8

Answers: 1

continue

Business, 22.06.2019 16:30, allytrujillo20oy0dib

Summarize the specific methods used by interest groups in order to influence governmental decisions making in all three branches of government. provide at least two examples from each branch.

Answers: 3

continue

Business, 22.06.2019 18:30, maddylol3863

Hilary works at klothes kloset. she quickly the customers, and her cash drawer is always correct at the end of her shift. however, she never tries to "upsell" the customers (for example, by asking if they would like to purchase earrings to go with the shirt they chose or by suggesting a purse that matches the shoes they are buying). give hilary some constructive feedback on her performance.

Answers: 3

continue

You know the right answer?

Long-term debt ratio 0.3
Times interest earned 10.0
Current ratio 1.2
Quick rat...