P4-1 need to solve problem in excel ( multiple step statement, retained earnings statement)

PROBLEMS P4-1 (103,4,6) (Multiple-Step Statement, Retained Earnings Statement) The following information is related to Dickinson Company for 2017 Retained earnings balance, January 1, 2017 $980,000 Sales revenue Cost of goods sold Interest revenue Selling and administrative expenses Write-off of goodwill Income taxes for 2017 Gain on the sale of investments Loss due to flood damage Loss on the disposition of the wholesale division (net of tax) 440,000 Loss on operations of the wholesale division (net of tax) 9o,000 Dividends declared on common stock Dividends declared on preferred stock 25,000,000 16,000,000 70,000 4.700,000 820,000 1,244,000 110,000 390,000 $250,000o 80,000 Dickinson Company decided to discontinue its entire wholesale operations (considered a discontinued operation) and to retain its manufacturing operations. On September 15. Diekinson sold the wholesale operations to Rogers Company. During 2017, there were 500,000 shares of common stock outstanding all year. Instructions Prepare a multiple-step income statement and a retained earnings statement