Please also include the steps for doing this problem on an excel spreadsheet. I'm not sure where to add the events and where not to on an excel spreadsheet. Thanks!

Financial statement data of American Traveler Magazine include the following items: (Click the icon to view the data.) Read the requirements. Current ratio = Total current assets + Total current liabilities Debt ratio = Total liabilities + Total assets Earnings per Share = (Net income - Preferred dividends) - Weighted average number of common shares outstanding Now, compute American Traveler's current ratio, debt ratio, and earnings per share. (Round all ratios to two decimal places, X.XX.) Debt Ratio Current Ratio Earnings per Share 0.99 1.48 0.65 $ Requirement 2. Compute the three ratios after evaluating the effects of each transaction. Consider each transaction separately. (Round all ratios to two decimal places, X.XX.) i (Click on the icon to view the transactions.) Current Ratio Debt Ratio Earnings per Share a. b. C. 1.38 2.11 0.68 $ 0.71 $ 0.99 0.99 Data table Cash Accounts Receivable, Net Merchandise Inventory Total Assets Accounts Payable Accrued Liabilities Short-term Notes Payable Long-term Liabilities Net Income Common Shares Outstanding Print $ 19,000 80,000 183,000 637,000 104,000 37,000 50,000 224,000 69,000 70,000 shares Done - X - X Requirements 1. Compute American Traveler's current ratio, debt ratio, and earnings per share. Round all ratios to two decimal places. 2. Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately. a. Purchased merchandise inventory of $49,000 on account. b. Borrowed $121,000 on a long-term note payable. c. Issued 7,000 shares of common stock, receiving cash of $107,000. d. Received cash on account, $8,000. Print Done