Prepare a classified balance sheet, in good form, using the adjusted trial balance below for Churchill...

 

Transcribed Image Text:

Prepare a classified balance sheet, in good form, using the adjusted trial balance below for Churchill Productions Inc. on December 31, 2023. HINT: Remember, the adjusted trial balance still has balances in all temporary accounts (they haven't been closed yet). This means the balance in the capital account reflects the beginning balance and will need to be amended when preparing the classified balance sheet at December 31 (in order to balance). Try to use a T-account to calculate the ending balance in this account! Use proper Excel formulas to show calculations. Use cell-references to the data. Account Cash Accounts receivable Prepaid rent Prepaid insurance Supplies Land Building Accumulated amort. - building Equipment Accumulated amort.- equipment Accounts payable Churchill Productions Adjusted Trial Balance December 31, 2023 $ Debit 2,000 9,000 5,000 2,500 3,200 30,000 50,000 35,000 $ Credit 10,000 7,000 8,000 1 12 13 122 14 15 16 17 18 19 20 21 23 24 File 26 27 28 29 30 31 32 33 Undo AutoSave Ready Home Insert Page Layout Formulas S LA Paste Off H ACC2310 (020)-W23 - TT2 - Student Name.xlsx ✓ V Clipboard N Cash Accounts receivable Prepaid rent Prepaid insurance Supplies Land A B Question 4 - Classified Balance Sheet V X✓ fx Accounts payable Salaries payable Interest payable Mortgage payable (due 12/31/2028) Lisa Churchill, Capital Lisa Churchill, Withdrawals 34 35 36 37 38 39 40 41 42 43 44 45 Classified Balance Sheet: Service revenue Salary expense Insurance expense Calibri Building Accumulated amort. - building Equipment Accumulated amort. - equipment Supplies expense Total B I U v Account Rent expense Utilities expense Advertising expense Amortization expense -building Amortization expense -equipment CoverPage Q1 Accessibility: Investigate 02 H Font Churchill Productions Adjusted Trial Balance December 31, 2023 Q3 9 Q4 ^ Data Review View A^ A A Ś $ Q5 с Debit Fy 2,000 9,000 5,000 2,500 3,200 30,000 50,000 35,000 10,000 Q6 == = = = = E Ś D Credit (+) 10,000 7,000 8,000 3,000 1,000 40,000 84,900 28,000 5,000 12,000 15,000 9,000 10,000 7,000 1,200 233,900 $ 233,900 80,000 Automate Help ab Wrap Text Alignment 25 marks O Search Merge & Center F G H Marks Student Q Search N General I $ % 9 500 000 Number J K N Conditional Format as Cell Formatting ✓ Table Styles ✓ Styles L M I N O 1 ←T 明 Insert Delete Format Р Cells Q R Σ ↓ Sami Abbas S 28 Sort & Find & Filter Select ✓ Editing B SA T U E Comments Analyze Data Analysis V Sensitivity Sensitivity W Share X 6:45 PM 2023-03-15 X 78% Prepare a classified balance sheet, in good form, using the adjusted trial balance below for Churchill Productions Inc. on December 31, 2023. HINT: Remember, the adjusted trial balance still has balances in all temporary accounts (they haven't been closed yet). This means the balance in the capital account reflects the beginning balance and will need to be amended when preparing the classified balance sheet at December 31 (in order to balance). Try to use a T-account to calculate the ending balance in this account! Use proper Excel formulas to show calculations. Use cell-references to the data. Account Cash Accounts receivable Prepaid rent Prepaid insurance Supplies Land Building Accumulated amort. - building Equipment Accumulated amort.- equipment Accounts payable Churchill Productions Adjusted Trial Balance December 31, 2023 $ Debit 2,000 9,000 5,000 2,500 3,200 30,000 50,000 35,000 $ Credit 10,000 7,000 8,000 1 12 13 122 14 15 16 17 18 19 20 21 23 24 File 26 27 28 29 30 31 32 33 Undo AutoSave Ready Home Insert Page Layout Formulas S LA Paste Off H ACC2310 (020)-W23 - TT2 - Student Name.xlsx ✓ V Clipboard N Cash Accounts receivable Prepaid rent Prepaid insurance Supplies Land A B Question 4 - Classified Balance Sheet V X✓ fx Accounts payable Salaries payable Interest payable Mortgage payable (due 12/31/2028) Lisa Churchill, Capital Lisa Churchill, Withdrawals 34 35 36 37 38 39 40 41 42 43 44 45 Classified Balance Sheet: Service revenue Salary expense Insurance expense Calibri Building Accumulated amort. - building Equipment Accumulated amort. - equipment Supplies expense Total B I U v Account Rent expense Utilities expense Advertising expense Amortization expense -building Amortization expense -equipment CoverPage Q1 Accessibility: Investigate 02 H Font Churchill Productions Adjusted Trial Balance December 31, 2023 Q3 9 Q4 ^ Data Review View A^ A A Ś $ Q5 с Debit Fy 2,000 9,000 5,000 2,500 3,200 30,000 50,000 35,000 10,000 Q6 == = = = = E Ś D Credit (+) 10,000 7,000 8,000 3,000 1,000 40,000 84,900 28,000 5,000 12,000 15,000 9,000 10,000 7,000 1,200 233,900 $ 233,900 80,000 Automate Help ab Wrap Text Alignment 25 marks O Search Merge & Center F G H Marks Student Q Search N General I $ % 9 500 000 Number J K N Conditional Format as Cell Formatting ✓ Table Styles ✓ Styles L M I N O 1 ←T 明 Insert Delete Format Р Cells Q R Σ ↓ Sami Abbas S 28 Sort & Find & Filter Select ✓ Editing B SA T U E Comments Analyze Data Analysis V Sensitivity Sensitivity W Share X 6:45 PM 2023-03-15 X 78%

Answer rating: 100% (QA)

Calculations for Classified Balance Sheet Current Assets Cash 2000 Accounts Receivable 9000 Prepaid ... View the full answer