Jill Akerley is concerned about her company's financial performance and financial position. She hasobtained the financial statement of her largest competitor, Nova Inc. and notes that the company is over tentimes larger than hers, so it is making the numbers difficult to compare.Below is condensed financial information from Nova Inc. and Scotia Inc.:Nova Inc. and Scotia Inc.Income StatementsFor the years ended August 31, 2024NOVASCOTIASales$5,000,000$400,000Cost of goods sold2,100,000120,000Gross profit2,900,000280,000Operating expenses2,200,000130,000Operating income700,000150,000Interest expense60,00010,000Income before taxes640,000140,000Income taxes150,00030,000Net income$490,000$110,000Required: USING MS EXCELa. Prepare a vertical analysis for the companies calculating the relative percentages of each item in thefinancial statements. (Round your answers to the nearest tenth of a percent, ie 0.13578 → 13.6%)b. Comment on the common-sized income statements of the companies (prepared in part a.

An analysis in which the items so reported are shown in form of percentage of base item is known as…

Jill Akerley is concerned about her company's financial performance and financial position. She has obtained the financial statement of her largest competitor, Nova Inc. and notes that the company is over ten times larger than hers, so it is making the numbers difficult to compare. Below is condensed financial information from Nova Inc. and Scotia Inc.: Nova Inc. and Scotia Inc. Income Statements For the years ended August 31, 2024 NOVA SCOTIA Sales $5,000,000 $400,000 Cost of goods sold Gross profit Operating expenses Operating income 2,100,000 120,000 2,900,000 280,000 2,200,000 130,000 700,000 150,000 Interest expense 60,000 10.000 Income before taxes 640,000 140,000 Income taxes 150,000 30,000 Net income $490,000 $110,000 Required: USING MS EXCEL a. Prepare a vertical analysis for the companies calculating the relative percentages of each item in the financial statements. (Round your answers to the nearest tenth of a percent, ie 0.13578 → 13.6%) b. Comment on the common-sized income statements of the companies (prepared in part a.

Jill Akerley is concerned about her company's financial performance and financial position. She has obtained the financial statement of her largest competitor, Nova Inc. and notes that the company is over ten times larger than hers, so it is making the numbers difficult to compare. Below is condensed financial information from Nova Inc. and Scotia Inc.: Nova Inc. and Scotia Inc. Income Statements For the years ended August 31, 2024 NOVA SCOTIA Sales $5,000,000 $400,000 Cost of goods sold Gross profit Operating expenses Operating income 2,100,000 120,000 2,900,000 280,000 2,200,000 130,000 700,000 150,000 Interest expense 60,000 10.000 Income before taxes 640,000 140,000 Income taxes 150,000 30,000 Net income $490,000 $110,000 Required: USING MS EXCEL a. Prepare a vertical analysis for the companies calculating the relative percentages of each item in the financial statements. (Round your answers to the nearest tenth of a percent, ie 0.13578 → 13.6%) b. Comment on the common-sized income statements of the companies (prepared in part a.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 890,000 $ 1,020,000 Marketable securities 0 300,000 Accounts receivable, net 2,420,000 1,520,000 Inventory 3,530,000 2,300,000 Prepaid expenses 240,000 180,000 Total current assets 7,080,000 5,320,000 Plant and equipment, net 9,380,000 8,980,000 Total assets $ 16,460,000 $ 14,300,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 3,960,000 $ 2,860,000 Note payable, 10% 3,620,000 3,020,000 Total liabilities 7,580,000 5,880,000 Stockholders' equity: Common stock, $70 par value…
Conglong Limited is a manufacturing company. Conglong’s accountant has just calculated the ratios for the latest financial year and obtained industry averages for these ratios. However, the accountant is unable to provide any insight into what Conglong Limited’s ratios reveal when compared with the industry averages. The company’s ratios and the ratios for industry averages are detailed below. Ratio Conglong Limited Industry averages RoCE 15% 36% Sales to total capital employed (Asset turnover) 1.5 times 3 times Operating profit margin 10% 12% Gross profit 40% 30% Current ratio 1 time 2 times Quick Acid ratio 0.6 times 1.6 times Inventory days 60 days 15 days Trade receivables days 60 days 30 days Trade payables days 20 days 30 days Interest cover 3 times 5 times Required: Identify and explain the nature of five (5) challenges associated with the use of ratio analysis.
Compare Income Statements and Balance Sheets of Competitors a. Following are selected income statements from two pharmaceutical companies, Pfizer and Dr. Reddy's, for their respective 2018 fiscal years. Express each income statement amount as a percentage of sales. Note: Round percentage to one decimal point (for example, round 18.566% to 18.6%). Income Statement ($ millions) Sales Pfizer Dr. Reddy's $46,136 0% $1,876 09 Cost of goods sold 11,248 0% 1,009 0% Gross profit 34,888 0% 867 0% Total expenses Net income 26,841 $8,047 0% 0% 878 $(11) 0% 0% b. Following are selected balance sheets from two pharmaceutical companies, Pfizer and Dr. Reddy's, for their respective 2018 fiscal years. Express each balance sheet amount as a percentage of total assets. Note: Round percentage to one decimal point (for example, round 18.566% to 18.6%). Balance Sheet ($ millions) Pfizer Dr. Reddy's Current assets $42,936 0% $1,448 0% Long-term assets Total assets 109,496 $152,432 0% 1,781 096 0% $3,229 09…
Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales $ 17,400,000 Net operating income $ 5,400,000 Average operating assets $ 35,300,000 Required: 1. Compute the margin for Alyeska Services Company. (Round your answer to 2 decimal places.) 2. Compute the turnover for Alyeska Services Company. (Round your answer to 2 decimal places.) 3. Compute the return on investment (ROI) for Alyeska Services Company. (Round your intermediate calculations and final answer to 2 decimal places.)
Tisdale Incorporated reports the following amounts in its December 31, 2024, income statement. Sales revenue Nonoperating revenue Selling expenses $310,000 Income tax expense 112,000 Cost of goods sold 62,000 Administrative expenses 52,000 General expenses Required: 1. Prepare a multiple-step income statement. 2. Indicate whether the statement "Tisdale Incorporated does not appear to have much profit-generating potentia Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a multiple-step income statement. (Losses should be indicated by a minus sign.) TISDALE INCORPORATED Multiple-Step Income Statement For the Year Ended December 31, 2024 Prev $32,000 192,000 42,000 2 of 6 Next
Please provide answer in text (Without image)
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex CompanyComparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 980,000 $ 1,220,000 Marketable securities 0 300,000 Accounts receivable, net 2,780,000 1,880,000 Inventory 3,620,000 2,200,000 Prepaid expenses 260,000 200,000 Total current assets 7,640,000 5,800,000 Plant and equipment, net 9,560,000 9,070,000 Total assets $ 17,200,000 $ 14,870,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,030,000 $ 3,020,000 Note payable, 10% 3,680,000 3,080,000 Total liabilities 7,710,000 6,100,000 Stockholders' equity: Common stock, $75 par value…
[The following information applies to the questions displayed below.] CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below: Sales Net operating income Average operating assets $ 4,700,000 $ 188,000 $ 940,000 The following questions are to be considered independently. 2. The entrepreneur who founded the company is convinced that sales will increase next year by 40% and that net operating income will increase by 250%, with no increase in average operating assets. What would be the company's ROI? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Return on investment (ROI) %
Alyeska Services Company, a division of a major oil company, provides various services to the operators of the North Slope oil field in Alaska. Data concerning the most recent year appear below: Sales Net operating income Average operating assets Required: $ 17,200,000 $ 5,100,000 $ 35,500,000 1. Compute the margin for Alyeska Services Company. Note: Round your answer to 2 decimal places. 2. Compute the turnover for Alyeska Services Company. Note: Round your answer to 2 decimal places. 3. Compute the return on investment (ROI) for Alyeska Services Company. Note: Round your intermediate calculations and final answer to 2 decimal places. 1. Margin 2. Turnover 3. ROI % %
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Conglong Limited is a manufacturing company. Conglong’s accountant has just calculated the ratios for the latest financial year and obtained industry averages for these ratios. However, the accountant is unable to provide any insight into what Conglong Limited’s ratios reveal when compared with the industry averages. The company’s ratios and the ratios for industry averages are detailed below. Ratio Conglong Limited Industry averages RoCE 15% 36% Sales to total capital employed (Asset turnover) 1.5 times 3 times Operating profit margin 10% 12% Gross profit 40% 30% Current ratio 1 time 2 times Quick Acid ratio 0.6 times 1.6 times Inventory days 60 days 15 days Trade receivables days 60 days 30 days Trade payables days 20 days 30 days Interest cover 3 times 5 times Required: Using the ratios above, explain to the directors of Conglong Limited what the ratios reveal about Conglong Limited’s…
Ivanhoe, Inc., has net income of $14,964,000 on net sales of $348,000,000. The company has total assets of $120,000,000 and stockholders' equity of $60,000,000. Use the extended DuPont identity to find the return on assets and return on equity for the firm. (Round answers to 2 decimal places, e.g. 12.25 or 12.25%.) Profit margin Total assets turnover Return on assets Return on equity % times % %