Need to find data from annual reports for Tesla for the year ended in 2020.
PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. F10 V X fx B E F G C $54,178 $51,326 D $13,629 $11,572 -$60 $102 Assigned Company P&G Unilever 39.8% 18.3% 18.4% 15.7% 74.5% Colgate-Palmolive 59.69 24.2% 16.5% 20.6% -315896 Assigned Company P&G 25 Beginning Stockholder's Equity 26 Ending Stockholder's Equity 27 28 Profitability Ratios 29 Gross Profit Margin 30 Operating Profit Margin 31 Profit Margin 32 Return on Assets 33 Return on Equity 34 35 Liquidity Ratios 36 Current Ratio 37 Quick Ratio 38 39 40 Activity Ratios 41 Inventory Turnover 42 Avg. Days in Inventory 43 Fixed Asset Turnover 44 Days Receivable 45 Days Payable 46 47 Composite Ratio 48 Cash to Cash Cycle 49 Unilever Colgate-Palmolive 0.78 1.14 0.77 0.57 Assigned Company P&G Unilever 7.41 49.24 4.93 30.10 170.2 Colgate-Palmolive 5.01 72.85 4.01 32.87 70.42 Assigned Company P&G Unilever -90.86 Colgate-Palmolive 35.3 50 Sheet1 Ready P TOSHIBA PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Ed F10 :X fix C G P&G $23,320 $4,686 $120,406 $118,310 $20,600 $4,624 $4,738 $28,237 $10,344 $65,247 D E Unilever Colgate-Palmolive $15,481 $3,793 $4,204 $1,400 $60,285 $12,676 $59,456 $12,161 $10,347 $3,881 $3,962 $1,221 $4,301 $1,250 $19,772 $3,329 $14,317 $1,212 $47,164 $11,964 A B 1 Balance Sheet Data Assigned Company 2 Current Assets 3 Accounts Receivable 4 Beginning Total Assets 5 Ending Total Assets 6 PPE (Fixed Assets) 7 Beginning Inventory 8 Ending Inventory 9 Current Liabilities 10 Accounts Payable 11 Total Liabilities 12 13 income Statement Data Assigned Company 14 Sales 15 Prior Year Sales 16 COGS 17 Prior Year COGS 18 SGA Expense 19 Prior Year SGA Expense 20 Interest Expense 21 Operating Income 22 Net Income 23 24 Equity Data Assigned Company 25 Beginning Stockholder's Equity 26 Ending Stockholder's Equity Sheet1 P&G $66,832 $53,715 $33,449 $31,942 $18,602 $18,431 $506 $14,781 $9,750 Unilever $50,982 $46,467 $30,703 $30,547 $25,000 $13,507 $591 $9,334 $9,389 Colgate-Palmolive $15,544 $15,454 $6,282 $6,099 $5,443 $5,408 $143 $3,759 $2,558 + P&G $54,178 $51,326 Unilever Colgate-Palmolive $13,629 -S60 $11,572) -$102 Ready X pe PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. F10 V X fx B E F G C $54,178 $51,326 D $13,629 $11,572 -$60 $102 Assigned Company P&G Unilever 39.8% 18.3% 18.4% 15.7% 74.5% Colgate-Palmolive 59.69 24.2% 16.5% 20.6% -315896 Assigned Company P&G 25 Beginning Stockholder's Equity 26 Ending Stockholder's Equity 27 28 Profitability Ratios 29 Gross Profit Margin 30 Operating Profit Margin 31 Profit Margin 32 Return on Assets 33 Return on Equity 34 35 Liquidity Ratios 36 Current Ratio 37 Quick Ratio 38 39 40 Activity Ratios 41 Inventory Turnover 42 Avg. Days in Inventory 43 Fixed Asset Turnover 44 Days Receivable 45 Days Payable 46 47 Composite Ratio 48 Cash to Cash Cycle 49 Unilever Colgate-Palmolive 0.78 1.14 0.77 0.57 Assigned Company P&G Unilever 7.41 49.24 4.93 30.10 170.2 Colgate-Palmolive 5.01 72.85 4.01 32.87 70.42 Assigned Company P&G Unilever -90.86 Colgate-Palmolive 35.3 50 Sheet1 Ready P TOSHIBA PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Ed F10 :X fix C G P&G $23,320 $4,686 $120,406 $118,310 $20,600 $4,624 $4,738 $28,237 $10,344 $65,247 D E Unilever Colgate-Palmolive $15,481 $3,793 $4,204 $1,400 $60,285 $12,676 $59,456 $12,161 $10,347 $3,881 $3,962 $1,221 $4,301 $1,250 $19,772 $3,329 $14,317 $1,212 $47,164 $11,964 A B 1 Balance Sheet Data Assigned Company 2 Current Assets 3 Accounts Receivable 4 Beginning Total Assets 5 Ending Total Assets 6 PPE (Fixed Assets) 7 Beginning Inventory 8 Ending Inventory 9 Current Liabilities 10 Accounts Payable 11 Total Liabilities 12 13 income Statement Data Assigned Company 14 Sales 15 Prior Year Sales 16 COGS 17 Prior Year COGS 18 SGA Expense 19 Prior Year SGA Expense 20 Interest Expense 21 Operating Income 22 Net Income 23 24 Equity Data Assigned Company 25 Beginning Stockholder's Equity 26 Ending Stockholder's Equity Sheet1 P&G $66,832 $53,715 $33,449 $31,942 $18,602 $18,431 $506 $14,781 $9,750 Unilever $50,982 $46,467 $30,703 $30,547 $25,000 $13,507 $591 $9,334 $9,389 Colgate-Palmolive $15,544 $15,454 $6,282 $6,099 $5,443 $5,408 $143 $3,759 $2,558 + P&G $54,178 $51,326 Unilever Colgate-Palmolive $13,629 -S60 $11,572) -$102 Ready X pe
