dition to a number of other internal and external factors. utline and Tasks: 1. For the purpose if this project students will obtain a set of public financial statements. Amazon, Walt Disney and many other companies make their information public. 2. Students will then compute ratios found in Chapter 13 of the text. For full credit students must compute three (3) liquidity, three (3) profitability, and three (3) solvency ratios. The ratios must be for two consecutive fiscal/calendar years. Use Excel with formulas to show your work. These will be your strengths and weaknesses (Internal areas of improvement). 3. Students will then write a memo describing their findings and what they mean. This should be one (1) page single spaced. 4. A grading rubric is in a separate file. D72 x fe 17631522 E F G H December 31 2017 S A 1 Tesla Inc 2 Consolidated Balance Sheets 3 (in thousands, except per share data) 4 5 December 31, 6 2018 7 Assets 8 Current assets 9 Cash and cash egus 3,685,618 10 Restricted cash 192,551 11 Accounts receivable, net 949,022 12 Inventory 3,113,446 13 Prepaid expenses and othe 365,671 14 Total current assets 8,306,308 15 Operating lease vehicles, 2,089,758 16. Solar energy systems, lease 6,271,396 17 Property, plant and equipmi 11,330,077 18. Intangible assets, net 282492 19. Goodwill 68,159 20 MyPower customer notes re 421,548 21 Restricted cash, net of curre 398,219 22 Other assets 571,657 25 Total assets S 29,739,614 24 Liabilities 25 Current liabilities 26 Accounts payable S 3,404 451 27 Accrued liabilities and othe 2,094253 28 Deferred revenue 630 292 29 Resale value guarantees 502.840 30 Customer deposits 792,601 31 Current portion of long 2.567,699 32 Current portion of promisso - 33 Total current abilities 9992136 54. Long term debt and capital 9,405,672 On: Sheet1 3,367,914 155,323 515,381 2,263,537 268,365 6,570,520 4,116,604 6,347,490 10,027,522 351,502 60,237 456,652 441,722 279,123 28,655,872 S 5 2,390,250 1.791,366 1,015, 255 782,333 353919 796.549 100 000 7.674,670 9,418 319 DE File Home Insert Page Layout Formulas Data Review View Help E42 X fr A B D E F G H 24 Liabilities 25. Current liabilities 26 Accounts payable S 3,404,451 S 2,390,250 27 Accrued liabilities and othe 2,094,253 1,731,366 28 Deferred revenue 630,292 1,015,253 29 Resale value guarantees 502,840 787,333 30 Customer deposits 792,601 853,919 31 Current portion of long-term 2,567,699 796,549 32 Current portion of promisso - 100,000 33. Total current liabilities 9,992,136 7,674,670 34 Long-term debt and capital 9,403,672 9,418,319 35 Deferred revenue, net of cul 990,873 1,177,799 36 Resale value guarantees, n 328,926 2,309,222 37 Other long-term liabilities 2,710,403 2,442,970 38 Total liabilities 23,426,010 23,022,980 39 Commitments and contingencies (Note 17) 40 Redeemable noncontrolling 555,964 397,734 41 Convertible senior notes (N 70 42 Equity 43 Stockholders' equity 44 Preferred stock: 50.001 par v- 45 no shares issued and outstanding 46 Common stock: $0.001 par ve 173 169 47 168,797 shares issued and outstanding as of December 31, 2018 and 2017 48 respectively 49. Additional paid in capital 10,249,120 9,178,024 50 Accumulated other compreh 18,218 33,348 51 Accumulated deficit 15,317,832 (4.974,299 2 52 Total stockholders' equity 4,925,243 4,237,242 53 Noncontrolling interests in 834,397 997,346 54 Total abilities als 29,739.614 $ 28.655,372 55 56 The accompanying notes are an integral part of these consolidated financial statements 50 Sheet1 Ready OP ( IN Bookl - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do E42 G M N 2017 2015 5 5 8.534.252 1106,548 9,641,300 1.116.266 1,001185 11,758,751 5,589,007 761,759 6.350.766 181394 467.972 7,000 132 B C D A Tesla, Inc 65 66 Consolidated Statements of Operations 67 in thousands, except per share data) 68 60 Year Ended December 31, TO 2018 71 Revenues 72. Automotive sales 5 17 631,522 73 Automotive leasing 883 461 74 Total automotive revenues 18,514,983 35 Enerty generation and stort 1.555,244 76 Services and other 1,391,043 77 Total revenues 21461,268 18 Cost of revenues 19 Automotive Sales 13.585,572 30 Automotive leasing 488425 81 Toral automotive cost of rey 14,173,937 82 Energy generation and store 1,354,895 83. Services and other 1880,354 34 Total cost of revenues 17419,247 05 Gross profit 4,042,021 36. Operating expenses 07 Research and development 1,450,370 Selling toneral and admin 2.854401 1 Restructuring and other 135,235 90 Total operating expenses 4450098 BL Los from operations 1388071 1 Interest income 24333 91 best expense 1563,071 er income (ESEL 21.166 95 Loss before comes 1.004745 35 Botion for income to S. utious 22062.53 Shoti 6,724 480 708,224 7,432,704 374,53 1,229,022 5.536.24 2222.47 4.268.07 31.994 4,750.081 178,832 472,462 5,400.875 1599 257 85440 1.378073 2/476 500 3.854.575 116320 19654 147125 1125,375 20032 9154 2265.597 567340 8,550 1910 JI1272 356 177.00 1 Book1 - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do E42 M N 26,698 (273,046 198,132 1 s 1674,914 D F G H 96 Provision for income taxes 57,837 31.545 97 Net loss 11,062,582 > (2.240,578 98 Net loss attributable to bor (6,491 (279,178 99 redeemable no controlling interests in subsidiaries 100 Net loss attributas 1976 091 5 (1961400) 101 Netloss per share of common stock attributable 102 to common stockholders 103 Basic 15.72 $ 11133 104 Diluted 5 (5.72 1 5 111.83 105 Weled average shares used in computing net loss 106 per share of common stock 10 Basic 170525 165.258 100 Outed 170525 165.758 ton 110 The accompanying notes are an integral part of these consolidated financial statements 112 5 5 (4.68 14.68 144212 144,212 114 75 115 116 112 110 Tesia, Inc 119 Consolled States of Compechoss 100 in that 2012 1,000 2016 3 1012054 Year Ended December 2011 174 DS 75.091 125 Une con deliver 126 Chanced 127 Location dus- Une non nument 42.568 4.70 15.57 1684 1 500 Show po Book1 - Excel Fide Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do E42 f G H M B D 114 73 115 116 117 118 Tesla, Inc 119 Consolidated Statements of Comprehensive Loss 120 in thousands 123 122 Year Ended December 31 13 2018 124 Net loss attributats 1976,091 125 Unrealized gains losses, on derivatives 126 Change in net unrealized - 127 Less: Reclassification adus- 128 Neruntealted loss or der 129 Foreign currency translation 41,566 130 Other comprehensive loss 41.566 151 Comprehensive los 11,017.657 s 2017 (1961,400 5 2016 (674,914 3 15570 15.520 62.658 57088 11.904312 43,220 14904 (1,684 (18,500 120,184 1695,099 134 135 356 137 130 139 140 12 144 13 Sheet