Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I please get an answer with a spreadsheet with the formulas view attached to the answer? So I can see the excel formulas used,

Can I please get an answer with a spreadsheet with the formulas view attached to the answer? So I can see the excel formulas used, as well as the answer obtained.

image text in transcribed

H 1 L M N o Q B E 1 Prepare the common-size, and common-base year of the Statement of Comprehensive Income for O'Leary Industrial Supply using the spreadsheets below. 3 2 4 5 6 Common-size Income Statement 7 O'Leary Industrial Supply Income Statement for the years ended December 31 2017 2018 1,542,700 1,841,300 1,174,800 1,397,400 367,900 443,900 2018 2019 2019 1,605,100 1,258,900 346,200 443,900 346,200 8 9 10 11 Sales 12 Cost of goods Sold 13 Gross Margin 14 Operating expenses 15 Administrative expenses 16 Selling expense 17 amortization 18 Total oper. Expenses 19 Operating income 20 (-) Interest expenses 21 Earnings before tax 22 Income taxes 23 Net Income 24 25 187,900 106,300 16,000 310,200 57,700 50,100 7,600 2,200 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122,100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1,100 Common-base year Income Statement 2017 Sales Cost of goods Sold Gross Margin 367,900 Operating expenses Administre 187,900 Selling ex: 106,300 amortizati 16,000 Total oper 310,200 Operating income 57,700 (-) Interest expenses 50,700 Earnings before tax 7,600 Income taxes 2,200 Net Income 5,400 141,270 115,580 14,400 271,250 172,650 50,550 122, 100 27,100 95,000 146,950 118,700 14,000 279,650 66,550 65,100 1,450 350 1,100

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

Public Finance

Authors: Harvey Rosen, Ted Gayer

10th edition

9781259716874, 78021685, 1259716872, 978-0078021688

More Books

Students also viewed these Finance questions

Question

I W/7y were you so motivated and able to work so productively?

Answered: 1 week ago