Create a common-size balance sheet for Tesla and use the difference (2017-2016) to comment on the...

Create a common-size balance sheet for Tesla and use the difference (2017-2016) to comment on the following items
Items	Your comments
1. Cash and Cash equivalents
2. Property and equiment, net
3. Total current liabilites
4. Long-term debt
5. Total stockholders' equity

Tesla Inc (NMS: TSLA)

Exchange rate used is that of the Year End reported date


As Reported Annual Balance Sheet
Report Date	12/31/2017	12/31/2016	12/31/2017	12/31/2016	Difference (2017-2016)
Currency	USD	USD
Audit Status	Not Qualified	Not Qualified
Consolidated	Yes	Yes
Scale	Thousands	Thousands	%	%
Cash & cash equivalents	3367914	3393216
Restricted cash & marketable securities	155323	105519
Restricted cash	-	-
Accounts receivable	515381	499142
Raw materials	821396	680339
Work in process	243181	233746
Finished goods	1013909	1016731
Service parts	185051	136638
Inventory	2263537	2067454
Prepaid expenses & other current assets	268365	194465
Total current assets	6570520	6259796
Operating lease vehicles, net	4116604	3134080
Solar energy systems, leased & to be leased, net	6347490	5919880
Building & building improvements	-	-
Land	-	-
Machinery, equipment & office furniture	4251711	2154367
Tooling	1255952	794793
Leasehold improvements	789751	505295
Land & buildings	2517247	1079452
Computer equipment & software	395067	275655
Construction in progress	2541588	2147332
Other property, plant & equipment	-	23548
Property & equipment, gross	11751316	6980442
Less: accumulated depreciation & amortization	1723794	997485
Property & equipment, net	10027522	5982957
Intangible assets, net	361502	376145
Goodwill	60237	-
MyPower customer notes receivable, net of current portion	456652	506302
Restricted cash, net of current portion	441722	268165
Emission credits	-	-
Debt issuance costs, net	-	-
Other assets	-	-
Other assets	-	-
Other assets	273123	216751
Total assets	28655372	22664076
Accounts payable	2390250	1860341
Accrued warranty, current portion	-	-
Build to suit finance obligation, current portion	-	-
Accrued interest	-	-
Environmental liabilities, current portion	-	-
Other accrued expenses	-	-
Accrued purchases	753408	585019
Payroll & related costs	378284	218792
Taxes payable	185807	152897
Financing obligation, current portion	67313	52031
Accrued warranty	125502	-
Other current liabilities	221052	-
Accrued warranty & other	-	201289
Accrued liabilities & other current liabilities	1731366	1210028
Accrued liabilities	-	-
Deferred revenue	1015253	763126
Resale value guarantee	787333	179504
Capital lease obligations, current portion	-	-
Customer deposits	853919	663859
Convertible debt, current portion	-	-
Current portion of long-term debt & capital leases	796549	984211
Current portion of solar bonds issued to related parties	100000	165936
Total current liabilities	7674670	5827005
Long-term debt & capital leases, net of current portion	9415700	5860049
Solar bonds issued to related parties, net of current portion	100	99164
Convertible senior notes issued to related parties	2519	10287
Deferred revenue, net of current portion	1177799	851790
Resale value guarantees, net of current portion	2309222	2210423
Capital lease obligations, less current portion	-	-
Convertible debt, less current portion	-	-
Deferred tax liabilities	-	-
Environmental liabilities, less current portion	-	-
Accrued warranty reserve, net of current portion	276289	149858
Build-to-suit lease liability, net of current portion	1665768	1323293
Deferred rent expense	46820	36966
Financing obligation, net of current portion	67929	84360
Liability for receipts from an investor	29713	76828
Other noncurrent liabilities	356451	220144
Other long-term liabilities	2442970	1891449
Other long-term liabilities	-	-
Total liabilities	23022980	16750167
Redeemable noncontrolling interests in subsidiaries	397734	367039
Convertible senior notes	70	8784
Common stock	169	161
Additional paid-in capital	9178024	7773727
Accumulated other comprehensive income (loss)	33348	-23740
Retained earnings (accumulated deficit)	-4974299	-2997237
Total stockholders' equity (deficit)	4237242	4752911
Non-controlling interests	997346	785175

Expert Solution

In common size balance sheet, we will express each and every item of balance sheet as a % of total assets

	12/31/2017	12/31/2016	12/31/2017	12/31/2016	Difference (2017-2016)
Cash & cash equivalents	3367914	3393216	11.75%	14.97%	-3.22%
Restricted cash & marketable securities	155323	105519	0.54%	0.47%	0.08%
Restricted cash	-	-
Accounts receivable	515381	499142	1.80%	2.20%	-0.40%
Raw materials	821396	680339	2.87%	3.00%	-0.14%
Work in process	243181	233746	0.85%	1.03%	-0.18%
Finished goods	1013909	1016731	3.54%	4.49%	-0.95%
Service parts	185051	136638	0.65%	0.60%	0.04%
Inventory	2263537	2067454	7.90%	9.12%	-1.22%
Prepaid expenses & other current assets	268365	194465	0.94%	0.86%	0.08%
Total current assets	6570520	6259796	22.93%	27.62%	-4.69%
Operating lease vehicles, net	4116604	3134080	14.37%	13.83%	0.54%
Solar energy systems, leased & to be leased, net	6347490	5919880	22.15%	26.12%	-3.97%
Building & building improvements	-	-
Land	-	-
Machinery, equipment & office furniture	4251711	2154367	14.84%	9.51%	5.33%
Tooling	1255952	794793	4.38%	3.51%	0.88%
Leasehold improvements	789751	505295	2.76%	2.23%	0.53%
Land & buildings	2517247	1079452	8.78%	4.76%	4.02%
Computer equipment & software	395067	275655	1.38%	1.22%	0.16%
Construction in progress	2541588	2147332	8.87%	9.47%	-0.61%
Other property, plant & equipment	-	23548	0.00%	0.00%	0.00%
Property & equipment, gross	11751316	6980442	41.01%	30.80%	10.21%
Less: accumulated depreciation & amortization	1723794	997485	6.02%	4.40%	1.61%
Property & equipment, net	10027522	5982957	34.99%	26.40%	8.60%
Intangible assets, net	361502	376145	1.26%	1.66%	-0.40%
Goodwill	60237	-	0.21%	0.00%	0.21%
MyPower customer notes receivable, net of current portion	456652	506302	1.59%	2.23%	-0.64%
Restricted cash, net of current portion	441722	268165	1.54%	1.18%	0.36%
Emission credits	-	-
Debt issuance costs, net	-	-
Other assets	-	-
Other assets	-	-
Other assets	273123	216751	0.95%	0.96%	0.00%
Total assets	28655372	22664076	100%	100%	0.00%

Accounts payable	2390250	1860341	8.34%	8.21%	0.13%
Accrued warranty, current portion	-	-
Build to suit finance obligation, current portion	-	-
Accrued interest	-	-
Environmental liabilities, current portion	-	-
Other accrued expenses	-	-
Accrued purchases	753408	585019	2.63%	2.58%	0.05%
Payroll & related costs	378284	218792	1.32%	0.97%	0.35%
Taxes payable	185807	152897	0.65%	0.67%	-0.03%
Financing obligation, current portion	67313	52031	0.23%	0.23%	0.01%
Accrued warranty	125502	-	0.44%	0.00%	0.44%
Other current liabilities	221052	-	0.77%	0.00%	0.77%
Accrued warranty & other	-	201289	0.00%	0.00%	0.00%
Accrued liabilities & other current liabilities	1731366	1210028	6.04%	5.34%	0.70%
Accrued liabilities	-	-
Deferred revenue	1015253	763126	3.54%	3.37%	0.18%
Resale value guarantee	787333	179504	2.75%	0.79%	1.96%
Capital lease obligations, current portion	-	-
Customer deposits	853919	663859	2.98%	2.93%	0.05%
Convertible debt, current portion	-	-
Current portion of long-term debt & capital leases	796549	984211	2.78%	4.34%	-1.56%
Current portion of solar bonds issued to related parties	100000	165936	0.35%	0.73%	-0.38%
Total current liabilities	7674670	5827005	26.78%	25.71%	1.07%
Long-term debt & capital leases, net of current portion	9415700	5860049	32.86%	25.86%	7.00%
Solar bonds issued to related parties, net of current portion	100	99164	0.00%	0.44%	-0.44%
Convertible senior notes issued to related parties	2519	10287	0.01%	0.05%	-0.04%
Deferred revenue, net of current portion	1177799	851790	4.11%	3.76%	0.35%
Resale value guarantees, net of current portion	2309222	2210423	8.06%	9.75%	-1.69%
Capital lease obligations, less current portion	-	-	0.00%	0.00%	0.00%
Convertible debt, less current portion	-	-	0.00%	0.00%	0.00%
Deferred tax liabilities	-	-	0.00%	0.00%	0.00%
Environmental liabilities, less current portion	-	-	0.00%	0.00%	0.00%
Accrued warranty reserve, net of current portion	276289	149858	0.96%	0.66%	0.30%
Build-to-suit lease liability, net of current portion	1665768	1323293	5.81%	5.84%	-0.03%
Deferred rent expense	46820	36966	0.16%	0.16%	0.00%
Financing obligation, net of current portion	67929	84360	0.24%	0.37%	-0.14%
Liability for receipts from an investor	29713	76828	0.10%	0.34%	-0.24%
Other noncurrent liabilities	356451	220144	1.24%	0.97%	0.27%
Other long-term liabilities	2442970	1891449	8.53%	8.35%	0.18%
Other long-term liabilities	-	-	0.00%	0.00%	0.00%
Total liabilities	23022980	16750167	80.34%	73.91%	6.44%
Redeemable noncontrolling interests in subsidiaries	397734	367039	1.39%	1.62%	-0.23%
Convertible senior notes	70	8784	0.00%	0.04%	-0.04%
Common stock	169	161	0.00%	0.00%	0.00%
Additional paid-in capital	9178024	7773727	32.03%	34.30%	-2.27%
Accumulated other comprehensive income (loss)	33348	-23740	0.12%	-0.10%	0.22%
Retained earnings (accumulated deficit)	-4974299	-2997237	-17.36%	-13.22%	-4.13%
Total stockholders' equity (deficit)	4237242	4752911	14.79%	20.97%	-6.18%
Non-controlling interests	997346	785175	3.48%	3.46%	0.02%

	12/31/2017	12/31/2016	Difference (2017-2016)
Cash & cash equivalents	11.75%	14.97%	-3.22%
Property & equipment, net	34.99%	26.40%	8.60%
Total current liabilities	26.78%	25.71%	1.07%
Total liabilities	80.34%	73.91%	6.44%
Total stockholders' equity (deficit)	14.79%	20.97%	-6.18%

1. Cash and cash equivalence has reduced by 3.22%
2. Property,Plant and equipment increased ny 8.60%
3.Total current liabilities increased by 1.07%
4. Long term debt (Total liabilities) increased by 6.44%
5. Total stockholder's equity decreased by 6.18%

ekkarill92 answered 3 years ago

Question 2: Create a common-size income statement and use the difference (2017-2016) to comment on the...

Question 2: Create a common-size income statement and use the difference (2017-2016) to comment on the following items (10 points) Items Comments 1. Automotive revenue Write your comments here 2. Income (loss) before income taxes 3. Interest expense 4. Net Income (loss) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date 12/31/2017 12/31/2016 12/31/2017 12/31/2016 Currency USD USD Audit Status Not Qualified Not Qualified Consolidated Yes Yes Scale Thousands Thousands %...

To create a common size balance sheet all items on the balance sheet by ....

To create a common size balance sheet ____________ all items on the balance sheet by ____________. 1. multiply; owners equity 2. multiply; total assets 3. divide; owners equity 4. divide; total assets 5. multiply; debt

(Analyzing common-size financial statements) Use the common-size financial statements found here: Common-Size Balance Sheet 2016 Cash...

(Analyzing common-size financial statements) Use the common-size financial statements found here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 500 1.5 % Accounts receivable 6,000 18.2 Inventory 9,450 28.7 Total current assets $ 15,950 48.4 % Net property, plant, and equipment 16,980 51.6 Total assets $ 32,930 100.0 % Accounts payable $ 7,240 22.0 % Short-term notes 6,750 20.5 Total current liabilities $ 13,990 42.5 % Long-term liabilities 6,990 21.2 Total liabilities $ 20,980 63.7 % Total common shareholders’...

Use the common-size financial statements found here: Common-Size Balance Sheet 2016 Cash and marketable securities $...

Use the common-size financial statements found here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 470 1.4 % Accounts receivable 5,990 18.2 Inventory 9,450 28.7 Total current assets $ 15,910 48.4 % Net property, plant, and equipment 16,990 51.6 Total assets $ 32,900 100.0 % Accounts payable $ 7,150 21.7 % Short-term notes 6,790 20.6 Total current liabilities $ 13,940 42.4 % Long-term liabilities 7,040 21.4 Total liabilities $ 20,980 63.8 % Total common shareholders’ equity 11,920 36.2 Total...

Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the...

Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the base year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to 2 decimal places (e.g., 32.16) and common-base-year answers to 4 decimal places (e.g., 32.1616).) JARROW CORPORATION 2013 Common-size 2014 Common-size Common-base year Assets Current assets Cash $8,964 % $10,904 % Accounts receivable 22,353 % 24,837 % Inventory 38,722 % 43,697 % Total $70,039 % $79,438...

Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year...

Perform a horizontal, common-size analysis of the balance sheet items, using 2017 as the base year (meaning each line item for 2017 is 100%). Also include a horizontal analysis of sales and net income. Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets: Current assets $ 1,700 $1,120 $1,544 Plant and equipment (net) 8,110 7,830 5,404 Other assets 1,004 695 772 Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity: Current liabilities $ 950 $ 880 $ 772 Long-term liabilities...

Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...

Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014. (Round your answers to one decimal place.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts...

Balance Sheet Calculations Dawson Company's balance sheet information at the end of 2016 and 2017 is...

Balance Sheet Calculations Dawson Company's balance sheet information at the end of 2016 and 2017 is as follows: 2016 2017 Current assets $ (a) $25,000 Long-term liabilities (b) 34,900 Total contributed capital (c) (g) Long-term investments 19,200 (h) Retained earnings 51,300 61,100 Total liabilities (d) (i) Intangible assets 10,400 9,000 Current liabilities 14,500 12,000 Common stock, $5 par (e) 20,000 Total assets 142,800 (j) Additional paid-in capital 15,000 (k) Property, plant, and equipment (net) 85,700 92,800 Accumulated other comprehensive income...

A common size balance sheet expresses the balance sheet items as a percentage of total assets....

A common size balance sheet expresses the balance sheet items as a percentage of total assets. Select one: True False

Solve the following problems: Using the balance sheet below: create a balance sheet for 2016 and...

Solve the following problems: Using the balance sheet below: create a balance sheet for 2016 and 2017. make a list of working capital accounts. what is the net working capital for 2016 and 2017? What is the change in net working capital for 2017? Balance Sheet Accounts of SimpleTec Corporation Account Balance 12/31/2013 Balance 12/31/2014 Accumulated Depreciation $2,030 $2,680 Accounts Payable $1,810 $2,070 Accounts Receivable $2,490 $2,700 Cash $1,310 $1,100 Common Stock $5,000 $5,000 Inventory $5,810 $6,040 Long-Term Debt $7,810...

Question