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