Question: Excel Exercise 1 Goal: Create an Excel worksheet to prepare an income statement, a balance sheet and a statement of changes in equity for a

Excel Exercise 1 Goal: Create an Excel worksheet to prepare an income statement, a balance sheet and a statement of changes in equity for a start-up business. Scenario: You have started a valet parking business called First Class Valet. You have tracked your cash, supplies, revenues, expenses, and other items in a spreadsheet. The totals for each account at the end of your first month are as follows (ignore GST}: 1. Sales Revenues, $400 2. Supplies on hand (asset account), $175 3. Cash, $300 4. Supplies expense, $225 5. Capital, 1 July 2019: $250 6. Salary payable, 8: Salary expense, $50. 7. Drawings: $20 8. Unearned revenue: $75 9. Accounts receivable: $5 Required
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
