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 Teslas 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 Teslas quick ratio? Are there any concerns with Teslas quick ratio values?

3. What is the common rule of thumb for a current ratio value? Are there any trends with Teslas current ratio? Are there any concerns with Teslas 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 Teslas 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?