I need to prepare a multi-step income statement including all mathematical work.

Intermediate Accounting I Assessment Assignment A Fall 2015 Technology Selected account balances of Todd Co. for 2015 along with additional information as of December 31, 2015 are as follows: Bad debts expense 32,000 Delivery expense 425,000 Depreciation expense - delivery trucks 25,000 Depreciation expense - office building 29,000 Depreciation expense - office equipment 15,000 Depreciation expense - store equipment 20,000 Dividend revenue 35,000 Dividends declared 150,000 Employee pension expense 190,000 Freight-in 145,000 Gain on sale of office equipment 9,000 Provision for income taxes 427,425 Interest revenue 10,000 Inventory, Jan 1, 2015 775,000 Inventory, Dec 31, 2015 aafter write-down for obsolete inventory 750,000 Loss on sale of investment securities 20,000 Loss on write-down of obsolete inventory 75,000 Miscellaneous general expense 45,000 Miscellaneous selling expense 50,000 Office and officers' salaries 550,000 Property tax expense 100,000 Purchase discounts 47,700 Purchases 4,633,200 Sales 8,125,000 Sales discounts 55,000 Sales returns and allowances 95,000 Sales salaries 521,000 Todd Co. has 30,000 shares of stock outstanding. Prepare a multi-step income statement for the year ended December 31, 2015. Use Excel tools and formulas for summation, addition, subtraction and division. Submit to the appropriate Moodle drop box