Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a classified balance sheet, in good form, using the adjusted trial balance below for Churchill Productions Inc. on December 31, 2023. HINT: Remember,

image text in transcribed image text in transcribed

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%

Step by Step Solution

3.43 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

Calculations for Classified Balance Sheet Current Assets Cash 2000 Accounts Receivable 9000 Prepaid ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby, Brandy Mackintosh

4th Canadian edition

978-1259269868, 978-1259103292

More Books

Students also viewed these Accounting questions

Question

8.4 Identify common stages in the pathway to addiction.

Answered: 1 week ago