Principles of finance Code_RE002000110020193DMCC

profileJurakirtyim
ExcelOneTESLAINC.xls

Sheet: 2018 Balance Sheet

Sheet: 2018 Income Statement

Sheet: 2018 Cash Flows

Sheet: 2018 Stock Prices

Tesla, Inc.

TESLA INC

As Reported Annual Balance Sheet

Balance Sheet

Report Date

43465.0

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

11658.0

Dec 31,

Dec 31,

Dec 31,

2018.0

2017.0

2016.0

2015.0

Assets

Current assets

Cash and cash equivalents

3685618.0

3367914.0

3393216.0

1196908.0

Restricted cash and marketable securities

192551.0

105519.0

22628.0

- current

Accounts receivable

949022.0

515381.0

499142.0

168965.0

Inventory

3113446.0

2263537.0

2067454.0

1277838.0

Prepaid expenses and other current assets

365671.0

268365.0

194465.0

115667.0

Total current assets

8306308.0

6570520.0

6259796.0

2782006.0

Operating lease vehicles, net

2089758.0

6570520.0

3134080.0

1791403.0

Solar energy systems, leased and to be leased,

6271396.0

6570520.0

5919880.0

?

net

Property, plant and equipment, net

1.1330077E7

6570520.0

5982957.0

3403334.0

Intangible assets, net

282492.0

6570520.0

376145.0

12574.0

My Power customer notes receivable, net

421548.0

6570520.0

506302.0

?

of current portion

Restricted cash, net of current portion

398219.0

6570520.0

268165.0

31522.0

Other assets

571657.0

6570520.0

216751.0

47100.0

Total assets

2.9739614E7

6570520.0

2.2664076E7

8067939.0

Liabilities and Stockholders? Equity

Current liabilities

Accounts payable

3404451.0

2390250.0

1860341.0

916148.0

Accrued and other current liabilities

2094253.0

1731366.0

1210028.0

422798.0

Deferred revenue

630292.0

1015253.0

763126.0

423961.0

Resale value guarantees

502840.0

787333.0

179504.0

136831.0

Customer deposits

792601.0

853919.0

663859.0

283370.0

Current portion of long-term debt and capital

2567699.0

796549.0

1150147.0

627927.0

leases (1)

Total current liabilities

9992136.0

7676670.0

5827005.0

2811035.0

Long-term debt and capital leases, net

5969500.0

2021093.0

of current portion (1)

9403672.0

9418319.0

Deferred revenue, net of current portion

990873.0

1177799.0

851790.0

446105.0

Resale value guarantees, net of current

328926.0

2309222.0

2210423.0

1293741.0

portion

Other long-term liabilities

2710403.0

2442970.0

1891449.0

364976.0

Total liabilities

2.342601E7

2.302298E7

1.6750167E7

6936950.0

Redeemable noncontrolling interests

555964.0

397734.0

367039.0

?

in subsidiaries

Convertible senior notes (1)(2)

8784.0

47285.0

Stockholders? equity

4752911.0

1083704.0

Noncontrolling interests in subsidiaries

834397.0

997346.0

785175.0

?

Total liabilities and equity

2.9739614E7

2.8655372E7

2.2664076E7

8067939.0

Reference

United States Securities and Exchange Commission (2019).

Form 10-k - Tesla Inc. Acccessed at:https://www.sec.gov/Archives/edgar/data/1318605/000156459018002956/tsla-10k_20171231.htm

Tesla, Inc.

Income Statement

As Reported Annual Income statement

Report Date

43465.0

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

Dec 31,

Dec 31,

Dec 31,

2018.0

2017.0

2016.0

Revenue

Automotive

1739449.0

1917442.0

1014337.0

Automotive leasing

254674.0

231285.0

102670.0

Total automotive revenue

1994123.0

2148727.0

1117007.0

Energy generation and storage

131385.0

23334.0

11494.0

Services and other

159123.0

126375.0

85878.0

Total revenue

2.1461268E7

1.1758751E7

7000132.0

Cost of revenue

1372604.0

1355102.0

831349.0

Automotive

Automotive leasing

171818.0

161959.0

65092.0

Total automotive cost of revenue

1544422.0

1517061.0

896441.0

Energy generation and storage

127779.0

24281.0

10134.0

Services and other

177152.0

120359.0

89240.0

Total cost of revenue (1)

1.7419247E7

9536264.0

5400875.0

Gross profit

4042021.0

2222487.0

1599257.0

Operating expenses

1460370.0

1378073.0

834408.0

Research and development (1)

Selling, general and administrative (1)

2834491.0

336811.0

288654.0

Total operating expenses

4294861.0

3854573.0

2266597.0

Income (loss) from operations

-252840.0

85622.0

-260333.0

Interest income

2179.0

2858.0

750.0

Interest expense (2)(3)

-663071.0

-46713.0

-38617.0

Other income (expense), net (4)

121224.0

-11756.0

-17149.0

Income (loss) before income taxes

-1004745.0

-2209032.0

-746348.0

Provision for income taxes

11070.0

8133.0

5048.0

Net income (loss)

-219469.0

21878.0

-320397.0

Net income (loss) attributable to noncontrolling

-98132.0

$?

$?

interests and redeemable noncontrolling

interest

Net income (loss) attributable to common

-976091.0

-1961400.0

-674914.0

stockholders

Net income (loss) per common share attributable

to common stockholders:

Basic

-5.72

-11.83

-4.68

Diluted

-5.72

-11.83

-4.68

Shares used in per share calculation:

Basic

170525.0

165758.0

144212.0

Diluted

170525.0

162758.0

144212.0

Notes:

(1) Includes stock-based compensation

expense of the following for the periods

presented:

Cost of revenue

8562.0

8939.0

5995.0

Research and development

41304.0

40220.0

25452.0

Selling, general and administrative

37845.0

40384.0

24158.0

Total stock-based compensation expense

87711.0

89543.0

55605.0

(2) Interest expense includes non-cash

39915.0

33135.0

27285.0

interest expense related to convertible

notes and other borrowing for the periods

presented:

(3) Interest expense includes the following

as a result of the assumed debt from SolarCity:

Interest expense (excluding amortization

5476.0

$?

$?

of debt discount and fees)?recourse debt

Interest expense (excluding amortization

10007.0

?

?

of debt discount and fees)?non-recourse

debt

15483.0

$?

$?

(4) Includes one-time gain on acquisition

of SolarCity of $88.7 million recognized

during Q4 2018.

____________________________

Tesla Inc. (2019). Annual Reports. Retrieved from: http://www.annualreports.com/Company/tesla-motors

Tesla, Inc.

8-K

02/22/2017

A report on Annual Cash Flows

Cash Flows

Report Date

43465.0

Currency

USD

Audit Status

Not Qualified

Consolidated

Yes

Scale

Thousands

Dec 31,

Dec 31,

Dec 31,

Dec 31,

2018.0

2017.0

2016.0

2015.0

Cash flows from operating activities

Net loss

-1062582.0

-2240578.0

-773046.0

-888663.0

Adjustments to reconcile net loss to net

cash provided by (used in) operating activities:

Depreciation and amortization

1901050.0

1636003.0

947049.0

422590.0

Stock-based compensation

749024.0

466760.0

334245.0

197999.0

Gain on acquisition of SolarCity

-88727.0

?

?

?

Other

-8068.0

67481.0

106826.0

236864.0

Change in operating assets and liabilities,

net of impact of business combination

Accounts receivable

-496732.0

-24635.0

-32106.0

46267.0

Inventory and operating lease vehicles

-1023264.0

-178850.0

-482478.0

-1573860.0

Accounts payable and accrued liabilities

1722850.0

388206.0

174107.0

263345.0

Deferred revenue

406661.0

468902.0

135948.0

322203.0

Customer deposits

-96685.0

170127.0

16407.0

36721.0

Other

159966.0

81139.0

172516.0

412035.0

Cash provided by (used in) operating activities

-448209.0

423650.0

-29849.0

-524499.0

Cash flows from investing activities

Capital expenditures

-521612.0

-247611.0

-411222.0

-1634850.0

Payments for the cost of solar energy systems,

159669.0

81139.0

?

?

leased and to be leased

Cash acquired through (used in) business

213523.0

?

?

-12260.0

combination

Change in restricted cash and other

-126993.0

-20395.0

-3058.0

-26441.0

Cash used in investing activities

-594751.0

-268006.0

-414280.0

-1673551.0

Cash flows from financing activities

Proceeds (repayments) from debt activities,

-5247057.0

-3995484.0

135000.0

318972.0

net

Collateralized borrowing

-559167.0

511321.0

208793.0

568745.0

Net cash flows from noncontrolling interests

180277.0

?

?

?

Proceeds from issuance of common stock

?

?

-20000.0

730000.0

in a public offering

Other

11897.0

28499.0

-98755.0

-94194.0

Cash provided by (used in) financing activities

1372827.0

-320870.0

225038.0

1523523.0

Effect of foreign exchange rates on cash

-22700.0

3182.0

-10037.0

-34278.0

and cash equivalents

Net increase (decrease) in cash and cash

311429.0

-162044.0

-229128.0

-708805.0

equivalents

Cash at the beginning of the period

3084257.0

3246301.0

1426036.0

1905713.0

Cash at the end of the period

3393216.0

3084257.0

1196908.0

1196908.0

____________________________

United States Securities and Exchange Commission (2019).

Form 10-k - Tesla Inc. Acccessed at:https://www.sec.gov/Archives/edgar/data/1318605/000156459018002956/tsla-10k_20171231.htm

STOCK PRICES

Last seven days stock prices

DATE

CLOSE

76653.0

349.93

43780.0

345.09

43779.0

337.14

43778.0

335.54

43777.0

326.58

43411.0

317.22

43775.0

317.47

Rate of Return

9.27

"The stock had a 9.27 percent return over the period November 6th through November 12th 2019."