Unadjusted | Adjusted | |||||||||
Trial Balance | Adjustments | Trial Balance | Income Statement | Balance Sheet | ||||||
Cash | 270,788 | 270,788 | 270,788 | |||||||
Accounts receivable | 1,070,384 | 1,070,384 | 1,070,384 | |||||||
Allowance for doubtful accounts | 18,513.6 | 74,567.14 | 93,080.74 | 93,081 | ||||||
Interest receivable | 8,530.525 | 8,531 | 8,531 | |||||||
Note receivable | 359,180 | 359,180 | 359,180 | |||||||
Merchandise inventory | 782,572 | 782,572 | 782,572 | |||||||
Prepaid insurance | 28,728 | 19,152 | 9,576 | 9,576 | ||||||
Prepaid rent | 47,880 | 6,390 | 41,490 | 41,490 | ||||||
Supplies | 121,296 | 116,622 | 4,674 | 4,674 | ||||||
Equipment | 1,118,264 | 1,118,264 | 1,118,264 | |||||||
Accumulated depreciation-Equipment | 118,104 | 110,626.4 | 228,730.4 | 228,730 | ||||||
Accounts payable | 111,826.4 | 111,826.4 | 111,826 | |||||||
Salaries & Wages payable | 71,490 | 71,490 | 71,490 | |||||||
Unearned revenue | 32,000 | 12,000 | 20,000 | 20,000 | ||||||
Interest payable | 15,920.1 | 15,920.1 | 15,920 | |||||||
Utilities payable | 12,314 | 12,314.0 | 12,314 | |||||||
Note payable (final payment due 2023) | 758,100 | 758,100 | 758,100 | |||||||
Common stock | 585,200 | 585,200 | 585,200 | |||||||
Retained earnings | 904,400 | 904,400 | 904,400 | |||||||
Dividends | 234,080 | 234,080 | 234,080 | |||||||
Sales | 11,179,980 | 11,179,980 | 11,179,980 | |||||||
Consulting Revenue | 12,000 | 12,000 | 12,000 | |||||||
Sales returns and allowances | 63,840 | 63,840 | 63,840 | |||||||
Sales discounts | 137,256 | 137,256 | 137,256 | |||||||
Cost of goods sold | 7,612,388 | 7,612,388 | 7,612,388 | |||||||
Salaries & wages expense | 1,733,256 | 71,490 | 1,804,746 | 1,804,746 | ||||||
Depreciation expense-equipment | 110,626.4 | 110,626 | 110,626 | |||||||
Bad debt expense | 74,567.14 | 74,567 | 74,567 | |||||||
Insurance expense | 19,152 | 19,152 | 19,152 | |||||||
Rent expense | 6,390 | 6,390 | 6,390 | |||||||
Supplies expense | 116,622 | 116,622 | 116,622 | |||||||
Utilities expense | 128,212 | 12,314 | 140,526 | 140,526 | ||||||
Interest revenue | 8,530.525 | 8,530.525 | 8,531 | |||||||
Interest expense | 15,920.1 | 15,920 | 15,920 | |||||||
13,708,124 | 13,708,124 | 447,612.165 | 447,612.165 | 14,001,572.165 | 14,001,572.165 | 10,102,033.640 | 11,200,510.525 | 3,899,538.525 | 2,801,061.640 | |
Net income | 1,098,476.885 | 1,098,476.885 | ||||||||
11,200,510.525 | 11,200,510.525 | 3,899,538.525 | 3,899,538.525 |
Calculations:
a | Interest expense for six months (July1 to Dec31) = 758,100 x 4.2% x (6/12) = 15,920.1 |
b | Insurance expense for 8 months (May1 to Dec31) = 28,728 x (8/12) = 19,152 |
c | Rent expense for 2 months (Nov1 to Dec31) = 12,780 x (2/4) = 6,390 |
d | Consulting revenue from unearned for 3 months (Oct1 to Dec31) = 32,000 x (3/8) = 12,000 |
e | Supplies expense = Supplies - Supplies on had = 121,296-4,674 = 116,622 |
f | Depreciation expense =[1,118,264-12,000]/10 years = 110,626.4 |
g | Interest revenue for 5 months (Aug1 to Dec31) = 359,180 x 5.7% x (5/12) = 8,530.525 |
h | Bad debt expense = 74,567.14 |
i | Wages expense = 71,490 |
j | Utilities expense = 12,314 |
Please note that for bad debt expense i relied upon your calculation because no additional information available to calculated bad debt expense.
this is my assumption and trial balance. I added the adjustments but i made a mistake...
please prepare closing entries. 41.400 4.674 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet Cash 270,788 270,78% 270,788 Accounts receivable 1,070,384 1.070,384 1,070,384 Allowance for doubtful accounts 18,513,6 74.567.14 93,080.74 93,081 Interest receivable 8.530.525 8,531 8.531 Nole receivable 359,180 359.180 359,180 Merchandise inventory 782.572 782,572 782,572 Prepaid insurance 28,728 19,1529,576 9.576 Prepaid rent 47.880 6,390 41,490 Supplies 121.296 116.622 4,674 Equipment 1,118,264 1,118,264 1,118,264 Accumulatod depreciation Equipment 118,104 110,626.4 228.730.4 228.730 Accounts payable 111.826.4 111,826.4 111,826 Salaries...
I need help with making sure the adjusting journal entries are correct and I'm not sure why the adjusted trail balances aren't equaling each other. Please help with both! The information for the journal entries is the first posted piece of information starting with On July 1, 2019. | a. Use the following information to prepare adjusting entries for Broomfield Industries: On July 1, 2019, Broomfield Industries signed a 4.2% bank loan due in 3 years. This is the only...
prepare an income statement and a statement of retained earnings. 4.674 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet Cash 270,788 270,788 270,78% Accounts receivable 1,070,384 1.070,384 1.070,384 Allowance for doubtful accounts 18.313.6 74,567.14 93,080.74 93,081 Interest receivable $_3530525 8.531 8,531 Note receivable 359.180 359.180 359.180 Merchandise inventory 782.572 782.572 782572 Prepaid insurance 28,728 19,152 9.576 9.576 Prepaid rent 47,880 6,390 41,490 41.490 Supplies 121.296 116.622 Equipment 1,118,264 1.118,264 1.118,264 Accumulated depreciation Equipment 118,104 110.626.4 228.730.4 228.730...
please prepare a balance sheet. Unadjusted Adjusted Trial Balance Adjustments Trial Balance Income Statement Balance Sheet Cash 270.788 270,788 270.78 Accounts receivable 1,070,384 1.070,384 1.070,384 Allowance for doubtful accounts 18.313.6 74,567.14 93,080.74 93.081 Interest receivable 8,530.525 8,531 8531 Note receivable 359,180 359.180 359.180 Merchandise inventory 782.572 782.572 782.572 Prepaid insurance 28,728 19,1529,576 9.576 Prepaid rent 47,880 6.390 41,490 41.490 Supplies 121.296 116,622 4.674 4.674 Equipment 1.118.264 1.118,264 1.118.264 Accumulated depreciation Equipment 118,104 110,626.4 228.730.4 228.730 Accounts payable 111.826.4 111.826.4 111.826...
I need help with the adjusting trail balance they aren't adding up and I'm not sure what I've done wrong. F 5 Account Title Income Statement DR CR Balance Sheet DR CR | 7 Cash 8 Accounts Receivable 9 Allowance for Doubtful Accounts 10 Interest Receivable 11 Note Receivable 12 Merchandise Inventory 13 Prepaid Insurance 14 Prepaid Rent 15 Supplies 16 Equipment 17 Accumulated Depreciation - Equipment 18 Accounts Payable 19 Salaries & Wages Payable 20 Uneamed Revenue 21 Interest...
I need help with this worksheet, I mostly with the I/S and B/S. Have I done it right so far? I also need to generate an Income statement, statement of retained earnings, Ballance sheet, and closing entries with this information. Any help would be appreciated! Account Title Cash Accounts Receivable Allowance for Doubtful Accounts Interest Receivable Note Receivable Merchandise Inventory Prepaid Insurance Prepaid Rent Supplies Fauipment Accumulated Depreciation - Equipment Accounts Payable Salaries & Wages Payable Unearned Revenue Interest Pavable...
can you help me spot my errors in the assumption? Use the following information to prepare adjusting entries for Broomfield Industries: On July 1, 2019, Broomfield Industries signed a 4.2% bank loan due in 3 years. This is the only outstanding note payable. b. Prepaid insurance represents a 12-month insurance policy purchased on May 1. On November 1, 2019, Broomfield Industries paid $12,780 for a 4-month lease for office space. Unearned revenue represents a 8-month contract for consulting services. The...
Use the following adjusting entries to complete the worksheet, prepare an income statement, statement of retained earnings, closing entries, and balance sheet. Broomfield Company Adjusting Journal Entries For the Year Ended December 31, 2019 Account Titles DR CR a. Interest Expense 15,920 Interest Payable 15,920 b. Insurance Expense 19,152 Prepaid Insurance 19,152 c. Rent Expense 23,940 Prepaid Rent 23,940 d. Unearned Revenue 12,000 Consulting Revenue 12,000 e. Supplies Expense 116,622 Supplies...
I need help completing this worksheet please Account Title Income Statement DR CR T End of Period Worksheet For the Year Ended December 31, 2019 Unadjusted Trial Balance Adjustments DR CR DR CR 270,788 1,070,384 18,514 8,531 359,180 782,572 28,728 19,152 47,880 6,390 121,296 43,206 1.118.264 118.104 110,626 | 111,826 71,490 32,000 12,000 15,920 12,314 758,100 585,200 904,400 234,080 11,179,980 12.000 63,840 137,256 7,612,388 1,733,256 71.490 110.626 Cash Accounts Receivable Allowance for Doubtful Accounts Interest Receivable Note Receivable 2 Merchandise...
Can I get help writing closing entries from this worksheet? WN 5 Account Title 7 Cash 8 Accounts Receivable 9 Allowance for Doubtful Accounts 10 Interest Receivable 11 Note Receivable 12 Merchandise Inventory 13 Prepaid Insurance 14 Prepaid Rent 15 Supplies 16 Equipment 17 Accumulated Depreciation - Equipment 18 Accounts Payable 19 Salaries & Wages Payable 20 Unearned Revenue 21 Interest Payable 22 Utilities Payable 23 Note Payable (final payment due 2023) 24 Common Stock 25 Retained Earnings 26 Dividends...