Prepare a vertical common size analysis for at least the most recent 2 years of the income statement. Use net sales or total revenue as the base.
I have been using 2020-2021 on the other sheets I created for this analysis.
Breakdown 3/31/2021 3/31/2020 3/31/2019 3/31/2018 > Total Revenue 27.214,593,000 29.929.992.000 30,225,681,000 29,379,510,000 Cost of Revenue 22,382.220,000 24,522,364,000 24,781,785,000 23,889,153,000 4,832,373.000 5,407,628,000 5,443,896,000 5,490,357,000 2,634.625.000 2,964,759,000 2.976,351.000 3,090,495,000 2,197.748.000 2,442,869,000 2,467,545,000 2,399.862.000 298,854,000 200.653,000 197.417.000 151,955,000 435,751,000 -88,915,000 -379,497.000 68,612,000 2.932.354.000 2,554,607,000 2,285,465,000 2,620,429.000 Gross Profit > Operating Expense Operating Income > Net Non Operating interest Inc. > Other Income Expense Pretax Income Tax Provision Earnings from Equity Interest Net... > Net Income Common Stockhold. Average Dilution Earnings Diluted Ni Available to Com Stockh... Basic EPS Diluted EPS 649,976,000 683.430,000 659.944.000 504,406,000 271.152.000 360.066.000 470,083,000 2,257.830,000 2,058.899,000 1,868,085,000 2,481,692.000 12,569.000 17.284.000 14,788,000 12,287.000 2.257.830,000 2,076,183,000 1,882.873,000 2,493.979.000 1.47k 130k 1.68% 1.46k 1.29 1.67K Basic Average Shares 1,399,459 1,435,767 1.473,683 1,423,009 1,459,337 1.497,383 2,197,748,000 2,442,869,000 2,467,545,000 2,399.862.000 25,016,845,000 27,487.123.000 27,758,136.000 26,979,648,000 Diluted Average Shares Total Operating Income as Reported Total Expenses Net Income from Continuing & Dis... Normalized Income Interest Income Interest Expense 2,245.261,000 2,076,183,000 1,882,873,000 2,493.983.000 2,164.365.338 2,152,032,840 2,116,545,994 2.475.670.488 105,600,000 232,870,000 225.495.000 179,541,000 42,421,000 32.217.000 28,078,000 27.586.000 Net Interest Income 298,854,000 200,653,000 197,417,000 151,955,000 EBIT 2,974,775.000 2,586,824,000 2,313,543,000 2,648,015.000 EBITDA Reconciled Cost of Revenue 22,382.220,000 24,522,364.000 24,781.785,000 23,889,153,000 1,644.290.000 1,605,383,000 1,792.375,000 1,734.033.000 2.245.261,000 2,076,183,000 1,882.873,000 2,493.983.000 103,979,000 -103,620,000 -328,654,000 22,664,000 Reconciled Depreciation Net Income from Continuing Oper... Total Unusual Items Excluding Go... Total Unusual Items Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 103,979,000 -103,620,000 -328,654,000 22.664,000 4.515.086.000 4,295,827,000 4,434,572,000 4,359,384.000 0 0 0 0 23.083,338 -27,770,160 -94.981,006 4.351.488
