Needs to follow this example below:

M10 CORPORATE INCOME STATEMENT The fellowing data were selected trom the records ot Magnus Incorporated for the month ended February 2os ra $10,100 Insurance expense 500 ~Interest expense $500 2,500 + Depreciation expense-office Doorecialtn exponsal-store 2.500s pol of2,000 expense-store 2,500 -Loss from dis equipment businessof Merchandise inventory, 10,000-Merchandise inventory -Office salaries expense 75,000 68,000 17,000 Extraordinary loss February 28 - Income tax: On continuing operations 15,000 Office 1,025 -Reduction applicable 4,500-purchases 300,000 from disposal of a of the business segment Rent expense - Sales 500 452.500 15,000 r Reduction applicable to extra- 1,100 les salaries expense Store supplies expense system generates these totals on a monthly basis. You have been asked ordinary loss 2,525 This firm's accounting to develop a worksheet (file name IS) that will allow a monthly income statement to be prep by entering monthly figures in the appropriate section for earnings per share. There were 20,000 shares of common stock (no preferred) cells. The income statement should include a outstanding throughout the month. Use the provided data as input for your worksheet. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: February net income, $50,950. To test your model, use the following data for the month ended March 31 Advertising expense Depreciation expense- $11,500 Insurance expense $ 500 Interest expense 810 Loss from disposal of a segment 1,000 of business (additional expenses from February office equipment 3235 disposal) expense- 3,325 Merchandise inventory, March 1 68,000 store equipment Extraordinary loss 7,500 Merchandise inventory, March 31 70,000 (additional expenses from February loss) 164