can you kindly assist me with the correct answer. Also i would really appreaciate if you can provide me with the solution in an excel sheet and share the link with me . Thank you so so much

THIS COULD BE ONE OF YOUR Debits Credits Plano Co. 12/31/13 Partial Trial Balance Data 700,000 60.000 110,000 Sales revenue Interest revenue Gain on sale of investments (infrequent but not unusual item) Cost of goods sold Selling expenses Restructuring costs Interest expense General and administrative expenses 500,000 150,000 40,000 30,000 60,000 Plano had 50,000 shares of stock outstanding throughout the year. Income tax expense has not yet been accrued. The effective tax rate is 30% of income Before Taxes Required: (3 pts each) SHOW ALL WORKINGS Total of 15 pts Prepare a multi-step income statement and provide answers for the following: a) What is the Gross Profit amount b) What is the total operating expenses c) What is the total other income (expense) net d) What is the net income e) What is the Earnings Per Share