Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

please use excel and show formulas. image text in transcribed
image text in transcribed
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}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bed And Breakfast IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304131793, 978-1304131799

More Books

Students also viewed these Accounting questions