first 4 is data, I need common size statement and analysis. please show me how you come up with numbers

will rate! please help!

Global Manufacturing, Inc. Introduction Phil Jackson, President and CEO, knew that good products and good service were important to his customers. Global Manufacturing, Inc. provides floor cleaning products for household users and business customers worldwide. The company offers many different types of floor cleaning vacuum systems. Global Manufacturing, Inc. sells its products to many different distributors, retailers, and resellers through its sales force. There has been an increasing demand for things Global Manufacturing, Inc. sells as the economy continues to improve. The growth in the sales was the good news for Phil. The less than good news was the intense competition they faced from other companies worldwide, especially Apex Manufacturing, Inc. Kim Holland, the company's Chief Financial Officer (CFO), was preparing for the end-of-year Senior Staff and Board meeting where all senior management would be presenting their expectations for next year. Kim wants to be fully prepared for this meeting to discuss the current financial condition of the company and the expectations for the future. Kim decided to enlist your help in preparing the financial analysis to present to the Senior Staff and the Board of Directors. She wants to examine the firm's financial statements from the last two years to see how well they had done and from this analysis she wants to develop an action plan for correcting any weaknesses without diminishing the strengths that the company already has. Kim had the accounting department prepare all the financial information you will need to complete this case study for Global Manufacturing. You will find all of the financial data needed for this case study presented in the various Excel worksheets of this file. Always use cell references to the FINANCIAL DATA worksheet data, do not type actual values into your formulas. INCOME STATEMENT o 2020 2021 $53,037,400 38,240,000 5,103,800 $63,412,800 46,418,200 5,985,800 9,693,600 11,008,800 TABLE #1 Total sales Cost of goods sold Administrative expense Earnings before interest, taxes, depreciation & amortization (EBITDA) Depreciation Earnings before interest & taxes.(EBIT) Interest expense Earnings Before Taxes (EBT) Taxes Net income Dividends Additions to Retained Earnings 15 16 17 18 19 20 21 714,800 8,978,800 830,675 8,148,125 1,629,600 6,518,525 1,303,700 5,214,825 887,800 10,121,000 1,166,300 8,954,700 1,790,900 7,163,800 1,432,800 5,731,000 BALANCE SHEET e 2020 2021 $750,500 12,076,200 11,239,600 24,066,300 23,186,000 $47,252,300 $1,267,400 14,605,100 12,419,500 28,292,000 27,733,800 $56,025,800 7 8 9 0 31 32 33 34 35 36 37 38 39 40 41 42 TABLE #2 ASSETS Cash Accounts receivable Inventory Total Current Assets Net Fixed Assets TOTAL ASSETS 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 EQUITY $4,839,100 5,687,100 10,526,200 8,073,900 18,600,100 5,250,000 23,402,200 28,652,200 $4,690,500 7,147,100 11,837,600 9,805,000 21,642,600 5,250,000 29,133,200 34,383,200 NO $47,252,300 $56,025,800 43 Global Manufacturing, Inc. ADDITIONAL INFORMATION Information 2020 2021 TABLE #3 Depreciation as a % of net fixed assets Short-term interest expense Long-term interest expense Income tax rate Dividend payout ratio 3.00% 5.42% 6.75% 20.00% 20.00% 3.50% 5.77% 7.29% 20.00% 20.00% Fixed assets as a percent of total capacity. 98.50% 81.20% 3 4 5 End of year stock price Number of common shares outstanding $66.11 2,550,000 $115.67 2,550,000 56 Global Manufacturing, Inc. 7 2020 COMMON SIZE STATEMENT CALCULATIONS AND ANALYSIS 8 Global Manufacturing BENCHMARK FIRM LINE BY LINE ANALYSIS OF 2020 INCOME STATEMENT COMPARED TO THE BENCHMARK FIRM (BETTER, SAME AS, WORSE than the Benchmark firm) 9 2020 10 2020 COMMON SIZE INCOME STATEMENT 11 Total sales 2020 0.0% 100.0% 0.0% 69.2% 0.0% 9.6% 0.0% 21.2% 12 Cost of goods sold 13 Administrative expense Earnings before interest, taxes, depreciation & 14 amortization (EBITDA) 15 Depreciation 16 Earnings before interest & taxes.(EBIT) 17 Interest expense 18 Earnings Before Taxes (EBT) 0.0% 2.2% 0.0% 19.0% 0.0% 2.2% 0.0% 16.8% TRATIO5202 EVALUA ... + COMMON SIZE 2021 RATIOS 2020 % CHANGE CASE STUDY INSTRUCTIONS FINANCIAL DATA COMMON SIZ 2020 520 A B C D 3 Earnings Before Taxes (EBT) E 0.0% 16.8% Taxes 0.0% 12.3% 13.7% Net income 1 Dividends E2 Additions to Retained Earnings 0.0% 1.4% 0.0% 12.3% 23 Global Manufacturing BENCHMARK FIRM LINE BY LINE ANALYSIS OF 2020 BALANCE SHEET COMPARED TO THE BENCHMARK FIRM (BETTER, SAME AS, WORSE than the Benchmark firm) 24 2020 2020 25 2020 COMMON SIZE BALANCE SHEET 26 ASSETS 0.0% 6.7% 27 Cash 28 Accounts receivable 0.0% 16.4% 30.6% 0.0% 29 Inventory 50.9% 53.7% 30 Total Current Assets 21 Net fixed assets CASE STUDY INSTRUCTIONS 0.0% COMMON SIZE 2020 COMMON SIZE 2021 46.3% % CHANGE RATIOS 2020 RATIOS 2021 EVALUAT FINANCIAL DATA Ready 52F B D 30 Total Current Assets 50.9% 53.7% 31 Net fixed assets 0.0% 46.3% 32 TOTAL ASSETS 0.0% 100.0% 33 LIABILITIES & STOCKHOLDERS' EQUITY 34 Accounts payable 0.0% 35 Notes payable 0.0% 22.3% 36 Total Current Liabilities 37 Long-term debt 0.0% 0.0% 38 TOTAL LIABILITIES 12.1% 15.4% 27.5% 15.8% 43.3% 4.5% 52.2% 56.7% 100.0% 39 Common stock 0.0% 0.0% 40 Retained earnings* 41 TOTAL STOCKHOLDERS' EQUITY 42 TOTAL LIABILITIES & STOCKHOLDERS' EQUITY 0.0% 0.0% 45 46 47 48 COMMON SIZE 2021 RATIOS 2021 EVALUA COMMON SIZE 2020 % CHANGE RATIOS 2020 CINANCIAL DATA + Global Manufacturing, Inc. Introduction Phil Jackson, President and CEO, knew that good products and good service were important to his customers. Global Manufacturing, Inc. provides floor cleaning products for household users and business customers worldwide. The company offers many different types of floor cleaning vacuum systems. Global Manufacturing, Inc. sells its products to many different distributors, retailers, and resellers through its sales force. There has been an increasing demand for things Global Manufacturing, Inc. sells as the economy continues to improve. The growth in the sales was the good news for Phil. The less than good news was the intense competition they faced from other companies worldwide, especially Apex Manufacturing, Inc. Kim Holland, the company's Chief Financial Officer (CFO), was preparing for the end-of-year Senior Staff and Board meeting where all senior management would be presenting their expectations for next year. Kim wants to be fully prepared for this meeting to discuss the current financial condition of the company and the expectations for the future. Kim decided to enlist your help in preparing the financial analysis to present to the Senior Staff and the Board of Directors. She wants to examine the firm's financial statements from the last two years to see how well they had done and from this analysis she wants to develop an action plan for correcting any weaknesses without diminishing the strengths that the company already has. Kim had the accounting department prepare all the financial information you will need to complete this case study for Global Manufacturing. You will find all of the financial data needed for this case study presented in the various Excel worksheets of this file. Always use cell references to the FINANCIAL DATA worksheet data, do not type actual values into your formulas. INCOME STATEMENT o 2020 2021 $53,037,400 38,240,000 5,103,800 $63,412,800 46,418,200 5,985,800 9,693,600 11,008,800 TABLE #1 Total sales Cost of goods sold Administrative expense Earnings before interest, taxes, depreciation & amortization (EBITDA) Depreciation Earnings before interest & taxes.(EBIT) Interest expense Earnings Before Taxes (EBT) Taxes Net income Dividends Additions to Retained Earnings 15 16 17 18 19 20 21 714,800 8,978,800 830,675 8,148,125 1,629,600 6,518,525 1,303,700 5,214,825 887,800 10,121,000 1,166,300 8,954,700 1,790,900 7,163,800 1,432,800 5,731,000 BALANCE SHEET e 2020 2021 $750,500 12,076,200 11,239,600 24,066,300 23,186,000 $47,252,300 $1,267,400 14,605,100 12,419,500 28,292,000 27,733,800 $56,025,800 7 8 9 0 31 32 33 34 35 36 37 38 39 40 41 42 TABLE #2 ASSETS Cash Accounts receivable Inventory Total Current Assets Net Fixed Assets TOTAL ASSETS 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 EQUITY $4,839,100 5,687,100 10,526,200 8,073,900 18,600,100 5,250,000 23,402,200 28,652,200 $4,690,500 7,147,100 11,837,600 9,805,000 21,642,600 5,250,000 29,133,200 34,383,200 NO $47,252,300 $56,025,800 43 Global Manufacturing, Inc. ADDITIONAL INFORMATION Information 2020 2021 TABLE #3 Depreciation as a % of net fixed assets Short-term interest expense Long-term interest expense Income tax rate Dividend payout ratio 3.00% 5.42% 6.75% 20.00% 20.00% 3.50% 5.77% 7.29% 20.00% 20.00% Fixed assets as a percent of total capacity. 98.50% 81.20% 3 4 5 End of year stock price Number of common shares outstanding $66.11 2,550,000 $115.67 2,550,000 56 Global Manufacturing, Inc. 7 2020 COMMON SIZE STATEMENT CALCULATIONS AND ANALYSIS 8 Global Manufacturing BENCHMARK FIRM LINE BY LINE ANALYSIS OF 2020 INCOME STATEMENT COMPARED TO THE BENCHMARK FIRM (BETTER, SAME AS, WORSE than the Benchmark firm) 9 2020 10 2020 COMMON SIZE INCOME STATEMENT 11 Total sales 2020 0.0% 100.0% 0.0% 69.2% 0.0% 9.6% 0.0% 21.2% 12 Cost of goods sold 13 Administrative expense Earnings before interest, taxes, depreciation & 14 amortization (EBITDA) 15 Depreciation 16 Earnings before interest & taxes.(EBIT) 17 Interest expense 18 Earnings Before Taxes (EBT) 0.0% 2.2% 0.0% 19.0% 0.0% 2.2% 0.0% 16.8% TRATIO5202 EVALUA ... + COMMON SIZE 2021 RATIOS 2020 % CHANGE CASE STUDY INSTRUCTIONS FINANCIAL DATA COMMON SIZ 2020 520 A B C D 3 Earnings Before Taxes (EBT) E 0.0% 16.8% Taxes 0.0% 12.3% 13.7% Net income 1 Dividends E2 Additions to Retained Earnings 0.0% 1.4% 0.0% 12.3% 23 Global Manufacturing BENCHMARK FIRM LINE BY LINE ANALYSIS OF 2020 BALANCE SHEET COMPARED TO THE BENCHMARK FIRM (BETTER, SAME AS, WORSE than the Benchmark firm) 24 2020 2020 25 2020 COMMON SIZE BALANCE SHEET 26 ASSETS 0.0% 6.7% 27 Cash 28 Accounts receivable 0.0% 16.4% 30.6% 0.0% 29 Inventory 50.9% 53.7% 30 Total Current Assets 21 Net fixed assets CASE STUDY INSTRUCTIONS 0.0% COMMON SIZE 2020 COMMON SIZE 2021 46.3% % CHANGE RATIOS 2020 RATIOS 2021 EVALUAT FINANCIAL DATA Ready 52F B D 30 Total Current Assets 50.9% 53.7% 31 Net fixed assets 0.0% 46.3% 32 TOTAL ASSETS 0.0% 100.0% 33 LIABILITIES & STOCKHOLDERS' EQUITY 34 Accounts payable 0.0% 35 Notes payable 0.0% 22.3% 36 Total Current Liabilities 37 Long-term debt 0.0% 0.0% 38 TOTAL LIABILITIES 12.1% 15.4% 27.5% 15.8% 43.3% 4.5% 52.2% 56.7% 100.0% 39 Common stock 0.0% 0.0% 40 Retained earnings* 41 TOTAL STOCKHOLDERS' EQUITY 42 TOTAL LIABILITIES & STOCKHOLDERS' EQUITY 0.0% 0.0% 45 46 47 48 COMMON SIZE 2021 RATIOS 2021 EVALUA COMMON SIZE 2020 % CHANGE RATIOS 2020 CINANCIAL DATA +