TABLE 4-5 Balance Sheet, Sample Company Vertical Vertical Analysis 2013 Category 2012 Analysis 2012 2013 $ 7,000,000 8,000,000 15,000,000 $ 9,000,000 6,000,000 15,000,000 Current assets Total fixed assets Total assets $ 3,000,000 4,000,000 $ 1,000,000 4,000,000 Current liabilities Long term debt Owner's equity 8,000,000 10,000,000 Total liabilities & owner's equity $15,000,000 $15,000,000 TABLE 4-6 Sample Balance Sheet Horizontal 2012 2013 Analysis $ 7,000,000 8,000,000 15,000,000 $ 9,000,000 6,000,000 15,000,000 $ 1,000,000 4,000,000 Current assets Total fixed assets Total assets $ 3,000,000 4,000,000 Current liabilities Long-term debt Owner's equity 8,000,000 10,000,000 Total liabilities & owner's equity $15,000,000 $15,000,000

TABLE 4-5 Balance Sheet, Sample Company Vertical Vertical Analysis 2013 Category 2012 Analysis 2012 2013 $ 7,000,000 8,000,000 15,000,000 $ 9,000,000 6,000,000 15,000,000 Current assets Total fixed assets Total assets $ 3,000,000 4,000,000 $ 1,000,000 4,000,000 Current liabilities Long term debt Owner's equity 8,000,000 10,000,000 Total liabilities & owner's equity $15,000,000 $15,000,000 TABLE 4-6 Sample Balance Sheet Horizontal 2012 2013 Analysis $ 7,000,000 8,000,000 15,000,000 $ 9,000,000 6,000,000 15,000,000 $ 1,000,000 4,000,000 Current assets Total fixed assets Total assets $ 3,000,000 4,000,000 Current liabilities Long-term debt Owner's equity 8,000,000 10,000,000 Total liabilities & owner's equity $15,000,000 $15,000,000

Financial & Managerial Accounting

13th Edition

ISBN:9781285866307

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 15.17EX: Profitability ratios The following selected data were taken from the financial statements of...

See similar textbooks

Similar questions

Profitability ratios The following selected data were taken from the financial statements of Robinson Inc. for December 31, 2016, 2015 and 2014: December31 2016 2015 2014 Total assets......................................... 4,800,000 4,400,000 4,000,000 Notes payable (8% interest)........................... 2,250,000 2,250,000 2,250,000 Common stock...................................... 250,000 250,000 250,000 Preferred 4% stock, 100 par (no change during year)........................... 500,000 500,000 500,000 Retained earnings................................... 1,574,000 1,222,000 750,000 The 2016 net income was 372,000, and the 2015 net income was 492,000. No dividends on common stock were declared between 2014 and 2016. a. Determine the rate earned on total assets, the rate earned on stockholders equity, and the rate earned on common Stockholders equity for the years 2015 and 2016. Round to one decimal place. b. What conclusions can be drawn from these data as to the companys profitability?
CALCULATING THE WACC Here is the condensed 2016 balance sheet for Skye Computer Company (in thousands of dollars): 2016 Current assets 2,000 Net fixed assets 3,000 Total assets 5,000 Accounts payable and accruals 900 Short-term debt 100 Long-term debt 1,100 Preferred stock (10,000 shares) 250 Common stock (50,000 shares) 1.300 Retained earnings 1,350 Total common equity 52,650 Total liabilities and equity 5,000 Skyes earnings per share last year were 3.20. The common stock sells for 55.00, Last year's dividend (Do) was 2.10, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 9%. Skye's preferred stock pays a dividend of 3.30 per share, and its preferred stock sells for 30.00 per share. The firm's before-tax cost of debt is 10%, and its marginal tax rate is 35%. The firms currently outstanding 10% annual coupon rate, long-term debt sells at par value. The market risk premium is 5%, the risk-free rate is 6%, and Skyes beta is 1.516. The firms total debt, which is the sum of the companys short-term debt and Long-term debt, equals 1.2 million. a. Calculate the cost of each capital component, that is, the after-tax cost of debt, the cost of preferred stock, the cost of equity from retained earnings, and the cost of newly issued common stock. Use the DCF method to find the cost of common equity. b. Now calculate the cost of common equity from retained earnings, using the CAPM method. c. What is the cost of new common stock based on the CAPM? (Hint: Find the difference between rc and rs. as determined by the DCF method, and add that differential to the CAPM value for rs) d. If Skye continues to use the same market-value capital structure, what is the firms WACC assuming that (1) it uses only retained earnings for equity? (2) If it expands so rapidly that it must issue new common stock?
ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.s 2016 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2016 Morrissey Technologies Inc.: Income Statement for December 31, 2016 Sales 3,600,000 Operating costs including depredation 3,279,720 EBIT 320,280 Interest 20,280 EBT 300,000 Taxes (40%) 120,000 Net Income 180,000 Per Share Data: Common stock price 45.00 Earnings per share (EPS) 1.80 Dividends per share (DPS) 1.08 Suppose that in 2017, sales increase by 10% over 2016 sales. The firm currently has 100,000 shares outstanding. It expects to maintain its 2016 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would like to reduce its operating costs/sales ratio to 87.5% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities-to-assets ratio currently is too low relative to the industry average.) The firm will raise 30% of the 2017 forecasted interest- bearing debt as notes payable, and it will issue long-term bonds for the remainder. The firm forecasts that its before-tax cost of debt (which includes both short- and long-term debt) is 12.5%. Assume that any common stock issuances or repurchases can be made at the firms current stock price of 45. a. Construct the forecasted financial statements assuming that these changes are made. What are the firms forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? b. If the profit margin remains at 5% and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firms sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.)
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Ratio of fixed assets to long-term liabilities
1. The balance sheets at the end of each of the first two years of operations indicate the following:20172016Total current assets$600,000$560,000Total investments60,00040,000Total property, plant, and equipment900,000700,000Total current liabilities125,00080,000Total long-term liabilities350,000250,000Preferred 9% stock, $100 par100,000100,000Common stock, $10 par600,000600,000Paid-in capital in excess of par--common stock60,00060,000Retained earnings325,000210,000Based on the above information, if net income is $130,000 and interest expense is $40,000 for 2017, and the market price is $40, what is the price-earnings ratio on common stock (round to one decimal place)?a. 14.9b. 19.8c. 17.3d. 18.4
PROBLEM 8:Tomas Co. has the following balance sheet as of December 31, 2021.Current assets 180,000.00Fixed assets 120,000.00Total assets 300,000.00Accounts payable 40,000.00Accrued liabilities 20,000.00Notes payable 50,000.00Other Long-term debt 75,000.00Total Equity 115,000.00Total liabilities and equity 300,000.00 In 2021, Tomas Co. reported sales of P1,500,0000, net income of P30,000, and dividends of P18,000. The company expected its sales to increase by 20% by next year and its retention ratio will remain at 40%. Assume that Tomas Co. is operating at full capacity and it uses the AFN approach in determining the amount of external financing needed.How much is the sales for 2022? Using Problem 8, how much is the increase in retained earnings for the purpose of computing the AFN? Using Problem 8, how much external funds needed for the year 2022?
Problem #1 The following balance sheet and income statement data is given: 31-Dec Yr 2021 Yr 2020 Cash $4,300 $3,700 Accounts receivable (net) 22,000 23,400 Inventories 10,000 7,000 Plant assets (net) 75,000 86,000 Total assets 111,300 120,100 Accounts payable 12,370 11,100 Bonds payable 70,000 70,000 Total liabilities 82,370 81,100 Common stock, $10 par 65,000 59,000 Paid-in capital 10,000 10,000 Retained earnings 24,300 20,600 Total stockholders’ equity 99,300 89,600 Net credit sales 100,000 Cost of goods sold 60,350 Gross profit 39,650 Net income 14,000 REQUIRED: Compute the following ratios for 2021. NOTE: Copy and paste the information below into the answer box first and then show your calculation steps for this problem to receive credits. (1) Accounts receivable turnover=____________________ (2) Inventory turnover=__________________ (3) Accounts payable…