Nothing Special   »   [go: up one dir, main page]

Tesla Inc NasdaqGS TSLA Financials

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 36

Tesla, Inc.

(NasdaqGS:TSLA) > Financials > Key Stats


In Millions of INR, except per share items. Currency: Indian Rupee   Conversion: Historical
Order: Latest on Right   Units: Millions (mm)
Decimals: Capital IQ (Default)   Dilution: Basic

Key Financials¹
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months†
Dec-31-2015A Dec-31-2016A Dec-31-2017A Dec-31-2018A Dec-31-2019A Dec-31-2020E
Currency INR INR INR INR INR INR

Total Revenue 267,927.8 475,414.0 750,518.2 1,493,685.6 1,749,238.4 2,175,127.55


Growth Over Prior Year 26.5% 73.0% 68.0% 82.5% 14.5% 16.38%

Gross Profit 61,154.4 108,613.5 141,883.0 281,323.2 289,594.4 -


Margin % 22.8% 22.8% 18.9% 18.8% 16.6% 17.16%

EBITDA (19,471.3) 20,473.6 255.3 114,700.8 155,650.8 263,620.93


Margin % (7.3%) 4.3% 0.0% 7.7% 8.9% 12.12%

EBIT (47,455.2) (43,848.6) (104,162.4) (17,608.8) 5,693.7 43,739.77


Margin % (17.7%) (9.2%) (13.9%) (1.2%) 0.3% 2.01%

Earnings from Cont. Ops. (58,847.3) (52,501.4) (143,031.8) (73,984.8) (55,157.4) -


Margin % (22.0%) (11.0%) (19.1%) (5.0%) (3.2%) -

Net Income (58,847.3) (45,836.8) (125,224.7) (67,929.6) (61,349.3) 42,109.43


Margin % (22.0%) (9.6%) (16.7%) (4.5%) (3.5%) 1.94%

Diluted EPS Excl. Extra Items³ (459.02) (317.84) (755.05) (398.11) (350.16) 265.65
Growth Over Prior Year NM NM NM NM NM 1,628.57%

Currency INR INR INR INR INR INR


Exchange Rate 66.22 67.915 63.825 69.6 71.1709 76.0433
Conversion Method H H H H H S

¹All results are taken from the most recently filed statement for each period. When there has been more than one, earlier filings can be viewed on the individual statement pages.
³All forward period figures are consensus mean estimates provided by the brokers and may not be on a comparable basis as financials.
†Growth rates for forward periods are calculated against prior period estimates or actual pro forma results as disclosed on the Estimates Consensus page.
Growth Rates are calculated in originally reported currency only and will not reflect any currency conversion selected above.

Latest Capitalization (Millions of INR)


Currency INR
Share Price 50,523.51
Shares Out. 184.0
Market Capitalization 9,295,900.8
- Cash & Short Term Investments 446,099.2
+ Total Debt 1,045,998.7
+ Pref. Equity -
+ Total Minority Interest 106,187.0
= Total Enterprise Value (TEV) 10,001,987.3

Book Value of Common Equity 471,009.0


+ Pref. Equity -
+ Total Minority Interest 106,187.0
+ Total Debt 1,045,998.7
= Total Capital 1,623,194.7

**For companies that have multiple share classes that publicly trade,
we are incorporating the different prices to calculate our company level
market capitalization. Please click on the value to see the detailed
calculation. Prices shown on this page are the close price of the
company’s primary stock class. Shares shown on this page are total
company as-reported share values.

Total Liability includes Total Debt, Minority Interest and Pref. Equity.
Net Liability includes Total Liability, net of Cash and Short Term Investments.
TEV includes Market Cap and Net Liability.
Total Capital includes Common Equity and Total Liability.

Valuation Multiples based on Current Capitalization


For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months
Dec-31-2018A Dec-31-2019A Dec-31-2020E Dec-31-2021E Dec-31-2022E
TEV/Total Revenue 6.5x 5.7x 4.91x 3.62x 2.78x
TEV/EBITDA 85.3x 53.8x 40.54x 22.52x 16.99x

TEV/EBIT NM NM 244.33x 61.21x 35.57x

P/Diluted EPS Before Extra NM NM 203.21x 58.86x 35.48x

P/BV 24.9x 19.4x 13.72x 11.03x 8.03x

Price/Tang BV 26.8x 21.1x - - -


12 months 12 months
Dec-31-2021E Dec-31-2022E
INR INR

2,953,660.94 3,842,722.05
35.79% 30.10%

- -
20.16% 21.42%

474,637.82 628,970.5
16.07% 16.37%

174,588.9 300,463.57
5.91% 7.82%

- -
- -

174,165.5 306,280.11
5.90% 7.97%

917.14 1,521.68
245.24% 65.92%

INR INR
76.0433 76.0433
S S
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Income Statement
In Millions of INR, except per share items. Template: Standard   Restatement: Latest Filings
Period Type: Annual   Order: Latest on Right
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)

Income Statement
Reclassified Restated Restated
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR

Revenue 202,184.1 267,927.8 475,414.0 750,518.2 1,493,685.6 1,749,238.4


Other Revenue - - - - - -
Total Revenue 202,184.1 267,927.8 475,414.0 750,518.2 1,493,685.6 1,749,238.4

Cost Of Goods Sold 146,449.2 206,773.4 366,800.4 608,635.2 1,212,362.4 1,459,644.0


Gross Profit 55,734.8 61,154.4 108,613.5 141,883.0 281,323.2 289,594.4

Selling General & Admin Exp. 38,160.4 61,070.2 95,793.4 158,094.5 197,316.0 188,318.2
R & D Exp. 29,376.0 47,539.3 56,668.8 87,950.9 101,616.0 95,582.5
Depreciation & Amort. - - - - - -
Other Operating Expense/(Income) - - - - - -

Other Operating Exp., Total 67,536.4 108,609.5 152,462.2 246,045.4 298,932.0 283,900.7

Operating Income (11,801.5) (47,455.2) (43,848.6) (104,162.4) (17,608.8) 5,693.7

Interest Expense (6,377.5) (7,870.3) (13,027.1) (30,444.5) (45,448.8) (51,598.9)


Interest and Invest. Income 71.2 99.9 579.3 1,212.7 1,670.4 3,131.5
Net Interest Exp. (6,306.3) (7,770.5) (12,447.8) (29,231.9) (43,778.4) (48,467.4)

Currency Exchange Gains (Loss) 126.4 (3,019.6) 1,772.6 (3,318.9) 139.2 3,416.2
Other Non-Operating Inc. (Exp.) (11.8) 261.4 (716.5) (574.4) 696.0 2,633.3
EBT Excl. Unusual Items (17,993.3) (57,983.8) (55,240.4) (137,287.6) (60,552.0) (36,724.2)

Restructuring Charges - - - - (6,403.2) (7,259.4)


Merger & Related Restruct. Charges - - (1,473.8) - - -
Impairment of Goodwill - - 6,025.9 - - -
Asset Writedown - - - - (904.8) -
In Process R & D Exp. - - - - - (3,345.0)
Legal Settlements - - - - (2,088.0) -
Other Unusual Items - - - (3,701.9) - -
EBT Incl. Unusual Items (17,993.3) (57,983.8) (50,688.2) (140,989.4) (69,948.0) (47,328.6)
Income Tax Expense 594.5 863.4 1,813.2 2,042.4 4,036.8 7,828.8
Earnings from Cont. Ops. (18,587.7) (58,847.3) (52,501.4) (143,031.8) (73,984.8) (55,157.4)

Earnings of Discontinued Ops. - - - - - -


Extraord. Item & Account. Change - - - - - -
Net Income to Company (18,587.7) (58,847.3) (52,501.4) (143,031.8) (73,984.8) (55,157.4)

Minority Int. in Earnings - - 6,664.6 17,807.2 6,055.2 (6,191.9)


Net Income (18,587.7) (58,847.3) (45,836.8) (125,224.7) (67,929.6) (61,349.3)

Pref. Dividends and Other Adj. - - - - - -

NI to Common Incl Extra Items (18,587.7) (58,847.3) (45,836.8) (125,224.7) (67,929.6) (61,349.3)
NI to Common Excl. Extra Items (18,587.7) (58,847.3) (45,836.8) (125,224.7) (67,929.6) (61,349.3)

Per Share Items


Basic EPS (149.25) (459.02) (317.84) (754.37) (397.25) (346.61)
Basic EPS Excl. Extra Items (149.25) (459.02) (317.84) (754.37) (397.25) (346.61)
Weighted Avg. Basic Shares Out. 124.5 128.2 144.2 166.0 171.0 177.0

Diluted EPS (149.25) (459.02) (317.84) (755.05) (398.11) (350.16)


Diluted EPS Excl. Extra Items (149.25) (459.02) (317.84) (755.05) (398.11) (350.16)
Weighted Avg. Diluted Shares Out. 124.5 128.2 144.2 166.0 171.0 177.0

Normalized Basic EPS (90.3) (282.68) (193.19) (409.62) (185.91) (164.66)


Normalized Diluted EPS (90.3) (282.68) (193.19) (409.62) (185.91) (164.66)

Dividends per Share NA NA NA NA NA NA

Shares per Depository Receipt 0.25 0.25 0.25 0.25 0.25 0.25

Supplemental Items
EBITDA 2,860.0 (19,471.3) 20,473.6 255.3 114,700.8 155,650.8
EBITA (11,801.5) (47,455.2) (43,848.6) (101,609.4) (13,015.2) 8,825.2
EBIT (11,801.5) (47,455.2) (43,848.6) (104,162.4) (17,608.8) 5,693.7
EBITDAR 5,786.8 (14,955.1) 28,406.1 NA NA 185,969.6
As Reported Total Revenue* 202,184.1 267,927.8 475,414.0 750,518.2 1,493,685.6 1,749,238.4
Effective Tax Rate % NM NM NM NM NM NM
Current Domestic Taxes 16.2 34.8 38.6 (510.6) 139.2 355.9
Current Foreign Taxes 581.8 684.8 3,664.8 2,744.5 1,670.4 6,120.7
Total Current Taxes 598.0 719.6 3,703.4 2,233.9 1,809.6 6,476.6
Deferred Domestic Taxes NA NA NA NA NA (284.7)
Deferred Foreign Taxes (3.5) 143.8 (1,890.2) (191.5) 2,227.2 1,636.9
Total Deferred Taxes (3.5) 143.8 (1,890.2) (191.5) 2,227.2 1,352.2

Normalized Net Income (11,245.8) (36,239.9) (27,860.6) (67,997.6) (31,789.8) (29,144.5)


Interest Capitalized NA 2,746.6 NA NA 3,828.0 2,206.3
Interest on Long Term Debt 7,003.3 11,881.6 9,198.3 10,212.0 15,868.8 25,265.7
Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020
Restatement Type NC NC RC RS RS O
Calculation Type REP REP REP REP REP REP

Supplemental Operating Expense Items


Marketing Exp. 3,091.2 3,860.6 3,259.9 2,361.5 2,227.2 1,921.6
Selling and Marketing Exp. 3,091.2 3,860.6 3,259.9 2,361.5 2,227.2 1,921.6
R&D Exp. 29,376.0 47,539.3 56,668.8 87,950.9 101,616.0 98,927.6
Net Rental Exp. 2,926.9 4,516.2 7,932.5 NA NA 30,318.8
Imputed Oper. Lease Interest Exp. 1,501.1 2,129.8 2,119.3 - - 12,856.6
Imputed Oper. Lease Depreciation 1,425.8 2,386.4 5,813.2 - - 17,462.2

Stock-Based Comp., COGS 1,103.4 1,274.3 2,064.6 4,084.8 7,586.4 9,109.9


Stock-Based Comp., R&D Exp. 3,957.3 5,914.0 10,501.8 13,913.9 18,165.6 20,283.7
Stock-Based Comp., SG&A Exp. 4,832.2 5,923.1 10,132.4 11,807.6 26,100.0 34,304.4
Stock-Based Comp., Unallocated - - - - 278.4 213.5
Stock-Based Comp., Total 9,892.9 13,111.5 22,698.9 29,806.3 52,130.4 63,911.5

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H
* Occasionally, certain items classified as Revenue by the company will be re-classified as other income if it is deemed to be non-recurring and unrelated to the core business of the firm. This field shows Total Revenue exa
Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-equivalent.
Revenue exactly as reported by the firm on its consolidated statement of income.
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Balance Sheet
In Millions of INR, except per share items. Template: Standard   Restatement: Latest Filings
Period Type: Annual   Order: Latest on Right
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)

Balance Sheet
Balance Sheet as of: Restated Restated Restated
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR
ASSETS
Cash And Equivalents 120,469.6 79,259.2 230,450.3 214,957.1 256,545.6 446,099.2
Total Cash & ST Investments 120,469.6 79,259.2 230,450.3 214,957.1 256,545.6 446,099.2

Accounts Receivable 14,324.8 11,188.9 33,899.2 32,894.2 66,050.4 94,230.3


Total Receivables 14,324.8 11,188.9 33,899.2 32,894.2 66,050.4 94,230.3

Inventory 60,286.6 84,618.4 140,411.1 144,470.2 216,664.8 252,799.0


Prepaid Exp. 4,812.8 7,176.1 13,207.1 17,128.4 25,473.6 50,744.9
Restricted Cash 1,134.5 1,498.4 7,166.3 9,913.5 13,432.8 17,508.0
Other Current Assets - 483.4 - - - -
Total Current Assets 201,028.3 184,224.4 425,134.0 419,363.4 578,167.2 861,381.4

Gross Property, Plant & Equipment 187,856.1 396,152.1 1,117,477.4 1,478,749.9 1,624,742.4 1,783,685.1
Accumulated Depreciation (23,749.2) (52,156.6) (96,245.2) (170,872.5) (254,248.8) (346,104.1)
Net Property, Plant & Equipment 164,106.8 343,995.5 1,021,232.2 1,307,877.4 1,370,493.6 1,437,581.0

Long-term Investments - - - 338.5 835.2 71.2


Goodwill - - - 3,844.6 4,732.8 14,091.8
Other Intangibles - 848.7 25,545.9 23,072.9 19,627.2 24,126.9
Accounts Receivable Long-Term - - 34,385.5 29,145.8 29,371.2 27,970.2
Other Long-Term Assets 3,450.5 5,190.3 32,933.1 45,286.5 66,676.8 76,579.9
Total Assets 368,585.6 534,258.9 1,539,230.7 1,828,929.1 2,069,904.0 2,441,802.4

LIABILITIES
Accounts Payable 49,177.9 60,667.3 126,345.1 152,557.7 236,988.0 268,385.5
Accrued Exp. 7,777.9 15,058.4 54,590.8 77,053.6 64,101.6 84,693.4
Curr. Port. of LT Debt 42,309.5 44,712.5 82,242.5 61,523.0 158,966.4 103,624.8
Curr. Port. of Leases 1,327.5 86.1 - 951.9 29,788.8 43,698.9
Curr. Income Taxes Payable 4,502.7 6,701.9 10,384.0 11,859.1 24,220.8 43,485.4
Unearned Revenue, Current 12,115.2 28,074.7 51,827.7 64,798.5 43,848.0 82,771.8
Other Current Liabilities 19,672.6 33,977.1 70,947.5 121,096.4 137,599.2 132,520.2
Total Current Liabilities 136,883.4 189,278.0 396,337.6 489,840.3 695,512.8 759,180.0

Long-Term Debt 114,974.5 133,836.8 411,147.9 605,459.8 588,885.6 742,953.0


Long-Term Leases 1,985.0 13,336.0 89,871.4 106,317.6 184,788.0 155,721.9
Unearned Revenue, Non-Current 18,475.9 29,541.1 57,849.3 75,173.0 68,973.6 85,903.3
Other Non-Current Liabilities 38,633.2 96,504.3 182,977.9 192,655.4 92,359.2 120,848.2
Total Liabilities 310,951.9 462,496.0 1,138,184.2 1,469,446.2 1,630,519.2 1,864,606.4

Common Stock 8.0 8.7 10.9 10.8 - -


Additional Paid In Capital 148,256.0 225,773.9 527,952.7 585,787.4 713,330.4 906,503.8
Retained Earnings (90,628.8) (153,784.2) (203,557.4) (317,484.6) (370,132.8) (432,932.6)
Treasury Stock - - - - - -
Comprehensive Inc. and Other (1.4) (235.5) (1,612.3) 2,128.4 (556.8) (2,562.2)
Total Common Equity 57,633.7 71,762.9 322,794.0 270,442.0 342,640.8 471,009.0

Minority Interest - - 78,252.6 89,041.0 96,744.0 106,187.0

Total Equity 57,633.7 71,762.9 401,046.6 359,483.0 439,384.8 577,196.0

Total Liabilities And Equity 368,585.6 534,258.9 1,539,230.7 1,828,929.1 2,069,904.0 2,441,802.4

Supplemental Items
Total Shares Out. on Filing Date 125.8 132.1 161.7 168.9 172.7 181.3
Total Shares Out. on Balance Sheet Date 125.7 131.4 161.6 168.8 172.6 181.0
Book Value/Share 458.55 546.04 1,997.97 1,602.17 1,985.14 2,602.26
Tangible Book Value 57,633.7 70,914.2 297,248.1 243,524.5 318,280.8 432,790.2
Tangible Book Value/Share 458.55 539.58 1,839.85 1,442.71 1,844.01 2,391.11
Total Debt 160,596.4 191,971.4 583,261.8 774,252.3 962,428.8 1,045,998.7
Net Debt 40,126.8 112,712.1 352,811.6 559,295.2 705,883.2 599,899.5
Debt Equivalent Oper. Leases 23,414.8 36,129.6 63,459.8 NA NA 242,550.4
Total Minority Interest NA NA 78,252.6 89,041.0 96,744.0 106,187.0
Inventory Method FIFO FIFO FIFO FIFO FIFO FIFO
Raw Materials Inventory 24,798.7 35,026.1 46,205.2 52,425.6 64,867.2 101,632.0
Work in Progress Inventory 3,547.2 10,848.8 15,874.9 15,521.0 20,671.2 25,763.9
Finished Goods Inventory 31,940.6 38,743.5 78,331.1 76,523.6 131,126.4 125,403.1
Land 3,127.8 34,536.2 73,311.0 160,663.3 281,671.2 215,220.8
Buildings 9,758.0 NA NA NA NA NA
Machinery 70,524.0 160,340.1 247,955.2 396,768.5 1,035,439.2 1,143,147.0
Construction in Progress 36,166.9 45,904.2 177,139.0 177,780.4 60,900.0 55,655.6
Leasehold Improvements 14,556.5 22,408.3 34,317.1 50,405.9 66,885.6 77,362.8
Full Time Employees 10,161 13,058 30,025 37,543 48,817 48,016
Assets under Cap. Lease, Gross NA NA NA NA 2,505.6 NA
Assets under Cap. Lease, Accum. Depr. NA NA NA NA (278.4) NA
Assets on Oper. Lease, Gross 53,722.9 132,963.3 583,156.0 693,131.9 177,340.8 203,050.6
Assets on Oper. Lease, Accum. Depr. (5,253.2) (14,336.6) (27,132.0) (46,802.9) (31,876.8) (28,895.4)
Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020
Restatement Type RS RS NC NC RS O
Calculation Type RUP RUP RUP RUP REP REP

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H

Note: For multiple class companies, total share counts are primary class equivalent, and for foreign companies listed as primary ADRs, total share counts are ADR-equivalent.
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Cash Flow
In Millions of INR, except per share items. Template: Standard   Restatement: Latest Filings
Period Type: Annual   Order: Latest on Right
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)

Cash Flow
Restated Restated Restated
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR

Net Income (18,587.7) (58,847.3) (45,836.8) (125,224.7) (67,929.6) (61,349.3)


Depreciation & Amort. 14,661.5 27,983.9 64,322.2 101,864.7 127,716.0 146,825.6
Amort. of Goodwill and Intangibles - - - 2,553.0 4,593.6 3,131.5
Depreciation & Amort., Total 14,661.5 27,983.9 64,322.2 104,417.7 132,309.6 149,957.1

Other Amortization 4,408.2 5,168.7 6,430.9 5,808.1 11,066.4 13,380.1


(Gain) Loss From Sale Of Assets 896.3 2,498.0 2,352.1 6,765.5 11,275.2 10,391.0
Asset Writedown & Restructuring Costs - - - - - 3,345.0
Stock-Based Compensation 9,892.9 13,111.5 22,698.9 29,806.3 52,130.4 63,911.5
Other Operating Activities 1,339.5 8,018.4 (11,253.6) 6,254.9 3,132.0 16,369.3
Change in Acc. Receivable (11,609.9) 3,063.8 (14,708.0) (1,595.6) (34,591.2) (26,119.7)
Change In Inventories (66,392.4) (24,459.3) (42,981.2) (11,424.7) (71,200.8) (30,532.3)
Change in Acc. Payable 26,225.1 17,438.7 50,979.7 24,764.1 119,920.8 48,538.6
Change in Unearned Rev. 13,255.0 21,336.3 26,008.9 29,933.9 28,257.6 57,007.9
Change in Other Net Operating Assets 22,287.1 (50,045.1) (66,423.0) (73,398.8) (38,349.6) (73,733.1)
Cash from Ops. (3,624.6) (34,732.3) (8,409.8) (3,893.3) 146,020.8 171,166.0

Capital Expenditure (61,311.3) (108,259.8) (97,829.6) (260,469.8) (161,402.4) (101,916.7)


Cash Acquisitions - (811.9) 23,275.8 (7,339.9) (1,252.8) (3,202.7)
Divestitures - - - - - -
Sale (Purchase) of Intangible assets - - - - - (355.9)
Invest. in Marketable & Equity Securt. (1,056.3) - 1,131.9 - - -
Net (Inc.) Dec. in Loans Originated/Sold - - - - - -
Other Investing Activities (243.3) (1,750.9) - - - 3,273.9
Cash from Investing (62,610.9) (110,822.5) (73,421.9) (267,809.7) (162,655.2) (102,201.4)

Short Term Debt Issued - - - - - -


Long-Term Debt Issued 145,601.3 58,784.6 246,033.8 488,197.4 429,849.6 759,322.3
Total Debt Issued 145,601.3 58,784.6 246,033.8 488,197.4 429,849.6 759,322.3
Short Term Debt Repaid - - - - - -
Long-Term Debt Repaid (706.7) (13,494.3) (129,343.0) (272,149.8) (423,655.2) (702,528.0)
Total Debt Repaid (706.7) (13,494.3) (129,343.0) (272,149.8) (423,655.2) (702,528.0)
Issuance of Common Stock 6,350.3 56,724.8 126,698.9 42,060.7 20,601.6 79,070.9

Total Dividends Paid - - - - - -

Special Dividend Paid - - - - - -


Other Financing Activities (15,766.9) (1,127.4) 10,882.4 23,679.1 13,154.4 (27,044.9)
Cash from Financing 135,478.0 100,887.7 254,272.1 281,787.4 39,950.4 108,820.3

Foreign Exchange Rate Adj. (2,245.7) (2,269.9) (445.0) 2,553.0 (1,600.8) 569.4
Net Change in Cash 66,996.8 (46,937.1) 171,995.3 12,637.4 21,715.2 178,354.3

Supplemental Items
Cash Interest Paid 1,298.4 2,123.0 2,627.8 11,680.0 26,517.6 32,382.8
Cash Taxes Paid 197.2 626.5 1,112.8 4,212.5 2,436.0 3,843.2
Levered Free Cash Flow (46,650.0) (70,350.7) 38,960.8 (93,828.2) (63,303.8) 103,544.8
Unlevered Free Cash Flow (47,072.3) (70,600.5) 40,671.9 (80,608.4) (45,964.7) 122,413.9
Change in Net Working Capital 2,939.4 (26,223.3) (78,885.8) (110,738.9) 57,996.8 (7,259.4)
Net Debt Issued 144,894.6 45,290.3 116,690.9 216,047.6 6,194.4 56,794.4
Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020
Restatement Type NC NC RS RS RS O
Calculation Type REP REP REP REP REP REP

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Multiples
View: Data   Frequency: Quarterly
Order: Latest on Right   Decimals: Capital IQ (Default)
Dilution: Basic  

In Millions of INR, except per share items.

For Quarter Ending Mar-29-2019 Jun-28-2019 Sep-30-2019 Dec-31-2019 Mar-31-2020


TEV/LTM Total Revenue Average 3.16x 2.37x 2.18x 2.82x 5.02x
High 4.09x 2.89x 2.58x 3.62x 7.27x
Low 2.63x 1.94x 1.95x 2.10x 3.11x
Close 2.79x 2.29x 2.16x 3.53x 4.33x

TEV/NTM Total Revenues Average 2.22x 1.97x 1.98x 2.48x 3.96x


High 2.51x 2.25x 2.18x 3.12x 5.55x
Low 2.03x 1.64x 1.81x 1.94x 2.38x
Close 2.17x 1.96x 2.00x 3.04x 3.56x

TEV/LTM EBITDA Average 59.58x 30.15x 23.17x 27.85x 49.32x


High 116.16x 37.88x 32.32x 35.42x 75.44x
Low 34.57x 24.31x 19.16x 20.58x 29.23x
Close 36.62x 28.70x 21.24x 34.51x 40.69x

TEV/NTM EBITDA Average 16.29x 16.49x 17.34x 18.17x 26.38x


High 17.72x 19.38x 18.77x 21.38x 35.63x
Low 15.32x 13.57x 14.52x 16.88x 15.95x
Close 18.14x 16.98x 17.55x 20.83x 27.03x

TEV/LTM EBIT Average NM NM 156.69x 165.59x NM


High NM NM 169.97x 173.03x NM
Low NM NM 145.88x 156.64x NM
Close NM NM 161.70x NM NM

TEV/NTM EBIT Average 48.65x 104.35x 196.86x 99.82x 95.23x


High 61.86x 136.17x 256.80x 207.94x 132.44x
Low 34.58x 59.88x 51.29x 61.34x 53.07x
Close 62.04x 134.46x 205.31x 78.68x 132.44x

P/LTM EPS Average NM NM NM NM NM


High NM NM NM NM NM
Low NM NM NM NM NM
Close NM NM NM NM NM

P/NTM EPS Average 48.61x 86.56x 204.89x 89.21x 85.77x


High 52.44x 120.42x 289.82x 174.78x 111.41x
Low 44.45x 47.35x 79.67x 55.75x 46.12x
Close 52.07x 113.58x 170.96x 69.99x 102.85x

P/LTM Normalized EPS Average NM NM NM NM NM


High NM NM NM NM NM
Low NM NM NM NM NM
Close NM NM NM NM NM

P/BV Average 10.85x 8.62x 7.74x 9.79x 17.35x


High 13.22x 10.23x 9.81x 12.84x 25.09x
Low 9.13x 6.75x 6.63x 7.25x 9.88x
Close 9.81x 8.43x 7.55x 12.47x 14.33x

P/Tangible BV Average 11.71x 9.31x 8.43x 10.73x 18.93x


High 14.35x 11.02x 10.61x 14.10x 27.31x
Low 9.83x 7.30x 7.23x 7.92x 10.75x
Close 10.56x 9.12x 8.24x 13.68x 15.60x

P/NTM CFPS Average 15.70x 18.33x 18.43x 24.02x 40.31x


High 18.20x 20.99x 50.66x 33.84x 55.78x
Low 13.87x 15.21x 15.42x 16.89x 21.96x
Close 15.90x 19.71x 17.57x 32.85x 40.08x

TEV/LTM Unlevered FCF Average NM NM 36.71x 52.39x 75.18x


High NM NM 39.04x 68.78x 103.91x
Low NM NM 30.13x 35.70x 44.41x
Close NM NM 38.25x 67.01x 61.82x

Market Cap/LTM Levered FCF Average NM NM 36.38x 56.85x 84.75x


High NM NM 39.25x 78.17x 116.02x
Low NM NM 28.93x 35.75x 45.68x
Close NM NM 38.26x 75.88x 66.27x

Average multiples are calculated using positive close values on each trading day within the frequency periods selected. Negative values are excluded from the calculation. When the Multiples are not meaningful, due to neg

When a mismatch exists between the currency of the equity listing and the reported financial results such results are translated into the currency of the listing at the exchange rate applicable on the financial period end date

Historical Equity Pricing Data supplied by Interactive Data Pricing and


Reference Data LLC
Apr-14-2020
4.53x
5.72x
3.81x
5.72x

3.84x
4.86x
3.20x
4.91x

42.61x
53.78x
35.80x
53.78x

30.39x
38.24x
25.05x
40.54x

NM
NM
NM
NM

182.46x
244.33x
135.70x
244.33x

NM
NM
NM
NM

140.14x
185.21x
99.48x
205.95x

NM
NM
NM
NM

15.07x
19.42x
12.43x
19.42x

16.41x
21.13x
13.53x
21.13x

38.38x
47.48x
34.53x
47.48x

64.73x
81.71x
54.38x
81.71x

69.70x
89.78x
57.47x
89.78x

ul, due to negative values, then they will not be displayed in the chart.

riod end date.


Tesla, Inc. (NasdaqGS:TSLA) > Financials > Historical Capitalization
In Millions of INR, except per share items. Frequency: Quarterly   Order: Latest on Right
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)
Dilution: Basic  

Historical Capitalization
Balance Sheet as of:
Sep-30-2018 Dec-31-2018 Mar-31-2019 Jun-30-2019 Sep-30-2019 Dec-31-2019
Pricing as of* Nov-02-2018 Feb-19-2019 Apr-29-2019 Jul-29-2019 Oct-29-2019 Feb-13-2020
Currency INR INR INR INR INR INR
Capitalization Detail
Share Price 25,244.63 21,799.77 16,859.44 16,217.53 22,418.7 57,312.74
Shares Out. 171.7 172.7 173.7 179.1 180.2 181.3

Market Capitalization 4,335,330.1 3,765,289.2 2,928,834.6 2,905,002.0 4,040,855.7 10,393,182.8


- Cash & Short Term Investments 215,277.6 256,519.0 152,300.1 341,505.5 377,147.8 446,099.2
+ Total Debt 984,013.9 962,378.1 883,278.1 987,069.7 1,034,083.2 1,045,998.7
+ Pref. Equity - - - - - -
+ Total Minority Interest 97,553.5 96,769.1 99,237.6 98,912.1 101,882.2 106,187.0
= Total Enterprise Value (TEV) 5,201,620.0 4,567,917.4 3,759,050.2 3,649,478.3 4,799,673.2 11,099,269.3

Book Value of Common Equity 327,093.7 342,657.7 319,098.7 393,933.5 426,746.5 471,009.0
+ Pref. Equity - - - - - -
+ Total Minority Interest 97,553.5 96,769.1 99,237.6 98,912.1 101,882.2 106,187.0
+ Total Debt 984,013.9 962,378.1 883,278.1 987,069.7 1,034,083.2 1,045,998.7
= Total Capital 1,408,661.0 1,401,804.9 1,301,614.4 1,479,915.2 1,562,711.9 1,623,194.7

Currency INR INR INR INR INR INR


Exchange Rate 72.545 69.6 69.285 68.925 70.6534 71.1709
Conversion Method H H H H H H

* Pricing as of the filing date of the balance sheet period end date. For
TEV calculation purposes on this page Capital IQ only uses balance
sheet components from the original filing that is publicly available as of
a given pricing date and does not use restated balance sheet data from
a later filing. In the cases where a company did not disclose balance
sheet values for a particular period, TEV is calculated using balance
sheet components from the last reported balance sheet as of this date.
The table above is organized along period end dates.
** For companies that have multiple share classes that publicly trade,
we are incorporating the different prices to calculate our company level
market capitalization. Please click on the value to see the detailed
calculation. Prices shown on this page are the close price of the
company’s primary stock class. Shares shown on this page are total
company as-reported share values.

Historical Equity Pricing Data supplied by Interactive Data Pricing and


Reference Data LLC
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Capital Structure Summary
In Millions of INR, except ratios and % of Total values. Restatement: Latest Filings   Period Type: Annual
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)
Order: Latest on Right  

Capital Structure Data


For the Fiscal Period Ending
12 months Dec-31-2017 12 months Dec-31-2018 12 months Dec-31-2019
Currency INR INR INR
Units Millions % of Total Millions % of Total Millions % of Total

Total Debt 774,252.3 68.3% 962,428.8 68.7% 1,045,998.7 64.4%


Total Common Equity 270,442.0 23.9% 342,640.8 24.4% 471,009.0 29.0%
Total Minority Interest 89,041.0 7.9% 96,744.0 6.9% 106,187.0 6.5%
Total Capital 1,133,735.3 100.0% 1,401,813.6 100.0% 1,623,194.7 100.0%

Currency INR INR INR


Exchange Rate 63.825 69.6 71.1709
Conversion Method H H H

Debt Summary Data


For the Fiscal Period Ending
12 months Dec-31-2017 12 months Dec-31-2018 12 months Dec-31-2019
Currency INR INR INR
Units Millions % of Total Millions % of Total Millions % of Total

Total Revolving Credit 129,417.4 16.7% 118,668.0 12.3% 137,644.5 13.2%


Total Term Loans 24,697.6 3.2% 26,096.7 2.7% 70,530.4 6.7%
Total Senior Bonds and Notes 440,455.9 56.9% 595,866.5 61.9% 622,232.9 59.5%
Total Subordinated Bonds and Notes 2,039.1 0.3% - - - -
Total Lease Liabilities 151,055.7 19.5% 214,576.8 22.3% 199,420.9 19.1%
General/Other Borrowings 38,941.2 5.0% 40,847.0 4.2% 40,487.8 3.9%
Total Principal Due 786,606.8 101.6% 996,055.0 103.5% 1,070,316.5 102.3%

Total Adjustments (12,354.5) (1.6%) (33,626.2) (3.5%) (24,317.8) (2.3%)


Total Debt Outstanding 774,252.3 100.0% 962,428.8 100.0% 1,045,998.7 100.0%

Available Credit
Undrawn Revolving Credit 101,757.6 - 86,234.4 - 101,916.7 -
Other Available Credit 1,246.8 - 1,252.8 - 110,172.6 -
Total Undrawn Credit 103,004.4 - 87,487.2 - 212,089.3 -
Additional Totals
Total Cash & ST Investments 214,957.1 - 256,545.6 - 446,099.2 -
Net Debt 559,295.2 - 705,883.2 - 599,899.5 -
Total Senior Debt 784,567.7 101.3% 996,055.0 103.5% 1,070,316.5 102.3%
Total Subordinated Debt 2,039.1 0.3% - - - -
Subordinated Debt 2,039.1 0.3% - - - -
Total Convertible Debt 237,604.1 30.7% 254,805.6 26.5% 262,335.9 25.1%
Curr. Port. of LT Debt/Cap. Leases 62,474.9 8.1% 188,755.2 19.6% 147,323.8 14.1%
Long-Term Debt (Incl. Cap. Leases) 711,777.4 91.9% 773,673.6 80.4% 898,675.0 85.9%
Total Bank Debt 154,115.0 19.9% 144,764.7 15.0% 208,174.9 19.9%
Total Secured Debt 418,624.9 54.1% 602,606.2 62.6% 669,624.4 64.0%
Senior Secured Loans 154,115.0 19.9% 144,764.7 15.0% 208,174.9 19.9%
Senior Secured Bonds and Notes 83,144.8 10.7% 210,212.9 21.8% 228,230.8 21.8%
Total Senior Secured Debt 418,624.9 54.1% 602,606.2 62.6% 669,624.4 64.0%
Total Unsecured Debt 367,982.0 47.5% 393,448.8 40.9% 400,692.2 38.3%
Senior Unsecured Bonds and Notes 357,311.1 46.1% 385,653.6 40.1% 394,002.1 37.7%
Securitized Debt 83,144.8 10.7% 210,212.9 21.8% 228,230.8 21.8%
Total Non-Recourse Debt 195,752.9 25.3% 161,300.4 16.8% 323,513.2 30.9%
Fixed Rate Debt 484,511.1 62.6% 561,441.1 58.3% 593,258.0 56.7%
Variable Rate Debt 147,546.5 19.1% 137,874.3 14.3% 198,922.7 19.0%
Zero Coupon Debt 5,519.3 0.7% 6,403.2 0.7% 6,903.6 0.7%

Credit Ratios
Net Debt/EBITDA NM - 6.2x - 3.2x -
Total Debt/EBITDA NM - 8.4x - 5.6x -
Total Senior Debt/EBITDA NM - 8.7x - 5.8x -
Total Senior Secured/EBITDA NM - 5.3x - 3.6x -
Total Sub. Debt/EBITDA 8.0x - - - - -
Subordinated Debt/EBITDA 8.0x - - - - -
Net Debt/(EBITDA-CAPEX) NM - NM - 7.1x -
Total Debt/(EBITDA-CAPEX) NM - NM - 12.4x -
Total Senior Debt/(EBITDA-CAPEX) NM - NM - 12.7x -
Total Senior Secured/(EBITDA-CAPEX) NM - NM - 8.0x -
Total Sub. Debt/(EBITDA-CAPEX) NM - - - - -
Subordinated Debt/(EBITDA-CAPEX) NM - - - - -

Fixed Payment Schedule


LT Debt (Incl. Cap. Leases) Due +1 137,698.7 17.8% 181,825.4 18.9% 122,540.9 11.7%
LT Debt (Incl. Cap. Leases) Due +2 121,712.2 15.7% 180,702.7 18.8% 185,784.9 17.8%
LT Debt (Incl. Cap. Leases) Due +3 31,898.7 4.1% 167,646.8 17.4% 176,811.5 16.9%
LT Debt (Incl. Cap. Leases) Due +4 102,251.9 13.2% 97,561.6 10.1% 134,892.2 12.9%
LT Debt (Incl. Cap. Leases) Due +5 90,712.2 11.7% 18,125.7 1.9% 161,559.4 15.4%
LT Debt (Incl. Cap. Leases) Due, Next 5 Yrs 484,273.7 62.5% 645,862.2 67.1% 781,589.0 74.7%
LT Debt (Incl. Cap. Leases) Due, After 5 Yrs 281,345.8 36.3% 308,710.7 32.1% 173,453.4 16.6%

Cap. Lease Payment Due +1 7,122.9 - 29,750.7 - 27,472.0 -


Cap. Lease Payment Due +2 8,504.9 - 34,385.0 - 31,751.7 -
Cap. Lease Payment Due +3 10,361.1 - 34,566.1 - 39,855.7 -
Cap. Lease Payment Due +4 8,550.1 - 1,627.1 - 14,879.5 -
Cap. Lease Payment Due +5 8,285.6 - 326.1 - 332.1 -
Cap. Lease Payment Due, Next 5 Yrs 42,824.5 - 100,655.0 - 114,291.0 -
Cap. Lease Payment Due, After 5 Yrs 108,230.3 - 113,897.6 - 863.5 -
Cap. Lease Payment Due (incl. Interest) +1 - - - - 33,735.0 -

Operating Lease Commitment Due +1 14,337.0 - 19,185.5 - 21,066.6 -


Operating Lease Commitment Due +2 13,041.7 - 17,882.4 - 18,646.8 -
Operating Lease Commitment Due +3 11,208.4 - 16,036.3 - 14,945.9 -
Operating Lease Commitment Due +4 9,991.9 - 12,730.6 - 12,383.7 -
Operating Lease Commitment Due +5 8,348.4 - 10,973.3 - 10,391.0 -
Operating Lease Commitment Due, Next 5 Yrs 56,927.5 - 76,808.1 - 77,433.9 -
Operating Lease Commitment Due, After 5 Yrs 27,144.5 - 36,511.5 - 26,475.6 -

Contractual Obligations Due +1 176,273.1 - 338,286.0 - 407,738.1 -


Contractual Obligations Due + 2 145,500.7 - 226,615.4 - 209,669.5 -
Contractual Obligations Due + 3 222,427.1 - 236,057.9 - 259,417.9 -
Contractual Obligations Due + 4 219,161.5 - 277,379.4 - 280,982.7 -
Contractual Obligations Due + 5 219,299.9 - 178,922.8 - 1,708.1 -
Contractual Obligations Due, Next 5 Yrs 982,662.3 - 1,257,261.5 - 1,159,516.3 -
Contractual Obligations Due, After 5 Yrs 135,899.3 - 1,670.3 - - -
Total Contractual Obligations 1,118,561.5 - 1,258,931.8 - 1,159,516.3 -

Interest Rate Data


Filing Date Feb-13-2020 - Feb-13-2020 - Feb-13-2020 -

Currency INR INR INR


Exchange Rate 63.825 69.6 71.1709
Conversion Method H H H
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Capital Structure Details
Principal Due in Millions of  
INR. Period Type: Annual Source: A 2019 filed Feb-13-2020
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)

FY 2019 (Dec-31-2019) Capital Structure As Reported Details

Coupon/Base
Description Type Principal Due (INR) Rate Floating Rate Maturity Seniority Secured
1.25% Convertible Senior Bonds and Notes 92,806.9 1.250% NA Mar-01-2021 Senior No
Notes Due in 2021
2.00% Convertible Senior Bonds and Notes 98,429.4 2.000% NA May-15-2024 Senior No
Notes Due in 2024
2.375% Convertible Senior Bonds and Notes 64,196.2 2.375% NA Mar-15-2022 Senior No
Notes Due in 2022
5.30% Senior Notes Due in Bonds and Notes 126,826.5 5.300% NA Aug-15-2025 Senior No
2025
Asset Based Revolving Credit Revolving Credit 122,912.1 2.700% - 4.800% LIBOR + 1.000% 6-2020 - 2023 Senior Yes
Agreement
Automotive Asset Backed Bonds and Notes 111,738.3 2.000% - 7.900% NA 2-2020 - 2023 Senior Yes
Notes
Build To Suit Lease Liability Capital Lease - NA NA - Senior Yes
Canada Credit Facility Revolving Credit 2,846.8 4.200% - 5.900% NA Nov-30-2022 Senior Yes
Cash Equity Debt I * Other Borrowings 8,339.7 5.700% NA Jul-31-2033 Senior Yes
Cash Equity Debt II * Other Borrowings 13,758.5 5.300% NA Jul-31-2034 Senior Yes
Cash Equity Debt III * Other Borrowings 11,699.6 5.800% NA Jan-31-2035 Senior Yes
China Loan Agreements Revolving Credit - NA Various Benchmarks 3-2020 - 2020 Senior No
Facility
China Loan Agreements Revolving Credit - NA Various Benchmarks - Senior No
Facility
China Loan Agreements from Term Loans 52,737.6 3.700% - 4.000% Various Benchmarks 9-2020 - 2024 Senior Yes
Banks
Finance Leases Capital Lease 115,154.5 6.500% NA - Senior Yes
Financing Obligation Other Borrowings 6,690.1 NA NA - Senior No
Operating Leases Capital Lease 84,266.3 6.500% NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 3,871.7 4.800% NA Nov-30-2038 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 4,996.2 4.600% NA Apr-30-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 11,387.3 4.000% NA Jul-31-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 2,953.6 5.400% NA Jul-31-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 7,366.2 4.200% NA Aug-31-2045 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 1,423.4 5.600% NA Aug-31-2045 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 3,715.1 5.300% NA Sep-30-2046 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 18,860.3 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 5,337.8 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 7,045.9 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 2,270.4 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 23,778.2 NA NA - Senior Yes
Solar Bonds and Other Loans Bonds and Notes 4,839.6 3.600% - 5.800% NA 3-2020 - 2031 Senior No
Solar Loan Backed Notes * Bonds and Notes 10,789.5 3.220% NA Sep-30-2048 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 2,377.1 15.900% NA Sep-30-2048 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 8,754.0 1.870% NA Sep-30-2049 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 626.3 1.860% NA Sep-30-2049 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 939.5 8.130% NA Sep-30-2049 Senior Yes
Solar Renewable Energy Credit Term Loans 6,405.4 4.500% - 7.400% NA 3-2020 - 2022 Senior Yes
and Other Loans
Solar Term Loans Bank Term Loans 11,387.3 5.400% 3-Month LIBOR Jan-31-2021 Senior Yes
Warehouse Agreements Revolving Credit 11,885.5 3.100% - 3.600% Benchmark Sep-30-2021 Senior Yes
Zero Coupon Convertible Bonds and Notes 6,903.6 NA NA Dec-01-2020 Senior No
Senior Notes Due in 2020

*Principal Due values translated into INR at an exchange rate of 71.171 INR/USD on Dec-31-2019.

FY 2018 (Dec-31-2018) Capital Structure As Reported Details

Coupon/Base
Description Type Principal Due (INR) Rate Floating Rate Maturity Seniority Secured
0.25% Convertible Senior Bonds and Notes 63,544.8 0.250% NA Mar-01-2019 Senior No
Notes Due in 2019
1.25% Convertible Senior Bonds and Notes 86,582.4 1.250% NA Mar-01-2021 Senior No
Notes Due in 2021
1.625% Convertible Senior Bonds and Notes 37,653.6 1.625% NA Nov-01-2019 Senior No
Notes Due in 2019
2.375% Convertible Senior Bonds and Notes 60,621.6 2.375% NA Mar-15-2022 Senior No
Notes Due in 2022
5.30% Senior Notes Due in Bonds and Notes 123,818.4 5.300% NA Aug-15-2025 Senior No
2025
Asset Based Revolving Credit Revolving Credit 107,184.0 2.700% - 4.800% LIBOR + 1.000% 6-2020 - 2023 Senior Yes
Agreement
Automotive Asset Backed Bonds and Notes 38,008.6 2.300% - 4.900% NA 2018 Senior Yes
Notes *
Automotive Asset Backed Bonds and Notes 58,283.0 NA NA 2018 Senior Yes
Notes *
Build To Suit Lease Liability Capital Lease 121,382.4 NA NA - Senior Yes
Canada Credit Facility Revolving Credit 5,080.8 4.200% - 5.900% NA Nov-30-2022 Senior Yes
Cash Equity Debt I * Other Borrowings 8,155.7 5.700% NA Jul-31-2033 Senior Yes
Cash Equity Debt II * Other Borrowings 13,454.8 5.300% NA Jul-31-2034 Senior Yes
Cash Equity Debt III * Other Borrowings 11,441.3 5.800% NA Jan-31-2035 Senior Yes
Finance Leases Capital Lease 93,194.4 6.500% NA - Senior Yes
Financing Obligation Other Borrowings 7,795.2 NA NA - Senior No
Solar Asset Backed Notes * Bonds and Notes 3,786.2 4.800% NA Nov-30-2038 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 4,885.9 4.600% NA Apr-30-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 11,136.0 4.000% NA Jul-31-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 2,888.4 5.400% NA Jul-31-2044 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 7,203.6 4.200% NA Aug-31-2045 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 1,392.0 5.600% NA Aug-31-2045 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 3,633.1 5.300% NA Sep-30-2046 Senior Yes
Solar Asset Backed Notes * Bonds and Notes 18,444.0 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 5,220.0 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 6,890.4 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 2,220.2 NA NA - Senior Yes
Solar Asset Backed Notes * Bonds and Notes 23,253.4 NA NA - Senior Yes
Solar Bonds and Other Loans Bonds and Notes 7,029.6 1.800% - 7.600% NA 1-2019 - 2031 Senior No
Solar Loan Backed Notes * Bonds and Notes 10,551.4 3.220% NA Sep-30-2048 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 2,324.6 15.900% NA Sep-30-2048 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 8,560.8 1.870% NA Sep-30-2049 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 612.5 1.860% NA Sep-30-2049 Senior Yes
Solar Loan Backed Notes * Bonds and Notes 918.7 8.130% NA Sep-30-2049 Senior Yes
Solar Renewable Energy Credit Term Loans 1,809.6 5.100% - 7.900% NA 12-2019 - 2021 Senior Yes
and Other Loans
Solar Term Loans Bank * Term Loans 11,715.7 5.400% 3-Month LIBOR Jan-31-2021 Senior Yes
Term Loan Due in 2019 * Term Loans 12,571.4 6.300% NA Dec-01-2019 Senior Yes
Warehouse Agreements Revolving Credit 6,403.2 3.100% - 3.600% Benchmark Sep-30-2021 Senior Yes
Zero Coupon Convertible Bonds and Notes 6,403.2 NA NA Dec-01-2020 Senior No
Senior Notes Due in 2020
Repayme
nt
Convertible Currency
Convertible USD

Convertible USD

Convertible USD

No USD

No USD

No USD

No USD
No USD
No USD
No USD
No USD
No CNY

No CNY

No CNY

No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD

No USD
No USD
Convertible USD

Repayme
nt
Convertible Currency
Convertible USD

Convertible USD

Convertible USD

Convertible USD

No USD

No USD

No USD

No USD

No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD
No USD

No USD
No USD
No USD
Convertible USD
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Ratios
Restatement: Latest Filings   Period Type: Annual
Order: Latest on Right   Decimals: Capital IQ (Default)

Ratios
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Profitability
Return on Assets % (2.8%) (6.4%) (2.6%) (4.0%) (0.5%) 0.2%
Return on Capital % (4.9%) (12.0%) (4.4%) (6.3%) (0.8%) 0.2%
Return on Equity % (37.2%) (89.1%) (22.1%) (38.8%) (17.8%) (10.7%)
Return on Common Equity % (37.2%) (89.1%) (23.1%) (43.6%) (21.3%) (14.9%)

Margin Analysis
Gross Margin % 27.6% 22.8% 22.8% 18.9% 18.8% 16.6%
SG&A Margin % 18.9% 22.8% 20.1% 21.1% 13.2% 10.8%
EBITDA Margin % 1.4% (7.3%) 4.3% 0.0% 7.7% 8.9%
EBITA Margin % (5.8%) (17.7%) (9.2%) (13.5%) (0.9%) 0.5%
EBIT Margin % (5.8%) (17.7%) (9.2%) (13.9%) (1.2%) 0.3%
Earnings from Cont. Ops Margin % (9.2%) (22.0%) (11.0%) (19.1%) (5.0%) (3.2%)
Net Income Margin % (9.2%) (22.0%) (9.6%) (16.7%) (4.5%) (3.5%)
Net Income Avail. for Common Margin % (9.2%) (22.0%) (9.6%) (16.7%) (4.5%) (3.5%)
Normalized Net Income Margin % (5.6%) (13.5%) (5.9%) (9.1%) (2.1%) (1.7%)
Levered Free Cash Flow Margin % (23.1%) (26.3%) 8.2% (12.5%) (4.2%) 5.9%
Unlevered Free Cash Flow Margin % (23.3%) (26.4%) 8.6% (10.7%) (3.1%) 7.0%

Asset Turnover
Total Asset Turnover 0.8x 0.6x 0.5x 0.5x 0.7x 0.8x
Fixed Asset Turnover 1.7x 1.0x 0.7x 0.7x 1.1x 1.2x
Accounts Receivable Turnover 23.2x 20.5x 21.0x 23.2x 29.3x 21.6x
Inventory Turnover 3.6x 2.8x 3.2x 4.4x 6.5x 6.2x

Short Term Liquidity


Current Ratio 1.5x 1.0x 1.1x 0.9x 0.8x 1.1x
Quick Ratio 1.0x 0.5x 0.7x 0.5x 0.5x 0.7x
Cash from Ops. to Curr. Liab. NM NM NM NM 0.2x 0.2x
Avg. Days Sales Out. 15.7 17.8 17.5 15.7 12.5 16.9
Avg. Days Inventory Out. 101.9 130.4 113.3 82.9 56.3 59.3
Avg. Days Payable Out. 67.4 89.7 82.1 79.7 57.9 62.5
Avg. Cash Conversion Cycle 50.3 58.6 48.7 18.9 10.9 13.7

Long Term Solvency


Total Debt/Equity 278.7% 267.5% 145.4% 215.4% 219.0% 181.2%
Total Debt/Capital 73.6% 72.8% 59.3% 68.3% 68.7% 64.4%
LT Debt/Equity 202.9% 205.1% 124.9% 198.0% 176.1% 155.7%
LT Debt/Capital 53.6% 55.8% 50.9% 62.8% 55.2% 55.4%
Total Liabilities/Total Assets 84.4% 86.6% 73.9% 80.3% 78.8% 76.4%

EBIT / Interest Exp. NM NM NM NM NM 0.1x


EBITDA / Interest Exp. 0.4x NM 1.6x 0.0x 2.5x 3.6x
(EBITDA-CAPEX) / Interest Exp. NM NM NM NM NM 1.6x
Total Debt/EBITDA 56.2x NM 28.5x NM 8.4x 5.6x
Net Debt/EBITDA 14.0x NM 17.2x NM 6.2x 3.2x
Total Debt/(EBITDA-CAPEX) NM NM NM NM NM 12.4x
Net Debt/(EBITDA-CAPEX) NM NM NM NM NM 7.1x

Altman Z Score 3.69 2.32 1.13 1.29 1.76 1.63

Growth Over Prior Year


Total Revenue 58.8% 26.5% 73.0% 68.0% 82.5% 14.5%
Gross Profit 93.2% 4.7% 73.2% 39.0% 81.8% 0.7%
EBITDA 1.0% NM NM (98.7%) 41,100.0% 32.7%
EBITA NM NM NM NM NM NM
EBIT NM NM NM NM NM NM
Earnings from Cont. Ops. NM NM NM NM NM NM
Net Income NM NM NM NM NM NM
Normalized Net Income NM NM NM NM NM NM
Diluted EPS before Extra NM NM NM NM NM NM

Accounts Receivable 361.4% (25.4%) 195.4% 3.3% 84.1% 39.5%


Inventory 180.2% 34.0% 61.8% 9.5% 37.5% 14.1%
Net PP&E 131.6% 100.1% 189.5% 36.3% (3.9%) 2.6%
Total Assets 141.2% 38.4% 180.9% 26.4% 3.8% 15.4%

Tangible Book Value 36.7% 17.5% 308.7% (12.8%) 19.9% 33.0%


Common Equity 36.7% 18.9% 338.6% (10.8%) 16.2% 34.4%
Cash from Ops. NM NM NM NM NM 14.6%
Capital Expenditures 267.1% 68.6% (11.9%) 183.3% (43.2%) (38.2%)
Levered Free Cash Flow NM NM NM NM NM NM
Unlevered Free Cash Flow NM NM NM NM NM NM
Dividend per Share NA NA NA NA NA NA

Compound Annual Growth Rate Over Two Years


Total Revenue 178.2% 41.8% 47.9% 70.5% 75.1% 44.6%
Gross Profit 441.5% 42.3% 34.7% 55.1% 59.0% 35.3%
EBITDA NM NM 158.1% NM 133.8% 2,238.3%
EBITA NM NM NM NM NM NM
EBIT NM NM NM NM NM NM
Earnings from Cont. Ops. NM NM NM NM NM NM
Net Income NM NM NM NM NM NM
Normalized Net Income NM NM NM NM NM NM
Diluted EPS before Extra NM NM NM NM NM NM

Accounts Receivable 190.6% 85.5% 48.4% 74.6% 37.9% 60.3%


Inventory 88.5% 93.8% 47.2% 33.1% 22.7% 25.3%
Net PP&E 114.9% 115.3% 140.7% 98.6% 14.4% (0.7%)
Total Assets 128.8% 82.7% 97.2% 88.5% 14.6% 9.4%

Tangible Book Value 187.3% 26.7% 119.1% 88.8% 2.2% 26.2%


Common Equity 170.4% 27.5% 128.3% 97.7% 1.8% 25.0%
Cash from Ops. NM NM NM NM NM NM
Capital Expenditures 101.4% 148.7% 21.9% 58.0% 26.9% (40.8%)
Levered Free Cash Flow NM NM NM NM NM NM
Unlevered Free Cash Flow NM NM NM NM NM NM
Dividend per Share NA NA NA NA NA NA

Compound Annual Growth Rate Over Three Years


Total Revenue 150.2% 113.9% 51.5% 54.3% 74.4% 52.0%
Gross Profit 142.8% 213.2% 51.9% 36.1% 63.6% 36.5%
EBITDA NM NM 88.8% (55.5%) NM 93.6%
EBITA NM NM NM NM NM NM
EBIT NM NM NM NM NM NM
Earnings from Cont. Ops. NM NM NM NM NM NM
Net Income NM NM NM NM NM NM
Normalized Net Income NM NM NM NM NM NM
Diluted EPS before Extra NM NM NM NM NM NM

Accounts Receivable 187.5% 84.6% 116.6% 31.5% 77.8% 38.4%


Inventory 167.0% 68.2% 82.5% 33.4% 34.6% 19.8%
Net PP&E 103.0% 109.8% 137.6% 99.1% 55.9% 10.3%
Total Assets 101.4% 93.5% 110.9% 70.0% 54.5% 14.8%

Tangible Book Value 63.3% 113.2% 87.2% 61.2% 62.2% 11.6%


Common Equity 59.7% 105.6% 92.4% 66.9% 65.6% 11.7%
Cash from Ops. NM NM NM NM NM NM
Capital Expenditures 74.0% 89.8% 76.0% 61.4% 12.4% (0.2%)
Levered Free Cash Flow NM NM NM NM NM 36.4%
Unlevered Free Cash Flow NM NM NM NM NM 42.1%
Dividend per Share NA NA NA NA NA NA

Compound Annual Growth Rate Over Five Years


Total Revenue 95.5% 103.2% 102.8% 95.4% 60.5% 50.4%
Gross Profit 147.3% 97.5% 91.8% 136.5% 54.7% 35.8%
EBITDA NM NM NM NM 105.7% 117.2%
EBITA NM NM NM NM NM NM
EBIT NM NM NM NM NM NM
Earnings from Cont. Ops. NM NM NM NM NM NM
Net Income NM NM NM NM NM NM
Normalized Net Income NM NM NM NM NM NM
Diluted EPS before Extra NM NM NM NM NM NM

Accounts Receivable 130.4% 90.6% 120.7% 80.6% 80.8% 42.3%


Inventory 110.2% 95.1% 110.5% 53.2% 55.7% 30.1%
Net PP&E 156.2% 111.6% 117.3% 105.3% 77.4% 50.7%
Total Assets 113.8% 83.7% 99.7% 91.4% 65.2% 42.5%

Tangible Book Value NM 40.9% 83.6% 103.1% 47.0% 46.2%


Common Equity NM 39.2% 84.2% 102.4% 49.1% 48.7%
Cash from Ops. NM NM NM NM 51.3% NM
Capital Expenditures 141.2% 109.8% 50.9% 76.4% 54.4% 8.1%
Levered Free Cash Flow NM NM NM NM NM NM
Unlevered Free Cash Flow NM NM NM NM NM NM
Dividend per Share NA NA NA NA NA NA
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Supplemental
In Millions of INR, except per share items. Restatement: Latest Filings   Period Type: Annual
Currency: Indian Rupee   Conversion: Historical
Order: Latest on Right   Units: Millions (mm)
Decimals: Capital IQ (Default)  

Supplemental
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR
Options Outstanding
Options Out. at the Beginning of the Period - - - - - 31.2
Options Granted During the Period - - - - - 1.5
Options Exercised During the Period - - - - - 1.4
Options Cancelled During the Period - - - - - 1.2
Options Out. at the End of the Period - - - - - 30.0
W/Avg. Strike Price of Out. at the End of the Period - - - - - 19,891.55
W/Avg. Strike Price of Granted - - - - - 18,878.79

Options Outstanding - All Classes


Options Out. at the Beginning of the Period - - - - - 31.2
Options Granted During the Period - - - - - 1.5
Options Exercised During the Period - - - - - 1.4
Options Cancelled During the Period - - - - - 1.2
Options Out. at the End of the Period - - - - - 30.0

Warrants Outstanding
Warrants Issued During the Period 6.3 - - - - -
Warrants W/Avg. Strike Price of Issued 34,237.24 - - - - -

Warrants Outstanding - All Classes


Warrants Issued During the Period 6.3 - - - - -

Stock Based Compensation


Stock Options Comp. Exp., Before Tax 2,256.8 1,390.6 2,791.3 765.9 - -
Stock Based Comp. Exp., Before Tax 9,892.9 13,111.5 22,698.9 29,806.3 52,130.4 63,911.5

Loss Carry Forward Related Items


NOL C/F, After Five Years 147,404.7 231,770.0 499,175.3 745,476.0 881,832.0 972,906.2
Total NOL C/F 147,404.7 231,770.0 499,175.3 745,476.0 881,832.0 972,906.2

Tax Benefit C/F, After Five Years 2,136.7 5,860.5 17,556.0 20,800.6 26,649.8 31,671.1
Tax Benefit C/F, No Expiration 2,313.7 4,105.6 11,110.9 14,245.7 19,223.5 20,212.5
Total Tax Benefit C/F 4,450.3 9,966.1 28,666.9 35,046.3 45,873.4 51,883.6

Adoption of FIN 48 Related Items


Unrecognized Tax Benefits - Beginning of Period 845.2 2,740.0 6,732.2 13,020.3 13,850.4 18,006.2
Increase in Unrecog. Tax Benefits - Current Yr. 1,766.9 3,385.4 4,265.4 5,361.3 4,176.0 4,199.1
Increase in Unrecog. Tax Benefits - Prior Yrs. 3.5 438.8 1,947.6 - - -
Decrease in Unrecog. Tax Benefits - Prior Yrs. - - - (1,978.6) (417.6) (2,775.7)
Unrecog. Tax Benefits - Other Adjustments - - 905.1 (3,701.9) - -
Unrecognized Tax Benefits - End of Period 2,615.6 6,564.2 13,850.3 12,701.2 17,608.8 19,429.7

Capitalized Interest Data


Interest Capitalized - 2,746.6 - - 3,828.0 2,206.3
Interest Capitalized, Expensed - 282.2 - - - -

Fair Value Measurements


Level 1 Assets - Quoted Prices 81,675.0 20,824.5 151,200.7 138,082.8 126,184.8 116,150.9
Level 2 Assets - Observable Prices - 483.4 101.2 3.8 835.2 71.2
Fair Value of Assets 81,675.0 21,307.9 151,301.9 138,086.5 127,020.0 116,222.1

Level 2 Liabilities - Observable Prices 210,012.9 226,688.1 217,711.1 397,065.0 412,240.8 558,122.2
Level 3 Liabilities - Unobservable Prices - - 39,099.0 74,249.9 98,762.4 99,639.3
Fair Value of Liabilities 210,012.9 226,688.1 256,810.1 471,314.9 511,003.2 657,761.5

Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H
Tesla, Inc. (NasdaqGS:TSLA) > Financials > Segments
In Millions of INR. View By: Line Items   Restatement: Latest Filings
Period Type: Annual   Order: Latest on Right
Currency: Indian Rupee   Conversion: Historical
Units: Millions (mm)   Decimals: Capital IQ (Default)

Business Segments
Reclassified Restated Restated
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR
Revenues
Automotive 201,918.1 266,969.1 463,094.6 679,289.5 1,385,457.6 1,640,275.7
Energy Generation and Storage 266.0 958.7 12,319.4 71,228.7 108,228.0 108,962.6
Total Revenues 202,184.1 267,927.8 475,414.0 750,518.2 1,493,685.6 1,749,238.4

Gross Profit Before Tax


Automotive 55,722.0 61,009.3 108,405.6 126,437.3 268,099.2 276,071.9
Energy Generation and Storage 12.8 145.0 208.0 15,445.7 13,224.0 13,522.5
Total Gross Profit Before Tax 55,734.8 61,154.4 108,613.5 141,883.0 281,323.2 289,594.4

Assets
Auto Manufacturers 368,585.6 - - - - -
Total Assets 368,585.6 - - - - -

Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H

Geographic Segments
Reclassified Restated Restated
For the Fiscal Period Ending 12 months 12 months 12 months 12 months 12 months 12 months
Dec-31-2014 Dec-31-2015 Dec-31-2016 Dec-31-2017 Dec-31-2018 Dec-31-2019
Currency INR INR INR INR INR INR
Revenues
United States - - 285,290.9 397,055.3 1,035,091.2 900,525.4
China 30,158.7 - 72,346.8 129,373.3 122,287.2 212,018.1
Netherlands - - 20,726.6 21,126.1 67,164.0 113,161.7
Norway 26,057.1 - 22,790.4 52,528.0 56,584.8 85,476.3
Other 52,938.3 - 74,259.3 150,435.5 212,558.4 438,056.9
Americas 93,029.9 - - - - -
Total Revenues 202,184.1 - 475,414.0 750,518.2 1,493,685.6 1,749,238.4

Assets
United States - - 774,200.1 994,902.8 1,165,173.6 1,113,397.6
International 9,089.8 18,796.9 34,181.2 50,232.4 59,856.0 63,342.1
Americas 155,017.0 206,571.8 - - - -
Total Assets 164,106.8 225,368.8 808,381.3 1,045,135.1 1,225,029.6 1,176,739.7

Filing Date Mar-01-2017 Feb-23-2018 Feb-19-2019 Feb-13-2020 Feb-13-2020 Feb-13-2020

Currency INR INR INR INR INR INR


Exchange Rate 63.215 66.22 67.915 63.825 69.6 71.1709
Conversion Method H H H H H H

You might also like