Question: 67 4 5 Microsoft (MSFT) 568 9 A 10 Statement to Use 2020 2021 2022 2023 11 Apple (APPL) 12 13 14 15 16 17

Statement to Use \begin{tabular}{|c|c|} \hlineB & C \\ \hline \begin{tabular}{c} Balance \\ Sheet \end{tabular} & \begin{tabular}{c} Balance \\ Sheet \end{tabular} \\ \hline \end{tabular} D E F G H I 1 L A and Balance Balance Income income Cash Flow Sheet Statement Statement Statement Microsoft (MSFT) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 2020 & 2.52 & NA & NA & NA & NA & 0.61 & 21.47 & 20.44 & $45,234,000 \\ \hline 2021 & 2.08 & 23.06 & 15.8 & 4.80 & 76.06 & 0.57 & 31.31 & 29.80 & $56,118,000 \\ \hline 2022 & 1.78 & 4.91 & 74.3 & 4.82 & 75.76 & 0.54 & 41.58 & 40.42 & $65,149,000 \\ \hline 2023 & 1.77 & 5.28 & 69.2 & 4.56 & 80.05 & 0.50 & 46.38 & 44.98 & $59,475,000 \\ \hline \end{tabular} Apple (APPL) \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2020 & 1.31 & NA & NA & NA & NA & $73,365,000 \\ \hline 2021 & 1.07 & & & & & $92,953,000 \\ \hline 2022 & 0.88 & & & & & $11,443,000 \\ \hline 2023 & 0.9 & & & & & $99,584,000 \\ \hline \end{tabular} Merk \& Co. (MRK) McDonalds (MCD) Nike (NKE) Chevron (CVX) B6: fx=181915000/72310000 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ A } & \multicolumn{2}{|l|}{ A } & B & \multicolumn{2}{|r|}{ C } & \multicolumn{2}{|r|}{ D } & E & \multirow[t]{2}{*}{ F } & \multirow{2}{*}{\begin{tabular}{c} G \\ Balance \\ Sheet \end{tabular}} & \multirow{2}{*}{\begin{tabular}{|c|} H \\ Income \\ Statement \\ \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} 1 \\ Income \\ Statement \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Cash Flow \\ Statement \end{tabular}} \\ \hline & Statement to U & & \begin{tabular}{c} Balance \\ Sheet \end{tabular} & & \begin{tabular}{l} Slance \\ Sheet \end{tabular} & & & \begin{tabular}{c} and Balance \\ Sheet \end{tabular} & & & & & \\ \hline 4 & & & & & & & & 14 & & & & 27 & 2 \\ \hline s & Microsoft (MS & & & & & & & & & & & 91 & \\ \hline 6 & & 2020 & 2.52 & NA & & NA & & NA & NA & 0.61 & 21.47 & 20.44 & $45,234,000 \\ \hline 7 & & 2021 & 2.08 & & 23.06 & & 15.8 & 4.80 & 76.06 & 0.57 & 31.31 & 29.80 & $56,118,000 \\ \hline 8 & & 2022 & 1.78 & & 4.91 & & 74.3 & 4.82 & 75.76 & 0.54 & 41.58 & 40.42 & $65,149,000 \\ \hline 9 & x= & 2023 & 1.77 & & 5.28 & & 69.2 & 4.56 & 80.05 & 0.50 & 46.38 & 44.98 & $59,475,000 \\ \hline 10 & + & + & 1 & 3 & & & & & & & & & \\ \hline 11 & Apple (APPL) & & 3 & U. & & & & & +1 & & & & +1 \\ \hline 12 & 8 & 2020 & 1.31 & NA & & NA & & NA & NA & & & & $73,365,000 \\ \hline 13 & 3 & 2021 & 1.07 & & & + & & & - & & & & $92,953,000 \\ \hline 14 & & 2022 & 0.88 & t. & & & & & I. & & & & $11,443,000 \\ \hline 15 & 8 & 2023 & 0.9 & & & & & - & E & & & & $99,584,000 \\ \hline 16 & & & & 8 & & & & & & & & & \\ \hline 17 & Merk \& Co. (M & ARK) & & 1 & & & & & & -1 & & & \\ \hline 18 & & 2019 & & NA & & NA & & NA & NA & & & & \\ \hline 19 & & 2020 & & & & & & & & & T. & & \\ \hline 20 & & 2021 & & & & - & & & & & & & \\ \hline 21 & & 2022 & & & & - & & & & & & & \\ \hline 22 & +2 & & & & & - & & & & & & & \\ \hline 23 & McDonalds (M & ACD) & & & & 8 & & & & & & & - \\ \hline 24 & & 2019 & & NA & & NA. & & NA & NA & & & & \\ \hline 25 & & 2020 & & & & & & & & & & & \\ \hline 26 & & 2021 & & & & & & & & & & & \\ \hline 27 & & 2022 & & & & & & & & & & & \\ \hline 28 & & = & & C & & & & & & & & & \\ \hline 29 & Nike (NKE) & & & E & & & & & & & & & \\ \hline 30 & & 2020 & & NA & & NA & & NA & NA & & & & \\ \hline 31 & & 2021 & & & & & & & & & & & \\ \hline 32 & & 2022 & & & & & & & & & & & \\ \hline 33 & & 2023 & & & & - & & H & & & & & \\ \hline 34 & & & & & & & & & & & & & \\ \hline 35 & Chevron (cvX) & & & & & & & + & & & & & \\ \hline 36 & & 2019 & & NA & & NA & & NA & NA & & & & BI \\ \hline 37 & & 2020 & & 17 & & 4 & & 11 & & & & & \\ \hline \end{tabular} Sheet1 + Workbook Statistics Type here to search Statement to Use \begin{tabular}{|c|c|} \hlineB & C \\ \hline \begin{tabular}{c} Balance \\ Sheet \end{tabular} & \begin{tabular}{c} Balance \\ Sheet \end{tabular} \\ \hline \end{tabular} D E F G H I 1 L A and Balance Balance Income income Cash Flow Sheet Statement Statement Statement Microsoft (MSFT) \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 2020 & 2.52 & NA & NA & NA & NA & 0.61 & 21.47 & 20.44 & $45,234,000 \\ \hline 2021 & 2.08 & 23.06 & 15.8 & 4.80 & 76.06 & 0.57 & 31.31 & 29.80 & $56,118,000 \\ \hline 2022 & 1.78 & 4.91 & 74.3 & 4.82 & 75.76 & 0.54 & 41.58 & 40.42 & $65,149,000 \\ \hline 2023 & 1.77 & 5.28 & 69.2 & 4.56 & 80.05 & 0.50 & 46.38 & 44.98 & $59,475,000 \\ \hline \end{tabular} Apple (APPL) \begin{tabular}{|c|c|c|c|c|c|c|} \hline 2020 & 1.31 & NA & NA & NA & NA & $73,365,000 \\ \hline 2021 & 1.07 & & & & & $92,953,000 \\ \hline 2022 & 0.88 & & & & & $11,443,000 \\ \hline 2023 & 0.9 & & & & & $99,584,000 \\ \hline \end{tabular} Merk \& Co. (MRK) McDonalds (MCD) Nike (NKE) Chevron (CVX) B6: fx=181915000/72310000 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{ A } & \multicolumn{2}{|l|}{ A } & B & \multicolumn{2}{|r|}{ C } & \multicolumn{2}{|r|}{ D } & E & \multirow[t]{2}{*}{ F } & \multirow{2}{*}{\begin{tabular}{c} G \\ Balance \\ Sheet \end{tabular}} & \multirow{2}{*}{\begin{tabular}{|c|} H \\ Income \\ Statement \\ \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} 1 \\ Income \\ Statement \end{tabular}} & \multirow{2}{*}{\begin{tabular}{l} Cash Flow \\ Statement \end{tabular}} \\ \hline & Statement to U & & \begin{tabular}{c} Balance \\ Sheet \end{tabular} & & \begin{tabular}{l} Slance \\ Sheet \end{tabular} & & & \begin{tabular}{c} and Balance \\ Sheet \end{tabular} & & & & & \\ \hline 4 & & & & & & & & 14 & & & & 27 & 2 \\ \hline s & Microsoft (MS & & & & & & & & & & & 91 & \\ \hline 6 & & 2020 & 2.52 & NA & & NA & & NA & NA & 0.61 & 21.47 & 20.44 & $45,234,000 \\ \hline 7 & & 2021 & 2.08 & & 23.06 & & 15.8 & 4.80 & 76.06 & 0.57 & 31.31 & 29.80 & $56,118,000 \\ \hline 8 & & 2022 & 1.78 & & 4.91 & & 74.3 & 4.82 & 75.76 & 0.54 & 41.58 & 40.42 & $65,149,000 \\ \hline 9 & x= & 2023 & 1.77 & & 5.28 & & 69.2 & 4.56 & 80.05 & 0.50 & 46.38 & 44.98 & $59,475,000 \\ \hline 10 & + & + & 1 & 3 & & & & & & & & & \\ \hline 11 & Apple (APPL) & & 3 & U. & & & & & +1 & & & & +1 \\ \hline 12 & 8 & 2020 & 1.31 & NA & & NA & & NA & NA & & & & $73,365,000 \\ \hline 13 & 3 & 2021 & 1.07 & & & + & & & - & & & & $92,953,000 \\ \hline 14 & & 2022 & 0.88 & t. & & & & & I. & & & & $11,443,000 \\ \hline 15 & 8 & 2023 & 0.9 & & & & & - & E & & & & $99,584,000 \\ \hline 16 & & & & 8 & & & & & & & & & \\ \hline 17 & Merk \& Co. (M & ARK) & & 1 & & & & & & -1 & & & \\ \hline 18 & & 2019 & & NA & & NA & & NA & NA & & & & \\ \hline 19 & & 2020 & & & & & & & & & T. & & \\ \hline 20 & & 2021 & & & & - & & & & & & & \\ \hline 21 & & 2022 & & & & - & & & & & & & \\ \hline 22 & +2 & & & & & - & & & & & & & \\ \hline 23 & McDonalds (M & ACD) & & & & 8 & & & & & & & - \\ \hline 24 & & 2019 & & NA & & NA. & & NA & NA & & & & \\ \hline 25 & & 2020 & & & & & & & & & & & \\ \hline 26 & & 2021 & & & & & & & & & & & \\ \hline 27 & & 2022 & & & & & & & & & & & \\ \hline 28 & & = & & C & & & & & & & & & \\ \hline 29 & Nike (NKE) & & & E & & & & & & & & & \\ \hline 30 & & 2020 & & NA & & NA & & NA & NA & & & & \\ \hline 31 & & 2021 & & & & & & & & & & & \\ \hline 32 & & 2022 & & & & & & & & & & & \\ \hline 33 & & 2023 & & & & - & & H & & & & & \\ \hline 34 & & & & & & & & & & & & & \\ \hline 35 & Chevron (cvX) & & & & & & & + & & & & & \\ \hline 36 & & 2019 & & NA & & NA & & NA & NA & & & & BI \\ \hline 37 & & 2020 & & 17 & & 4 & & 11 & & & & & \\ \hline \end{tabular} Sheet1 + Workbook Statistics Type here to search
Step by Step Solution
There are 3 Steps involved in it
The images youve provided appear to show financial data for various companies over a period of years ... View full answer
Get step-by-step solutions from verified subject matter experts
