Question

1 Approved Answer

Posted on Jul 30, 2024

Copy of ACCT550CourseProjectWorksheetAlt8- Microsoft Excel non-c Home Insert Page Layout Formulas Data Review View Cut General Arial copy B l u.lit'lls-a- Merge & Center.. $.

Copy of ACCT550CourseProjectWorksheetAlt8- Microsoft Excel non-c Home Insert Page Layout Formulas Data Review View Cut General Arial copy B l u.lit'lls-a- Merge & Center.. $. % , ma Paste BIUA E Formatting as T Styles Format Painter Clipboard Font Alignment Number 130 8 165,700 1.776,816 1750,700191,816(26,116) 2,650 5 Account Receivable 6 Allowance for Doubtful Accounts 7 Notes Receivable (due 20xx0) 8 Inventories$25/unit 9 Long-term Investments in Warren Co 10 Land 11 Building and Equipment 2 Accumulated Depreciation's 13 Copyrights 14 Patents 2,650 16,000 16,000 15,250 95,630 12,500 1268,000 1.583,250 (1.268 000) 95,630 12,500 1,120,000 1,120,000 350,000 350,000 112,000 219,335 115,000 225,000 47.200 112,000 219,335 115,000 15 Trademarks 16 Goodwill 17 Deposits With Vendors 18 Accounts Payable 19 Income Taxes Payable 225,000 47,200 200,500 42,340 1,268 000 (1,268,000) 1,468,500 42,340 0 Interest Payable 21 Customer Deposits (expected to be paid in 20Xx) 222% Notes Payable to Banks (due 2009 23 Mortgage Payable ($2,780 per month) 24 Twenty-year, 3% Bonds, Due 1/1/20xx 25 Common Stock 26 Additional Paid-in Capital 27 Retained Earnings 28 Sales Revenue 29 Rental Revenue 375 26,000 667,200 600,000 44,850 40,000 375 26,000 667,200 600,000 544,850 127,500 1.776316(1,7/6,816)1,776,816 0 Cost of Goods Sold 31 Selling Expenses 2 Uncolectible Account Expense 33 Interest Expense sBegnnng Bala Copy of ACCTS orksheetAltB- Microsoft Excel n Home Insert Page Layout Formulas Data ReviewView Cut Arial 10AWrap TextGeneral a Copy , JFormat Painter B 1 'iO-A- aMerge & Center. S. % , ad Condition Formatting Clipboard ent Number J30 The Beg. Trial Balance is linked. Beginning Trial Balance Journal Entries Ending Trial Balance Credit Debit Credit Debit Credit 1,796,000 (1.750,700 Debit 45,300 165,700 1,750,700 1,776,816 1750,700 191,816(26,116) Account Receivable Allowance for Doubtful Accounts Notes Receivable (due 20x00 Inventories @$25/unit Long-term Investments in Warren Co 2,650 2,650 16,000 315,250 95,630 12,500 ,120,000 16,000 1,268,000 95,630 12,500 Building and Equipment Accumulated Depreciation's 350,000 4 Patents 5 Trademarks 6 Goodwll 112,000 219,335 15,000 225,000 47 200 112,000 219,335 115,000 225,000 7 Deposits With Vendors 8 Accounts Payable 9 Income Taxes Payable 200,500 42,340 20 Interest Payable 21 Customer Deposits (expected to be paid in 20000) 22.2% Notes Payable to Banks (due 2000 375 26,000 667 200 23 Mongage Payable ($2,780 per month) 24 Twenty-year, 3% Bonds, Due 1/1/20XX 25 Common Stock 26 Addtional Paid-In Capital 27 Retained Earnings 375 26,000 667 200 600,000 544,850 40,000 127 500 1.776 816 (1776816/ 1776816 600,000 I 544,850 40,000 127,500 28 Sales Revenue 29 Rental Revenue 30 Cost of Goods Sold O Type here to search sc 1 inventory 260,000 420,000 48,000 240,000 Accounts payable To record for inventory purchased from suppliers) 1,268,000 2 Accounts Payable 1,124,450 10 Cash 1,124,450 To record for payment made to supplier) 3 Account Receivable 12 13 14 1,776,816 Sales Revenue 776,816 (To record for payments from customens) 4 Account Receivable 15 16 17 18 5 interest Expense 1,750,700 Cash 1,750,700 To record cash collected from customers) 17,415 19 20 21 Cash 7,415 (To record for total interest paid) 6 Cash 25,650 Rental Revenue 25,650 23 24 25 26 To record for property leased using rental income) Loss on sale of building and equipment Accumulated Depreciation To record for disposal of the store 7 Cash 59.200 35,800 25,000 Building and Equipment 28 120,000 29 8 Bad Debt Expense 522 Allowance for doubtful debts To record for total interest paid) Cash 25,650 Rental Revenue 25,650 To record for property leased using rental income) Loss on sale of building and equipment Accumulated Depreciation To record for disposal of the store) 7 Cash 59,200 35,800 25,000 Building and Equipment 120,000 8 Bad Debt Expense 522 Allowance for doubtful debts 522 To record doubtful debts made) 9 Selling and Administrative expenses 128,475 (56,000 Cash To record for selling and administration expenses being paid) 10 Income tax Expense 72,475 90,500 Cash 7 38 39 90,500 To record for income tax being paid) Copy of ACCT550CourseProjectWorksheetAlt8- Microsoft Excel non-c Home Insert Page Layout Formulas Data Review View Cut General Arial copy B l u.lit'lls-a- Merge & Center.. $. % , ma Paste BIUA E Formatting as T Styles Format Painter Clipboard Font Alignment Number 130 8 165,700 1.776,816 1750,700191,816(26,116) 2,650 5 Account Receivable 6 Allowance for Doubtful Accounts 7 Notes Receivable (due 20xx0) 8 Inventories$25/unit 9 Long-term Investments in Warren Co 10 Land 11 Building and Equipment 2 Accumulated Depreciation's 13 Copyrights 14 Patents 2,650 16,000 16,000 15,250 95,630 12,500 1268,000 1.583,250 (1.268 000) 95,630 12,500 1,120,000 1,120,000 350,000 350,000 112,000 219,335 115,000 225,000 47.200 112,000 219,335 115,000 15 Trademarks 16 Goodwill 17 Deposits With Vendors 18 Accounts Payable 19 Income Taxes Payable 225,000 47,200 200,500 42,340 1,268 000 (1,268,000) 1,468,500 42,340 0 Interest Payable 21 Customer Deposits (expected to be paid in 20Xx) 222% Notes Payable to Banks (due 2009 23 Mortgage Payable ($2,780 per month) 24 Twenty-year, 3% Bonds, Due 1/1/20xx 25 Common Stock 26 Additional Paid-in Capital 27 Retained Earnings 28 Sales Revenue 29 Rental Revenue 375 26,000 667,200 600,000 44,850 40,000 375 26,000 667,200 600,000 544,850 127,500 1.776316(1,7/6,816)1,776,816 0 Cost of Goods Sold 31 Selling Expenses 2 Uncolectible Account Expense 33 Interest Expense sBegnnng Bala Copy of ACCTS orksheetAltB- Microsoft Excel n Home Insert Page Layout Formulas Data ReviewView Cut Arial 10AWrap TextGeneral a Copy , JFormat Painter B 1 'iO-A- aMerge & Center. S. % , ad Condition Formatting Clipboard ent Number J30 The Beg. Trial Balance is linked. Beginning Trial Balance Journal Entries Ending Trial Balance Credit Debit Credit Debit Credit 1,796,000 (1.750,700 Debit 45,300 165,700 1,750,700 1,776,816 1750,700 191,816(26,116) Account Receivable Allowance for Doubtful Accounts Notes Receivable (due 20x00 Inventories @$25/unit Long-term Investments in Warren Co 2,650 2,650 16,000 315,250 95,630 12,500 ,120,000 16,000 1,268,000 95,630 12,500 Building and Equipment Accumulated Depreciation's 350,000 4 Patents 5 Trademarks 6 Goodwll 112,000 219,335 15,000 225,000 47 200 112,000 219,335 115,000 225,000 7 Deposits With Vendors 8 Accounts Payable 9 Income Taxes Payable 200,500 42,340 20 Interest Payable 21 Customer Deposits (expected to be paid in 20000) 22.2% Notes Payable to Banks (due 2000 375 26,000 667 200 23 Mongage Payable ($2,780 per month) 24 Twenty-year, 3% Bonds, Due 1/1/20XX 25 Common Stock 26 Addtional Paid-In Capital 27 Retained Earnings 375 26,000 667 200 600,000 544,850 40,000 127 500 1.776 816 (1776816/ 1776816 600,000 I 544,850 40,000 127,500 28 Sales Revenue 29 Rental Revenue 30 Cost of Goods Sold O Type here to search sc 1 inventory 260,000 420,000 48,000 240,000 Accounts payable To record for inventory purchased from suppliers) 1,268,000 2 Accounts Payable 1,124,450 10 Cash 1,124,450 To record for payment made to supplier) 3 Account Receivable 12 13 14 1,776,816 Sales Revenue 776,816 (To record for payments from customens) 4 Account Receivable 15 16 17 18 5 interest Expense 1,750,700 Cash 1,750,700 To record cash collected from customers) 17,415 19 20 21 Cash 7,415 (To record for total interest paid) 6 Cash 25,650 Rental Revenue 25,650 23 24 25 26 To record for property leased using rental income) Loss on sale of building and equipment Accumulated Depreciation To record for disposal of the store 7 Cash 59.200 35,800 25,000 Building and Equipment 28 120,000 29 8 Bad Debt Expense 522 Allowance for doubtful debts To record for total interest paid) Cash 25,650 Rental Revenue 25,650 To record for property leased using rental income) Loss on sale of building and equipment Accumulated Depreciation To record for disposal of the store) 7 Cash 59,200 35,800 25,000 Building and Equipment 120,000 8 Bad Debt Expense 522 Allowance for doubtful debts 522 To record doubtful debts made) 9 Selling and Administrative expenses 128,475 (56,000 Cash To record for selling and administration expenses being paid) 10 Income tax Expense 72,475 90,500 Cash 7 38 39 90,500 To record for income tax being paid)