please answer in excel

Requirements 1. Prepare the income statement for the month ended July 31, 2018. 2. Prepare the statement of retained earnings for the month ended July 31, 2018. The beginning balance of retained earnings was $0. 3. Prepare the balance sheet as of July 31, 2018. 4. Calculate the debt ratio as of July 31, 2018. Data table Sharon Sutton, Registered Dietician Trial Balance July 31, 2018 Account Title Balance Debit Credit Cash $ 36,000 8,800 1,900 Accounts Receivable Office Supplies Prepaid Insurance Equipment 2,200 14,000 Data table 14,000 $ 2,700 Equipment Accounts Payable Unearned Revenue Notes Payable Common Stock 7,266 24,000 27,000 Dividends 2,400 7,184 Service Revenue Salaries Expense Rent Expense 1,900 850 100 toe onanen - X Data table 7,266 Unearned Revenue Notes Payable Common Stock 24,000 27,000 Dividends 2,400 7.184 1,900 Service Revenue Salaries Expense Rent Expense Utilities Expense 850 100 $ 68,150 $ 68,150 Total Requirement 1. Prepare the income statement for the month ended July 31, 2018. (If a box is not used in the statement, leave the box empty; do not select a label or enter a zero.) Sharon Sutton, Registered Dietician Income Statement Month Ended July 31, 2018 Requiremont 2. Prepare the statement of retained earnings for the month ended July 31, 2018. The beginning balance of retained earnings was $0. (Enter any increases in retained earnings prior to the subtotal and any decreases to retained eamings below the subtotal. Enter a "0" for any zero balances.) Sharon Sutton, Registered Dletician Statement of Retained Earnings Month Ended July 31, 2018 Retained Earnings, July 1, 2018 Retained Earnings, July 31, 2018 Requirement 3. Prepare the balance sheet as of July 31, 2018. (If a box is not used in the statement, leave the box empty; do not select a label or enter a zero.) Sharon Sutton, Registered Dietician Balance Sheet July 31, 2018 Assets Liabilities Stockholders' Equity Requirement 4. Calculate the debt ratio as of July 31, 2018. Select the debt ratio formula on the first line and then calculate the ratio. Debt ratio %