12/31/2015 -(Google $758.88)**Note close price adjusted for both dividends and splits.

Do not include stock splits into your financial statement analysis due to the prices being adjusted for splits.

For cash dividends reinvest amount back into that adjusted closing price for that day.

Determine total investment value at 12/31/2019.

using the adjusted close at 12/31/2015 excel spread sheet showing your math, the value change for the stocks, and answers to the following ratios. Also I would like the ratios grouped by ratio type- Liquidity, Leverage, Efficiency, Profitability, and market Value ratios, by year, and by company. The years will be FYE for 2016, 2017, 2018, and 2019 for each company and the data can come from the SEC 10k or annual report from each of the respective companies and years.

Return on Assets

price to earnings ratio

Current Ratio

debt ratio

asset turnover ratio

cash ratio

Return on Equity

Acid Test Ratio

Dividend yield ratio

inventory turnover ratio

Debt to Equity

return to equity ratio

Price to earnings ratio

gross martin ratio

Operating cash flow ratio

interest coverage ratio

debt service ratio

earnings per share