Can you do Questions A), D) ,E) ,and F) PleasePlease show working out. The following trial balance was extracted from the books of Columbus Ltd at December 31, the end ofthe company's financial year. The company is owned by John Columbus and is in the business of buyingand farming supplies.Trial Balance as at December 31, 2018Trial BalanceA/C NameDRCRCashAccounts receivableAllowance for bad debtMerchandise InventoryStore SuppliesPrepaid InsuranceFurniture and FixturesAccumulated depreciation -Furniture and FixturesComputer EquipmentAccumulated depreciation Computer Equipment|Accounts payableWages payableUnearned Sales revenue1,000,000450,00015,000186,000120,000450,0001,000,000360,000600,000320,000150,000Notes Payable, Long TermJohn Columbus, CapitalJohn Columbus, Withdrawals900,0002,200,00095,000Sales revenue1,761,000Sales discountSales returns and allowancesCost of goods soldWages ExpenseInsurance ExpenseDepreciation Expense - Furniture and FixturesDepreciation Expense -Computer EquipmentStore Supplies ExpenseUtilities ExpenseBad Debt ExpenseInterest ExpenseTotal120,00095,000650,000450,000180,00040,000180,00090,0005,706,0005,706,000The following additional information is available at December 31, 2018: (i)Insurance of $450,000 was paid on May 1, 2018 for the 10-months to February 2019.(ii)The furniture and fixtures have an estimated useful life of 10 years and is being depreciatedon the straight-line method down to a residual value of $100,000.(iii)The computer equipment was acquired on March 1, 2018 and is being depreciated over 10years on the double-declining method of depreciation, down to a residue of $60,000.(iv)Wages earned by employees NOT yet paid amounted to 15,000 at December 31, 2018.(v)A physical count of inventory at December 31, reveals $180,000 worth of inventory on hand.(vi)At December 31, $140,000 of the previously unearned sales revenue had been earned.(vii)The aging of the Accounts Receivable schedule at December 31 indicated that the estimateduncollectible on account receivable should be $45,000.REQUIRED:a)Prepare the necessary adjusting journal entries on December 31. [Narrations are not required]b)Prepare Columbus Ltd multiple-step income statement for the year ended December 31, 2018.c)Prepare Columbus Ltd statement of owner's equity for the year ended December 31, 2018.d)Prepare Columbus Ltd classified balance sheet at December 31, 2018.e)Prepare the closing entriesf)Prepare the post-closing trial balance

Since you have asked multiple questions, we will solve the first question for you. If you want any…

Answered: Prepare the necessary adjusting journal…

Business

Accounting

Prepare the necessary adjusting journal entries on December 31. [Narrations are not required]

College Accounting (Book Only): A Career Approach

13th Edition

ISBN:9781337280570

Author:Scott, Cathy J.

Publisher:Scott, Cathy J.

ChapterB: Bad Debts

Section: Chapter Questions

Problem 2P: Hardys Landscape Services total revenue on account for 2018 amounted to 273,205. The company, which...

See similar textbooks

Related questions

Q: Remo Company and Angelo Inc. are separate companies that operate in the same industry. Following are…

A: Contribution Margin Ratio is calculated at 2 decimal places . And final answer of Break Even Sales…

Q: Could you please finish the remaining questions?

A: The breakeven point (break-even price) of a transaction or investment is determined by comparing the…

Q: Can I get help with requirement 4-7 as well?

A: Calculation of Return on Equity (ROE) for the previous year and current year. Return on Equity (ROE)…

Q: Can you please step this out line by line (not all in one line) and state the formula used

A: The concept of time value of money states that worth of money changes with passage of time. This is…

Q: calculations to these answers?

A: Cost allocation is the process of assigning or distributing the costs to different business units,…

Q: an you show how to do both steps by hand?

A: Price of bond is the present value of coupon payment plus present value of par value of the bond…

Q: Student ID Day 63638034 Monday 23957096 Thursday 28080825 Monday Exam Score 61 70 1. How many…

A: =COUNTIF is used to count the cells satisfying the given criteria in the given range.

Q: What does CAPM allow you to calculate?

A: CAPM model is basically the capital asset pricing model which helps us in determining the expected…

Q: answers be itemized

A: There are situations when a company computes that if there is a change in the depreciation method…

Q: Can you show steps on how you got the answers?

A: Workings:

Q: can you please type out the equation

A: Solution:- When an equal amount is saved each period at end of period, it is called ordinary…

Q: Can you please show ALL the calculations in step 2?

A: Product mix: The product mix or product assortment refers to the total number of different product…

Q: Can you please write out the equations

A: Present value of annuity is the current value of the future payments that are calculated using the…

Q: Could I also get the results for part D. through F.

A: The process of accounting for expenses involved in the manufacture of items is known as…

Q: What order is advised when doing tasks using an ABC system?

A: Introduction: Overhead and indirect costs are assigned to related products and services using the…

Q: What is the suggested order for performing tasks using the ABC system?

A: Activity-based costing, or ABC for short, is a way of allocating overhead and indirect expenses to…

Q: For Part 2, can that be calculated using excel?

A: The price of bond is sum of present value of the future cash flow from its coupons and the present…

Q: Explain an example of prepayments.

A: The outflow of money to reduce the liabilities occurred in the current accounting period refers to…

Q: Can you please provide the calculations that you used.

A: Current Assets - Current Assets is the assets which can convert into cash with in a span of one…

Q: AN I SEE THE MANUAL WORKING OF THE PROBLEM

A: The future value of the annuity includes the amount that is being deposited over the years and…

Question

Can you do Questions

A), D) ,E) ,and F) Please

Please show working out.

The following trial balance was extracted from the books of Columbus Ltd at December 31, the end of
the company's financial year. The company is owned by John Columbus and is in the business of buying
and farming supplies.
Trial Balance as at December 31, 2018
Trial Balance
A/C Name
DR
CR
Cash
Accounts receivable
Allowance for bad debt
Merchandise Inventory
Store Supplies
Prepaid Insurance
Furniture and Fixtures
Accumulated depreciation -Furniture and Fixtures
Computer Equipment
Accumulated depreciation Computer Equipment
|Accounts payable
Wages payable
Unearned Sales revenue
1,000,000
450,000
15,000
186,000
120,000
450,000
1,000,000
360,000
600,000
320,000
150,000
Notes Payable, Long Term
John Columbus, Capital
John Columbus, Withdrawals
900,000
2,200,000
95,000
Sales revenue
1,761,000
Sales discount
Sales returns and allowances
Cost of goods sold
Wages Expense
Insurance Expense
Depreciation Expense - Furniture and Fixtures
Depreciation Expense -Computer Equipment
Store Supplies Expense
Utilities Expense
Bad Debt Expense
Interest Expense
Total
120,000
95,000
650,000
450,000
180,000
40,000
180,000
90,000
5,706,000
5,706,000
The following additional information is available at December 31, 2018:

(i)
Insurance of $450,000 was paid on May 1, 2018 for the 10-months to February 2019.
(ii)
The furniture and fixtures have an estimated useful life of 10 years and is being depreciated
on the straight-line method down to a residual value of $100,000.
(iii)
The computer equipment was acquired on March 1, 2018 and is being depreciated over 10
years on the double-declining method of depreciation, down to a residue of $60,000.
(iv)
Wages earned by employees NOT yet paid amounted to 15,000 at December 31, 2018.
(v)
A physical count of inventory at December 31, reveals $180,000 worth of inventory on hand.
(vi)
At December 31, $140,000 of the previously unearned sales revenue had been earned.
(vii)
The aging of the Accounts Receivable schedule at December 31 indicated that the estimated
uncollectible on account receivable should be $45,000.
REQUIRED:
a)
Prepare the necessary adjusting journal entries on December 31. [Narrations are not required]
b)
Prepare Columbus Ltd multiple-step income statement for the year ended December 31, 2018.
c)
Prepare Columbus Ltd statement of owner's equity for the year ended December 31, 2018.
d)
Prepare Columbus Ltd classified balance sheet at December 31, 2018.
e)
Prepare the closing entries
f)
Prepare the post-closing trial balance

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Shannon Corporation began operations on January 1, 2019. Financial statements for the years ended December 31, 2019 and 2020, contained the following errors: In addition, on December 31, 2020, fully depreciated machinery was sold for 10,800 cash, but the sale was not recorded until 2021. There were no other errors during 2019 or 2020, and no corrections have been made for any of the errors. Refer to the information for Shannon Corporation above. Ignoring income taxes, what is the total effect of the errors on the amount of working capital (current assets minus current liabilities) at December 31, 2020? a. working capital overstated by 4,200 b. working capital understated by 5,800 c. working capital understated by 6,000 d. working capital understated by 9,800
Roxas Company reported the following net income: 2018 - P1,750,000 2019 - P2,000,000 An examination of the accounting records for the year ended December 31, 2019 revealed that several errors were made. The following errors were discovered: • The footings and extensions showed that the inventory on December 31, 2018 was overstated by P190,000. • Prepaid insurance of P120,000 applicable to 2020 was expensed in 2019. • Interest receivable of P20,000 was not recorded on December 31, 2019. . On January 1, 2019, an equipment costing P400,000 was sold for P220,000. At the date of sale, the equipment had accumulated depreciation of P240,000. • The cash received was recorded as miscellaneous income in 2019. . In addition, depreciation was recorded for the equipment for 2019 at the rate of 10%. Required: 1. Prepare worksheet showing corrected net income for 2018 and 2019. 2. Prepare adjusting entries on December 31, 2019 assuming (a) books are still open and (b) books are already closed.
At December 31, 2024, Michelle Walker Corporation reported current assets of $344,933 and current liabilities of $192,700. The following items may have been recorded incorrectly. Walker uses a perpetual inventory system. 1. 2. 3. Goods purchased costing $21,090 were shipped f.o.b. shipping point by a supplier on December 28. Walker received and recorded the invoice on December 29, 2024, but the goods were not included in Walker's inventory because they were not received until January 4, 2025. Goods purchased costing $16,010 were shipped f.o.b. destination by a supplier on December 26. Walker received and recorded the invoice on December 31, but the goods were not included in Walker's 2024 inventory because they were not received until January 2, 2025. Goods held on consignment from Claudia Kishi Company were included in Walker's December 31, 2024, inventory at $12,250.
prepare these entries for Sarah's plant services. prepare general journal entries for the needed balance dy adjustments for the year ending 30/6/21: A stocktake of the inventory on hand was completed on 30/6/21. The value of the stocktake was $17,000. The inventory asset account as at 30/6/21 before adjustments was $18.000 The allowance for Doubtful debts should be 5% of the balance of Accounts Receivable. The accounts receivable balance at 30/6/21 is $76,120 and the balance of the Allowance for Doubtful Debts was $3,450
Mackenzie Inc. uses a perpetual inventory system and has prepared the following adjusted trial balance on December 31, 2019: Mackenzie Inc. ADJUSTED TRIAL BALANCE December 31, 2019 ACCOUNT TITLE DEBIT CREDIT 1 Cash 2,200.00 2 Accounts Receivable 2,600,00 3 Allowance for Doubtful Accounts 250.00 4 Inventory 6,400.00 5 Prepaid Insurance 800.00 6 Land 5,600.00 7 Buildings and Equipment 31,200.00 8 Accumulated Depreciation 17,000.00 9 Accounts Payable 3,400.00 10 Salaries Payable 450.00 11 Unearned Rent 360.00 12 Income Taxes Payable 2,750.00 13 Note Payable 5,600.00 14 Interest Payable 700.00 15 Common Stock 7,500.00 16 Retained Earnings 7,460.00 17 Dividends 1,300.00 18 Income Summary 19 Sales Revenue 28,970.00 20 Rent Revenue 1,310.00 21 Cost of Goods Sold 14,500.00 22 Selling Expenses 4,900.00 23 Administrative Expenses 2,800,00 24 Interest Expense 700.00 25 Income Tax Expense 2,750.00 26 Totals 75,750.00 75,750.00 For classification purposes: Note payable is due July 1, 2023 Interest…
1. Prepare the entry to record the write-off ofuncollectible accounts during 2019. 2. Prepare the entries to record the recovery ofthe uncollectible account during 2019 3. Prepare the entry to record bad debt expense(BDE) at the end of 2019. Ending balance ofAFDA was Rp18,200 (Cr.) 4. Determine the ending balance of AccountsReceivable as of December 31, 2019. 5. What is the net realizable value of thereceivables at the end of 2019? 6. The company has a notes receivable ofRp24,000 at January 15, 2019 for 3 months at10% interest rate. Prepare journal entry as ofApril 15, 2019, on its due date.
On November 1, 2025, Marin Inc. had the following account balances. The company uses the perpetual inventory method. Cash Accounts Receivable Supplies Equipment 22 25 27 28 29 29 10 29 11 12 During November, the following summary transactions were completed. 15 Debit 19 $27,000 20 6,720 2,580 75,000 $111,300 Accumulated Depreciation-Equipment Accounts Payable Unearned Service Revenue Salaries and Wages Payable Common Stock Nov. 8 Paid $10,650 for salaries due employees, of which $5,550 is for November and $5,100 is for October. Received $5,700 cash from customers in payment of account. Purchased merchandise on account from Dimas Discount Supply for $24,000, terms 2/10, n/30. Sold merchandise on account for $16,500, terms 2/10, n/30. The cost of the merchandise sold was $12,000. Received credit from Dimas Discount Supply for merchandise returned $900. Received collections in full, less discounts, from customers billed on sales of $16,500 on November 12. Paid Dimas Discount Supply in…
At December 31, 2019, Stacy McGill Corporation reported current assets of $370,000 and current liabilities of $200,000. The following items may have been recorded incorrectly. 1. Goods purchased costing $22,000 were shipped f.o.b. shipping point by a supplier on December 28. McGill received and recorded the invoice on December 29, 2019, but the goods were not included in McGill's physical count of inventory because they were not received until January 4, 2020. 2. Goods purchased costing $15,000 were shipped f.o.b. destination by a supplier on December 26. McGill received and recorded the invoice on December 31, but the goods were not included in McGill's 2019 physical count of inventory because they were not received until January 2, 2020. 3. Goods held on consignment from Claudia Kishi Company were included in McGill's December 31, 2019, physical count of inventory at $13,000. 4. Freight-in of $3,000 was debited to advertising expense on December 28, 2019. Instructions a.…
Below is the adjusted trial balance which was extracted from the books of Ready Hospital Supplies on June 30, the end of the company’s financial year. You are required to apply the accrual basis of accounting in the preparation of the company’s financial statements. Ready Hospital Supplies Adjusted Trial Balance as at June 30, 2020 Dr $ Cr $ Cash 127,000.00 Accounts Receivable 151,000.00 Allowance for Bad-Debts 19,500.00 Merchandise Inventory 186,000.00 Store Supplies 25,000.00 Prepaid Insurance 48,000.00 Prepaid Rent 14,000.00 Furniture & Fixtures 800,000.00 Accumulated Depreciation: Furniture & Fixtures 320,000.00 Computer Equipment 450,000.00 Accumulated Depreciation: Computer Equipment 45,000.00 Accounts Payable 133,500.00 Salaries Payable 14,000.00 Interest Payable 36,000.00…
Causeway Ltd adopts perpetual inventory system and prepares its financial statements at 31 December. The unadjusted trial balance of the company at 31 December 2022 is detailed below: Account Title Land Equipment Accumulated depreciation - Equipment Inventories Prepaid rent Accounts receivable Allowance for doubtful accounts Cash Loan payable Accounts payable Tax payable Share capital Dividends - Interim (paid in August 2022) Retained earnings (at 1 January 2022) Sales Cost of goods sold Administrative expense Salary expense Selling expense Rent expense Utilities expense Other expense Tax expense + Dr $497,000 120,000 107,600 7,200 181,100 63,400 15,000 554,100 52,880 174,000 91,000 18,000 Cr $30,000 5,000 150,000 222,500 20,000 100,000+ 274,580 1,167,800 21,200 47,400 20,000 $1,969,880 $1,969,880 Additional information: 1. On 1 November 2022, Causeway Ltd paid $7,200 for office rent covering the period from 1 November 2022 to 31 January 2023 at $2,400 per month. Causeway Ltd recorded…
XYZ Corp. is a calendar-year corporation whose financial statements for 2019 and 2020 included errors as follows: Ending Inventory. Year Depreciation Expense 2019 30,000 overstated $36,000 overstated O a. $4,000 decrease O b. $32,000 increase 12,000 understated Time left 2:51:11 $ 2020 10,000 understated Assume that purchases were recorded correctly and that no correcting entries were made at December 31, 2019 or December 31, 2020. Ignoring income taxes, by how much should XYZ's retained earnings be retrospectively adjusted at January 1, 2021?
Jason Co. began operations on January 1, 2023. Financial statements for 2023 and 2024 contained the following errors: Ending inventory Depreciation expense Dec. 31, 2023 $75,500 overstated 48,500 understated Dec. 31, 2024 $105,500 overstated Accumulated depreciation. 48,500 understated 48,500 understated Insurance expense 43,500 overstated 43,500 understated Prepaid expense 43,500 understated In addition, on December 26, 2024, fully depreciated equipment was sold for $58,000, but the sale was not recorded until 2025. No corrections have been made for any of the errors. Ignoring income taxes, calculate the total effect of the errors on 2024 net income. Total effect of the errors on 2024 net income $