please use excel and show formulas.
Using the financial statements below for the Global Manufacturing corporation, a. Compute common-size financial statements. \begin{tabular}{|c|c|c|c|} \hline Income Statement & \begin{tabular}{l} Years ended December \\ 31 \end{tabular} & 2020 & \\ \hline \multicolumn{2}{|l|}{ Net Revenues } & 700,000 & 600,000 \\ \hline \multicolumn{2}{|l|}{ COGS } & 450,000 & 375,000 \\ \hline \multicolumn{2}{|c|}{ Gross Profit } & 250,000 & 225,000 \\ \hline \multicolumn{4}{|l|}{ Operating Expenses: } \\ \hline \multicolumn{2}{|c|}{ General \& Administrative } & 95,000 & 95,000 \\ \hline \multicolumn{2}{|l|}{ Selling \& Marketing } & 56,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Depreciation } & 25,000 & 20,000 \\ \hline \multicolumn{2}{|c|}{ Operating Income } & 74,000 & 60,000 \\ \hline \multicolumn{2}{|l|}{ Interest } & 14,000 & 10,000 \\ \hline \multicolumn{2}{|c|}{ Income before taxes } & 60,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Income taxes (40%)} & 24,000 & 20,000 \\ \hline \multicolumn{2}{|c|}{ Net Income } & 36,000 & 30,000 \\ \hline \multicolumn{2}{|c|}{ \# Shares Outstanding } & 50,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Earnings per share } & 0.72 & 0.60 \\ \hline \end{tabular} Using the financial statements below for the Global Manufacturing corporation, a. Compute common-size financial statements. \begin{tabular}{|c|c|c|c|} \hline Income Statement & \begin{tabular}{l} Years ended December \\ 31 \end{tabular} & 2020 & \\ \hline \multicolumn{2}{|l|}{ Net Revenues } & 700,000 & 600,000 \\ \hline \multicolumn{2}{|l|}{ COGS } & 450,000 & 375,000 \\ \hline \multicolumn{2}{|c|}{ Gross Profit } & 250,000 & 225,000 \\ \hline \multicolumn{4}{|l|}{ Operating Expenses: } \\ \hline \multicolumn{2}{|c|}{ General \& Administrative } & 95,000 & 95,000 \\ \hline \multicolumn{2}{|l|}{ Selling \& Marketing } & 56,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Depreciation } & 25,000 & 20,000 \\ \hline \multicolumn{2}{|c|}{ Operating Income } & 74,000 & 60,000 \\ \hline \multicolumn{2}{|l|}{ Interest } & 14,000 & 10,000 \\ \hline \multicolumn{2}{|c|}{ Income before taxes } & 60,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Income taxes (40%)} & 24,000 & 20,000 \\ \hline \multicolumn{2}{|c|}{ Net Income } & 36,000 & 30,000 \\ \hline \multicolumn{2}{|c|}{ \# Shares Outstanding } & 50,000 & 50,000 \\ \hline \multicolumn{2}{|l|}{ Earnings per share } & 0.72 & 0.60 \\ \hline \end{tabular}