Question: 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.

Can I please get an answer with a spreadsheet with the formulas

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!