|
Tesla Inc. |
|||||||
|
Consolidated Balance Sheets |
|||||||
|
(in thousands, except per share data) |
31 Dec '17 |
31 Dec '16 |
31 Dec '15 |
31 Dec '14 |
31 Dec '13 |
31 Dec '12 |
31 Dec '11 |
|
Total assets |
28,655 |
22,664 |
8,068 |
5,831 |
2,417 |
1,114 |
713 |
|
Total current assets |
6,571 |
6,260 |
2,782 |
3,180 |
1,266 |
525 |
373 |
|
Cash and cash equivalents |
3,368 |
3,393 |
1,197 |
1,906 |
846 |
202 |
255 |
|
Short-term marketable securities |
-- |
-- |
-- |
-- |
-- |
-- |
25 |
|
Restricted cash and marketable securities |
155 |
106 |
23 |
18 |
3 |
19 |
23 |
|
Accounts receivable |
515 |
499 |
169 |
227 |
49 |
27 |
10 |
|
Inventory |
2,264 |
2,067 |
1,278 |
954 |
340 |
269 |
50 |
|
Prepaid expenses and other current assets |
268 |
194 |
116 |
76 |
28 |
8 |
9 |
|
Operating lease vehicles, net |
4,117 |
3,134 |
1,791 |
767 |
382 |
10 |
12 |
|
Solar energy systems, leased and to be leased, net |
6,347 |
5,920 |
0 |
-- |
-- |
-- |
-- |
|
Property, plant and equipment, net |
10,028 |
5,983 |
3,403 |
1,829 |
738 |
552 |
298 |
|
Intangible assets, net |
422 |
376 |
13 |
-- |
-- |
-- |
-- |
|
Intangible assets, net excluding goodwill |
362 |
||||||
|
Goodwill |
60 |
||||||
|
MyPower customer notes receivable, net of current portion |
457 |
506 |
0 |
-- |
-- |
-- |
-- |
|
Restricted cash |
442 |
268 |
32 |
11 |
6 |
5 |
8 |
|
Other assets, net |
273 |
217 |
47 |
43 |
24 |
22 |
22 |
|
Total liabilities and stockholders equity |
28,655 |
22,664 |
8,068 |
5,831 |
2,417 |
1,114 |
713 |
|
Total liabilities |
23,023 |
16,750 |
6,937 |
4,861 |
1,750 |
989 |
489 |
|
Total current liabilities |
7,675 |
5,827 |
2,811 |
2,107 |
675 |
539 |
191 |
|
Accounts payable and accrued liabilities |
4,122 |
3,070 |
1,339 |
1,047 |
412 |
343 |
88 |
|
Accounts payable |
2,390 |
1,860 |
916 |
778 |
304 |
303 |
56 |
|
Accrued liabilities |
1,731 |
1,210 |
423 |
269 |
108 |
40 |
32 |
|
Deferred revenue |
1,015 |
763 |
424 |
192 |
92 |
2 |
2 |
|
Capital lease obligations |
-- |
-- |
-- |
8 |
4 |
1 |
|
|
Resale value guarantees |
797 |
180 |
137 |
0 |
-- |
-- |
-- |
|
Customer deposits |
854 |
664 |
283 |
258 |
163 |
139 |
92 |
|
Convertible senior notes and other debt |
-- |
-- |
-- |
0 |
0 |
-- |
|
|
Current portion of long-term debt and capital leases |
897 |
1,150 |
628 |
611 |
-- |
51 |
8 |
|
Current portion of long-term debt and capital leases excluding current portion of solar bonds issued to related parties |
797 |
984 |
628 |
611 |
-- |
51 |
8 |
|
Current portion of solar bonds issued to related parties |
100 |
166 |
0 |
-- |
-- |
-- |
-- |
|
Long-term debt and capital leases |
9,418 |
5,970 |
2,021 |
1,819 |
586 |
401 |
268 |
|
Long-term debt and capital leases, net of current portion |
9,416 |
5,860 |
2,021 |
-- |
-- |
401 |
-- |
|
Convertible senior notes and other debt |
3 |
10 |
0 |
-- |
586 |
0 |
-- |
|
Solar bonds issued to related parties, net of current portion |
0 |
99 |
0 |
-- |
-- |
-- |
-- |
|
Common stock warrant liability |
-- |
-- |
-- |
-- |
11 |
9 |
|
|
Capital lease obligations - non current |
-- |
-- |
-- |
-- |
13 |
10 |
3 |
|
Deferred revenue - non current |
1,178 |
852 |
446 |
292 |
181 |
3 |
3 |
|
Capital lease obligations |
|||||||
|
Other long-term liabilities |
4,752 |
4,102 |
1,659 |
643 |
294 |
25 |
15 |
|
Resale value guarantees |
2,309 |
2,210 |
1,294 |
488 |
236 |
0 |
-- |
|
Other long-term liabilities excluding resale value guarantees |
2,443 |
1,891 |
365 |
155 |
58 |
25 |
15 |
|
Redeemable noncontrolling interests in subsidiaries |
398 |
367 |
0 |
-- |
-- |
-- |
-- |
|
Convertible senior notes |
0 |
9 |
47 |
58 |
0 |
-- |
-- |
|
Total stockholders equity |
4.237 |
4,753 |
1,084 |
912 |
667 |
125 |
224 |
|
Preferred stock |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Common stock |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Additional paid-in capital |
9,178 |
7,774 |
3,409 |
2,345 |
1,807 |
1,190 |
893 |
|
Accumulated deficit |
-4,941 |
-3,021 |
-2,326 |
-1,434 |
-1,140 |
-1,066 |
-669 |
|
Accumulated other comprehensive loss |
33 |
-24 |
-4 |
-0 |
-- |
-- |
-0 |
|
Accumulated deficit excluding accumulated other comprehensive loss |
-4,977 |
-2,997 |
-2,322 |
-1,434 |
-- |
-- |
-669 |
|
Noncontrolling interests in subsidiaries |
997 |
785 |
0 |
-- |
-- |
-- |
-- |
|
Tesla, Inc. |
|||||||||
|
Consolidated Statements of Operations |
|||||||||
|
(in thousands, except per share data) |
31 Dec ‘17 |
31 Dec '16 |
31 Dec '15 |
31 Dec '14 |
31 Dec '13 |
31 Dec '12 |
31 Dec '11 |
31 Dec '10 |
|
|
Total revenues |
11,759 |
7,000 |
4,046 |
3,198 |
2,014 |
413 |
204 |
117 |
|
|
Total automotive revenue |
9,641 |
6,351 |
3,741 |
3,007 |
1,922 |
386 |
149 |
97 |
|
|
Automotive |
9,641 |
6,351 |
3,741 |
3,007 |
1,922 |
386 |
149 |
97 |
|
|
Automotive excluding automotive leasing |
8,535 |
5,589 |
3,432 |
2,874 |
-- |
-- |
-- |
-- |
|
|
Automotive leasing |
1,107 |
762 |
309 |
133 |
-- |
-- |
-- |
-- |
|
|
Services and other |
2,117 |
649 |
305 |
191 |
92 |
28 |
56 |
20 |
|
|
Energy generation and storage |
1,116 |
181 |
14 |
4 |
-- |
-- |
-- |
-- |
|
|
Services and other excluding energy generation and other |
1,001 |
468 |
291 |
187 |
-- |
-- |
-- |
-- |
|
|
Total cost of revenues |
-9,536 |
-5,401 |
-3,123 |
-2,317 |
-1,557 |
-383 |
-143 |
-86 |
|
|
Total automotive cost of revenues |
-7,433 |
-4,750 |
-2,823 |
-2,146 |
-1,483 |
-372 |
-115 |
-80 |
|
|
Automotive |
-7,433 |
-4,750 |
-2,823 |
-2,146 |
-1,483 |
-372 |
-115 |
-80 |
|
|
Automotive excluding automotive leasing |
-6,724 |
-4,268 |
-2,640 |
-2,058 |
-- |
-- |
-- |
-- |
|
|
Automotive leasing |
-708 |
-482 |
-183 |
-87 |
-- |
-- |
-- |
-- |
|
|
Services and other |
-2,104 |
-651 |
-299 |
-171 |
-74 |
-12 |
-27 |
-6 |
|
|
Energy generation and storage |
-875 |
-178 |
-12 |
-4 |
-- |
-- |
-- |
-- |
|
|
Services and other excluding energy generation and storage |
-1,229 |
-472 |
-287 |
-167 |
-- |
-- |
-- |
-- |
|
|
Gross profit |
2,222 |
1,599 |
924 |
882 |
456 |
30 |
62 |
31 |
|
|
Total operating expenses |
-3,855 |
-2,267 |
-1,640 |
-1,068 |
-518 |
-424 |
-313 |
-178 |
|
|
Research and development |
-1,378 |
-834 |
-718 |
-465 |
-232 |
-274 |
-209 |
-93 |
|
|
Selling, general and administrative |
-2,477 |
-1,432 |
-922 |
-604 |
-286 |
-150 |
-104 |
-85 |
|
|
Loss from operations |
-1,632 |
-667 |
-717 |
-187 |
-61 |
-394 |
-251 |
-147 |
|
|
Interest income |
20 |
9 |
2 |
1 |
0 |
0 |
0 |
0 |
|
|
Interest expense |
-471 |
-199 |
-119 |
-101 |
-33 |
-0 |
-0 |
-1 |
|
|
Other income / expense, net |
-125 |
111 |
-42 |
2 |
23 |
-2 |
-3 |
-7 |
|
|
Loss / income before income taxes |
-2,209 |
-746 |
-876 |
-285 |
-71 |
-396 |
-254 |
-154 |
|
|
Provision for income taxes |
-32 |
-27 |
-13 |
-9 |
-3 |
-0 |
-0 |
-0 |
|
|
Net loss / income |
-2,241 |
-773 |
-889 |
-294 |
-74 |
-396 |
-254 |
-154 |
|
|
Net income / loss attributable to noncontrolling interests and redeemable noncontrolling interest |
279 |
98 |
0 |
0 |
-- |
-- |
-- |
-- |
|
|
Net income / loss attributable to common stockholders |
-1,961 |
-675 |
-889 |
-294 |
-74 |
-396 |
-254 |
-154 |
|
|
Per share |
|||||||||
|
Basic |
-11.83 |
-4.68 |
-6.93 |
-2.36 |
-0.62 |
-3.69 |
-2.53 |
-3.04 |
|
|
Diluted |
-11.83 |
-4.68 |
-6.93 |
-2.36 |
-0.62 |
-3.69 |
-2.53 |
-3.04 |
|
|
Weighted average shares |
|||||||||
|
Basic |
165.8 |
144.2 |
128.2 |
124.5 |
119.4 |
107.3 |
100.4 |
50.7 |
|
|
Diluted |
165.8 |
144.2 |
128.2 |
124.5 |
119.4 |
107.3 |
100.4 |
50.7 |
|
Income statement:
Did Sales of Tesla increase (decrease) in the last 3 years of operations? Provide specific amounts and percentage.
Did Net Income of Tesla increase (decrease) in the last 3 years of operations? Provide specific amounts and percentage.
In your opinion, what business activities were responsible for sales growth (decline)?
Do income statements of your company have Cost of Goods Sold? (Hint: Often companies use different terminology when they report COGS, for example Cost of Revenues).
What percentage of Sales does COGS constitute?
Did this percentage increase (decrease) in the last three years of the operations?
Why do you think this happen?
List three other major expenses (after COGS) of the company.
What percentage of sales do they constitute?
Did these percentage increase (decrease) in the last three years of operations?
In your opinion, what business activities were responsible for observed dynamics?
Do you think this was beneficial (detrimental) for your business?
In: Accounting
The typical supermarket has 30,000 different products on sale at any given time. The manager of that supermarket must determine not only what mix of products to have on hand but where to locate those products and what price to set on each one at any specific time. Usually, the price is based on a markup on the cost of the item, and the only reason the price is altered is that costs change. When you reserve a hotel room, you find that there are several different prices offered for that same room, depending on whether you work for the government, are a member of AARP or some other organization, are staying more than one night, and so on. Why doesn’t the hotel just offer a single price? These examples illustrate just a few of the many problems confronting businesses in their relations with customers. Companies do not seem to know much about their customers. For instance, companies often base prices on the anecdotal evidence of a few vocal salespeople or product managers. Even Mercedes-Benz, when it was about to launch one of its A-class models in the German market, initially proposed a price tag of DM29,500, based on little more than the belief that DM30,000 was a psychologically important barrier. Consultants point out that price has a disproportionate effect on the bottom line, far more than greater volume or cuts in fixed and variable costs. Assuming that volumes stay constant, a 1 percent price increase produces between an 8 percent and 11 percent improvement in operating profits.
So does this mean that most businesses should raise their prices? Explain your answer.
Are these businesses leaving money on the table—that is, not generating the greatest revenue they could by knowing the customer better?” Explain your answer.
In: Economics
Consider the results from a completely randomized design showing commuting times in three states. Use an appropriate Excel ANOVA tool, to test for any significant differences in commuting times between the three states. Use α = 0.05.
| Illinois | Ohio | Texas |
| 26.8 | 27.5 | 10.1 |
| 17.6 | 28.9 | 18.8 |
| 27 | 19.1 | 31.4 |
| 20 | 36.9 | 44.2 |
| 50.7 | 40.8 | 24.6 |
| 24.4 | 9.5 | 29.5 |
| 36.8 | 37.4 | 38.1 |
| 42.2 | 38.9 | 30.3 |
| 26.3 | 46.2 | 11.7 |
| 14 | 35.8 | 35.8 |
| 28.5 | 20.7 | 22.4 |
| 36.9 | 37.8 | 17 |
| 25.6 | 49.7 | 15.4 |
| 25.9 | 44.3 | 15.4 |
| 29.5 | 12.1 | 6.8 |
| 29.7 | 43.7 | 14.8 |
| 30.5 | 35.9 | 59.3 |
| 20 | 30.2 | 5.3 |
| 23.2 | 8.5 | 0.6 |
| 20.7 | 34.6 | 20.7 |
| 6.2 | 37.9 | 18.6 |
| 44.2 | 50.9 | 24.9 |
| 28.2 | 24.2 | 9.3 |
| 28.8 | 39.1 | 11.9 |
| 16.6 | 20.4 | 19.6 |
| 20.2 | 12.4 | 31 |
| 13.1 | 28 | 25.9 |
| 16.9 | 28.4 | 52.6 |
| 32.4 | 19.4 | 38.3 |
| 19.6 | 42.5 | 34 |
| 12.8 | 27.2 | 24.9 |
| 30.2 | 22.6 | 32.1 |
| 65.1 | 50.8 | 43 |
| 25.5 | 34.1 | 31.1 |
| 17.5 | 27.1 | 16.8 |
| 11.1 | 38.9 | 34.1 |
| 48.8 | 28.7 | 40.4 |
| 38.9 | 54.2 | 29.4 |
| 23.1 | 30.6 | 9.8 |
| 21.6 | 15.9 | 19.5 |
| 22.3 | 15.1 | 9.6 |
| 27.3 | 30.1 | 21.6 |
| 30.7 | 32.2 | 26.5 |
In: Math
You obtain three samples from three different populations.
Observed genotype frequencies.
Population 1 AA=0.70 ; Aa=0.25 ; aa = 0.05
Population 2 AA=0.35 ; Aa=0.55 ; aa=0.10
Population 3 AA=0.45 ; Aa=0.40 ; aa=0.15
Populations 2 and 3 have no barrier between them. But populations 1 and 2, and populations 1 and 3 have a barrier between them.
What are the FST values between these three pairs of populations?
In: Biology
Horse Heaven Farm began 20X6 with cash of 180,000. During the year, Horse Heaven earned service revenue of 600,000 and collected 480,000 from customers. Expenses for the year totaled 330,000, with 300,000 paid in cash to suppliers and employees. Horse heaven also paid 138,000 to purchase equipment and a cash dividend of 47,000 to shareholders. During 20X6, Horse Heaven borrowed 25,000 by issuing a note payable. Prepare the company's statement of cash flows for the year. Format operating activities by the direct method. Calculate Horse's free cash flow and cash realization ratio.
In: Accounting
Lant Company has provided the following information:
• Cash sales totaled $290,000.
• Credit sales totaled $489,000.
• Cash collections from customers for services yet to be provided
totaled $89,000.
• A $25,000 loss from the sale of property and equipment
occurred.
• Interest income was $8,700.
• Interest expense was $18,900.
• Supplies expense was $390,000.
• Rent expense for the store was $39,000.
• Wages expense was $49,000.
• Other operating expenses totaled $79,000.
• Unearned revenue was $3,900.
What is the amount of Lant’s income before income taxes?
Multiple Choice
$275,800
$186,800
$389,000
$197,000
In: Accounting
A car manufacturer is offering the following incentive with any purchase of its new 2019 mid- size sedans at one of its affiliated dealerships. The vehicle sells for $24,000. Free maintenance services for 2 years at the dealership
Assume there are no other promotions running during this time. The car manufacturer estimates that the normal selling price for the maintenance services it will provide to customers, on average, over the two year period under this promotion is $1,000. Assuming the customer pays $24,000 for the vehicle, how much revenue is recognized on the sale date? You can ignore the time value of money.
In: Accounting
Wayne’s Workshop shows average revenue per customer of $400. Monthly fixed costs are $40,000. Variable costs in the last month were in total $32,000. During that month the workshop had 1,200 customers.
Required
1. Calculate the contribution margin ratio.
2. Calculate the breakeven point.
3. What was the profit last month?
4. Prepare an income statement for last month using the contribution format.
5. What was the operating leverage?
6. Using the operating leverage formula, calculate the new operating income if sales fall by 5%.
In: Accounting
QUESTION 1
KataranaSdnBhd operates a business in the wholesale distribution
of consumer products. You are one of the auditors attached to Vijay
Salleh& Associates who has been appointed to audit
KataranaSdnBhd's financial statements for the financial year ended
31 December 2018. Your team leader has assigned you to review the
company's sales system. Your observations are as follows:
Sales Department
The sales department directly receives orders from both regular
and new customers. For regular customers, Encik Faizal, who is the
sales department assistant processes the order and immediately
prepares the delivery order in four copies. The first copy is sent
to the customer, second copy to the store, third copy to the
accounts department and the fourth copy is retained in the sales
department's file. For new customers, the sales manager grants the
credit and processes the order after the approval by the higher
management.
Warehousing Department
EncikKhairil is the only storekeeper handling the stores department. On receipt of the delivery order from the sales department, he makes the necessary arrangement to deliver the goods to the customers. He prepares the delivery notes in quadruplicate with the customer's details, quantity, specification and rates of the goods delivered. Goods will be delivered to the customers either at the stores or at their site based on the terms in the delivery order. The original copy of the delivery note is given to the customer at the time of delivery. The second copy is given to accounts department, third copy is sent to the sales department and the fourth copy is kept in the store's file.
Accounts Department
The accounts department is headed by Puan Amirah and assisted by
a clerk, Encik Muthu and a cashier. On receipt of a copy of the
delivery order and delivery note, Encik Muthu raises the invoice
and forwards the original copy to the customer. The second copy is
sent to the sales departrnent while the third copy is retained in
his department's file. All cheques received by the company are
handed over to the cashier who will issue serially numbered
receipts and the cashier, then, deposits the cheques into the
bank.
Encik Muthu, who maintains the sundry debtors' ledger, posts the transactions and prepares monthly schedules of outstanding debtors. If the customer delays payment or made short payment, he will write to them. If the short payment is due to shortage in supply or poor quality of product, Encik Muthu will credit the customer's account with suitable rebate or allowances. Encik Muthu also prepares the bank reconciliation statement once in every three months.
Required:
Present your answers in the following format:
|
Internal control weaknesses |
Impact of the weaknesses |
In: Accounting
|
male |
1st Systolic |
1st Diastolic |
2nd Systolic |
2nd Diastolic |
|
1 |
132 |
74 |
132 |
82 |
|
2 |
108 |
70 |
108 |
74 |
|
3 |
124 |
78 |
134 |
78 |
|
4 |
116 |
42 |
116 |
48 |
|
5 |
118 |
76 |
116 |
70 |
|
6 |
128 |
80 |
128 |
80 |
|
7 |
132 |
90 |
130 |
92 |
|
8 |
106 |
64 |
110 |
64 |
|
female |
||||
|
1 |
168 |
46 |
156 |
52 |
|
2 |
198 |
82 |
192 |
84 |
|
3 |
110 |
74 |
110 |
76 |
|
4 |
170 |
94 |
168 |
100 |
|
5 |
142 |
58 |
140 |
52 |
|
6 |
168 |
52 |
172 |
54 |
|
7 |
90 |
32 |
82 |
0 |
For the above data, test the hypothesis that the first reading and the second reading each are greater than 115 mmHg, with an α of 0.05. (Here, combine men and women into one sample: you should have an N of 15) What test would be most appropriate and why? Is the result significant? State your conclusions.
In: Statistics and Probability