To determine: Various financial ratios to complete the
Explanation of Solution
Given information:
Long term debt ratio is 0.4
Times-interest earned is 8.0
Current ratio is 1.4
Cash ratio is 0.2
Inventory turnover ratio is 5.0
Tax rate is 0.40
Quick ratio is 1.0
Calculation of financial ratios:
Therefore, total assets are $115
Therefore, total current liabilities are $55
Therefore, total current assets are $77
Hence, cash is $11
Therefore, accounts receivables are $44
Therefore, inventory is $22
Therefore, fixed assets are $38
Therefore, long-term debt and equity is $60
Therefore, long-term debt is $24
Therefore, equity is $36
For completing the balance sheet the following ratios are needed,
Therefore, average inventory is $24
Therefore, cost of goods sold is $120
Therefore, average receivables are $39
Therefore, sales are $195
Therefore, EBIT is $45.
Therefore, interest is $5.625
Therefore, interest is $39.375
Therefore, tax is $15.75
Therefore, company balance sheet is as follows,
Want to see more full solutions like this?
Chapter 28 Solutions
Principles of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- Current Ratio, Quick Ratio, and Times-Interest-Earned Ratio The following data is from the current accounting records of Florence Company: Cash $336 Accounts receivable (net of allowance of $112) 560 Inventory 420 224 305 476 Other current assets Accounts payable Other current liabilities The president of the company is concerned that the company is in violation of a debt covenant that requires the company to maintain a minimum current ratio of 2.0. He believes the best way to rectify this is to reverse a bad debt write-off in the amount of $28 that the company just recorded. He argues that the write-off was done too early and that the collections department should be given more time to collect the outstanding receivables. The CFO argues that this will have no effect on the current ratio, so a better idea is to use $28 of cash to pay accounts payable early. Florence Company uses the allowance method to account for bad debts. a. Calculate the current ratio under the following scenarios:…arrow_forwardSelected 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, $52,900; total assets, $219,400; common stock, $86,000; and retained earnings, $31,757.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory. Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit $ 14,000 8,200 30,000 38,150 2,600 149,300 $ 242, 250 Operating expenses Interest expense Income before taxes Income tax expense Net income $ 456,600 297,750 158,850 99,000 4,600 55,250 22,257 $32,993 CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity Accounts payable Accrued wages payable Income taxes payable Long-term note payable, secured by mortgage on plant assets Common stock Retained earnings Total liabilities and equity $ 18,500 3,600 4,000…arrow_forward1. Compute the following ratios for the comparative periods (2018 and 2019). The company used 365 days in its computation for some of the ratios. Show your solution. d. Accounts Receivable Turnover Ratio e. Average Collection Period f. Inventory Turnover Ratio g. Average Days in Inventory h. Number of days in Operating Cycle i. Debt to Total Assets Ratio j. Debt to Equity Ratio k. Times Interest Earned Ratio l. Gross Profit Ratio m. Profit Margin Ratio n. Return on Assets o. Return on Equity p. Assets Turnover Ratioarrow_forward
- INSTRUCTIONS Determine the following measures for both 20Y8 and 20Y9, rounding percentages and ratios other than per-share amounts to one decimal place. Briefly explain how or why management would use this information and comment on the trend from 20Y8 and 20Y9. Working capital Current ratio Quick ratio Accounts receivable turnover Number of days’ sales in receivables Inventory turnover Number of days’ sales in inventory Ratio of fixed assets to long-term liabilities Ratio of liabilities to stockholders’ equity Times interest earned Asset turnover Return on total assets Return on stockholders’ equity Return on common stockholders’ equity Earnings per share on common stock Price-earnings ratio Dividends per share Dividend yieldarrow_forwardCalculate ratios related to how quickly the company pays its trade debt and how quickly it collects from its customers. These are known as Accounts Payable (AP) Turnover and Accounts Receivable (AR) Turnover. The formula for AP Turnover is: Cost of Goods Sold/average accounts payable. The formula for AR Turnover is: credit sales/average accounts receivable. Calculate the AP and AR Turnover for each of 2011-2014. Interpret your calculations: what does this information mean? How is the company doing?arrow_forwardGuys could you please help me: I'm attaching AT&T's Balance Sheet and Income Statement for the analysis.I'd really appreciate help with the following: Perform a vertical financial analysis incorporatingi. Debt ratioii. Debt to equity ratioiii. Return on assetsiv. Return on equityv. Current ratiovi. Quick ratiovii. Inventory turnoverviii. Days in inventoryix. Accounts receivable turnoverx. Accounts receivable cycle in daysxi. Accounts payable turnoverxii. Accounts payable cycle in daysxiii. Earnings per share (EPS)xiv. Price to earnings ratio (P/E)xv. Cash conversion cycle (CCC), andxvi. Working capitalxvii. Explain Dupont identity, apply it to your selected company, interpret thecomponents in Dupont identity.arrow_forward
- Please Help! I am struggling so much with this chapter. Instructions: Determine the following measures for 20Y2, rounding to one decimal place including percentages, except for per-share amounts. 1. Working Capital 2. Current Ratio 3. Quick Ratio 4. Accounts Receivable Turnover 5. Number of days' sales in receivables 6. Inventory Turnover 7. Number of days' sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholder's equity 10. Times interest earned 11. Asset Turnover 12. Return on Total Assets 13. Return on Stockholder's Equity 14. Return on Common Stock 15. Earnings per share on Common Stock 16. Price-earnings ratio 17. Dividends per share of Common Stock 18. Dividend Yieldarrow_forwardIndicate the effect of the transactions listed in the following table on total current assets, current ration, and net income. Use (+) to indicate an increase, (-) to indicate a decrease, and (0) to indicate either no effect or an indeterminate effect. Be prepared to state any necessary assumptions and assume an initial current ratio of more than 1.0. Short-term notes receivable are sold at a discount.arrow_forwardCalculate the following financial ratios for Phone Corporation: (Use 365 daysin a year. Do not round intermediate calculations. Round your finalanswers to 2 decimal places.)1. Return on Assets (use average balance sheet figures)2. Return on capital (use average balance sheet figures) %3. Days in inventory (use start of year balance sheet figures) %4. Inventory turnover (use start of year balance sheet figures5. Average collection period (use start of year balance sheet figures)6. Operating profit margin %7. Long term debt ratio (use end of year balance sheet figures)8. Total Debt ratio (use end of year balance sheet figures)arrow_forward
- Alex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.arrow_forward1))For the years ended December 31, 2018 of your analysis, assume all sales are on credit and then compute the following: · (a) collection period, · (b) accounts receivable turnover, · (c) inventory turnover, and · (d) days' sales in inventory. · (e) Based on your estimates, comment on the changes in the ratios from 2018 year by drawing conclusion regarding efficiency in managing inventory and in collecting receivables (Note: Comment not more than 10 lines). 2))Provide your recommendations for improving the financial condition of your company. (Note: Comment not more than 10 lines).arrow_forwardUse the Dynamic Exhibit to answer the following questions. 1. When the percent of uncollectible accounts is .75%, the entry for bad debt expense is a debit to bad debt expense for $fill in the blank 2 2. When the percent of uncollectible accounts is 1%, the entry for bad debt expense is a debit to bad debt expense for $fill in the blank 4 3. When the unadjusted balance of Allowance for Doubtful Accounts is a debit of $2,100, and the percent of uncollectible accounts is .75%, the adjusted balance at December 31 after the entry for uncollectible accounts is made is $fill in the blank 5 4. When the unadjusted balance of Allowance for Doubtful Accounts is a credit of $3,250, and the percent of uncollectible accounts is .75%, the adjusted balance at December 31 after the entry for uncollectible accounts is made is $fill in the blank 6arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education