Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please include all of the EXCEL FORMULAS used to compute Using the financial statements below for the Global Manufacturing corporation, a. Compute common-size financial statements.
Please include all of the EXCEL FORMULAS used to compute
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} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started