1. Calculate efficiency ratios or activity ratios of Tesla company for 2018 and 2019?

2. Compare both years and make some explanation regarding efficiency ratios?

3. To measure how well a Tesla manages various activities, particularly how efficiently it manages its various assets in 2018 and 2019?

(financial statement can take it from internet for years 2018 and 2019)

Please help me with the calculation in excel.

- Liabilities & Shareholders' Equity All values USD Millions. 2019 2018 ST Debt & Current Portion LT Debt 2,070 2,711 Short Term Debt 228 Current Portion of Long Term Debt 1,842 2,711 Accounts Payable 3,771 3,404 Accounts Payable Growth 10.77% 42.43% Income Tax Payable 611 349 Other Current Liabilities 4,215 3,528 Accrued Payroll 466 449 Miscellaneous Current Liabilities 3,749 3,079 Total Current Liabilities 10,667 9,992 Current Ratio 1.13 0.83 Quick Ratio 0.80 0.52 Cash Ratio 0.61 0.39 Long-Term Debt 12,627 11,116 Long-Term Debt excl. Capitalized Leases 10,402 8,410 Non-Convertible Debt 10,402 8,410 Capitalized Lease Obligations 1,269 2,706 Provision for Risks & Charges 581 413 Other Liabilities 2,324 1,905 Other Liabilities (excl. Deferred Income) 1,117 855 Deferred Income 1,207 1,050 Total Liabilities 26,199 23,426 Total Liabilities/Total Assets 76.36% 78.77% Common Equity (Total) 6,618 4,923 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 12,737 10,249 Retained Earnings (6,083) (5,318) Other Appropriated Reserves (36) (8) Common Equity/Total Assets 19.29% 16.55% Total Shareholders' Equity 6,618 4,923 Total Shareholders' Equity/Total Assets 19.29% 16.55% Accumulated Minority Interest 1,492 1,390 Accumulated Minority Interest 1,492 1,390 Total Equity 8,110 6,314 Liabilities & Shareholders' Equity 34,309 29,740 Assets Fiscal year is January-December. All values USD Millions. 2019 2018 Cash & Short Term Investments 6,514 3,878 Cash Only 6,514 3,878 Cash & Short Term Investments Growth 67.97% 10.07% Cash & ST Investments/Total Assets 18.99% 13.04% Total Accounts Receivable 1,324 949 Accounts Receivables, Net 1,324 949 Accounts Receivables, Gross 1,324 949 Accounts Receivable Growth 39.51% 84.14% Accounts Receivable Turnover 18.56 22.61 Inventories 3,552 3,113 Finished Goods 1,356 1,582 Work in Progress 362 297 Raw Materials 1,834 1,235 Other Current Assets 713 366 Miscellaneous Current Assets 713 366 Total Current Assets 12,103 8,306 Net Property, Plant & Equipment 20,199 19,691 Property, Plant & Equipment - Gross 25,062 22,886 Buildings 3,024 4,047 Machinery & Equipment 1,493 1,398 Construction in Progress 764 807 Computer Software and Equipment 595 487 Leased Property 2,853 2,090 Other Property, Plant & Equipment 15,115 14,057 Accumulated Depreciation 4,863 3,195 Total Investments and Advances 270 398 Other Long-Term Investments 270 398 Long-Term Note Receivable 393 422 Long-Term Note Receivable 393 422 Intangible Assets 537 351 Net Goodwill 198 68 Net Other Intangibles 339 282 Other Assets 807 572 Deferred Charges Tangible Other Assets 807 572 Total Assets 34,309 29,740 Assets - Total - Growth 15.36% 3.78% Asset Turnover 0.77 Return On Average Assets -2.69% - Liabilities & Shareholders' Equity All values USD Millions. 2019 2018 ST Debt & Current Portion LT Debt 2,070 2,711 Short Term Debt 228 Current Portion of Long Term Debt 1,842 2,711 Accounts Payable 3,771 3,404 Accounts Payable Growth 10.77% 42.43% Income Tax Payable 611 349 Other Current Liabilities 4,215 3,528 Accrued Payroll 466 449 Miscellaneous Current Liabilities 3,749 3,079 Total Current Liabilities 10,667 9,992 Current Ratio 1.13 0.83 Quick Ratio 0.80 0.52 Cash Ratio 0.61 0.39 Long-Term Debt 12,627 11,116 Long-Term Debt excl. Capitalized Leases 10,402 8,410 Non-Convertible Debt 10,402 8,410 Capitalized Lease Obligations 1,269 2,706 Provision for Risks & Charges 581 413 Other Liabilities 2,324 1,905 Other Liabilities (excl. Deferred Income) 1,117 855 Deferred Income 1,207 1,050 Total Liabilities 26,199 23,426 Total Liabilities/Total Assets 76.36% 78.77% Common Equity (Total) 6,618 4,923 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 12,737 10,249 Retained Earnings (6,083) (5,318) Other Appropriated Reserves (36) (8) Common Equity/Total Assets 19.29% 16.55% Total Shareholders' Equity 6,618 4,923 Total Shareholders' Equity/Total Assets 19.29% 16.55% Accumulated Minority Interest 1,492 1,390 Accumulated Minority Interest 1,492 1,390 Total Equity 8,110 6,314 Liabilities & Shareholders' Equity 34,309 29,740 Assets Fiscal year is January-December. All values USD Millions. 2019 2018 Cash & Short Term Investments 6,514 3,878 Cash Only 6,514 3,878 Cash & Short Term Investments Growth 67.97% 10.07% Cash & ST Investments/Total Assets 18.99% 13.04% Total Accounts Receivable 1,324 949 Accounts Receivables, Net 1,324 949 Accounts Receivables, Gross 1,324 949 Accounts Receivable Growth 39.51% 84.14% Accounts Receivable Turnover 18.56 22.61 Inventories 3,552 3,113 Finished Goods 1,356 1,582 Work in Progress 362 297 Raw Materials 1,834 1,235 Other Current Assets 713 366 Miscellaneous Current Assets 713 366 Total Current Assets 12,103 8,306 Net Property, Plant & Equipment 20,199 19,691 Property, Plant & Equipment - Gross 25,062 22,886 Buildings 3,024 4,047 Machinery & Equipment 1,493 1,398 Construction in Progress 764 807 Computer Software and Equipment 595 487 Leased Property 2,853 2,090 Other Property, Plant & Equipment 15,115 14,057 Accumulated Depreciation 4,863 3,195 Total Investments and Advances 270 398 Other Long-Term Investments 270 398 Long-Term Note Receivable 393 422 Long-Term Note Receivable 393 422 Intangible Assets 537 351 Net Goodwill 198 68 Net Other Intangibles 339 282 Other Assets 807 572 Deferred Charges Tangible Other Assets 807 572 Total Assets 34,309 29,740 Assets - Total - Growth 15.36% 3.78% Asset Turnover 0.77 Return On Average Assets -2.69%