Please answer 5-7! Thank you!!
20 Basic Net income Per Share1 21 Diluted Net Income Per Share1 22 Average Shares Outstanding - Basic \begin{tabular}{|rrr|} $2.26 & $1.80 & $2.09 \\ \hline$2.25 & $1.79 & $2.07 \\ \hline 4,315 & 4,295 & 4,276 \\ \hline 25 & 28 & 38 \\ 4,340 & 4,323 & 4,314 \\ \hline \end{tabular} 5. Prepare a vertical analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021 . Write a paragraph highlighting what you have learned from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2020 and 2021 and between Coke and Pepsi. 6. Prepare a horizontal analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021. Be sure to calculate the change in dollars and percentages for all of the revenues and expenses. What do the changes indicate about Pepsi's success in 2021 relative to 2020? Do the same comparison for Coke's income statement. What do the changes indicate about Coke's improvement or lack thereof between 2021 and 2020? With this comparison of both companies over time now compare Coke vs. Pepsi and explain why one company seems to do better than the other, financially speaking. 7. Based on all of your calculations and observations described above, make a recommendation as to which company would be a better investment. Give the reasons for your conclusion. 20 Basic Net income Per Share1 21 Diluted Net Income Per Share1 22 Average Shares Outstanding - Basic \begin{tabular}{|rrr|} $2.26 & $1.80 & $2.09 \\ \hline$2.25 & $1.79 & $2.07 \\ \hline 4,315 & 4,295 & 4,276 \\ \hline 25 & 28 & 38 \\ 4,340 & 4,323 & 4,314 \\ \hline \end{tabular} 5. Prepare a vertical analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021 . Write a paragraph highlighting what you have learned from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2020 and 2021 and between Coke and Pepsi. 6. Prepare a horizontal analysis on the income statement and the balance sheet for Pepsi and Coca Cola for 2020 and 2021. Be sure to calculate the change in dollars and percentages for all of the revenues and expenses. What do the changes indicate about Pepsi's success in 2021 relative to 2020? Do the same comparison for Coke's income statement. What do the changes indicate about Coke's improvement or lack thereof between 2021 and 2020? With this comparison of both companies over time now compare Coke vs. Pepsi and explain why one company seems to do better than the other, financially speaking. 7. Based on all of your calculations and observations described above, make a recommendation as to which company would be a better investment. Give the reasons for your conclusion