Please Insert your answers in the excel template provided at bottom:

After returning from vacation, the accountant of Online Buying Inc. was dismayed to discover that the income statement for the year ended December 31,2020, was prepared incorrectly. All amounts included in the statement are before tax (assume a rate of 40% ). The company had 200,000 common shares issued and outstanding throughout the year as well as 70,000$1.00 cumulative preferred shares. Dividends had not been paid for the past two years (2018 and 2019). Retained earnings at December 31,2019 , were $171,000. Required Please revise the income statement, including earnings per share information