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.)
|
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 |
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 $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, 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, 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 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 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 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 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 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 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; 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...