As you can see this is an excel sheet that I'm working on and would like help filling out the sheet specifically the number 7 (paid $250 to creditor).

Requirements 1. Use Excel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs. a. For each transaction record the amount (either an increase or decrease) under the correct account. Enter only non-zero amounts. If an account is not affected by the transaction, leave the amount blank. Be sure to use a minus sign (-) if the amount is a decrease. Enter dividends b. The row totals will be calculated automatically. c. The accounting equation (Assets = Liabilities + Equity) should remain in balance after each transaction. The accounting equation is calculated automatically to the right of the transaction table. 2. Prepare the income statement, statement of retained earnings, balance sheet and statement of cash flows for the company. Each financial statement appears on a separate worksheet tab. Fill in the blue shaded areas using a formula that references the account balances at the end of Description Assets Accounts Office Receivabl Supplie e S Liabili Equity Contribu ted Retained Earnings Accoun Service Rent S ts Common Revenu Expens Expen Payable Stock Dividends e se Total Total Liabiliti Assets es Total A = Equity L.SE Cash Land Received $50,000 cash from Luigi Stefanni and 1 issued stock. Balance Purchased land for 2 $23,000 cash. Balance Purchased $300 of office 3 supplies on account. Balance Received $7,500 cash for 4 services performed. Balance Performed services on 5 account, $2,000. Balance Paid in cash: $1,500 for rent & $1,100 for 6 employees' salaries Balance Paid $250 to oreditor on 7 account. Balance Collected $1,600 from 8 customers on account. Balance 9 Paid $4,000 cash Balance