- Provide common-size analysis of your companys income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
- Income Statements
-
- Balance sheet
- Please show what to put for the formulas in excel. Thank-you
Key Stats Income Statement Balance Sheet Cash Flow Ratios Restatement: Latest Filings Enable Freeze Panes Order: Latest on Left Go More Options >> View All 2020 2019 2018 2017 LTM 12 months Jun-26-2021 USD 12 months Mar-27-2021 USD 12 months Mar-28-2020 USD Reclassified 12 months Mar-30-2019 USD Reclassified 12 months Mar-31-2018 USD Reclassified 12 months Apr-01-2017 USD 5,289.6 4,400.8 6,159.8 6,313.0 6,182.3 6,652.8 i i i i 5,289.6 1,788.8 3,500.8 2,862.1 (12.1) 4,400.8 1,510.1 2,890.7 2,666.8 (27.5) 6,159.8 2,347.0 3,812.8 3,081.4 58.7 6,313.0 2,419.8 3,893.2 3,144.4 0.4 6,182.3 2,423.0 3,759.3 3,061.3 10.2 6,652.8 2,803.8 3,849.0 2,857.3 6.2 i i 14.7 20.2 11.4 18.1 22.9 29.6 283.4 24.1 24.0 i i i i Template: Standard Period Type: Annual 2022 2021 In Millions of the reported currency, except per share items. Chart Selected Items For the Fiscal Period Ending Currency + Revenue Other Revenue Total Revenue # Cost Of Goods Sold Gross Profit Selling General & Admin Exp. Provision for Bad Debts R & D Exp. Depreciation & Amort. Amort. of Goodwill and Intangibles F Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Income/(Loss) from Affiliates Currency Exchange Gains (Loss) + Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. + Asset Writedown Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. # Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg. Diluted Shares Out. Normalized Basic EPS Normalized Diluted EPS Dividends per Share Payout Ratio % 2,896.3 604.5 (52.2) 8.6 (43.6) (0.1) 3.3 3.2 567.3 (249.3) 20.5 20.2 11.4 2,691.3 199.4 (48.5) 9.7 (38.8) (0.1) 8.7 (1.0) 168.2 (236.8) 3,210.7 602.1 (17.6) 34.4 16.8 0.1 (1.1) 0.7 618.6 (48.5) 23.5 18.2 3,186.5 706.7 (20.7) 40.8 20.1 2.9 (2.8) 0.5 727.4 (130.2) 3,095.5 663.8 (18.2) 12.3 (5.9) (4.5) 4.5 (3.1) 654.8 (116.9) 3,171.0 678.0 (12.4) 7.3 (5.1) (5.2) 1.1 (3.4) 665.4 (745.7) i i i i i i i (26.6) 16.4 307.8 136.5 171.3 (26.6) 20.4 (74.8) 46.3 (121.1) (7.1) (22.9) (213.7) 326.4 (57.9) 384.3 (10.5) (4.2 582.5 (34.0) (14.7) 489.2 326.4 162.8 (24.6) (104.9) (5.6 (99.3) i 151.6 430.9 171.3 (121.1) 384.3 430.9 162.8 (99.3) i 171.3 (121.1) 384.3 430.9 162.8 (99.3) i i 171.3 171.3 (121.1) (121.1) 384.3 384.3 430.9 430.9 162.8 162.8 (99.3) (99.3) $5.35 5.35 80.6 i $ 2.33 2.33 73.7 $ 2.31 2.31 74.1 $ 4.81 4.79 $0.69 0.0% i $ (1.65) (1.65) 73.5 $ (1.65) (1.65) 73.5 1.43 1.43 $ 5.07 5.07 75.8 $ 4.98 4.98 77.2 $ 5.10 5.01 $ 2.75 53.1% $ (1.20) (1.20) 82.7 $ (1.20) (1.20) 82.7 $ 1.99 1.99 81.7 $ 1.97 1.97 82.5 S 5.01 4.96 $ 2.00 99.8% $ 5.27 5.27 81.7 S 5.64 5.56 $ 2.50 44.3% i $ 5.03 5.03 NA NM $ 2.00 NM i 845.6 624.7 604.5 NA 44.3% (40.0) 50.7 10.7 15.7 19.9 35.6 354.6 NA i Supplemental Items EBITDA EBITA EBIT EBITDAR Effective Tax Rate % Current Domestic Taxes Current Foreign Taxes Total Current Taxes Deferred Domestic Taxes Deferred Foreign Taxes Total Deferred Taxes Normalized Net Income Interest on Long Term Debt Non-Cash Pension Expense Filing Date Restatement Type Calculation Type Supplemental Operating Expense Items Advertising Exp. Selling and Marketing Exp. Net Rental Exp. Imputed Oper. Lease Interest Exp. Imputed Oper. Lease Depreciation Stock-Based Comp., SG&A Exp. Stock-Based Comp., Unallocated Stock-Based Comp., Total 447.0 219.6 199.4 998.3 NM (40.0) 50.7 10.7 15.7 19.9 35.6 105.1 9.7 (0.8) May-20-2021 o REP 973.9 730.2 706.7 1,423.2 26.0% 49.2 93.9 143.1 11.9 (3.4) 8.5 871.6 625.0 602.1 1,494.2 NM 18.3 92.6 110.9 (23.6) (145.2) (168.8) 386.6 8.1 0.3 May-20-2021 NC REP 944.9 687.8 663.8 1,388.0 66.7% 159.6 82.7 242.3 76.7 7.4 84.1 409.3 NA 2.0 May-27-2020 RC REP 985.5 702.1 678.0 1,446.0 NM (31.4) 64.7 33.3 (28.0) (10.9 (38.9 415.9 NA 2.5 May-16-2019 RC REP i 454.6 NA (0.2) May-20-2021 RC REP i Aug-03-2021 o LTM NA 472.4 NA i i 265.0 458.1 551.3 62.5 488.8 278.0 478.7 622.6 42.2 580.4 97.0 3.6 100.6 272.8 475.0 449.3 82.9 366.4 88.6 241.1 435.6 443.1 74.3 368.8 219.9 432.8 460.5 48.0 412.5 59.3 4.3 63.6 72.7 i 74.0 2.0 76.0 71.7 2.8 74.5 72.7 88.6 Jun-26-2021 USD Mar-27-2021 USD Mar-28-2020 USD i i i i i i 2,596.4 368.0 2,964.4 367.2 130.8 498.0 808.0 88.5 2,579.0 197.5 2,776.5 451.5 120.4 571.9 1,620.4 495.9 2,116.3 277.1 138.3 415.4 i i i i 764.0 72.0 1.5 22.1 4,208.0 4,545.2 (2,291.7) 2,253.5 19.3 4,378.2 4,404.2 (2,248.3) 2,155.9 736.4 74.7 1.4 31.0 3,375.2 4,619.5 (2,128.4) 2,491.1 i i i i i i i i 937.8 116.6 290.2 5.3 77.9 7,961.9 934.6 121.1 283.9 5.3 81.1 7,887.5 915.5 141.0 245.2 4.9 107.0 7,279.9 i i i i i i i i # Balance Sheet as of: Currency ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments Accounts Receivable Other Receivables Total Receivables Inventory Prepaid Exp. Restricted Cash Other Current Assets Total Current Assets Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Long-term Investments + Goodwill # Other Intangibles Deferred Tax Assets, LT Deferred Charges, LT Other Long-Term Assets Total Assets LIABILITIES Accounts Payable Accrued Exp. # Short-term Borrowings + Curr. Port. of LT Debt + Curr. Port. of Leases Curr. Income Taxes Payable + Unearned Revenue, Current Other Current Liabilities Total Current Liabilities Long-Term Debt Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities + Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity Supplemental Items Total Shares Out. on Filing Date Total Shares Out. on Balance Sheet Date Book Value/Share Tangible Book Value Tangible Book Value/Share Total Debt Net Debt Debt Equiv. of Unfunded Proj. Benefit Obligat.. Debt Equivalent Oper. Leases Inventory Method Land Buildings Machinery Construction in Progress Leasehold Improvements Full Time Employees Part-Time Employees Accum. Allowance for Doubtful Accts Filing Date Restatement Type Calculation Type 370.3 727.3 - 498.7 304.4 60.9 9.7 142.0 2,113.3 1,135.0 1,594.5 22.4 10.8 368.2 5,244.2 i i i i i 355.9 722.3 - - 322.6 50.6 12.0 121.4 1,584.8 1,632.9 1,665.0 22.4 10.7 367.3 5,283.1 1.3 2,667.1 5,872.9 (5,816.1) (120.8) 2,604.4 2,604.4 7,887.5 246.8 581.4 475.0 299.8 298.2 65.1 14.6 111.1 2,092.0 396.4 1,757.7 19.5 10.0 311.2 4,586.8 1.3 2,594.4 5,994.0 (5.778.4) (118.2) 2,693.1 2,693.1 7,279.9 i i i i 1.3 2,685.5 5,987.1 (5,844.9) (111.3) 2,717.7 2,717.7 7,961.9 i i i i i i i i i 73.5 73.6 $ 36.93 1,663.3 $ 22.60 3,532.6 568.2 NA NA NA 15.3 492.8 981.0 32.4 1,146.8 NA NA 38.6 Aug-03-2021 o REP 73.1 73.2 $ 35.58 1,548.7 $ 21.16 3,620.5 844.0 (0.7) 4,410.4 Avg Cost 15.3 492.8 1,000.7 34.5 1,207.2 12,100 8,200 40.1 May-20-2021 o REP 72.7 73.5 $ 36.64 1,636.6 $ 22.27 3,227.1 1,110.8 4.0 4,980.8 Avg Cost 15.3 309.0 1,008.3 37.5 1,194.5 13,700 11,200 71.5 May-20-2021 NC REP i i i i i i i Key Stats Income Statement Balance Sheet Cash Flow Ratios Restatement: Latest Filings Enable Freeze Panes Order: Latest on Left Go More Options >> View All 2020 2019 2018 2017 LTM 12 months Jun-26-2021 USD 12 months Mar-27-2021 USD 12 months Mar-28-2020 USD Reclassified 12 months Mar-30-2019 USD Reclassified 12 months Mar-31-2018 USD Reclassified 12 months Apr-01-2017 USD 5,289.6 4,400.8 6,159.8 6,313.0 6,182.3 6,652.8 i i i i 5,289.6 1,788.8 3,500.8 2,862.1 (12.1) 4,400.8 1,510.1 2,890.7 2,666.8 (27.5) 6,159.8 2,347.0 3,812.8 3,081.4 58.7 6,313.0 2,419.8 3,893.2 3,144.4 0.4 6,182.3 2,423.0 3,759.3 3,061.3 10.2 6,652.8 2,803.8 3,849.0 2,857.3 6.2 i i 14.7 20.2 11.4 18.1 22.9 29.6 283.4 24.1 24.0 i i i i Template: Standard Period Type: Annual 2022 2021 In Millions of the reported currency, except per share items. Chart Selected Items For the Fiscal Period Ending Currency + Revenue Other Revenue Total Revenue # Cost Of Goods Sold Gross Profit Selling General & Admin Exp. Provision for Bad Debts R & D Exp. Depreciation & Amort. Amort. of Goodwill and Intangibles F Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Income/(Loss) from Affiliates Currency Exchange Gains (Loss) + Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill Gain (Loss) On Sale Of Invest. + Asset Writedown Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. # Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg. Diluted Shares Out. Normalized Basic EPS Normalized Diluted EPS Dividends per Share Payout Ratio % 2,896.3 604.5 (52.2) 8.6 (43.6) (0.1) 3.3 3.2 567.3 (249.3) 20.5 20.2 11.4 2,691.3 199.4 (48.5) 9.7 (38.8) (0.1) 8.7 (1.0) 168.2 (236.8) 3,210.7 602.1 (17.6) 34.4 16.8 0.1 (1.1) 0.7 618.6 (48.5) 23.5 18.2 3,186.5 706.7 (20.7) 40.8 20.1 2.9 (2.8) 0.5 727.4 (130.2) 3,095.5 663.8 (18.2) 12.3 (5.9) (4.5) 4.5 (3.1) 654.8 (116.9) 3,171.0 678.0 (12.4) 7.3 (5.1) (5.2) 1.1 (3.4) 665.4 (745.7) i i i i i i i (26.6) 16.4 307.8 136.5 171.3 (26.6) 20.4 (74.8) 46.3 (121.1) (7.1) (22.9) (213.7) 326.4 (57.9) 384.3 (10.5) (4.2 582.5 (34.0) (14.7) 489.2 326.4 162.8 (24.6) (104.9) (5.6 (99.3) i 151.6 430.9 171.3 (121.1) 384.3 430.9 162.8 (99.3) i 171.3 (121.1) 384.3 430.9 162.8 (99.3) i i 171.3 171.3 (121.1) (121.1) 384.3 384.3 430.9 430.9 162.8 162.8 (99.3) (99.3) $5.35 5.35 80.6 i $ 2.33 2.33 73.7 $ 2.31 2.31 74.1 $ 4.81 4.79 $0.69 0.0% i $ (1.65) (1.65) 73.5 $ (1.65) (1.65) 73.5 1.43 1.43 $ 5.07 5.07 75.8 $ 4.98 4.98 77.2 $ 5.10 5.01 $ 2.75 53.1% $ (1.20) (1.20) 82.7 $ (1.20) (1.20) 82.7 $ 1.99 1.99 81.7 $ 1.97 1.97 82.5 S 5.01 4.96 $ 2.00 99.8% $ 5.27 5.27 81.7 S 5.64 5.56 $ 2.50 44.3% i $ 5.03 5.03 NA NM $ 2.00 NM i 845.6 624.7 604.5 NA 44.3% (40.0) 50.7 10.7 15.7 19.9 35.6 354.6 NA i Supplemental Items EBITDA EBITA EBIT EBITDAR Effective Tax Rate % Current Domestic Taxes Current Foreign Taxes Total Current Taxes Deferred Domestic Taxes Deferred Foreign Taxes Total Deferred Taxes Normalized Net Income Interest on Long Term Debt Non-Cash Pension Expense Filing Date Restatement Type Calculation Type Supplemental Operating Expense Items Advertising Exp. Selling and Marketing Exp. Net Rental Exp. Imputed Oper. Lease Interest Exp. Imputed Oper. Lease Depreciation Stock-Based Comp., SG&A Exp. Stock-Based Comp., Unallocated Stock-Based Comp., Total 447.0 219.6 199.4 998.3 NM (40.0) 50.7 10.7 15.7 19.9 35.6 105.1 9.7 (0.8) May-20-2021 o REP 973.9 730.2 706.7 1,423.2 26.0% 49.2 93.9 143.1 11.9 (3.4) 8.5 871.6 625.0 602.1 1,494.2 NM 18.3 92.6 110.9 (23.6) (145.2) (168.8) 386.6 8.1 0.3 May-20-2021 NC REP 944.9 687.8 663.8 1,388.0 66.7% 159.6 82.7 242.3 76.7 7.4 84.1 409.3 NA 2.0 May-27-2020 RC REP 985.5 702.1 678.0 1,446.0 NM (31.4) 64.7 33.3 (28.0) (10.9 (38.9 415.9 NA 2.5 May-16-2019 RC REP i 454.6 NA (0.2) May-20-2021 RC REP i Aug-03-2021 o LTM NA 472.4 NA i i 265.0 458.1 551.3 62.5 488.8 278.0 478.7 622.6 42.2 580.4 97.0 3.6 100.6 272.8 475.0 449.3 82.9 366.4 88.6 241.1 435.6 443.1 74.3 368.8 219.9 432.8 460.5 48.0 412.5 59.3 4.3 63.6 72.7 i 74.0 2.0 76.0 71.7 2.8 74.5 72.7 88.6 Jun-26-2021 USD Mar-27-2021 USD Mar-28-2020 USD i i i i i i 2,596.4 368.0 2,964.4 367.2 130.8 498.0 808.0 88.5 2,579.0 197.5 2,776.5 451.5 120.4 571.9 1,620.4 495.9 2,116.3 277.1 138.3 415.4 i i i i 764.0 72.0 1.5 22.1 4,208.0 4,545.2 (2,291.7) 2,253.5 19.3 4,378.2 4,404.2 (2,248.3) 2,155.9 736.4 74.7 1.4 31.0 3,375.2 4,619.5 (2,128.4) 2,491.1 i i i i i i i i 937.8 116.6 290.2 5.3 77.9 7,961.9 934.6 121.1 283.9 5.3 81.1 7,887.5 915.5 141.0 245.2 4.9 107.0 7,279.9 i i i i i i i i # Balance Sheet as of: Currency ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments Accounts Receivable Other Receivables Total Receivables Inventory Prepaid Exp. Restricted Cash Other Current Assets Total Current Assets Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Long-term Investments + Goodwill # Other Intangibles Deferred Tax Assets, LT Deferred Charges, LT Other Long-Term Assets Total Assets LIABILITIES Accounts Payable Accrued Exp. # Short-term Borrowings + Curr. Port. of LT Debt + Curr. Port. of Leases Curr. Income Taxes Payable + Unearned Revenue, Current Other Current Liabilities Total Current Liabilities Long-Term Debt Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities + Common Stock Additional Paid In Capital Retained Earnings Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity Supplemental Items Total Shares Out. on Filing Date Total Shares Out. on Balance Sheet Date Book Value/Share Tangible Book Value Tangible Book Value/Share Total Debt Net Debt Debt Equiv. of Unfunded Proj. Benefit Obligat.. Debt Equivalent Oper. Leases Inventory Method Land Buildings Machinery Construction in Progress Leasehold Improvements Full Time Employees Part-Time Employees Accum. Allowance for Doubtful Accts Filing Date Restatement Type Calculation Type 370.3 727.3 - 498.7 304.4 60.9 9.7 142.0 2,113.3 1,135.0 1,594.5 22.4 10.8 368.2 5,244.2 i i i i i 355.9 722.3 - - 322.6 50.6 12.0 121.4 1,584.8 1,632.9 1,665.0 22.4 10.7 367.3 5,283.1 1.3 2,667.1 5,872.9 (5,816.1) (120.8) 2,604.4 2,604.4 7,887.5 246.8 581.4 475.0 299.8 298.2 65.1 14.6 111.1 2,092.0 396.4 1,757.7 19.5 10.0 311.2 4,586.8 1.3 2,594.4 5,994.0 (5.778.4) (118.2) 2,693.1 2,693.1 7,279.9 i i i i 1.3 2,685.5 5,987.1 (5,844.9) (111.3) 2,717.7 2,717.7 7,961.9 i i i i i i i i i 73.5 73.6 $ 36.93 1,663.3 $ 22.60 3,532.6 568.2 NA NA NA 15.3 492.8 981.0 32.4 1,146.8 NA NA 38.6 Aug-03-2021 o REP 73.1 73.2 $ 35.58 1,548.7 $ 21.16 3,620.5 844.0 (0.7) 4,410.4 Avg Cost 15.3 492.8 1,000.7 34.5 1,207.2 12,100 8,200 40.1 May-20-2021 o REP 72.7 73.5 $ 36.64 1,636.6 $ 22.27 3,227.1 1,110.8 4.0 4,980.8 Avg Cost 15.3 309.0 1,008.3 37.5 1,194.5 13,700 11,200 71.5 May-20-2021 NC REP
