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.

[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) %

Bellingham Industries, a manufacturer of the furniture industry, had the following               financial performance for the last two years as shown on their income statements below:                               Billingham Industries, Inc.     Comparative Income Statement     For the Years Ended December 31, 2021 and 2020           2021   2020           Amount   Amount       Sales   $1,280,000   $1,180,000       Cost of goods sold   644,800   613,600       Gross profit   635,200   566,400       Selling expenses   230,500   188,800       Administrative expenses   182,500   177,000       Total operating expenses   413,000   365,800       Income from operations   222,200   200,600       Other income   77,000   70,800       Income before income tax   299,200   271,400       Income tax expense   121,600   106,200       Net income   $177,600   $165,200                                     1. Prepare a horizontal analysis using the form provided to…

Bellingham Industries, a manufacturer of the furniture industry, had the following               financial performance for the last two years as shown on their income statements below:                               Billingham Industries, Inc.     Comparative Income Statement     For the Years Ended December 31, 2021 and 2020           2021   2020           Amount   Amount       Sales   $1,280,000   $1,180,000       Cost of goods sold   644,800   613,600       Gross profit   635,200   566,400       Selling expenses   230,500   188,800       Administrative expenses   182,500   177,000       Total operating expenses   413,000   365,800       Income from operations   222,200   200,600       Other income   77,000   70,800       Income before income tax   299,200   271,400       Income tax expense   121,600   106,200       Net income   $177,600   $165,200                                     1. Prepare a horizontal analysis using the form provided to…

please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)

Bramble Corp. reported the following in its 2025 and 2024 income statements. Net sales Cost of goods sold Operating expenses Income tax expense Net income Gross profit rate 2025 $154,000 86,240 27,720 21,560 $18,480 (a1) Determine the company's gross profit rate and profit margin for both years. (Round answers to 1 decimal place, eg. 52.7%) Profit margin 2024 $124,000 69,440 16,120 13,640 $24,800 2025 2024 %

Please help with all the calculations and answer The 2016 income statement for J.Galarraga Corporation is below: Revenues $ 14,000,000Cost of Goods Sold 6,500,000Gross Margin $ 7,500,000Selling Expenses 3,400,000Administrative Expenses 700,000Net Operating Income $ 3,400,000 The company's margin of safety is $8,500,000. What would our revenues need to be to earn the NOI of $5,100,000?A. $ 16,300,000B. $ 19,750,000C. $ 18,250,000D. $ 15,700,000E. None of the above