please help i had 3 people help me and none of them did it correct please help thank you so much. please use a spreadsheet like the ones on the images above..

Transactions; Financial Statements Bev's Dry Cleaners is owned and operated by Beverly Zahn. A building and equipment are currently being rented, pending expansion to new facilities. The actual work of dry cleaning is done by another company for a fee. The assets and the abilities of the business on November 1, 2019, are as follows: Cash, $18.480; Accounts Receivable, $37,840; Supplies, $3,520; Land, 544,000; Accounts payable, 515,840. Business transactions during November are summarized as follows: a. Beverly Zahn invested additional cash in the business with a deposit of $33,000 in the business bank account, b. Purchased land adjacent to land currently owned by Bev's Dry Cleaners to use in the future as a parking lot, paving cash of $15.000. c. Pald rent for the month, $12,140. d. Charged customers for dry cleaning revenue on account, $34,410, e. Pald creditors on account, $14.170. 1. Purchased supplies on account, $6,070. 9. Received cash from cash customers for dry cleaning revenue, $32,380, h. Received cash from customers on account. $40,480. 1. Received monthly invoice for dry cleaning expense for November (to be paid on December 10). $16.190 J. Pald the following: wages expense, 58,910, truck expense, 53,240; Utilities expense, 53,440 miscellaneous expense, $1.540 * Determined that the cost of supplies on hand was $8,170; therefore, the cost of supplies used during the month was 51,420. 1. Withdrew $9,300 cash for personal use. Required: 1. Determine the amount of Beverly Zahn's capital as of November 1. 88,000 5 2. Use the attached spreadsheet to complete part 2. Click on the Spreadsheet kon above to open and save the Excel file to your computer. Your input it to the spreadsheet will not be included in your grade in CengageNOW on this problemi 3. Using the balances from the series prepare an income statement for November, a statement of mercy for swimber, and a balance sheet of aber 30.00 Indicate a los aplicable Income Statement Cleaners Statement ork 1 Dry cleaning Wage - . 10 11 Statement of Owner's Equity Bev's Dry Cleaners Statement of Owner's Equity for the Month Ended November 30, 2019 $ Beverly Zahn, capital. November 1, 2019 88,000 $ 2 Additional investment during November 33,000 3.Net Income for November 4 Withdrawals 9,300 5 Increase in owners equity 6 Beverly Zahn, capital November 10, 2019 Balance sheet as of November 30: When entering assets, enter them in order of liquity Balance Sheet Hey's Dry Cleaners Balance Sheet November 10, 2012 Liabilities Accounts payable 1 Assets 2 Cash Account cele 4 Supplies [ 17 5 Land . Owner's Equity Bredbantal - Totes and owner's equity Totalets pl et ook THE Spreadshee! Printer 4. Prepare a statement of cash flows for November Use the minus sign to indicate cash outflows, decreases in cash, and cash payments. Statement of Cash Flows Bev's Dry Cleaners Statement of Cash Flows - For the Month Ended November 30, 2019 1 Cash flows from operating activities 2 Cash receipts from customers " Cosh payments for expenses and payments to creditors . Nutcash flow from operating activities TI 5. Cathed for investing activities Cash payment for purchase of land Cith flows from finding activities maccipkot owners investment as withdrawal 10 Net cash flow from financing activities 11 Net Increase in cash during November I'000 12 Cash balance, November 1, 2019 13 Cash balance, November 30, 2019