For the Google Company can you prepare an excel spread sheet with the following information?
1) Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year). Values should be expressed as percentage of Total Revenues for the year.
2) Horizontal and vertical analysis of the balance sheets for the past three years (all yearly balances set as a percentage of total assets for that year). Values should be expressed as percentage of total assets for that year.
3) Ratio analysis (eight ratios of your choosing) for the past three years
4) A measurement for the creditworthiness of Google as measured by Altman’s Z-score. Please also present industry-average ratios or current year competitor ratios for this ratio analysis. Comparing Google's ratios to a close competitor or an industry-average ratio.