Please answer in spreadsheet form. Thank you in advance for your help

Requirements 1. Calculate the profit margin ratio for 2019 and 2018. 2. Calculate the rate of return on total assets for 2019 and 2018 3. Calculate the asset turnover ratio for 2019 and 2018. 4. Calculate the rate of return on common stockholders' equity for 2019 and 2018. 5. Calculate the earnings per share for 2019 and 2018. 6. Calculate the 2019 dividend payout on common stock. Assume dividends per share for common stock are equal to $0 37 per share. 7. Did the company's operating performance improve or deteriorate during 2019? Data table McKnight, Inc. Comparative Income Statement Years Ended December 31, 2019 and 2018 Dollars in thousands 2019 2018 2017 Net Sales Revenue $ 188,000 $ 152,000 Cost of Goods Sold 94,500 83,000 46,500 44,000 Selling and Administrative Expenses Interest Expense 9,000 11,500 Income Tax Expense 13,000 8,500 $ 25,000 $ 5,000 Net Income Data table Cost of Goods Sold 94,500 83,000 46,500 44,000 Selling and Administrative Expenses Interest Expense 11,500 9,000 13,000 Income Tax Expense 8,500 5,000 Net Income $ 25,000 $ Additional data: Total Assets $ 208,000 $ 190,000 $ 168,000 96,500 85,000 79,000 Common Stockholders' Equity Preferred Dividends Common Shares Outstanding During the Year 2,500 2,500 0 30,000 30,000 25,000