Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Kindly prepare a three (3) year's annual financial report for Tesla Inc The report should include the following financial information, Balance sheet, Income statement, Equality
Kindly prepare a three (3) year's annual financial report for Tesla Inc
The report should include the following financial information, Balance sheet, Income statement, Equality statement, and Cash flow statement. Also, perform these analyses, Ratios analysis, vertical analysis, and horizontal analysis. Explain each financial note in detail.
The report structure should include an introduction, various analyses, and a conclusion.
Kindly see below attached financial statement for your use:
Fiscal year is January-December. All values USD Millions. INCOME STATEMENT | 2022 | 2021 | 2020 |
Sales/Revenue | 81,462 | 53,823 | 31,536 |
Sales Growth | 51.35% | 70.67% | 28.31% |
Cost of Goods Sold (COGS) incl. D&A | 60,609 | 40,217 | 24,906 |
COGS excluding D&A | 57,066 | 37,306 | 22,584 |
Depreciation & Amortization Expense | 3,543 | 2,911 | 2,322 |
Depreciation | 2,655 | 1,910 | - |
Amortization of Intangibles | 888 | 1,001 | - |
COGS Growth | 50.70% | 61.48% | 21.44% |
Gross Income | 20,853 | 13,606 | 6,630 |
Gross Income Growth | 53.26% | 105.22% | 62.94% |
Gross Profit Margin | 25.60% | - | - |
SG&A Expense | 7,021 | 7,110 | 4,636 |
Research & Development | 3,075 | 2,593 | 1,491 |
Other SG&A | 3,946 | 4,517 | 3,145 |
SGA Growth | -1.25% | 53.36% | 16.22% |
EBIT | 13,832 | 6,496 | 1,994 |
Unusual Expense | 150 | -40 | 36 |
Non Operating Income/Expense | -69 | 122 | -86 |
Non-Operating Interest Income | 297 | 56 | 30 |
Interest Expense | 191 | 371 | 748 |
Interest Expense Growth | -48.52% | -50.40% | 9.20% |
Gross Interest Expense | 191 | 424 | 796 |
Interest Capitalized | - | 53 | 48 |
Pretax Income | 13,719 | 6,343 | 1,154 |
Pretax Income Growth | 116.29% | 449.65% | 273.53% |
Pretax Margin | 16.84% | - | - |
Income Tax | 1,132 | 699 | 292 |
Income Tax - Current Domestic | 62 | 9 | 4 |
Income Tax - Current Foreign | 1,266 | 839 | 248 |
Income Tax - Deferred Domestic | 27 | - | - |
Income Tax - Deferred Foreign | -223 | -149 | 40 |
Other After Tax Income (Expense) | 27 | 5 | -31 |
Consolidated Net Income | 12,614 | 5,649 | 831 |
Minority Interest Expense | 31 | 125 | 141 |
Net Income | 12,583 | 5,524 | 690 |
Net Income Growth | 127.79% | 700.58% | 179.31% |
Net Margin | 15.45% | - | - |
Net Income After Extraordinaries | 12,583 | 5,524 | 690 |
Net Income Available to Common | 12,583 | 5,524 | 690 |
EPS (Basic) | 3.62 | 1.63 | 0.21 |
EPS (Basic) Growth | 122.04% | 667.84% | 164.97% |
Basic Shares Outstanding | 3,130 | 2,958 | 2,799 |
EPS (Diluted) | 3.62 | 1.63 | 0.21 |
EPS (Diluted) Growth | 122.04% | 667.96% | 164.96% |
Diluted Shares Outstanding | 3,475 | 3,387 | 3,249 |
EBITDA | 17,375 | 9,407 | 4,316 |
EBITDA Growth | 84.70% | 117.96% | 93.20% |
EBITDA Margin | 21.58% | - | - |
EBIT | 13,832 | 6,496 | 1,994 |
Fiscal year is January-December. All values USD Millions BALANCE SHEET | |||
Assets | 2022 | 2021 | 2020 |
Cash & Short Term Investments | 22,479 | 18,052 | 19,622 |
Cash Only | 16,547 | 17,921 | 19,622 |
Cash & Short Term Investments Growth | 24.52% | -8.00% | 201.23% |
Cash & ST Investments / Total Assets | 27.30% | 29.05% | 37.63% |
Total Accounts Receivable | 2,952 | 1,913 | 1,886 |
Accounts Receivables, Net | 2,952 | 1,913 | 1,886 |
Accounts Receivables, Gross | 2,952 | 1,913 | 1,886 |
Accounts Receivable Growth | 54.31% | 1.43% | 42.45% |
Accounts Receivable Turnover | 27.6 | 28.14 | 16.72 |
Inventories | 12,839 | 5,757 | 4,101 |
Finished Goods | 3,475 | 1,277 | 1,666 |
Work in Progress | 2,385 | 1,089 | 493 |
Raw Materials | 6,979 | 3,391 | 1,942 |
Other Current Assets | 2,647 | 1,378 | 1,108 |
Miscellaneous Current Assets | 2,647 | 1,378 | 1,108 |
Total Current Assets | 40,917 | 27,100 | 26,717 |
Net Property, Plant & Equipment | 36,635 | 31,176 | 23,375 |
Property, Plant & Equipment - Gross | 48,134 | 39,867 | 29,893 |
Buildings | 7,751 | 4,675 | 3,662 |
Machinery & Equipment | 2,579 | 2,188 | 1,811 |
Construction in Progress | 4,263 | 5,559 | 1,621 |
Computer Software and Equipment | 2,072 | 1,414 | 856 |
Leased Property | 6,075 | 5,284 | 3,537 |
Other Property, Plant & Equipment | 22,831 | 18,731 | 16,848 |
Accumulated Depreciation | 11,499 | 8,691 | 6,518 |
Total Investments and Advances | 377 | 223 | 279 |
Other Long-Term Investments | 377 | 223 | 279 |
Long-Term Note Receivable | 280 | 299 | 334 |
Intangible Assets | 593 | 1,717 | 520 |
Net Goodwill | 194 | 200 | 207 |
Net Other Intangibles | 399 | 1,517 | 313 |
Other Assets | 3,536 | 1,616 | 923 |
Tangible Other Assets | 3,536 | 1,616 | 923 |
Total Assets | 82,338 | 62,131 | 52,148 |
Assets - Total - Growth | 32.52% | 19.14% | 52.00% |
Asset Turnover | 1.13 | - | - |
Return On Average Assets | 17.42% | - | - |
Liabilities & Shareholders' Equity | |||
All values USD Millions. | 2022 | 2021 | 2020 |
ST Debt & Current Portion LT Debt | 1,987 | 1,957 | 2,459 |
Short Term Debt | 485 | 368 | 286 |
Current Portion of Long Term Debt | 1,502 | 1,589 | 2,173 |
Accounts Payable | 15,255 | 10,025 | 6,051 |
Accounts Payable Growth | 52.17% | 65.68% | 60.46% |
Income Tax Payable | 1,235 | 1,122 | 777 |
Other Current Liabilities | 8,232 | 6,601 | 4,961 |
Accrued Payroll | 1,026 | 906 | 654 |
Miscellaneous Current Liabilities | 7,206 | 5,695 | 4,307 |
Total Current Liabilities | 26,709 | 19,705 | 14,248 |
Current Ratio | 1.53 | 1.38 | 1.88 |
Quick Ratio | 1.05 | 1.08 | 1.59 |
Cash Ratio | 0.84 | 0.92 | 1.38 |
Long-Term Debt | 3,761 | 6,916 | 10,888 |
Long-Term Debt excl. Capitalized Leases | 1,029 | 4,254 | 8,513 |
Non-Convertible Debt | 1,029 | 4,254 | 8,462 |
Convertible Debt | - | - | 51 |
Capitalized Lease Obligations | 568 | 991 | 1,121 |
Provision for Risks & Charges | 51 | 133 | 519 |
Deferred Taxes | 82 | 24 | 151 |
Deferred Taxes - Credit | 82 | 24 | 151 |
Other Liabilities | 5,837 | 3,770 | 2,663 |
Other Liabilities (excl. Deferred Income) | 3,033 | 1,718 | 1,379 |
Deferred Income | 2,804 | 2,052 | 1,284 |
Total Liabilities | 36,440 | 30,548 | 28,469 |
Total Liabilities / Total Assets | 44.26% | 49.17% | 54.59% |
Common Equity (Total) | 44,704 | 30,189 | 22,225 |
Common Stock Par/Carry Value | 3 | 1 | 1 |
Additional Paid-In Capital/Capital Surplus | 32,177 | 29,803 | 27,260 |
Retained Earnings | 12,885 | 331 | -5,399 |
Other Appropriated Reserves | -361 | 54 | 363 |
Common Equity / Total Assets | 54.29% | 48.59% | 42.62% |
Total Shareholders' Equity | 44,704 | 30,189 | 22,225 |
Total Shareholders' Equity / Total Assets | 54.29% | 48.59% | 42.62% |
Accumulated Minority Interest | 1,194 | 1,394 | 1,454 |
Total Equity | 45,898 | 31,583 | 23,679 |
Liabilities & Shareholders' Equity | 82,338 | 62,131 | 52,148 |
Fiscal year is January-December. All values USD Millions. CASH FLOW STATEMENT | |||
Operating Activities | 2022 | 2021 | 2020 |
Net Income before Extraordinaries | 12,587 | 5,644 | 862 |
Net Income Growth | 123.02% | 554.76% | 211.23% |
Depreciation, Depletion & Amortization | 3,747 | 2,911 | 2,322 |
Depreciation and Depletion | 2,420 | 1,910 | 2,271 |
Amortization of Intangible Assets | 1,327 | 1,001 | 51 |
Other Funds | 2,298 | 2,424 | 2,575 |
Funds from Operations | 18,632 | 10,979 | 5,759 |
Changes in Working Capital | -3,908 | 518 | 184 |
Receivables | -1,124 | -130 | -652 |
Inventories | -6,465 | -1,709 | -1,494 |
Accounts Payable | 6,029 | 4,578 | 2,102 |
Other Assets/Liabilities | -2,348 | -2,221 | 228 |
Net Operating Cash Flow | 14,724 | 11,497 | 5,943 |
Net Operating Cash Flow Growth | 28.07% | 93.45% | 147.11% |
Net Operating Cash Flow / Sales | 18.07% | 21.36% | 18.85% |
Investing Activities | |||
All values USD Millions. | 2022 | 2021 | 2020 |
Capital Expenditures | -7,172 | -8,014 | -3,242 |
Capital Expenditures (Fixed Assets) | -7,163 | -6,514 | -3,232 |
Capital Expenditures (Other Assets) | -9 | -1,500 | -10 |
Capital Expenditures Growth | 10.51% | -147.19% | -125.61% |
Capital Expenditures / Sales | -8.80% | -14.89% | -10.28% |
Net Assets from Acquisitions | -45 | - | -13 |
Sale of Fixed Assets & Businesses | - | 2 | 24 |
Purchase/Sale of Investments | -5,813 | -132 | - |
Purchase of Investments | -5,835 | -132 | - |
Sale/Maturity of Investments | 22 | - | - |
Other Sources | 1,012 | 278 | 123 |
Net Investing Cash Flow | -12,018 | -7,866 | -3,108 |
Net Investing Cash Flow Growth | -52.78% | -153.09% | -168.63% |
Net Investing Cash Flow / Sales | -14.75% | -14.61% | -9.86% |
Financing Activities | |||
All values USD Millions. | 2022 | 2021 | 2020 |
Change in Capital Stock | 541 | 707 | 12,686 |
Sale of Common & Preferred Stock | 541 | 707 | 12,686 |
Proceeds from Stock Options | - | - | 12,269 |
Other Proceeds from Sale of Stock | 541 | 707 | 417 |
Issuance/Reduction of Debt, Net | -3,866 | -5,741 | -2,494 |
Change in Long-Term Debt | -3,866 | -5,741 | -2,494 |
Issuance of Long-Term Debt | - | 8,874 | 9,707 |
Reduction in Long-Term Debt | -3,866 | -14,615 | -12,201 |
Other Funds | -157 | -171 | -243 |
Other Uses | -157 | -171 | -243 |
Net Financing Cash Flow | -3,482 | -5,205 | 9,949 |
Net Financing Cash Flow Growth | 33.10% | -152.32% | 695.92% |
Net Financing Cash Flow / Sales | -4.27% | -9.67% | 31.55% |
Exchange Rate Effect | -444 | -183 | 334 |
Net Change in Cash | -1,220 | -1,757 | 13,118 |
Free Cash Flow | 7,561 | 4,983 | 2,711 |
Free Cash Flow Growth | 51.74% | 83.81% | 178.62% |
Free Cash Flow Yield | 1.77 |
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