Prepare a Vertical Analysis. Net SalesCost of Good SoldGross ProfitSelling and administrative expenseOperating IncomeInterest expenseIncome before income taxesIncome tax expenseNet incomeFIDAS MERCHANDISINGSTATEMENT OF COMPREHENSIVE INCOMEFor the year ended December 31, 2021 and 202021$2,213,3001,032,1001,181,200889,200P292,00090,900201,10060,300P140.800PERCENTAGE100.00%46.63%53.37%40.18%13.19%4.11%9.09%2.72%6.36%

Introduction:- Vertical analysis is used analysis each item in the financial statement is shown in…

Answered: Prepare a Vertical Analysis.

Business

Accounting

Prepare a Vertical Analysis.

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter2: Financial Statements, Cash Flow,and Taxes

Section: Chapter Questions

Problem 15P: Use the following income statement of Elliott Game Theory Consulting to determine its net operating...

See similar textbooks

Similar questions

Use the following income statement of Elliott Game Theory Consulting to determine its net operating profit after taxes (NOPAT). Use 25% as the tax rate. Elliott Game Theory Consulting Income Statement for Year Ending December 31
Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Intel-period Tax Allocation Chris Green, CPA, is auditing Rayne Co.s 2019 financial statements. For the year ended December 31, 2019, Rayne is applying GAAP for income taxes. Raynes controller, Dunn, has prepared a schedule of all differences between financial statement and income tax return income. Dunn believes that as a result of pending legislation, the enacted tax rate at December 31, 2019, will be increased for 2020. Dunn is uncertain which differences to include and which rates to apply in computing deferred taxes. Dunn has requested an overview of GAAP from Green. Required: Prepare a brief memo to Dunn from Green that identifies the objectives of accounting for income taxes, defines temporary differences, explains how to measure deferred tax assets and liabilities, and explains how to measure deferred income tax expense or benefit.
Intraperiod Tax Allocation Wright Company reports the following information for the year ended December 31, 2019: Required: 1. Prepare the year-end journal entry necessary to record the 2019 intraperiod income tax allocation in regard to the preceding information. 2. Prepare Wrights 2019 income statement and statement of retained earnings.
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). 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. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,788,322 211,362 571,823 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…
Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Reported Horizon Period $ millions 2018 2019 2020 2021 2022 TerminalPeriod Sales $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 NOA 4,032 4,097 4,158 4,221 4,284 4,327 Answer the following requirements assuming a discount rate (WACC) of 7.8%, a terminal period growth rate of 1%, common shares outstanding of 135.6 million, net nonoperating obligations (NNO) of $(6,129) million, which is negative because Humana’s nonoperating assets exceed its nonoperating liabilities, and no noncontrolling interest (NCI) on the balance sheet. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. Instructions: Round all answers to the nearest whole number, except for discount factors, shares outstanding (do not round), and…
Selected ratios formulars Unilever 2021 BOPP 2021 ROCE PBIT / net assets * 100 (32,424/39,406 *100 = - 82% 102,154 / 192,758 *100 =53% Net Assets Turnover Revenue / Net Assets 526,912 / 39,406 = 13 times 214,174 / 192,758 = 1 time Gross Profit Margin Gross profit / revenue *100 97,046 / 526,912 *100 18.4% 115,462 / 214,174 * 100 54% Net Profit Before Tax PBT / revenue * 100 (35,005) / 526,912* 100 = -6.6% 104,778 / 214,174* 100 =48.9% Current Ratio Current assets / current liabilities 214,665/341,171 = 0.5 139,104 / 30,368 = 4.5 Quick Ratio Current assets – inventory / current liabilities 214,665-91,627 /341,171 = 0.4 139,104 -13,248/ 30,368 = 4.1 Inventory Days Inventory / cost of sales * 365 days 91,627/ 429,866 *365 = 77 days 13,248 / 101,397 *365 = 47 days Receivable Days Receivables / cost of sales * 365 days 24,515 / 429,866 *365 =20 days 92,860 / 101,397 *365 =334 days Payable Days…
LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…
LOGIC COMPANYComparative Income StatementFor Years Ended December 31, 2019 and 2020 2020 2019 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANYComparative Balance SheetDecember 31, 2019 and 2020 2020 2019 Assets Current assets: Cash $ 12,000 $ 9,000 Accounts receivable 16,500 12,500 Merchandise inventory 8,500 14,000 Prepaid expenses 24,000 10,000 Total current assets $ 61,000 $ 45,500 Plant and…
Sound Break CorporationIncome and Retained Earnings StatementFor the year Ended December 31, 2020Net Sales P1,000,000Cost of Goods Sold:Inventory, Dec. 31, 2019 P250,000Purchases 720,000Total Goods Available P970,000Inventory 220,000 750,000Gross Margin on Sales P 250,000Selling and Administrative (including Depreciation of P20,000) 125,000Net Income before Tax P 125,000Provision for Income Tax 35,000Net Income for the Year P 90,000Retained Earnings, beginning 130,000Total P 220,000Dividends Paid 30,000Retained Earnings, December 31, 2020 P 190,000 Sound Break CorporationBALANCE SHEETDecember 31, 2019 and 2020 ASSETS 2019 2020Current Assets:Cash P 75,000 P 85,000Marketable Securities 25,000 25,000Trade Receivables, net 185,000 245,000Inventory, at cost 250,000 220,000Prepaid Expenses 15,000 10,000Total Current Assets P550,000 P585,000Property and Other Assets:Equipment, net P340,000 P320,000Other Assets 15,000 15,000Total Property and Other Assets P355,000 P335,000 Total Assets…