It is excel spread sheet
Company A 2015 Balance Sheet Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date See Ratios on 2017 Balance Sheet (Students: Let your instructor know where your ratios are located if it's not on the first tab.) As Reported Annual Balance Sheet Report Date12/31/15 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Cash & cash equivalents845,889 Restricted cash & marketable securities- Restricted cash3,012 Accounts receivable49,109 Raw materials184,665 Work in process42,500 Finished goods69,324 Service parts43,866 Inventory340,355 Prepaid expenses & other current assets27,574 Total current assets1,265,939 Operating lease vehicles, net382,425 Machinery, equipment & office furniture322,394 Tooling230,385 Leasehold improvements94,763 Building & building improvements67,707 Land45,020 Computer equipment & software42,073 Construction in progress76,294 Property & equipment, gross878,636 Less: accumulated depreciation & amortization140,142 Property & equipment, net738,494 Restricted cash6,435 Emission credits13,930 Debt issuance costs, net7,315 Other assets2,392 Other assets23,637 Other assets- Total assets2,416,930 Accounts payable303,969 Accrued warranty, current portion19,917 Build to suit finance obligation, current portion- Accrued interest- Environmental liabilities, current portion2,132 Other accrued expenses2,578 Taxes payable38,067 Accrued purchases19,023 Payroll & related costs26,535 Warranty & other accrued expenses- Accrued liabilities108,252 Deferred revenue91,882 Resale value guarantee- Capital lease obligations, current portion7,722 Customer deposits163,153 Convertible debt, current portion182 Long term debt & capital leases- Total current liabilities675,160 Deferred revenue181,180 Long term debt & capital leases- Resale value guarantee236,299 Capital lease obligations, less current portion12,855 Convertible debt, less current portion586,119 Accrued warranty, less current portion33,265 Deferred rent liability9,886 Deferred tax liabilities6,821 Environmental liabilities, less current portion3,364 Other long-term liabilities4,861 Other long-term liabilities- Other long-term liabilities- Convertible senior notes- Total liabilities1,749,810 Common stock123 Additional paid-in capital1,806,617 Accumulated other comprehensive income (loss)-Data quality check: Retained earnings (accumulated deficit)-1,139,620Assets =Liabilities + Equity Total stockholders' equity (deficit)667,1202,416,9302,416,930 Reference (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Company A 2016 Balance Sheet Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date12/31/16 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Cash & cash equivalents1,905,713 Restricted cash & marketable securities17,947 Restricted cash- Accounts receivable226,604 Raw materials392,292 Work in process56,114 Finished goods397,318 Service parts107,951 Inventory953,675 Prepaid expenses & other current assets94,718 Total current assets3,198,657 Operating lease vehicles, net766,744 Machinery, equipment & office furniture720,746 Tooling295,906 Leasehold improvements230,270 Building & building improvements154,362 Land49,478 Computer equipment & software98,970 Construction in progress572,125 Property & equipment, gross2,121,857 Less: accumulated depreciation & amortization292,590 Property & equipment, net1,829,267 Restricted cash11,374 Emission credits- Debt issuance costs, net- Other assets- Other assets- Other assets43,209 Total assets5,849,251 Accounts payable777,946 Accrued warranty, current portion32,321 Build to suit finance obligation, current portion21,030 Accrued interest7,222 Environmental liabilities, current portion3,573 Other accrued expenses10,470 Taxes payable71,229 Accrued purchases68,547 Payroll & related costs54,492 Warranty & other accrued expenses- Accrued liabilities268,884 Deferred revenue191,651 Resale value guarantee- Capital lease obligations, current portion9,532 Customer deposits257,587 Convertible debt, current portion601,566 Long term debt & capital leases- Total current liabilities2,107,166 Deferred revenue292,271 Long term debt & capital leases- Resale value guarantee487,879 Capital lease obligations, less current portion12,267 Convertible debt, less current portion1,806,518 Accrued warranty, less current portion- Deferred rent liability- Deferred tax liabilities- Environmental liabilities, less current portion- Other long-term liabilities- Other long-term liabilities- Other long-term liabilities173,244 Convertible senior notes58,196 Total liabilities4,937,541 Common stock126 Additional paid-in capital2,345,266 Accumulated other comprehensive income (loss)-Data quality check: Retained earnings (accumulated deficit)-1,433,682Assets =Liabilities + Equity Total stockholders' equity (deficit)911,7105,849,2515,849,251 Reference (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Company A 2017 Balance Sheet Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date12/31/17 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Cash & cash equivalents1,196,908RatiosIndustry Average (Students: include a reference for this data too) Restricted cash & marketable securities22,628201720162015 Restricted cash- Accounts receivable168,965Current Ratio0.991.521.88 Raw materials528,935Debt / Equity Ratio6.435.422.62109.19 Work in process163,830Free Cash Flow (000)-$2,159,349-$1,027,222-$6,230 Finished goods476,512Earnings per Share$ (6.93)$ (2.36)$ (0.62)1.63 Service parts108,561Price / earnings ratio-34.62-94.20-242.7213.00 Inventory1,277,838Return on Equity-81.61%-32.25%-11.09%12.40% Prepaid expenses & other current assets125,229Net profit margin -21.96%-9.19%-3.68%5.00% Total current assets2,791,568Stock Data Operating lease vehicles, net1,791,403Number of Shares Outstanding131,425125,688123,091 Machinery, equipment & office furniture1,694,910Closing Price Last Business Day in December240.01222.41150.43 Tooling550,902 Leasehold improvements338,392 Building & building improvements461,303 Land60,234 Computer equipment & software175,512 Construction in progress693,207 Property & equipment, gross3,974,460 Less: accumulated depreciation & amortization571,126 Property & equipment, net3,403,334 Restricted cash31,522 Emission credits- Debt issuance costs, net- Other assets- Other assets- Other assets74,633 Total assets8,092,460 Accounts payable916,148 Accrued warranty, current portion- Build to suit finance obligation, current portion- Accrued interest- Environmental liabilities, current portion- Other accrued expenses- Taxes payable101,206 Accrued purchases140,540 Payroll & related costs86,859 Warranty & other accrued expenses94,193 Accrued liabilities422,798 Deferred revenue423,961 Resale value guarantee136,831 Capital lease obligations, current portion- Customer deposits283,370 Convertible debt, current portion- Long term debt & capital leases633,166 Total current liabilities2,816,274 Deferred revenue446,105 Long term debt & capital leases2,040,375 Resale value guarantee1,293,741 Capital lease obligations, less current portion- Convertible debt, less current portion- Accrued warranty, less current portion- Deferred rent liability- Deferred tax liabilities- Environmental liabilities, less current portion- Other long-term liabilities- Other long-term liabilities- Other long-term liabilities364,976 Convertible senior notes42,045 Total liabilities7,003,516 Common stock131 Additional paid-in capital3,414,692 Accumulated other comprehensive income (loss)-3,556Data quality check: Retained earnings (accumulated deficit)-2,322,323Assets =Liabilities + Equity Total stockholders' equity (deficit)1,088,9448,092,4608,092,460 References (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Industry Averages. (2018). Industry: Example Only - Major. Retrieved February 11, 2018 from: (link to industry averages here) Company A 2015 Income Statement Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date12/31/15 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Development services15,710 Automotive sales1,997,786 Services & other revenues- Total revenues2,013,496 Development services13,356 Automotive sales1,543,878 Services & other cost of revenues- Total cost of revenues1,557,234 Gross profit (loss)456,262 Research & development231,976 Selling, general & administrative285,569 Total operating expenses517,545 Income (loss) from operations-61,283 Interest income189 Interest expense32,934 Other income (expense), net22,602 Income (loss) before income taxes - domestic-75,279 Income (loss) before income taxes - international3,853 Income (loss) before income taxes-71,426 Current state income taxes (benefit)178 Current foreign income taxes (benefit)2,349 Current income taxes (benefit)2,527 Deferred foreign income taxes (benefit)61 Deferred income taxes (benefit)61 Provision for income taxes (benefit)2,588 Net income (loss)-74,014 Weighted average shares outstanding-basic119,421 Weighted average shares outstanding-diluted119,421 Year end shares outstanding123,091 Net income (loss) per share - basic-1 Net income (loss) per share - diluted-1 Number of full time employees5,859 Number of common stockholders699 Foreign currency translation adjustments- Reference (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Company A 2016 Income Statement Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date12/31/16 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Development services5,633 Automotive sales3,192,723 Services & other revenues- Total revenues3,198,356 Development services6,674 Automotive sales2,310,011 Services & other cost of revenues- Total cost of revenues2,316,685 Gross profit (loss)881,671 Research & development464,700 Selling, general & administrative603,660 Total operating expenses1,068,360 Income (loss) from operations-186,689 Interest income1,126 Interest expense100,886 Other income (expense), net1,813 Income (loss) before income taxes - domestic-60,451 Income (loss) before income taxes - international-224,185 Income (loss) before income taxes-284,636 Current state income taxes (benefit)257 Current foreign income taxes (benefit)9,203 Current income taxes (benefit)9,460 Deferred foreign income taxes (benefit)-56 Deferred income taxes (benefit)-56 Provision for income taxes (benefit)9,404 Net income (loss)-294,040 Weighted average shares outstanding-basic124,539 Weighted average shares outstanding-diluted124,539 Year end shares outstanding125,688 Net income (loss) per share - basic-2 Net income (loss) per share - diluted-2 Number of full time employees10,161 Number of common stockholders769 Foreign currency translation adjustments- Reference (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Company A 2017 Income Statement Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date12/31/17 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Development services- Automotive sales3,740,973 Services & other revenues305,052 Total revenues4,046,025 Development services- Automotive sales2,823,302 Services & other cost of revenues299,220 Total cost of revenues3,122,522 Gross profit (loss)923,503 Research & development717,900 Selling, general & administrative922,232 Total operating expenses1,640,132 Income (loss) from operations-716,629 Interest income1,508 Interest expense118,851 Other income (expense), net-41,652 Income (loss) before income taxes - domestic-415,694 Income (loss) before income taxes - international-459,930 Income (loss) before income taxes-875,624 Current state income taxes (benefit)525 Current foreign income taxes (benefit)10,342 Current income taxes (benefit)10,867 Deferred foreign income taxes (benefit)2,172 Deferred income taxes (benefit)2,172 Provision for income taxes (benefit)13,039 Net income (loss)-888,663 Weighted average shares outstanding-basic128,202 Weighted average shares outstanding-diluted128,202 Year end shares outstanding131,425 Net income (loss) per share - basic-7 Net income (loss) per share - diluted-7 Number of full time employees13,058 Number of common stockholders836 Foreign currency translation adjustments-10,999 Reference (example) Mergent Online. (2018). Company A Retrieved January 21, 2018 from: (link to financial statement here) Company A 2015 Cash Flow Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Cash Flow Report Date12/31/15 CurrencyUSD Audit StatusNot Qualified ConsolidatedYes ScaleThousands Net income (loss)-74,014 Depreciation & amortization106,083 Stock-based compensation80,737 Amortization of discount on convertible debt9,143 Inventory write-downs8,918 Write-off of Department of Energy (DOE) loan origination costs5,558 Change in fair value of DOE warrant liability-10,692 Fixed asset disposal- Other non-cash operating activities3,611 Foreign currency transaction loss (gain)3,655 Account receivables-21,917 Inventories & operating lease vehicles-463,270 Prepaid expenses & other current assets-17,466 Other assets-342 Accounts payable-243 Accrued liabilities66,567 Accounts payable & accrued expenses- Deferred