Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BUSI 690 Case Study: Tesla Net Present Value analysis of proposed strategys new cash flow you may also use Excel to solve for this. From
BUSI 690
Case Study: Tesla
Net Present Value analysis of proposed strategys new cash flow you may also use Excel to solve for this. From the income statement the change in operating income between your with and without strategy should serve as your cash inflow for each year.
Dec. 31, 2020 12 Months Ended Change (%) Dec. 31, 2019 Change (%) Dec. 31. 2018 $ 862 (211) $ (775) (27.09) $ (1,063) Statements of Cash Flows - USD ($) Sin Millions Cash Flows from Operating Activities Net income (loss) Adjustments to reconcile net income (loss) to net cash provided by operating activities: Depreciation, amortization and impairment Stock-based compensation Amortization of debt discounts and issuance costs Inventory and purchase commitments write-downs Loss on disposals of fixed assets Foreisn currency transaction net loss (ain) Non-cash interest and other operating activities Operating cash flow related to repayment of discounted convertible senior notes Changes in operating assets and liabilities, net of effect of business combinations: 2,322 1,734 180 202 117 114 228 8 8 93 (4) 5 (20) (338) 23 (100) 2.154 898 188 193 146 (48) 186 (188) ) 13.31 19.89 18.24 127.06 (9.88) 23 00.00 279.59 1,901 749 159 85 162 02 49 (652) (422) (1,072) (251) (344) 2.102 321 7 495 5.943 78 (2) 40 (13) (399) 225 (60) (112) (10,000) 147 (367) (429) (764) (288) 115 646 801 (58) (5) 2.405 (26.16) (58.06) 255.35 251.22 (155.56) (64.05 ) 97.29 (39.58) (80.00) 14.63 (497) (1,023) (215) (82) (207) 1.797 406 (96). (25) 2,098 (36.84) (51.83) (2,101) (218) (3,157) (75) 123 (10) (13) (3.132) 138 (29) 167 100 (71) 118 (1.327) (105) 46 (5) (45) (1.436) 150.00 (38.55) (18) (2,337) 12,269 9.713 (11.623) 1,347 (9) 27 848 10.669 (9.161) Accounts receivable Inventory Operating lea se vehicles Prepaid expenses and other current assets Other non-current assets Accounts payable and accrued liabilities Deferred revenue Customer deposits Other long-tem liabilities Net cash provided by operating activities Cash Flows from Investing Activities Purchases of property and equipment excluding finance te ases, net of sales Purchases of solar energy systems, net of sales Receipt of government grants Purchase of intangible assets Business combinations, net of cash acquired Net cash used in investing activities Cash Flows from Financing Activities Proceeds from issuances of common stock in public offerings, net of issuance costs Proceeds from issuances of convertible and other debt Repayments of convertible and other debt Rep ayments of borrowings issued to related parties Collateralized lease repayments Proceeds from exercises of stock options and other stock issuances Principal payments on finance le ases Debt is suance costs Purchase of convertible note hedges Proceeds from issuance of warrants Proceeds from investments by noncontrolling interests in subsidiaries Distributions paid to noncontrolling interests in subsidiaries Payments for buy-outs of noncontrolling interests in subsidiaries Net cash provided by financing activities Effect of exchange rate changes on cash and cash equivalents and restricted cash Net increase in cash and cash equivalents and restricted cash Cash and cash equivalents and restricted cash, beginning of period Cash and cash equivalents and restricted cash, end of period Supplemental Non-Cash Investing and Financing Activities Equity issued in comection with business combination Acquisitions ofproperty and equipment included in liabilities Estimated fair value of facilities under build-to-suit le ases Supplemental Disclosures Cash paid during the period for interest, net of amounts capitalized Cash paid during the period for taxes, net of re fiinds 72.75 74.60 (100.00) (30.41) (240) 417 (338) (6) 6,176 (5,247) (100) (559) 296 (181) (15) (11.15) 77.35 146.67 24 (208) (35) 9,973 334 13,1 18 6.783 19,901 (38) 59 5 (84) (100) (100) (91) (33) 289 552 4,075 423 59 193 (389) 263 (321) (37) (476) 174 279 (311) (9) 1,529 8 2,506 4,277 6.783 (36.16) 37.00 50.00 166.38 (134.78) 703.21 7.87 58.59 437 (227) (6) 574 (23) 312 3,965 4,277 (100) 94 207 562 1,088 125.70 (100.00) 249 94 444 $ 115 (2) 113 455 $ 54 19.42 54.29 381 $ 35 Dec. 31, 2020 12 Months Ended Change (%) Dec. 31, 2019 Change (%) Dec. 31. 2018 $ 862 (211) $ (775) (27.09) $ (1,063) Statements of Cash Flows - USD ($) Sin Millions Cash Flows from Operating Activities Net income (loss) Adjustments to reconcile net income (loss) to net cash provided by operating activities: Depreciation, amortization and impairment Stock-based compensation Amortization of debt discounts and issuance costs Inventory and purchase commitments write-downs Loss on disposals of fixed assets Foreisn currency transaction net loss (ain) Non-cash interest and other operating activities Operating cash flow related to repayment of discounted convertible senior notes Changes in operating assets and liabilities, net of effect of business combinations: 2,322 1,734 180 202 117 114 228 8 8 93 (4) 5 (20) (338) 23 (100) 2.154 898 188 193 146 (48) 186 (188) ) 13.31 19.89 18.24 127.06 (9.88) 23 00.00 279.59 1,901 749 159 85 162 02 49 (652) (422) (1,072) (251) (344) 2.102 321 7 495 5.943 78 (2) 40 (13) (399) 225 (60) (112) (10,000) 147 (367) (429) (764) (288) 115 646 801 (58) (5) 2.405 (26.16) (58.06) 255.35 251.22 (155.56) (64.05 ) 97.29 (39.58) (80.00) 14.63 (497) (1,023) (215) (82) (207) 1.797 406 (96). (25) 2,098 (36.84) (51.83) (2,101) (218) (3,157) (75) 123 (10) (13) (3.132) 138 (29) 167 100 (71) 118 (1.327) (105) 46 (5) (45) (1.436) 150.00 (38.55) (18) (2,337) 12,269 9.713 (11.623) 1,347 (9) 27 848 10.669 (9.161) Accounts receivable Inventory Operating lea se vehicles Prepaid expenses and other current assets Other non-current assets Accounts payable and accrued liabilities Deferred revenue Customer deposits Other long-tem liabilities Net cash provided by operating activities Cash Flows from Investing Activities Purchases of property and equipment excluding finance te ases, net of sales Purchases of solar energy systems, net of sales Receipt of government grants Purchase of intangible assets Business combinations, net of cash acquired Net cash used in investing activities Cash Flows from Financing Activities Proceeds from issuances of common stock in public offerings, net of issuance costs Proceeds from issuances of convertible and other debt Repayments of convertible and other debt Rep ayments of borrowings issued to related parties Collateralized lease repayments Proceeds from exercises of stock options and other stock issuances Principal payments on finance le ases Debt is suance costs Purchase of convertible note hedges Proceeds from issuance of warrants Proceeds from investments by noncontrolling interests in subsidiaries Distributions paid to noncontrolling interests in subsidiaries Payments for buy-outs of noncontrolling interests in subsidiaries Net cash provided by financing activities Effect of exchange rate changes on cash and cash equivalents and restricted cash Net increase in cash and cash equivalents and restricted cash Cash and cash equivalents and restricted cash, beginning of period Cash and cash equivalents and restricted cash, end of period Supplemental Non-Cash Investing and Financing Activities Equity issued in comection with business combination Acquisitions ofproperty and equipment included in liabilities Estimated fair value of facilities under build-to-suit le ases Supplemental Disclosures Cash paid during the period for interest, net of amounts capitalized Cash paid during the period for taxes, net of re fiinds 72.75 74.60 (100.00) (30.41) (240) 417 (338) (6) 6,176 (5,247) (100) (559) 296 (181) (15) (11.15) 77.35 146.67 24 (208) (35) 9,973 334 13,1 18 6.783 19,901 (38) 59 5 (84) (100) (100) (91) (33) 289 552 4,075 423 59 193 (389) 263 (321) (37) (476) 174 279 (311) (9) 1,529 8 2,506 4,277 6.783 (36.16) 37.00 50.00 166.38 (134.78) 703.21 7.87 58.59 437 (227) (6) 574 (23) 312 3,965 4,277 (100) 94 207 562 1,088 125.70 (100.00) 249 94 444 $ 115 (2) 113 455 $ 54 19.42 54.29 381 $ 35
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started