Case \#2 Balance Sheet and Cash Flow In a Business Insider report in 2018, Tesla is "burning through billions" in cash. You are a financial analyst at Tesla and your manager has asked you to prepare a data analytics report on the cash flow trends over the past few years. This report will be used for senior executives to quickly identify cash flow and liquidity trends, identify areas of concern, project future outcomes and strategize for improving cash flow. Your approach is to analyze the cash flow statements and balance sheets from 2015 to 2018. You have extracted the data from Yahoo Finance. Your report should include the charts or graphs to summarize your findings in the following data aspects: 1) Cash Flow By Year - This should include cash flow broken out by activity (operating, investing, financing) and a consolidated net change in cash. 2) Quick Ratio Value By Year 3) Quick Ratio Dollar Values By Year 4) Current Ratio Value by Year 5) Current Ratio Dollar Values by Year Business Insider report: https://www.businessinsider.com/tesla-cash-problem-raises-questions-2018-4 Answer the following questions: 1. Which year did Tesla have the largest positive (negative) net cash flow? What were Tesla's quick ratio and current ratio in 2017 and 2018 ? 2. What is the common rule of thumb for a quick ratio value? Are there any trends with Tesla's quick ratio? Are there any concerns with Tesla's quick ratio values? 3. What is the common rule of thumb for a current ratio value? Are there any trends with Tesla's current ratio? Are there any concerns with Tesla's common ratio values? 4. Did Tesla have a cash issue in 2018 as the Business Insider report headline suggests? What strategies could be implemented to resolve Tesla's cash issue? 5. How does net change in cash for all activities compare year over year? Does the data show a trend in cash flow? Does the trend help predict cash flow in future years? 6. Which cash flow activity (operating, investing, financing) represents the largest source of cash outflows from 2015 to 2018 . What specific transactions may have contributed to this cash outflow? Case \#2 Balance Sheet and Cash Flow In a Business Insider report in 2018, Tesla is "burning through billions" in cash. You are a financial analyst at Tesla and your manager has asked you to prepare a data analytics report on the cash flow trends over the past few years. This report will be used for senior executives to quickly identify cash flow and liquidity trends, identify areas of concern, project future outcomes and strategize for improving cash flow. Your approach is to analyze the cash flow statements and balance sheets from 2015 to 2018. You have extracted the data from Yahoo Finance. Your report should include the charts or graphs to summarize your findings in the following data aspects: 1) Cash Flow By Year - This should include cash flow broken out by activity (operating, investing, financing) and a consolidated net change in cash. 2) Quick Ratio Value By Year 3) Quick Ratio Dollar Values By Year 4) Current Ratio Value by Year 5) Current Ratio Dollar Values by Year Business Insider report: https://www.businessinsider.com/tesla-cash-problem-raises-questions-2018-4 Answer the following questions: 1. Which year did Tesla have the largest positive (negative) net cash flow? What were Tesla's quick ratio and current ratio in 2017 and 2018 ? 2. What is the common rule of thumb for a quick ratio value? Are there any trends with Tesla's quick ratio? Are there any concerns with Tesla's quick ratio values? 3. What is the common rule of thumb for a current ratio value? Are there any trends with Tesla's current ratio? Are there any concerns with Tesla's common ratio values? 4. Did Tesla have a cash issue in 2018 as the Business Insider report headline suggests? What strategies could be implemented to resolve Tesla's cash issue? 5. How does net change in cash for all activities compare year over year? Does the data show a trend in cash flow? Does the trend help predict cash flow in future years? 6. Which cash flow activity (operating, investing, financing) represents the largest source of cash outflows from 2015 to 2018 . What specific transactions may have contributed to this cash outflow