Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The first three photos are the financial information needed to answer the questions in yellow on the last two photos. please help ASAP. Global Manufacturing,
The first three photos are the financial information needed to answer the questions in yellow on the last two photos. please help ASAP.
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 D Always use cell reference for all calculations. Global Manufacturing, Inc. 2021 FINANCIAL RATIO CALCULATIONS AND ANALYSIS INCOME STATEMENT BENCHMARK FIRM If you stato be su YOUR ANALYSIS OF 2021 RATIO (BETTER, SAME, or, WORSE than the benchmark firm) RATI docin value 2021 2021 0.0% 0.0% 0.0% 0.0% 0.0% 13.8% 9.2% 12.8% 23.8% 85.9% WORSE WORSE WORSE WORSE WORSE 9 ASSIGNED RATIOS 10 PROFITABILITY RATIOS 11 Operating Margin 12 Profit Margin 13 Return On Assets (ROA) 14 Return On Common Equity (ROU) 15 Plowback or Retention Ratio 16 ASSET UTILIZATION RATIOS 17 Receivables Turnover 13 Days Sales in Receivables 19 Inventory Turnover 20 Days Sales in Inventory 21 Fixed Asset Turnover 22 Total Asset Turnover 2 LIQUIDITY RATIOS 24 Current Ratio WORSE 0.0 0.0 0.0 0.0 0.0 0.0 7.1 51.4 2.7 135.2 2.8 1.1 WORSE WORSE WORSE WORSE WORSE 0.0 1.9 WORSE nn COMMON SIZE 2021 ANCIAL DATA COMMON SIZE 2020 CHANGE FUATIOS 2020 ane RATIOS 2021 EVALUATION OF FINDINOS LOCK C D 24 Current Ratio 25 Quick ratio 26 Cash Ratio 0.0 0.0 1.9 0.8 0.2 WORSE WORSE WORSE 0.0 WORSE WORSE WORSE 27 FINANCIAL LEVERAGE RATIOS 28 Accounts Payable Ratio 29 Notes Payable Ratio 30 Long-term-debt Ratio 31 Total Debt Ratio 32 Debt-Equity Ratio 33 Equity Multiplier 34 Times Interest Earned 35 Cash Coverage Ratio 0.0% 0.0% 0.0% 0.0% 0.0 0.0 0.0 0.0 29.4% 34.3% 36.3% 45.2% 0.8 1.8 8.9 10.2 WORSE WORSE WORSE WORSE WORSE WORSE WORSE 35 MARKET VALUE RATIOS 37 Earnings Per Share (EPS) 38 Dividends Per Share (DPS) 39 End-of-Year Dividend Yield 40 Cash Por Share (CPS) 41 Pricelearnings (P/E) 42 Market/book (M/B) 43 Enterprise Value (EV) 44 EV Multiple $0.00 $0.00 0.0% $0.00 0.0 0.0 SO 0.0 $2.75 $0.31 1.2% $0.74 39.8 8.6 WORSE WORSE WORSE WORSE 28.9 WORSE 45 45 47 48 49 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started