Question: solve the question by using Microsoft Excel. 2. Create the sheet below to show the Income Statement of eastern Petroleum for the first half of
solve the question by using Microsoft Excel.
2. Create the sheet below to show the Income Statement of eastern Petroleum for the first half of year 2019. (8 marks) Income $1,900,000 Eastern Petroleum Income Statement For the Year Ended June 30, 2019 Expenses Net Sales Cost of Goods Sold $1,050,000 Gross Margin Operating Expenses Selling Expenses $50,000 Administrative Expenses $40,000 Total Operating Expenses Income from Continuing Operations Before Taxes Income Taxes Expense $300.000 Income from Continuing Operations Discontinued Operations Loss from Discontinued Operations $50,000 Taxes of Discontinued Operations $35,000 Total Loss from Discontinued Operations Income Before Extraordinary Items Extraordinary Items Income Net Income 12.500 A. Calculate the grey cells using simple arithmetic operators
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
