You have to do two tasks in this Assignment: Collect Data of a company (Tesla) and do Ratio Analysis. 1. Collect Data: Go to EDGAR https://www.sec.gov/edgar searched gar companysearch.html and put Tesla in the scarch box and click Search. You will see a list of names that contain Tesla. Click on "Tesla Inc". (LI) Put "10-K in the Filling type box and click Search. You will see a list of Annual report for all the years (i) Click on "Interactive of the Annual report of 2020 and then click View Excel Document. The report will be downloaded to your computer in Excel form with all data. 2. Do Ratio Analysis Using the data from Sheets "Consolidated Balance Sheets" and "Consolidated Statements of Operation" (.e. Income Statement) calculate the ratios in any THREE categories for Tesla for 2018 and 2019 (note that for 2018 you just need to copy the formula from 2019). After that, briefly comment on how Tesla compare to General Motors with regard to these 2 areas (i.e. better or worse compared to GM's). For questions, feel free to use the course's forum or email me. Category Ratio Formula Tesla 2019 Remarks 2013 Liquidity Ratios General Motor 2019 083 0.761 0.225 Long-term Solvency Ratio Profitability Current Ratio Quick Ratio Cash Ratio Debt Equity Ratio Long-term Debt Ratio Equity Multiplier Profit Margin ROA ROE Inventory Tumover Total Asset Turnover NR Tumover PE ratio Market-to-Book ratio CA/CL (CA-Inv)CL CashCL TL/TE LTD/LTD-TE) TATE NI Sales NITA NITE COGS/Iny Sales TA Credit Sales/AR Price EPS Price/BV of Equity 0679 5.184 0.049 0.029 0.143 10642 0.602 18.052 6.9 Asset Management Market Value * Note: You can download the original financial statements for publicly traded firms on https://www.sec.gov/edgar/searchedgar companysearch.html Once there, look up the financials for a company. Next to the 10-Q (quarterly) and 10-K (annual reports, you should notice a link that says "Interactive Data." Click on this link, follow the Financial Statements" link, and select View Excel Document. This link will allow you to download all of the financial statements in one Excel document. D E Dec 31, 2018 Dec 31, 2019 $3.686 $6,268 246 1,124 193 949 3,113 386 8.307 11,330 713 12.103 10,396 1218 339 198 393 269 808 34,309 68 398 572 Carate Balance Sheets - USD ($) $ In Mans 2 Ourense 3 Cash and cash equivalents 4 Restricted cash 5 Accounts receivable.net 6 Inventory 7 Prepaid expenses and other current assets 8 Total current assets 9 Property, plant and equipment, met 10 Operating lease-of-use assets 11 Intangible assets, et 12 Goodwill 13 My Power Customer notes receivable net of current portion 14 Restricted cash, net of current portion 15 Other assets 16 Talsts 17 Current Labs 18 Accounts payable 19 Accrued abilities and other 20 Deferred revenue 21 Resale value guarantees 22 Gustomer deposits 23 Current portion of debt and finance leases 24 Total current liabilities 25 Debt and finance leases, et of current portion 26 Deferred revenge of current portion 27 Resale value guarantee of current portion 28 Other long-term blinds 29 Totallibilis 30 Commitments and contingencies (Note 16) 31 Redeemale non controlling interests in subsidiaries 32 Stockholders' equity 33 Preferred stod: 50.001 par value: 100 shares authorised, no share issued and outstanding Common stock: 50.001 par value 2,000 shares authorized: 181 and 173 shares issued and outstanding as 34 of December 31, 2019 and 2018, respectively 35 Additional paid in capital 36 Accumulated other comprehensive loss 37 Accumulated deficit 38 Total stockholders' equity 39 Noncontrolling interests in subsidiaries 10 Totals and equity 41 Operating Lease Vehicles (Member 42 Current assets 13 Operating lease met 4 Solar Energy Systems Member 45 Current assets Solar energy systems, net Written Assignment 1 Sheet1 Sheet2 + Ready 3.771 2.905 1.163 317 726 1785 10,667 11,634 1.207 36 2,655 26.199 3405 2094 610 503 793 2.568 9,993 9,404 991 2,710 23,427 643 556 . 0 12.737 (36) 16,083) 6,618 849 34,309 10.249 18 15,318) 4,923 834 29,740 2.447 2.000 56,138 56,271 MacBook B D E 12 Months Ended Dec 31, 2018 Dec 31, 2019 Dec 31, 2017 $ 869 20,821 2,226 24,578 $ 863 18,515 1,391 21,461 $ 1,107 9,642 1,001 11,759 459 16,398 2,770 20,509 4,069 708 7433 1.229 14,174 1,880 17419 4,042 9,536 2,223 1,378 2477 1 Consolidated Statements of Operations - USD ($) shares in Milom, $in Millions 2 3 Reveres 4 Automotive leasing 5 Total automotive revenues 6 Services and other 7 Total revenues 8 Cost of revenues 9 Automotive leasing 10 Total automotive cost of revenues 11 Services and other 12 Total cost of revenues 13 Gross profit 14 Operating experies is Research and development 16 Seling general and administrative 17 Restructuring and other 18 Total operating expenses 19 Loss from operations 20 Interest income 21 Interest expense 22 Other income (expense), net 23 Loss before income taxes 24 Provision for income taxes 25 Net loss Net income (loss) attributable to noncontrolling interests and redeemable noncontrolling interests in 26 subsidiaries 27 Netloss attributable to common stockholders 28 Netloss per share of common stock attributable to common stockholders 29 Bask 30 Duted 31 Weighted average shares used in computing net loss per share of common stock 32 Bask 33 Diluted 34 Automotive Sales (Member) 35 Revenues 36 Revenues 37 Cost of revenues 3 Cost of revenues 39 Energy Generation and Storage Member 40 Revenues 41 Revenues AZ Cost of revenues 3 Cost of revenues 1,343 2,646 149 4,138 (69) 44 (685) 45 (665) 110 (775) 87 1,460 2,835 135 4,430 (388) 24 (663) 22 (1,005) 58 (1,063) (87) 3,855 (1,632) 19 (471) (125) (2,209) 32 (2,241) (279) $(862) $ 1976) S (1,962) $14.92) $14.92) $15.72) $15.72) S (1183) $(1183) 177 177 171 171 166 166 $ 19,952 $ 17,632 $ 8,535 15,939 13,686 6,725 1,531 1,555 1,116 51,341 $1,365 $ 874 14 16 You have to do two tasks in this Assignment: Collect Data of a company (Tesla) and do Ratio Analysis. 1. Collect Data: Go to EDGAR https://www.sec.gov/edgar searched gar companysearch.html and put Tesla in the scarch box and click Search. You will see a list of names that contain Tesla. Click on "Tesla Inc". (LI) Put "10-K in the Filling type box and click Search. You will see a list of Annual report for all the years (i) Click on "Interactive of the Annual report of 2020 and then click View Excel Document. The report will be downloaded to your computer in Excel form with all data. 2. Do Ratio Analysis Using the data from Sheets "Consolidated Balance Sheets" and "Consolidated Statements of Operation" (.e. Income Statement) calculate the ratios in any THREE categories for Tesla for 2018 and 2019 (note that for 2018 you just need to copy the formula from 2019). After that, briefly comment on how Tesla compare to General Motors with regard to these 2 areas (i.e. better or worse compared to GM's). For questions, feel free to use the course's forum or email me. Category Ratio Formula Tesla 2019 Remarks 2013 Liquidity Ratios General Motor 2019 083 0.761 0.225 Long-term Solvency Ratio Profitability Current Ratio Quick Ratio Cash Ratio Debt Equity Ratio Long-term Debt Ratio Equity Multiplier Profit Margin ROA ROE Inventory Tumover Total Asset Turnover NR Tumover PE ratio Market-to-Book ratio CA/CL (CA-Inv)CL CashCL TL/TE LTD/LTD-TE) TATE NI Sales NITA NITE COGS/Iny Sales TA Credit Sales/AR Price EPS Price/BV of Equity 0679 5.184 0.049 0.029 0.143 10642 0.602 18.052 6.9 Asset Management Market Value * Note: You can download the original financial statements for publicly traded firms on https://www.sec.gov/edgar/searchedgar companysearch.html Once there, look up the financials for a company. Next to the 10-Q (quarterly) and 10-K (annual reports, you should notice a link that says "Interactive Data." Click on this link, follow the Financial Statements" link, and select View Excel Document. This link will allow you to download all of the financial statements in one Excel document. D E Dec 31, 2018 Dec 31, 2019 $3.686 $6,268 246 1,124 193 949 3,113 386 8.307 11,330 713 12.103 10,396 1218 339 198 393 269 808 34,309 68 398 572 Carate Balance Sheets - USD ($) $ In Mans 2 Ourense 3 Cash and cash equivalents 4 Restricted cash 5 Accounts receivable.net 6 Inventory 7 Prepaid expenses and other current assets 8 Total current assets 9 Property, plant and equipment, met 10 Operating lease-of-use assets 11 Intangible assets, et 12 Goodwill 13 My Power Customer notes receivable net of current portion 14 Restricted cash, net of current portion 15 Other assets 16 Talsts 17 Current Labs 18 Accounts payable 19 Accrued abilities and other 20 Deferred revenue 21 Resale value guarantees 22 Gustomer deposits 23 Current portion of debt and finance leases 24 Total current liabilities 25 Debt and finance leases, et of current portion 26 Deferred revenge of current portion 27 Resale value guarantee of current portion 28 Other long-term blinds 29 Totallibilis 30 Commitments and contingencies (Note 16) 31 Redeemale non controlling interests in subsidiaries 32 Stockholders' equity 33 Preferred stod: 50.001 par value: 100 shares authorised, no share issued and outstanding Common stock: 50.001 par value 2,000 shares authorized: 181 and 173 shares issued and outstanding as 34 of December 31, 2019 and 2018, respectively 35 Additional paid in capital 36 Accumulated other comprehensive loss 37 Accumulated deficit 38 Total stockholders' equity 39 Noncontrolling interests in subsidiaries 10 Totals and equity 41 Operating Lease Vehicles (Member 42 Current assets 13 Operating lease met 4 Solar Energy Systems Member 45 Current assets Solar energy systems, net Written Assignment 1 Sheet1 Sheet2 + Ready 3.771 2.905 1.163 317 726 1785 10,667 11,634 1.207 36 2,655 26.199 3405 2094 610 503 793 2.568 9,993 9,404 991 2,710 23,427 643 556 . 0 12.737 (36) 16,083) 6,618 849 34,309 10.249 18 15,318) 4,923 834 29,740 2.447 2.000 56,138 56,271 MacBook B D E 12 Months Ended Dec 31, 2018 Dec 31, 2019 Dec 31, 2017 $ 869 20,821 2,226 24,578 $ 863 18,515 1,391 21,461 $ 1,107 9,642 1,001 11,759 459 16,398 2,770 20,509 4,069 708 7433 1.229 14,174 1,880 17419 4,042 9,536 2,223 1,378 2477 1 Consolidated Statements of Operations - USD ($) shares in Milom, $in Millions 2 3 Reveres 4 Automotive leasing 5 Total automotive revenues 6 Services and other 7 Total revenues 8 Cost of revenues 9 Automotive leasing 10 Total automotive cost of revenues 11 Services and other 12 Total cost of revenues 13 Gross profit 14 Operating experies is Research and development 16 Seling general and administrative 17 Restructuring and other 18 Total operating expenses 19 Loss from operations 20 Interest income 21 Interest expense 22 Other income (expense), net 23 Loss before income taxes 24 Provision for income taxes 25 Net loss Net income (loss) attributable to noncontrolling interests and redeemable noncontrolling interests in 26 subsidiaries 27 Netloss attributable to common stockholders 28 Netloss per share of common stock attributable to common stockholders 29 Bask 30 Duted 31 Weighted average shares used in computing net loss per share of common stock 32 Bask 33 Diluted 34 Automotive Sales (Member) 35 Revenues 36 Revenues 37 Cost of revenues 3 Cost of revenues 39 Energy Generation and Storage Member 40 Revenues 41 Revenues AZ Cost of revenues 3 Cost of revenues 1,343 2,646 149 4,138 (69) 44 (685) 45 (665) 110 (775) 87 1,460 2,835 135 4,430 (388) 24 (663) 22 (1,005) 58 (1,063) (87) 3,855 (1,632) 19 (471) (125) (2,209) 32 (2,241) (279) $(862) $ 1976) S (1,962) $14.92) $14.92) $15.72) $15.72) S (1183) $(1183) 177 177 171 171 166 166 $ 19,952 $ 17,632 $ 8,535 15,939 13,686 6,725 1,531 1,555 1,116 51,341 $1,365 $ 874 14 16