N Ratio analysis part 2 File Edit View Insert 5 < 8 9 100% Format + Sheets Data Tools Extensions Help % .0 123 Arial - 10 + docs.google.com BIA G = { 00 2 Share A C- Y +88 B34:F35 A 1 2 3 4 5 fx B C D E F G H | J K L M N Name of Company Volkswagen ENTER DATA IN THE YELLOW-CODED CELLS ONLY 6 Profitability Rat Most Recent Year 31.12.23 Oldest Year 31.12.22 31.12.21 31.12.20 31.12.19 7 ROA % (Net) 8 ROE % (Net) 9 ROI % (Operating) 10 EBITDA Margin % 11 Calculated Tax Rate % Revenue per Employee 1234567 Liquidity Ratios 31.12.23 31.12.22 31.12.21 31.12.20 31.12.19 Quick Ratio Current Ratio Net Current Assets % TA Note: This worksheet is programmed to calculate the performance and insert the comments Performance From First to Recent Year; Shows Percentage Change in Ratios Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Notice how conditional statements were programmed to determine if ratios improved or deteriorated, and to calculate the percentage change in the ratios. Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior fill in the percentages for telsa's ratio if performance improved or deteriorated 18 19 Debt Manageme 31.12.23 31.12.22 31.12.21 31.12.20 31.12.19 20 LT Debt to Equity 21 Total Debt to Equity 22 Interest Coverage Performance Improved or Deterior | Performance Improved or Deterior Performance Improved or Deterior 31.12.23 31.12.22 31.12.21 31.12.20 31.12.19 Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Asset Managem Total Asset Turnover Receivables Turnover Inventory Turnover Accounts Payable Turnover Accrued Expenses Turnover 8888888 + Sheet1 Sheet2 Performance Improved or Deterior N Ratio analysis part 2 File Edit View Insert < 8 9 100% B34:F35 A fx Net Current Assets % TA 17 18 19 86383885 B Format + Sheets Data Tools Extensions Help % .0 123 Arial docs.google.com G 2 Share - 10 + BIA = { 00 A C- Y D E F G 31.12.23 31.12.22 31.12.21 31.12.20 31.12.19 31.12.23 31.12.22 31.12.21 31.12.20 31.12.19 Debt Manageme LT Debt to Equity Total Debt to Equity Interest Coverage Asset Managem Total Asset Turnover Receivables Turnover Inventory Turnover Accounts Payable Turnover 28 29 Accrued Expenses Turnover 30 Property Plant & Equip Turnover 31 Cash & Equivalents Turnover 32 33 Per Share 31.12.23 31.12.22 31.12.21 31.12.20 34 Cash Flow per Share 35 Book Value per Share 36 37 38 Source of Data: Mergent Online Database, Strayer University Resour 39 40 41 42 43 44 45 + Sheet1 Sheet2 H Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior Performance Improved or Deterior +88 J K L M N 31.12.19 Performance Improved or Deterior Performance Improved or Deterior fill in the performance