Answered step by step
Verified Expert Solution
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.
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,100Step 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