Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multifractal Financial Markets An Alternative Approach To Asset And Risk Management

Authors: Yasmine Hayek Kobeissi

1st Edition

1461444896, 978-1461444893

More Books

Students also viewed these Finance questions

Question

Describe the options and trends in management education

Answered: 1 week ago