a.
To prepare: The income statement and determine operating leverage for each year.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
b.
To compute: The degree of financial leverage for each year.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
c.
To compute: The degree of combined leverage for each year and provide analysis for leverages.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
d.
To prepare: line chart representing all the three leverages computed.
Introduction: Income Statement’ shows the revenue earned and expenses incurred over a period of time. It is used to compute the net income for a particular period.
Want to see the full answer?
Check out a sample textbook solutionChapter 7 Solutions
EBK FINANCIAL ANALYSIS WITH MICROSOFT E
- Toby’s forecasted 2021 financial statements follow, along with some industry average ratios. Calculate Toby’s 2021 forecasted ratios and fill in the above table. Calculate the EPS and DPS. The company has a 40% payout ratio. Please provide the solutions for the EPS, DPS, Days Sales Outstanding, Fixed Asset Turnover, Total Asset Turnover, Return on Assets, Return on Equity, Total Debt Ratio, Profit Margin on Sales, P/E Ratio.arrow_forwardAlpha Milk Corp is considering taking over their competitor, Dana Dairy Products, and asked your consultancy firm to perform financial statement analysis to assess feasibility of this strategic initiative. You are given the following key financial ratios, the firm’s income statement and the balance sheet. You can assume that there are 365 days in a year. a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity. b) Evaluate the company’s performance against industry average ratios and compare with last year’s results. To answer, please refer to pictures attachedarrow_forwardPresented below are summary financial data from Pebble Company’s annual report: Assume that the Pebble Company is all equity financed. Calculate the following ratios for Years 1 and 2: Return on equity, Return on assets (levered), Return on sales (levered), Total asset turnover, Financial leveragearrow_forward
- You are a financial Manager of Chevron Corp. You need to assess the effectiveness of working capital management of the company for 2018 using the following data. What is the 2018 Inventory turnover? 2017 Account Receivable = 15,353,000 2018 Account Receivable = 15,050,000 2017 Inventory = 5,585,000 2018 Inventory = 5,704,000 2017 Accounts Payable = 14,565,000 2018 Accounts Payable = 13,953,000 2017 Sales = 134,674,000 2018 Sales = 158,902,000 2017 Cost of Sales = 95,114,000 2018 Cost of Sales = 113,997,000 2017 Purchases = 95,114,000 2018 Purchases = 123,435,000arrow_forwardYou are a financial Manager of Chevron Corp. You need to assess the effectiveness of working capital management of the company for 2018 using the following data. What is the 2018 Receivable turnover? 2017 Account Receivable = 15,353 000 2018 Account Receivable = 15.050,00O 2017 Inventory = 5,585.000 2018 Inventory = 5 704.00O 2017 Accounts Payable= 14 565 00I 2018 Accounts Payable = 13 953 000 2017 Sales 134,674 000 2018 Sales 158.902 000. 2017 Cost of Sales = 95 114.000 2018 Cost of Sales = 113 997 000 2017 Purchases= 95 114 000 2018 PurchaSes = 123 435 000arrow_forwardThis is the operating margin from 2015 to 2019: 2015: 23.33% 2016: 15.69% 2017: 18.15% 2018: 25.06% 2019: 16.82% What is the trend analysis for the operating margin ratio above? In general, why the operating margin of a company become decrease and increase?arrow_forward
- You are given the financial statements of a company for over the 6-year periods (2016 –2021). Considering 2016 as the base year, compute the trend index for the following items:a. Revenue, cost of goods sold, total expenses and net earnings. Comment on the trends of each of the items.b. Total assets, total liabilities and shareholders’ equity. Comment on the trends of each of the items.c. Cash flow from operation, cash flow from investing, cash flow from financing and closing cash balances. Comment on the trends of each of the items.arrow_forwardPlease describe what is meant by “Times Interest Earned.” How is it calculated? Suppose you calculated this ratio for a company for two consecutive years and the results were the following: year 2018 – 24.0 year 2017 – 28.0 Please interpret the results. What conclusions can you draw?arrow_forwardProfitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its first-year performance. The following shows Diusitech Inc.’s income statement for the last two years. The company had assets of $10,575 million in the first year and $16,916 million in the second year. Common equity was equal to $5,625 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 Net Sales 5,715 4,500 Operating costs except depreciation and amortization 1,365 1,268 Depreciation and…arrow_forward
- Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the operating performance of a firm. Your boss has asked you to calculate the profitability ratios of Petroxy Oil Co. and make comments on its second-year performance as compared with its first-year performance. The following shows Petroxy Oll Co.'s Income statement for the last two years. The company had assets of $9,400 million in the first year and $15,037 million in the second year. Common equity was equal to $5,000 million in the first year, and the company distributed 100% of its earnings out as dividends during the first and the second years. In addition, the firm did not issue new stock during either year. Petroxy Oil Co. Income Statement For the Year Ending on December 31 (Millions of dollars) Year 2 Year 1 4,000 1,268 Net Sales Operating costs except depreciation and amortization Depreciation and amortization Total Operating Costs…arrow_forwardPresented is the income statement and balance sheet for PartsCo, a $1.2 billion supplier of machinery parts. The company is expected to increase revenues by 8 percent annually for the next five years. Forecast the next five years of income statements for PartsCo. Assume that the next five years’ forecast ratios are identical to this year’s ratios. Forecast depreciation as a percentage of the prior year’s property, plant, and equipment. Forecast interest as a percentage of the prior year’s total debt.arrow_forwardBooker Inc. is a distributor of building supplies. Management for the company has developed the following forecasts of net income: Table 8 Forecasted Net Income of Booker Inc. in USD (As of December 31st of each year) Year Forecasted Net Income 2011 $111,432 2012 $131,490 2013 $156,473 2014 $178,379 2015 $199,784 Management expects net income to grow at a rate of 7% per year after 2015 and the company's cost of equity capital is 14%. Management has set a dividend payout ratio equal to 25% of net income and plans to continue this policy. Booker’s common shareholders' equity at January 1, 2011, is $544,902. Using the residual income model, compute the value of equity of Booker as of January 1, 2011. Using the dividend discount model, compute the value of equity of Booker as of January 1, 2011. Compare the results in parts (a) and (b) and discuss possible reasons for any discrepancies.arrow_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