For the manufacturing organization and service organization chosen in Part $1,$ analyze the balance sheet and income statements. Create a Google spreadsheet and share it so that anyone with the link can view it$.$Within the spreadsheet, conduct a horizontal analysis of the balance sheet for each company over the past three years. You can use a different sheet tab for each company to keep data organized. Refer to Example $15\mathrm{.}1$ in the textbook, wherein Year $1$ is the baseline $(100\%$ value$).$Within the spreadsheet, conduct a vertical analysis of the income statement for each company over the past three years with net sales as the base. You can use a different sheet tab for each company to keep data organized.