Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first picture is the questions and the second picture is the worksheet that you can work off of. The income statement columns and balance

The first picture is the questions and the second picture is the worksheet that you can work off of. The income statement columns and balance sheet columns are the areas that need to be completed. Thanks in advance! (Note: The cash account balance is for the worksheet is 108,560, for some reason it didn't show up in the second picture.) image text in transcribed

image text in transcribed

I have also added pictures of the entire general ledger image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
9 When the worksheet's adjusted trial balance columns are in balance, complete the remainder of the worksheet. Income statement (revenues and expense account balances are carried over to the appropriate income statement debit or credit columns and balance sheet (asset, liability and equity) account balances are carried over to the appropriate balance sheet debit or credit columns. (See pages 131-133 in your textbook for an example.) 10 Total the income statement columns and the balance sheet columns. Debits will not equal credits when you compare the income statement columns and the balance sheet columns. The difference between the debit and credit columns of the income statement is the net income. This must be the same difference when you compare the debit and credit columns of the balance sheet. K37 fx B D E F G M H N Rocky Ram, Inc. Worksheet 12/31/2020 Income Statement Dr Cr Balance Sheet Dr Cr. UP 400 2) Acc. Account Titles 3 1020 Cash in Savings Account 1030 Accounts Receivable 10 1035 Alowance for Doubtful Accounts 1040 Merchandise Inventory 12 1050 Prepaid Insurance 13 1060 Supplies 1510 Office Equipment 15 1515 Accum. Depr - Office Equip 16 1520 Land 17 1530 Building 18 1535 Accum. Depr - Bidg 19 2010 Accounts Payable 20 2020 Wages & Salaries Payable 21 2030 Uneamed Rent Revenue 22 2040 Interest Payable 23 2050 Income Taxes Payable 24 2500 Dividends Payable 25 2700 Notes Payable 26 2800 Mortgage Notes Payable 27 3000 Common Stock 28 3800 Retained Earrings 29 3900 Dividends 4010 Sales Revenue 4100 Sales Returns and Alowances 32 4150 Sales Discounts 33 5010 Cost of Goods Sold 6000 Wage & Salary Expense 35 6010 Insurance Expense 6020 Unis Expense 37 6030 Supplies Expense 6040 Depreciation Expense. Big 6050 Depreciation Expense - Equip 6060 Bad Debt Expense 7000 interest Expense 42 7100 interest Revenue 43 7150 Rent Revenue 9000 Income Tax Expense Totale Nov.TB Unadjusted Til Balance Dr. Cr Ref 60 830 118,000 1,500 201,000 1600 21.000 190,000 47,000 380 000 18,000 11 500 52.000 0 6.000 0 10) 0 8,200 45,000 200,000 190.000 400D 14 200 249.750 21,200 17 273 1,268 267 716.000 6) 3.200 3) 76,220 26 000 5.500 11.000 0 1) 5,958 9) 830 0 7 Adjustments Adjusted Trial Balance Dr. Cr Dr Cr 60,830 118,000 1) 11.500 13,000 23 3.300 197 700 3) 1,200 3.300 24,300 190,000 4) 1,000 48.000 380,000 18,000 5) 500 12,000 52,000 6) 31,500 31.500 7) 6,000 12.000 76 0 8) 15,000 15.000 8.200 45 000 9) 200,000 0 190.000 480 000 142000! 2.319,758 21,200 17,273 1.268 267 31,500 747,500 400 3.600 78.220 26.000 500 6,000 1,000 12 000 11,500 11,500 200,000 205 958 10) 76 906 6 000 6,000 15.000 15.000 40 TEL worksheet AJE Financials TROR LURR GJ2 GL CJE PostTB Ratios GJ1 Ready RI C H 1 2 3 C D Rocky Ram, Inc. General Ledger 4 5 6 Acct. No 1010 Cash Explanation Balance - Nov 30 2017 Post Ref. 7 Debit Credit B 9 17.000 6,000 35 000 10 11 12 13 14 15 16 30 000 Balance Debit Credit 46,100 63,100 69 100 34,100 64,100 33.100 108.560 93,560 91,540 J1 J2 J3 J5 JB J9 J13 J14 31 000 75 460 15 000 2020 17 18 19 20 21 22 23 24 25 1020 Cash in Savings Account Explanation Balance - Nov. 30. 2017 Post Ref. Debit Credit Balance Debit Credit 60 830 Post Ref. Debit Credit 27 28 29 30 31 32 33 34 35 36 1030 Accounts Receivable Explanation Balance - Nov. 30, 2017 Kanga Roo Poodle & Co Poodle & Co Poodle & Co Bulldog Inc Bulldog Inc 17.000 30 000 Balance Debit Credit 75 000 58.000 28.000 105.000 28.000 118.000 104000 J1 J5 JB J9 J10 J11 77 000 77,000 90 000 38 39 1035 Allowance for Doubtful Accts Explanation Balance - Nov 30, 2017 Post Ref. Balance Credit Debit Credit 40 41 Debit 1,500 13 000 AJ9 11 500 43 44 45 46 1040 Merchandise Inventory Explanation Balance - Nov 30, 2017 Post Ref. Debit Credit Balance Debit Credit 201.000 165 000 137.000 133 700 J6 J10 AJ4 36.000 28.000 3.300 48 49 50 51 52 53 54 55 Rocky Ram, Inc General Ledger 57 58 59 60 61 62 03 Acct. No 1050 Prepaid Insurance Explanation Balance - Nov 30, 2017 Post Ref Balance Credit Debit Credit Debit 1.000 A3 400 1,200 66 Nov. TB GJ1 GJ2 GL worksheet Financials AJE Ideas E30 fr =+'GJ1'1F7 D H Post Ref. Debit Credit F Balance Debit Credit 17.000 21 000 24 300 14 A4 4.000 3.300 Post Ref. Debit Balance Credit Credit Debit 130 000 190.000 60.000 Post Ref. Debit Balance Credit Credit Debit A2 1,000 47,000 43.000 Post Ret Debit Credit Balance Debit Credit 380,000 1060 Supplies 69 Explanation TO Balance - Nov. 30, 2017 71 72 73 74 75 76 1510 Office Equipment 77 Explanation 78 Balance - Nov 30, 2017 79 NO 81 82 83 1515 Accum. Depr Office Equip Explanation 85 Balance - Nov 30, 2017 M 67 8 89 90 1520 Land 91 Explanation 92 Balance - Nov 30, 2017 93 94 95 96 1530 Building 97 Explanation 98 Balance - Nov. 30, 2017 90 100 101 102 1535 Accum. Depr.- Building 103 Explanation 104 Balance - Nov 30, 2017 105 106 TOT 100 109 110 111 112 113 114 Acet 115 No. 116 2010 Accounts Payable 117 Explanation 118 Balance - Nov 30, 2017 110 Acne Corporation 120 Bow & Arrow Inc 121 Boa Construction Inc Boa Construction Inc Post Ret Debit Credit Balance Debit Credit 180.000 Post Ref Debit Balance Credit Credit Debit AJI 11,500 12.000 Rocky Ram, Inc. General Ledger Post Ref. Balance Credit Debit Credit Debit 13 12.000 8.000 15,000 52000 40.000 32.000 17.000 20.000 J3 J4 4,000 Post Ref Balance Credit Debit Credit Debit 0 31,500 A5 125 126 2020 Wages & Salaries Payable 127 Explanation Balance - Nov.2017 120 130 131 132 2030 Unearned Rent Revenue Explanation Nov.TB GJ1 Post Ref Debit Credit worksheet AJE Balance Debit Credit Financials GJ2 GL Styles Ideas E30 fx *+'GJ1'.F7 D H Post Ref Debit Credit Debit Balance Credit -12 AJG 6,000 0 6.000 12 000 Post Ref. Debit Credit Debit Balance Credit 131 132 2030 Unearned Rent Revenue 133 Explanation 134 Balance Nov 30 2017 135 136 137 138 13 140 2040 Interest Payable 101 Explanation Balance - Nov 30, 2017 143 144 145 1-46 147 2050 Income Taxes Payable 148 Explanation 140 Balance - Nov 30, 2017 150 151 152 1532500 Dividends Payable 154 Explanation 155 Balance. Now 30 2017 156 157 AJB 76 0 0 Post Ref. Debut Credit Debit Balance Credit AUTO 0 12000 Post Rel Debit Credit Debit Balance Credit J7 8,200 0 8.200 Post Ref. Debit Credit Debit Balance Credit 313 45.000 0 45,000 Rocky Ram, Inc. General Ledger Post 159 160 2700 Note Payable 161 Explanation 162 Balance Nov 30 2017 163 164 105 166 167 16 169 Acct. 170 No. 171 2800 Mortgage Note Payable 172 Explanation 173 Balance - Nov-30 2017 1741 175 176 177 3000 Common Stock 178 Explanation 179 Balance - Nov 30, 2017 130 131 162 1503800 Retained Earnings Explanation 185 Balance Nov 30, 2017 Ret Debit Credit Debit Balance Credit 200.000 200,000 AJZ 200,000 Post Ref. Debit Credit Balance Credit Debit 190.000 Post Ret Debit Credit Debit Balance Credit 150 Post Ref Debit Credit Debit 190390 Dividends 1911 Explanation 192 Balance - Nov 30.2017 190 194 105 10 Balance Credit 5.000 14,200 JT 8.200 Nov.TB GJ1 G2 GL worksheet AJE Financials + *+GJ1'117 D H Post Ref. Debit Credit Debit Balance Credit Post Ref. Debit Credit Debit A B 1973999 Income Summary 19 Explanation 199 Balance - Nov 30, 2017 200 201 202 200 204 205 4010 Sales Revenue 206 Explanation 207 Balance - Nov 30, 2017 208 209 210 2111 212 213 4100 Sales Returns and Allowances 214 Explanation 215 Balance - Nov 30, 2017 216 217 218 219 220 Balance Credit 2.152.758 2.229.758 2.319.758 J6 910 77 000 90,000 Post Ret. Debit Credit Balance Debit Credit 7,200 21,200 14,000 Rocky Ram, Inc. General Ledger Post Ret Debit Credit Balance Debit Credit 15733 17,273 J9 1.540 222 223 Acet 224 No 225 4150 Sales Discounts 226 Explanation 227 Balance Nov 30, 2017 225 229 230 231 232 5010 Cost of Goods Sold 233 Explanation 234 Balance - Nov 30, 2017 235 236 237 230 Post Ret Debut Credit Balance Debit Credit 1204267 1,240,287 1 268 267 36,000 28.000 J10 9.000 240 241 Post Ref Debit Credit Debit Balance Credit 243 6000 Wage & Salary Expense Explanation 245 Balance - Nov 30, 2017 245 247 248 31000 31 500 AJ5 716.000 747 500 Post Ref. Debit 250 251 6010 Insurance Expense Explanation 253 Balance Nov 30, 2017 254 255 256 Credit Debit Balance Credit 3.200 3.600 AJB 400 25 6020 Utilities Expense 260 Explanation 28 Balance No.9.2017 Post Red Debit Credit Balance Credit Debit Nov. TB J14 GJ2 GL GJ1 2.020 worksheet AJE 76220 Financials Styles Ideas E30 fr +GJ1'1F7 c D H F 74 200 76 220 J14 2020 Post Ret Debit Credit Balance Debit Credit 26.000 281 Balance - Nov 30, 2017 262 263 264 255 288 267 6030 Supplies Expense 260 Explanation 269 Balance - Nov 30, 2017 270 271 272 273 274 275 278 277 278 Acct. 279 No. 250 6040 Depreciation Exp.. Bldg. 281 Explanation 282 Balance - Nov. 30, 2017 200 284 2:55 286 Rocky Ram, Inc. General Ledger Post Ret Debit Credit Debit Balance Credit 5.500 6.000 500 Post Ref. Debit Credit Balance Debit Credit 11000 12.000 AJ? 1.000 Post Ref. Debit Credit Balance Debit Credit 0 11,500 AJE 11.500 Post Ref. Debit Credit Balance Debit Credit 5.958 205.98 AT 200.000 203 6050 Depreciation Exp. - Equip 289 Explanation 2:00 Balance - Nov 30, 2017 291 202 200 294 295 6060 Bad Debt Expense 200 Explanation 297 Balance - Nov 30, 2017 29 299 300 301 7000 Interest Expense 302 Explanation 303 Balance - Nov 30, 2017 304 sos 300 307 7100 Interest Revenue 308 Explanation 309 Balance - Nov. 30, 2017 310 311 312 313 314 7150 Rent Revenue 315 Explanation 316 Balance - Nov 30, 2017 317 318 319 320 321 9900 Income Tax Expense Explanation Balance Nov 30, 2017 324 325 Post Ref. Debit Credit Balance Credit Debit AJB 830 905 76 Post Ret Debit Credit Balance Credit Debit O AJO 6.000 0 Post Debit Credit Balance Debit Credit 0 15.000 A110 15 000 Nov.TB GJ1 GJ2 GL worksheet AJE Financials

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Not For Profit Audit Committee Best Practices

Authors: Warren Ruppel

1st Edition

0471697419, 978-0471697411

More Books

Students also viewed these Accounting questions