Given the following information: $8 million Average Inventory: $6 million Average A/R: Average Fixed Assets: Accounts Payables:$4 million Revenues: $2 million Liabilities: Total Expenses: Cost of Goods Sold: $10 million $7 million $3 million $10 million Assume no other assets or liabilities exist beyond what is articulated above. a. Compute Net Profit Margin b. Compute Total Asset Turnover c. Compute Return on Equity (ROE) d. Compute Inventory Turnover e. How much equity would have to be swapped out for debt to increase ROE by 1% assuming that nothing else changes? f. What is the firm's sustainable growth rate if dividends are equal to $0.5 million?

Given the following information: $8 million Average Inventory: $6 million Average A/R: Average Fixed Assets: Accounts Payables:$4 million Revenues: $2 million Liabilities: Total Expenses: Cost of Goods Sold: $10 million $7 million $3 million $10 million Assume no other assets or liabilities exist beyond what is articulated above. a. Compute Net Profit Margin b. Compute Total Asset Turnover c. Compute Return on Equity (ROE) d. Compute Inventory Turnover e. How much equity would have to be swapped out for debt to increase ROE by 1% assuming that nothing else changes? f. What is the firm's sustainable growth rate if dividends are equal to $0.5 million?

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 26MCQ

See similar textbooks

Similar questions

You are given the following information for Smashville, Inc. Cost of goods sold: Investment income: Net sales: Operating expense: Interest expense: Dividends: Tax rate: Current liabilities: Cash: Long-term debt: Other assets: Fixed assets: Other liabilities: Investments: Operating assets: Gross margin Operating margin Return on assets Return on equity $174,000 $ 1,400 $379,000 $ 86,000 $ 7,400 8,000 $ % % % % 40% $ 21,000 $ 21,000 $ 46,000 $ 38,000 $130,000 Calculate the gross margin, the operating margin, return on assets, and return on equity. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) $ 3,000 $ 34,000 $ 64,000
Required: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.
I Current ratioli. Times interest earnedjli. Inventory turnover¡v. Total asset turnoverv. Operating profit marginVi. Debt ratiovi. Average collection periodVii Fixed asset turnoverixReturn on equity
GIVE AN INTERPRETATION OF THESE RATIOS CONCLUSIVELY Acid test ratio = (total current asset – inventory – prepaid expenses) / total current liability Total asset turnover = 1.918 times Gearing ratio = 0.2243 or 22.43% Gross profit margin = 0.361 or 36.1% Net profit margin = 0.1143 or 11.43% Return on capital employed = 0.2664 or 26.64% Current ratio = 2.1753 times Acid test ratio = 1.0413 times Receivables days = (Trade Receivables/Net Sales) * 365 = (74480/768400) *365 = 36 days Payables days = (Trade Payables/ Net Purchases) * 365 = (72000/460400) *365 = 58 days Inventory Days = (Inventory/ Cost of goods sold) * 365 = (84000/476400) * 365 = 65 days Gross Profit Margin (GPM) = 292000/808800*100= 36.10% Net Profit Margin (NPM) = 92480/808800 *100 = 11.43% Return on Capital Employed (ROCE) = 92480/327080*100 = 28.27% Current ratio = 162280/74600= 2.17 Acid test ratio = (162280- 84000)/74600= 1.049 Total asset turnover = Sales revenue / Total average asset…
EXHIBIT 2 Selected Financial Data for Tesla, Inc., Years Ended December 31, 2015-2019 (in millions, except per share data) Income Statement Data: Revenues: Automotive sales Automotive leasing Total automotive revenues Energy generation and storage. Services and other Total revenues Cost of revenues: Automotive sales Automotive leasing Total automotive cost of revenues Energy generation and storage Services and other Total cost of revenues. Gross profit (loss) Operating expenses: Research and development Selling, general and administrative Restructuring and other Total operating expenses. Loss from operations Interest income Interest expense Other income (expense), net Loss before income taxes Provision for income taxes 2015 2 $3.432 309 3,741 14 291 4,046 Net loss Net loss attributable to noncontrolling interests and subsidiaries 2,640 183 2,823 12 287 3,123 924 7.189 922 1,640 (717) 2 (119) (42) (876) 13 $ (889) Years Ended December 31 2016 $5,589 $ 8,535 762 1.107 9,642 1.116 6,351…
Find the following using the data bellow Accounts receivable = 111,100,000 Current assets = 316,500,000 Total assets = 600,000,000 A. Return on assets B. Common equity C .Quick ratio
1- Calulate the following liquidity ratio: a. Current Ratio b. Quick Ratio 2-Calulate the following asset management ratios a. Average collection period b. Inventory Turnover c. Fixed-asset turnover d. Total asset turnover 3. Calculate the following financial leverage management ratios: a. debt ratio b. Debt-to-equity ratio c. Times interest earned ratio d. Fixed-charge coverage ratio 4. Calculate the following profitablity leverage management ratios a. Gross profit margin b. Net profit margin c. Return on investment d. Return on Stockholders' equity 5. Calculate the following market-based ratios: a. Price-to-earnings ratio b. Market price-to-book value ratio
Q. Calculate the current assets and current liabilities from the data given below. Current ratio. 1.8 Quick ratio. 1.2 Inventory turnover ( on c.g.s). 12 Gross profit rate. 25% Credit period. 1month Working capital. 640000
Based on the income statement given calculate and explain the :profitability ratioa. Gross profit ratio = gross profit/net salesb. Operating margin ratio =operating income/net salesc. Asset Turnover ratio = net sales / total assetsd. Return on equity ratio = net sales/ shareholders equity Leverage ratioa. interest coverage ratio =operating income / interest expensesb. Debt service ratio=operating income/debt service
Using the statements provided Calculate the following liquidity ratios: Current ratio Quick ratio Calculate the following asset management ratios: Average collection period Inventory turnover Fixed asset turnover Total asset turnover Calculate the following financial leverage ratios Debt to equity ratio Long-term debt to equity Calculate the following profitability ratios: Gross profit margin Net profit margin Return on assets Return on stockholders’ equity For example: you should present it like the text, or as:Gross margin = 1,933 divided by 8,689 = 22.2% A competitor of ACME has for the same time period reported the following three ratios: Current ratio 1.52Long-term debt to equity .25 or 25%Net profit margin .08 or 8% Given these three ratios only which company is performing better on each ratio? Also overall who would you say has the best financial performance and position. Support your answer.
Using the Du Pont Identity Method, calculate return on equity given the following information. Profit margin 16%; total asset turnover 0.85; equity multiplier 1.5. OA. OB. O C. O D. OE 20.40% 21.40% 22.40% 23.40% 24.40%
Receivable turnover Average collection period Inventory turnover Fixed asset turnover Total asset turnover Current ratio Quick ratio Assets Utilization Ratios c. Liquidity ratios. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Liquidity Ratios times times times days times times times