the first three photos are the financial data worksheet needed to complete the second two photos questions. please help.

Global Manufacturing, Inc. INCOME STATEMENT 7 2020 $53,037,400 38,240,000 5,103,800 9,693.600 2021 $63,412,800 46,418,200 5,985,800 20 11 11,000,000 TABLE #1 12 11 14 15 16 17 18 19 20 21 24 25 Total sales Cost of goods sold Administrative expense Earnings before Interest, taxes, depreciation & amortization (EBITDA Depreciation Earnings before interest & taxes (EDIT interent expense Earnings Before Taxes ( ET) Taxes Net Income Dividends Additions to Retained Earings 714,800 3,970,800 830,675 8,148,125 1,629,600 6,518,525 1,303,700 5,214,825 887 80D 10,121,000 1,166.300 6,054.700 1,790,900 7,163,800 1.432.800 5.731.000 Global Manufacturing, Inc. BALANCE SHEET 2020 2021 26 27 20 10 33 ANSET Cash ACCOUNT receivable inventory Total Current Ass NetPined Asset TOTAL ASSETS LAADILITIES STOCKHOLDERS EQUITY Accounts payable Natus pale ANCE DAYA COMMON WHO COMMON $750,500 12 076 209 11.239.000 24,056,300 23.100.000 147 252,300 $1,267 400 14,605,100 17.419.500 25,202,000 27,733,000 356,025,000 TABLE #2 34.850,100 5.417.100 54 000,500 741474100 I MVMTORO ONLOOKBOX Cain CHANGE FUATION MacBook Air 21 24 25 Global Manufacturing, Inc. BALANCE SHEET 2020 2021 25 27 28 29 30 $750, 500 12,076.200 11.239.600 24,066,300 23,136.000 547,252.300 $1,267,400 14,605,100 12.419.500 28,202,000 27.733.000 $56,025,000 32 33 34 15 36 37 TABLE #2 ng#n ASSETS Cash Accounts receivable Inventory Total Current Assets Net Fixed Assets TOTAL ASSETS LIABILITIES & STOCKHOLDER'S EQUITY Accounts payable Notes payable Total currenties Long-term debt TOTAL LIABILITIES Common stock Retained earnings TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDER'S EQUITY 54,839,100 5.687,100 10,526,200 8,073.000 18,600,100 5.250,000 23,402 200 28.652 200 547 252 300 34,690,500 74147.100 11,837,600 9.805.000 21,642,600 5.250,000 29,133,200 34,383,2001 556.025.000 39 40 41 42 41 44 45 35 2021 AR Global Manufacturing, Inc. ADDITIONAL INFORMATION information 2020 Depreciation of netweets 3.00 2 short term interest expense 5.42% Long-term interest expense 6.75% income tax rate 20.0054 nivar NANCIAL DATA COMMONSI COMMONS CHANGETRATOS 3.50% 5,779 7.20% 20.00% BLE 113 51 ITOS TWIATTON OF LOOK TABLE 14 35 35 37 38 39 40 41 LIABILITIES & STOCKHOLDER'S EQUITY Accounts payable Notes payable Total current liabilities Long-term debt TOTAL LIABILITIES Common stock Retained earnings TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDER'S FQUITY $4,839,100 5.687.100 10,526,200 8.073.900 18,600,100 5.250.000 23,402,200 28,652.200 $47,252,300 $4,690,500 7.147.100 11,837,600 9,805,000 21,642,600 5,250,000 29,133,200 34,383,200 $56,025,800 43 44 Global Manufacturing, Inc. ADDITIONAL INFORMATION 45 Information 2020 2021 47 41 SO 51 TABLE #3 3.50% 5.77% 7.29% 20.00% 20.00% 3.00% 5.42% 6.75% 20.00% 20.00% 98.50% 366.11 2,550,000 Depreciation as a % of not fixed assets Short-term interest expense Long-term interest expense Income tax rate Dividend payout ratio Fixed assets as a percent of total capacity. End of year stock price Number of common shares outstanding 81.20% $115.67 2,550,000 S6 57 If you chc statement Analysis calculate the same Benchmar 2020 COMMON SIZE STATEMENT CALCULATIONS AND ANALYSIS LINE BY UNE ANALYSIS OF 2020 INCOME STATEMENT Global BENCHMARK COMPARED TO Manufacturing FIRM THE BENCHMARK FIRM 10 2020 COMMON SIZE INCOME STATEMENT 2020 (BETTER, SAME AS, WORSE 2020 than the Benchmark firm) 11 Total sales 0.0% 100.0% 12 Cost of goods sold 0.0% 69.2% BETTER 13 Administrative expense 0.0% 9.6% BETTER Earnings before Interest, taxes, depreciation amortization 0.0% BETTER 14 EBITDA) 21.2% is Depreciation 0.0% 2.2% BETTER 16 Earnings before Interest&tas (EBIT) 0.0% 19.0% BETTER 12 Interest expense 0.0% 2.2% BETTER 11 Earnings Before TEROS (ET) 0.0% 16.0% BETTER 0.0% 20 Net Income 0.0% 13.7% BETTER 21 Dividende 0.0% 1.4% BETTER 22 Additions to Retained Earnings 0.0% 123% BELTER 23 1 Taxes BENCHMARK FIRM 2020 LINE BY LINE ANALYSIS OF 2020 BALANCE SHEET COMPARED TO THE BENCHMARK FIRM (BITTER, SAME AS WORSE than the Benchmark firm Global 24 Manufacturing 25 2020 COMMON SIZE BALANCE SHEET 2020 26 ASSETS Cash 0.0% ALBAN COMMONSI COMMONSITE CHANGE 6.7% BETTER WALLATION OF POWODOX GOVETAGIONE A B 0 0.0% 12.3% BETTER 22 Additions to Retained Earnings 23 Global Manufacturing 2020 24 LINE BY LINE ANALYSIS OF 2020 BALANCE SHEET COMPARED TO THE BENCHMARK FIRM BETTER, SAME AS, WORSE than the Benchmark firm) BENCHMARK FIRM 2020 25 2020 COMMON SIZE BALANCE SHEET 26 ASSETS 27 Cash 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 6.7% 16.4% 30.6% 53.7% 46.3% 100.0% BETTER BETTER BETTER BETTER BETTER BETTER 28 Accounts receivable 29 Inventory 30 Total Current Assets 31 Not fixed assets 32 TOTAL ASSETS 3 LIABILITIES & STOCKHOLDERS' EQUITY Accounts payable 2 Notes payable 36 Total Current Liabilities Long-term debit TOTAL LIABILITIES Common stock Retained earnings TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDERS' EQUITY BETTER DETTER BETTER BETTER BETTER 0.0% 0.0% 0.0% 0.0% 0.0% 0.0 0.0% 0.0% 0.0% 12.1% 19.4% 27.5% 15.8% 43.3% 4.5% 52.2% 56.7% 100.0% BETTER BETTER BETTER 15 TECIMENTOS COMMONS NANGUL DATA COMMON cwe OS 102021 TUDOWOFONDS MacBook Air