Question

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 debt
Accounts receivable Long-term debt
Inventory Total debt
Total current assets
Fixed assets Equity
Total assets Total debt and stockholders' equity
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Ans. ASSETS in millions LIABILITIES in millions
Cash 0.78 Current debt 2.56
Accounts receivables 1.5 Long - term debt 2.24
Inventory 5.4 Total debt 4.8
Total current assets 7.68
Fixed assets 4.32 Equity 7.2
Total assets 12 Total debt and stockholders' equity 12
*Calculations:
1 Sales to Total assets =   Sales / Total assets
1.80   = 21.60 / Total assets
Total assets = 21.60 / 1.80
$12 million
2 Total debt to Total assets = Total debt / Total assets
0.40   =    Total debt / 12
Total debt   =   12 * 0.40
$4.8 million
3 Fixed assets turnover =   Sales / Fixed assets
5   = 21.60 / Fixed assets
Fixed assets = 21.60 / 5
$4.32 million
4 Current assets = Total assets - Fixed assets
12 - 4.32
$7.68 million
5 Current ratio = Current assets / Current liabilities
3 = 7.68 / Current liabilities
Current liabilities = 7.68 / 3
$2.56 million
6 Total debt = Current liabilities + Long term debt
4.8 = 2.56 + Long term debt
Long term debt = 4.8 - 2.56
$2.24 million
7 Inventory turnover = Sales / Inventory
4 = 21.60 / inventory
Inventory = 21.60 / 4
$5.4 million
8 Average collection period = No. of days in year / Receivables turnover
25 =   360 / Receivables turnover
Receivables turnover = 360 / 25
14.4 times
Receivables turnover = Sales / Receivables
14.4 = 21.60 / Receivables
Receivables   = 21.60 / 14.4
$1.5 million
9 Current assets = Inventory + Receivables + Cash
7.68 = 5.4 + 1.5 + Cash
Cash = 7.68 - 5.4 - 1.5
$0.78 million
10 Total debt and stockholder's equity = Total debt + Equity
12 = 4.80 + Equity
Equity = 12 - 4.80
Equity   = 7.20
*Total debt and stockholder's equity = Total assets
Add a comment
Know the answer?
Add Answer to:
The following information is from Harrelson Inc.'s, financial statements. Sales (all credit) were $21.60 million for...
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
  • 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...

  • 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...

  • 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 $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...

  • 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...

  • 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...

  • Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50...

    Current ratio = 2.6 times Credit sales $1,314m Average collection period 50 days Inventory turnover 1.50 times Total asset turnover 0.50 times Debt ratio 75% Use the above information to complete the balance sheet below. (Enter your answer in millions. Use 365 days a year.) Cash million million Current liabilities Accounts receivable $ 670 million million Long-term debt Inventory million 0 million Total debt Current assets 670 million million Stockholders' equity million 670 million Fixed assets $ 0 million Total...

  • Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance...

    Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $48,900; total assets, $189,400; common stock, $90,000; and retained earnings, $33,748.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 448,600 Cost of goods sold 297,250 Gross profit 151,350 Operating expenses 98,600 Interest expense 4,100 Income before taxes 48,650 Income tax expense 19,598 Net income $ 29,052 Assets Cash Short-term...

  • Selected current year-end financial statements of Cabot Corporation follow. All sales were on credit; selected balance...

    Selected current year-end financial statements of Cabot Corporation follow. All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory \$55,9 ; total assets, $189,400; common stock$89,000 and retained earnings38,032 ) Check my work Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit: selected balance sheet amounts at December 31 of the prior year were inventory. $55,900; total assets. $189,400, common stock, $89,000, and retained earnings $38,032.) CABOT...

  • Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet...

    Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $50,900, total assets, $209,400, common stock, $83,000; and retained earnings, $40,300.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 $ 454,608 298,158 156,45e 99,400 Sales Cost of goods sold Gross profit operating expenses Interest expense Income before taxes Income taxes 4,300 52,750 21,250 Net income 31,5ee CABOT CORPORATION Balance Sheet December 31, 2017 ASsets Cash...

  • need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit;...

    need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...

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