Please calculate all the ratios for 2019 and 2020.
BALANCE SHEET 2019 2020 26 27 28 29 30 $2,836,450 8,509,350 20,351,550 31,697,350 22,975,245 $54,672,595 $1,851,754 $10,262,510 $23,144,820 35,259,084 $27,826,540 $63,085,624 31 32 33 34 35 36 37 TABLE #2 ASSETS Cash Accounts receivable Inventory Total Current Assets N Net Fixed Assets TOTAL ASSETS LIABILITIES & STOCKHOLDERS EQUITY m Accounts payable Notes payable Total current liabilities Long-term debt TOTAL LIABILITIES Common stock Retained earnings* TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDER'S EQUITY $5,758,070 7,961,031 13.719,101 12,359,868 26,078,969 2,040,000 26,553,626 28,593,626 $7,151,072 10,094,260 17,245,332 12,783,245 30,028,5771 2,040,000 31,017,047 33,057,047 39 40 41 42 $54,672,595 $63,085,624 43 14 GESTANCIA DATA TI COMMON SIZE 2019 COMMON SIZE 2020 A B D 6 C Global Manufacturing, Inc. INCOME STATEMENT 7 2019 2020 8 9 10 $70,911,420 $48,113,332 $13,785,239 $85,218,840 57,181,806 16,873,362 11 9,012,849 11,163,672 12 13 14 15 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 16 17 1.700,510 7,312,339 1,390,284 5,922,055 1,243,632 4,678,423 1,169,606 3,508,818 2,027,160 9,136,512 1,603,312 7,533,200 1,581,972 5,951,228 1,487,807 4,463,421 18 19 20 21 24 Global Manufacturing, Inc. BALANCE SHEET 25 28,593,626 33.057/0471 TOTAL STOCKHOLDERS EQUI TOTAL LIABILITIES & STOCKHOLDER'S EQUITY $54,672,595 $63,085,624 45 Global Manufacturing, Inc. ADDITIONAL INFORMATION 46 Information 2019 2020 47 48 49 50 Depreciation as a % of net fixed assets Short-term interest expense Long-term interest expense Income tax rate Dividend payout ratio TABLE #3 7.68% 6.72% 6.92% 21.00% 25.00% 8.82% 7.12% 6.92% 21.00% 25.00% 51 52 Fixed assets as a percent of total capacity. 84.00% 91.00% 5B 5.4 End of year stock price Number of common shares outstanding $67.13 1,750,000 $69.21 1,750,000 55 56 57 58 59 B E F G H 2019 FINANCIAL RATIOS ANALYSIS 1 HELP: See the CASE STUDY HELP files named "TUTORIAL FOR FINANCIAL RATIO ANALYSIS.pdf" and "03-SAMPLE COMPANY RATIO CALCULATION & ANALYSIS.pdf" for help with your ANALYSIS OF RATIOS 2 FINANCIAL RATIOS INSTRUCTIONS: For all of these calculations use the financial information provided on the FINANCIAL DATA worksheet. CALCULATIONS: On this worksheet calculate Global's listed financial ratios for the year 2019. See the "TUTORIAL FOR FINANCIAL RATIO ANALYSIS.pdf for the all of the formulas for calculating the required ratio values ANALYSIS: See the " TUTORIAL FOR FINANCIAL RATIO ANALYSIS.pdf" for help with analyzing's the required ratio values Compare each of Global's ratlos lo the Benchmark firm to determine it oachratio is BETTER SAME AS or WORSE than the Benchmark Firm's allo NOTE Cells shaded in YELLOWare the cells you must provide the calculations or analysis ALLE calculations or analysis. Global Manufacturing, Inc. 2019 FINANCIAL RATIO CALCULATIONS AND ANALYSIS Global Manufacturing, BENCHMARK FIRM Inc. YOUR ANALYSIS OF 2019 RATIO (BETTER, SAME, or, WORSE than the benchmark firm) 2019 2019 0.0% 19.0% 0.0% 13.7% 0.0% 14.4% 0.0% 24.6% 90.00% 0.0% ASSIGNED RATIOS PROFITABILITY RATIOS Operating Margin Profit Margin Return On Assets (ROA) Return On Common Equity (RO Plovback or Retention Ratio ASSET UTILIZATION RATIOS Receivables Turnover Days Sales in Receivables Inventory Turnover Dags Sales in Inventory Fixed Asset Turnover Total Asset Turnover LIQUIDITY RATIOS 0.0 7.5 48.7 0.0 0.0 0.0 1352 2.9 0.0 0.0 1.5 B E F G H 0.0 2.0 0.0 0.8 0.0 0.2 2 LIQUIDITY RATIOS 3 Current Ratio 4 Quick ratio 25 Cash Ratio 26 FINANCIAL LEVERAGE RATIOS 27 Accounts Payable Ratio 28 Notes Payable Ratio 229 Long-term-debt Ratio 30 Total Debt Ratio 31 Debt-Equity Ratio 32 Equity-Multiplier 33 Times Interest Earned 134 Cash Coverage Ratio 0.0% 0.0% 0.0% 0.0% 0.0 0.0 27.9% 35.6% 36.5% 43.3% 0.8 1.8 0.0 8.6 0.0 9.6 35 MARKET VALUE RATIOS $0.00 $0.00 0.0% $2.79 $0.28 0.8% $2.21 27.9 6.1 $0.00 36 Earnings Per Share (EPS) 37 Dividends Per Share (DPS) 38 End-of-Year Dividend Yield 39 Cash Per Share (CPS) 40 Pricelearnings (P/E) 41 Market book (MIB) 42 Enterprise Value (EV) 43 EM Multiple 0.0 0.0 $0 0.0 16.8 E F G C D Global Manufacturing, Inc. 2020 FINANCIAL RATIO CALCULATIONS AND ANALYSIS Global Manufacturing, BENCHMARK YOUR ANALYSIS OF 2020 Inc. FIRM BATIO (BETTER, SAME, or, WORSE ASSIGNED RATIOS 2020 2020 than the benchmark firm) PROFITABILITY RATIOS Operating Margin 0.0% 17.8% Profit Margin 0.0% 12.5% Return On Assets (ROA) 0.0% 13.9% Return On Common Equity (RO 0.0% 23.8% Plowback or Retention Ratio 0.0% 90.0% ASSET UTILIZATION RATIOS Receivables Turnover 0.0 7.1 Days Sales in Receivables 0.0 51.4 Inventory Turnover 0.0 2.7 Days Sales in Inventory 0.0 135.2 Fixed Asset Turnover 0.0 2.8 Total Asset Turnover 0.0 1.1 LIQUIDITY RATIOS 0.0 0.2 0.0% 0.0% Cash Ratio S FINANCIAL LEVERAGE RATIOS Accounts Payable Ratio 3 Notes Payable Ratio 3 Long-term-debt Ratio Total Debt Ratio 1 Debt-Equity Ratio 2 Equity-Multiplier 3 Times Interest Earned & Cash Coverage Ratio 29.4% 34,3% 36.3% 45.25% 0.0% 0.0% 0.0 0.8 0.0 0.0 0.0 8.8 5 MARKET VALUE RATIOS $3.08 $0.00 $0.00 0.098 $0.34 1.29% $2.03 29.3 $0.00 6 Earnings Per Share (EPS) 7 Dividends Per Share (DPS) e End-of-Year Dividend Yield 9 Cash Per Share (CPS) O Prieelearnings (PPE) 31 Markettbook (MIB) 2 Enterprise Value (EV) 43 EV Multiple 0.0 0.0 SO 0.0 15.9
