Coffee & cafe supplier accounting excel

PLEASE COMPLETE FOLLOWING QUESTIONS IN EXCEL, AND PUTTING ANSWERS IN THE WORKSHEET (IN EXCEL).

 

7. Schedules of accounts

a. Create a schedule of accounts receivable balances as at the end of June.

b. Create a schedule of accounts payable balances as at the end of June.

8. Financial statements

a. Prepare an income statement for the month of June.

b. Prepare a statement of stockholders’ equity for the month of June.

c. Prepare a balance sheet as at the end of June.

9. Closing entries

a. Journalise closing entries in the general journal.

b. Post the closing entries from the general journal to the relevant ledger accounts.

10. Post-closing trial balance

Prepare a post-closing trial balance as at the end of June.