5. The following shows the last 6 columns of the Goody Two-Shoes Dance Studio Spreadsheet for...

Transcribed Image Text:

5. The following shows the last 6 columns of the Goody Two-Shoes Dance Studio Spreadsheet for the month ending April 30, 20X1. a. Complete the spreadsheet calculating Net Income (Net Loss) and finishing the Balance Sheet columns. GOODIE TWO-SHOES DANCE STUDIO SPREADSHEET APRIL 30, 20X1 Name of Account Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit Cash 13,752 Accounts Receivable 9,840 Prepaid Rent Equipment 2,280 23,050 Acc. Depreciation - Equipment 4,921 Accounts Payable Interest Payable 5,700 157 Notes Payable T. Goodie, Capital * T. Goodie, Drawing 5,672 30,960 3,650 Lessons Revenue 17,590 Salaries Expense 10,840 Rent Expense 760 Depreciation Expense - Equipt. 671 Interest Expense 157 Totals 65,000 65,000 Net Income (Net Loss) Totals * No additional Investments were made this period. b. From the completed spreadsheet prepare the Income Statement, Statement of Owner's Equity, and the "Classified" Balance Sheet for the month ending April 30, 20X1. (Use front and back of sheet) 5. The following shows the last 6 columns of the Goody Two-Shoes Dance Studio Spreadsheet for the month ending April 30, 20X1. a. Complete the spreadsheet calculating Net Income (Net Loss) and finishing the Balance Sheet columns. GOODIE TWO-SHOES DANCE STUDIO SPREADSHEET APRIL 30, 20X1 Name of Account Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit Cash 13,752 Accounts Receivable 9,840 Prepaid Rent Equipment 2,280 23,050 Acc. Depreciation - Equipment 4,921 Accounts Payable Interest Payable 5,700 157 Notes Payable T. Goodie, Capital * T. Goodie, Drawing 5,672 30,960 3,650 Lessons Revenue 17,590 Salaries Expense 10,840 Rent Expense 760 Depreciation Expense - Equipt. 671 Interest Expense 157 Totals 65,000 65,000 Net Income (Net Loss) Totals * No additional Investments were made this period. b. From the completed spreadsheet prepare the Income Statement, Statement of Owner's Equity, and the "Classified" Balance Sheet for the month ending April 30, 20X1. (Use front and back of sheet)