Question

Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.s, financial statements. Sales (all credit) were $30.60 million for last year Sales to total assets Total debt to total assets Current ratio Inventory turnover Average collection period Fixed asset turnover 1.80 times 40 % 2.40 times 6 times 19 days 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal places.) Answer is complete but not entirely correct S in millions $ in millions $4.16Current debt Cash Accounts receivable Inventory 1.62クLong-term debt 5.10Total debt 4.53 2.27ク 6.80ク Total current assets Fixed assets $10.88 1Equity 0.20 4.16 17.00 о Total debt and stockholders UI Total assets

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Ans. ASSETS in millions LIABILITIES in millions
Cash 4.16 Current debt 4.53
Accounts receivables 1.62 Long - term debt 2.27
Inventory 5.1 Total debt 6.8
Total current assets 10.88
Fixed assets 6.12 Equity 10.2
Total assets 17 Total debt and stockholders' equity 17
*Calculations:
1 Sales to Total assets =   Sales / Total assets
1.80   =   30.60 / Total assets
Total assets =   30.60 / 1.80
17
2 Total debt to Total assets = Total debt / Total assets
0.40   =    Total debt / 17
Total debt   =   17 * 0.40
6.8
3 Fixed assets turnover =   Sales / Fixed assets
5   =   30.60 / Fixed assets
Fixed assets =   30.60 / 5
6.12
4 Current assets = Total assets - Fixed assets
17 - 6.12
10.88
5 Current ratio = Current assets / Current liabilities
2.40 = 10.88 / Current liabilities
Current liabilities =   10.88 / 2.40
4.53
6 Total debt = Current liabilities + Long term debt
6.8 = 4.53 + Long term debt
Long term debt = 6.8 - 4.53
2.27
7 Inventory turnover = Sales / Inventory
6 = 30.60 / inventory
Inventory = 30.60 / 6
5.1
8 Average collection period = No. of days in year / Receivables turnover
19 =   360 / Receivables turnover
Receivables turnover = 360 / 19
18.947
Receivables turnover = Sales / Receivables
18.95 = 30.60 / Receivables
Receivables   =   30.60 / 18.947
1.62
9 Current assets = Inventory + Receivables + Cash
10.88 = 5.1 + 1.62 + Cash
Cash = 10.88 - 5.1 - 1.62
4.16
10 Total debt and stockholder's equity = Total debt + Equity
17 =   6.80 + Equity
Equity = 17 - 6.80
Equity   = 10.20
*Total debt and stockholder's equity = Total assets
Add a comment
Know the answer?
Add Answer to:
Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s,...

    Problem 3-35 Using ratios to construct financial statements [LO3-2] The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $18.00 million for last year.     Sales to total assets 1.20 times Total debt to total assets 45 % Current ratio 2.80 times Inventory turnover 6 times Average collection period 24 days Fixed asset turnover 5 times     Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2...

  • The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $21.60 million for...

    The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $21.60 million for last year.     Sales to total assets 1.80 times Total debt to total assets 40 % Current ratio 3.00 times Inventory turnover 4 times Average collection period 25 days Fixed asset turnover 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal places.) $ in millions $ in millions Cash Current...

  • The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $18.00 million for...

    The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $18.00 million for last year. Sales to total assets Total debt to total assets Current ratio Inventory turnover Average collection period Fixed asset turnover 1.50 times 45% 2.90 times 6 times 19 days 5 times Complete the balance sheet: (Use a 360-day year. Do not round intermediate calculations. Input your answers in millions rounded to 2 decimal places.) $ in millions $ in millions Current debt 0.90...

  • The following information is from Boston Pharmaceutical Inc.'s financial statements: $30,500,000 Sales (all cr...

    The following information is from Boston Pharmaceutical Inc.'s financial statements: $30,500,000 Sales (all credit) 2.5 times Total assets turnover 40% Total debt to total assets 6.00 times Fixed asset turnover 2.6 times Current ratio Average collection period 30 days 12 times Inventory turnover Part A Using the above listed ratios and data, compute the balance of the following accounts. Assume all sa are on credit and a 360-day year. Round to the nearest dollar. [Hint: use ratio formulas to derive...

  • The following information is from Pramacy Inc.’s financial statements: Sales (all credit) $245,000 Total assets turnover...

    The following information is from Pramacy Inc.’s financial statements: Sales (all credit) $245,000 Total assets turnover 0.80 times Total debt to total assets 30.83% Fixed asset turnover 1.1 times Current ratio 4.04 times Average collection period 29.68 days Inventory turnover 7.42 times Part A Using the above listed ratios and data, compute the balance of the following accounts. Assume all sales are on credit and a 360-day year. Round to the nearest dollar. [Hint: use ratio formulas to derive the...

  • Please fill in the balance sheet below: c. Fixed assets d Long-term debt. u 35. The...

    Please fill in the balance sheet below: c. Fixed assets d Long-term debt. u 35. The following information is from Harrelson Inc.'s financial statements. Sales (all credit) were $28.50 million for last year sti Sales to total assets ℡al debt to total assets Current ratio Inventory tumover Average collection period Fixed asset turnover 1.90 times 35% 2.50 times 10.00 times 20 days 5.00 times Fill in the balance sheet: Cash Accounts receivable Inventory Current debt... Long-term debt Total debt Total...

  • Use the information from the Income Statement and Balance Sheet to construct the ratios and answer...

    Use the information from the Income Statement and Balance Sheet to construct the ratios and answer the questions below. Downloadable Financial statements HW 4 SXP 19.docxPreview the document hw3 ratios.jpg Barry Computers Income statement DEC 31, 2016 Sales 1,607,500 GOGS 1,392,500 Gross Profit 215,000 SG&A 145,000 EBIT 70,000 Interest Expenses 24,500 EBT 45,500 TX (40%) 18,200 NI 27,300 Barry Computers Balance Sheet DEC 31, 2016 Cash 77,500 Accounts Payable 129,000 Accounts receivables 336,000 Accruals 117,000 Inventory 241,500 Notes Payable 84,000...

  • QUESTION 3 From following financial statements, calculate following ratios and analyse the current year and previous...

    QUESTION 3 From following financial statements, calculate following ratios and analyse the current year and previous year performance a) Current ratio. b) Days sales outstanding (DSO). (Sales 2017 RM500m & Sales 2018 RM600m) c) Inventory turnover ratio d) Total debt to assets e) Return on assets (ROA) (Net income 2017 RM42m &Net income 2018 RM58m) Moon Inc. Balance Sheet (RM millions) as at December 31, 2015 and 2016 2015 21 51 2016 20 84 Cash Accounts receivable Inventory Prepaid expenses...

  • ne saved CILJUDI Check my work Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements...

    ne saved CILJUDI Check my work Problem 4-7 Financial Ratios (LO3) Here are simplified financial statements for Phone Corporation in a recent year: points eBook INCOME STATEMENT (Figures in $ millions) Net sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest expense Income before tax Taxes (at 35%) Net income Dividends $ 13,700 4,360 4,047 2,698 $ 2,595 715 $ 1,880 658 $ 1,222 $ 916 Print References BALANCE SHEET (Figures in $ millions)...

  • Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the...

    Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter. SNIDER CORPORATION Balance Sheet December 31, 20X1 Assets Current assets Cash Marketable securities Accounts receivable (net) Inventory $ 54,200 28,800 180,000 244,000 $507,000 60,400 Total current assetS Investments $658,000 255,000 Plant and equipment. Less: Accumulated depreciation Net plant and equipment 403,000 Total assets $ 970,400 Liabilities and Stockholders' Equity Current liabilities Accounts payable Notes payable Accrued taxes $ 94,800 78,400 14,500 $187,700 Total...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT