Prepare statement of cash flow for Tesla and then based off statements of cash flow determine if you would invest 1 million into the company
PROBLEM 2-15 CASH FLOW RESEARCH PAPER Target Investment-$ 1,000.000 Select company that you desire to invest in 1. , ermine asset allocation between safe and risky investment 3. Track current ratio for 3 years s Track liability to asset ratio for 3 years 6. Risky-stock 7. Track stock prices quarterly for 3 years s. Track cash flow statement annually for three years 9. Statement format: -Cash flow from operations . Cash flow from investing Cash flow from financing Make a decision if you would invest $1,000,000 in the company tudy TEXTBOOK SOLUTIONS EXPERT O&A Show all steps. ON ON (1 Bookmark) Show all steps pter 3, Problem 17PC Tesla Motors Statement of Cash Flows (amounts in thous ands) Problem 3.17) Year Ended December 31 2012 2011 2010 Cash Flows From Operating Activities Net loss Adjustments to reconcile net loss to net cash used in operating S396213) S25441) 154328) 28825 1691910,623 50145 29419 21,156 activities Depreciation and amortization Change in fair value of warrant liabilities Discounts and premiums on short-term marketable securities Stock-based compensation Excess tax benefits from stock-based compensation Loss on abandonment of fixed assets Inventory write-downs Changes in operating assets and liabilities 1,854 56 2,750 (112) 5,022 (74) 1,504 4,929 345 1,828 951 (17,303) (2,829) (3,222) Accounts receivable Inventories and operating lease vehicles Prepaid expenses and other current assets Other assets Accounts payable Accrued liabilities Deferred development compens.ation (194,726) 1,121 (482) 187,821 9,603 (13,638 (28513) (248) (288) (4977) (463) 212) 19,891 10,620 13,345 (156 Deferred revenue Reservation payments Other (526) (1,927) 4,801 47,056 61,006 102552641 4707 TOSHIBA F9 F10 F11 High Quality CustomEasyBib:Free Brblog0 Study Searc TEXTBOOK SOLUTIONS EXPERT Q&A (1 Bookmark) Show all steps: ON apter 3, Problem 17PC Cash Flows From Operating Activities Net loss Adjustments to reconcile net loss to net cash used in operating 396213) $(254411) $(154328) activities: 28, 825 16919 1062 Depreciation and amortization Change in fair value of warrant liabilities Discounts and premiums on short-term marketable securities Stock-based compensation Excess tax benefits from stock-based compensation Loss on abandonment of fixed assets Inventory write-downs Changes in operating assets and liabilities 2750 29,419 345 5,022 50,145 21,156 (74) 1,504 4,929 1,828 951 17303) (2,829) (3222) Accounts receivable Inventories and operating lease vehicles Prepaid expenses and other current assets Other assets Accounts payable Accrued liabilities Deferred development compens ation Deferred revenue Reservation payments (194726 (13,638) (28513) (248) (4977) (463) 1,121 (482) (288) 87,821 1 19,891 13,345 (156) 4801 4707 3,515 9,603 10620 (526) 47,056 10.255 (1,927) 61,006 Other long-term liabilities Net cash used in operating activities 60 04 (127817 Cash Flows From Investing Activities Purchases of market able securities Maturities of short-term marketable securities Payments related to acquisition of Fremont manufacturing facility (14992) 40,000 (64952) 40,000 and related assets Purchases of property and equipment excluding capital leases Withdrawals.o (65.210 (239228) (184226) (40,203) Department of TOSHIBA FAFS F6 F F8 F9F1O F11 21Or High Quality CustomEasyBIB I ggStudy TEXTBOOK SOLUTIONS EXPERT a&A N(1 Bookmark) Show all steps. (D , ON Chapter 3, Problem 17PC Cash Flows From Investing Activities (14992) (64952) 40,000 40, Purchases of marketable securities Maturitles of short-term marketable securities Payments related to acquisition of Fremont manufacturing facility - (65,210 28) (184226 (40203) and related assets Purchases of property and equipment excluding capital leases(2392 Withdrawals out of (transfers into) our dedicated Department of 50,121 (73,597) Energy account, net Increase in other restricted cash 8620 (1,330) (1,287) (3,201)00707 (206930) (162258 (180,297 Net cash used in investing activities Cash Flows From Financing Activities Proceeds from issuance of common stock in public offerings, net 221,496 172410 188,842 Proceeds from issuance of common stock in private placements 59058 80000 Exhibit 3.20 (Continued) Principal payments on capital leases and other debt Proceeds from long-term debt and other long-term liabilities Principal payments on long-term debt (416) (2,832) 88,796 204423 (12,710) 315) 71,828 Proceeds from exerdse of stock options and other stock is suances 24,885 Excess tax benefits from stock-based compensation Deferred common stock and loan facility issuance costs 10,525 1,350 74 (3,734) Net cash provided by financing activities 419635 53376 155,708 29,931 299,55869,627 446,000 338,045 Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period 255 266 s 201,890 $255.266 $99,558 Source Tesla Motos Inc. Fom 10-K for the Fiscal Year Ended De cember 31 2012 TOSHIBA F3 Fl F5 F6 F7 F8 F9 F10 FI1 PROBLEM 2-14 STATEMENT OF CASH FLOWS Continued: Peoples Company BALANCE SHEET 2013 2013 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets: Property, Plant, and Equipment Less Accumulated Depreciation Net Property Plant and Equipment Long Term Investments Total Assets: Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities: Bonds Payable Total Liabilities: Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 2012 15,000 240,000 175,000 9,000 340,000 125,000 436.000 470,000 85,000 385.000 610,000 517.000 230,000 72,000 310,000 60,000 336,000 410,000 250,000 74,000 210,000 107,000 324,000 1,017.000 Required: Prepare Statement of Cash Flows PROBLEM 2-14 STATEMENT OF CASH FLOWs The financial statements for the Peoples Show Store are as follows: INCOME STATEMENT 2013 Sales Cost of Goods Sold Gross Profit Selling and Operating Expenses Net Operating Income Nonoperating items: 800,000 500,000 300,000 213,000 87,000 Gain on sale of investing 7,000 Loss on sale of equipment Income before taxes Income taxes Net Income (4.000) 3,000 90,000 7,000 3,000 During 2013, Peoples sold some equipment for $20,000 that had cost $40,000 and on which there was accumulated depreciation of $16,000. In addition, the company sold long-term investments for $10,000that had cost $3,000 when purchased several years ago. A cash dividend was paid during 2013 and the company repurchased $40,000 of its own stock. Peoples did not retire any bonds during 2013 PROBLEM 2-15 CASH FLOW RESEARCH PAPER Target Investment-$ 1,000.000 Select company that you desire to invest in 1. , ermine asset allocation between safe and risky investment 3. Track current ratio for 3 years s Track liability to asset ratio for 3 years 6. Risky-stock 7. Track stock prices quarterly for 3 years s. Track cash flow statement annually for three years 9. Statement format: -Cash flow from operations . Cash flow from investing Cash flow from financing Make a decision if you would invest $1,000,000 in the company tudy TEXTBOOK SOLUTIONS EXPERT O&A Show all steps. ON ON (1 Bookmark) Show all steps pter 3, Problem 17PC Tesla Motors Statement of Cash Flows (amounts in thous ands) Problem 3.17) Year Ended December 31 2012 2011 2010 Cash Flows From Operating Activities Net loss Adjustments to reconcile net loss to net cash used in operating S396213) S25441) 154328) 28825 1691910,623 50145 29419 21,156 activities Depreciation and amortization Change in fair value of warrant liabilities Discounts and premiums on short-term marketable securities Stock-based compensation Excess tax benefits from stock-based compensation Loss on abandonment of fixed assets Inventory write-downs Changes in operating assets and liabilities 1,854 56 2,750 (112) 5,022 (74) 1,504 4,929 345 1,828 951 (17,303) (2,829) (3,222) Accounts receivable Inventories and operating lease vehicles Prepaid expenses and other current assets Other assets Accounts payable Accrued liabilities Deferred development compens.ation (194,726) 1,121 (482) 187,821 9,603 (13,638 (28513) (248) (288) (4977) (463) 212) 19,891 10,620 13,345 (156 Deferred revenue Reservation payments Other (526) (1,927) 4,801 47,056 61,006 102552641 4707 TOSHIBA F9 F10 F11 High Quality CustomEasyBib:Free Brblog0 Study Searc TEXTBOOK SOLUTIONS EXPERT Q&A (1 Bookmark) Show all steps: ON apter 3, Problem 17PC Cash Flows From Operating Activities Net loss Adjustments to reconcile net loss to net cash used in operating 396213) $(254411) $(154328) activities: 28, 825 16919 1062 Depreciation and amortization Change in fair value of warrant liabilities Discounts and premiums on short-term marketable securities Stock-based compensation Excess tax benefits from stock-based compensation Loss on abandonment of fixed assets Inventory write-downs Changes in operating assets and liabilities 2750 29,419 345 5,022 50,145 21,156 (74) 1,504 4,929 1,828 951 17303) (2,829) (3222) Accounts receivable Inventories and operating lease vehicles Prepaid expenses and other current assets Other assets Accounts payable Accrued liabilities Deferred development compens ation Deferred revenue Reservation payments (194726 (13,638) (28513) (248) (4977) (463) 1,121 (482) (288) 87,821 1 19,891 13,345 (156) 4801 4707 3,515 9,603 10620 (526) 47,056 10.255 (1,927) 61,006 Other long-term liabilities Net cash used in operating activities 60 04 (127817 Cash Flows From Investing Activities Purchases of market able securities Maturities of short-term marketable securities Payments related to acquisition of Fremont manufacturing facility (14992) 40,000 (64952) 40,000 and related assets Purchases of property and equipment excluding capital leases Withdrawals.o (65.210 (239228) (184226) (40,203) Department of TOSHIBA FAFS F6 F F8 F9F1O F11 21Or High Quality CustomEasyBIB I ggStudy TEXTBOOK SOLUTIONS EXPERT a&A N(1 Bookmark) Show all steps. (D , ON Chapter 3, Problem 17PC Cash Flows From Investing Activities (14992) (64952) 40,000 40, Purchases of marketable securities Maturitles of short-term marketable securities Payments related to acquisition of Fremont manufacturing facility - (65,210 28) (184226 (40203) and related assets Purchases of property and equipment excluding capital leases(2392 Withdrawals out of (transfers into) our dedicated Department of 50,121 (73,597) Energy account, net Increase in other restricted cash 8620 (1,330) (1,287) (3,201)00707 (206930) (162258 (180,297 Net cash used in investing activities Cash Flows From Financing Activities Proceeds from issuance of common stock in public offerings, net 221,496 172410 188,842 Proceeds from issuance of common stock in private placements 59058 80000 Exhibit 3.20 (Continued) Principal payments on capital leases and other debt Proceeds from long-term debt and other long-term liabilities Principal payments on long-term debt (416) (2,832) 88,796 204423 (12,710) 315) 71,828 Proceeds from exerdse of stock options and other stock is suances 24,885 Excess tax benefits from stock-based compensation Deferred common stock and loan facility issuance costs 10,525 1,350 74 (3,734) Net cash provided by financing activities 419635 53376 155,708 29,931 299,55869,627 446,000 338,045 Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period 255 266 s 201,890 $255.266 $99,558 Source Tesla Motos Inc. Fom 10-K for the Fiscal Year Ended De cember 31 2012 TOSHIBA F3 Fl F5 F6 F7 F8 F9 F10 FI1 PROBLEM 2-14 STATEMENT OF CASH FLOWS Continued: Peoples Company BALANCE SHEET 2013 2013 Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets: Property, Plant, and Equipment Less Accumulated Depreciation Net Property Plant and Equipment Long Term Investments Total Assets: Accounts Payable Accrued Liabilities Income Taxes Payable Total Current Liabilities: Bonds Payable Total Liabilities: Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity 2012 15,000 240,000 175,000 9,000 340,000 125,000 436.000 470,000 85,000 385.000 610,000 517.000 230,000 72,000 310,000 60,000 336,000 410,000 250,000 74,000 210,000 107,000 324,000 1,017.000 Required: Prepare Statement of Cash Flows PROBLEM 2-14 STATEMENT OF CASH FLOWs The financial statements for the Peoples Show Store are as follows: INCOME STATEMENT 2013 Sales Cost of Goods Sold Gross Profit Selling and Operating Expenses Net Operating Income Nonoperating items: 800,000 500,000 300,000 213,000 87,000 Gain on sale of investing 7,000 Loss on sale of equipment Income before taxes Income taxes Net Income (4.000) 3,000 90,000 7,000 3,000 During 2013, Peoples sold some equipment for $20,000 that had cost $40,000 and on which there was accumulated depreciation of $16,000. In addition, the company sold long-term investments for $10,000that had cost $3,000 when purchased several years ago. A cash dividend was paid during 2013 and the company repurchased $40,000 of its own stock. Peoples did not retire any bonds during 2013
