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

Hardys Landscape Services total revenue on account for 2018 amounted to 273,205. The company, which uses the allowance method, estimates bad debts at percent of total revenue on account. Required Journalize the following selected entries: 2012 Dec. 12Record services performed on account for E. E. Morton, 245. 31Record the adjusting entry for Bad Debts Expense. 31Record the closing entry for Bad Debts Expense. 2013 Feb. 18Write off the account of E. E. Morton as uncollectible, 245. Check Figure Adjusting entry amount, 1,366.03
Prepare adjusting entries to record the depreciation expenses and estimated bad debts on 31 Jan. 2021
Prepare the company’s Statement of profit or loss for the year ended 31st December 2018 and its Statement of financial position as at that date, in accordance with IAS 1 Presentation of Financial Statements.
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.
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
Using direct method, ZARA company decided on December 2, 2019 to write-off 370$ that owned to HH company Ltd. The journal entry to record this transaction is O a. Bad debt expense 370 Account receivable 370 O b. Bad debt expense 370 Cash 370 Oc Bad debt expense 370 C. Allowance for doubtful account 370 O d. Cash370 Bad debt expense 370
JUBILEE is a quoted company reporting under IFRSs. During the year end 31 December 2012, the company changed its accounting policy with respect to property valuation. There are also a number of other issues that need to be finalised before the financial statements can be published.JUBILEE’s trial balance from the general ledger at 31 December 2012 showed the following balances:GH¢’mGH¢’mRevenue 2,648Loan note interest paid3Purchases1,669Distribution costs514Administrative expenses345Interim dividend paid6Inventories at 1 January 2012444Trade receivables545Trade payables434Cash and cash equivalents2850Gp ordinary shares100Capital surplus814Retained earnings at 1 January 20123494% loan note repayable 2018 (issued 2010)150Land and buildings: Cost (including GH¢60m land) 380 Accumulated depreciation at 1/1/201264Plant and equipment: Cost 258 Accumulated depreciation at 1/1/2012126Investment property at 1 January 2012548Rental income48Proceeds from sale of equipment7,4,7404,740Further…
Teal Tool Company's December 31 year-end financial statements contained the following errors. Ending inventory Depreciation expense December 31, 2020 $10,500 understated $2,400 understated Total effect of errors on net income $ An insurance premium of $69,000 was prepaid in 2020 covering the years 2020, 2021, and 2022. The entire amount was charged to expense in 2020. In addition, on December 31, 2021, fully depreciated machinery was sold for $16,000 cash, but the entry was not recorded until 2022. There were no other errors during 2020 or 2021, and no corrections have been made for any of the errors. (Ignore income tax considerations.) (a) Compute the total effect of the errors on 2021 net income. Total effect on working capital $ December 31, 2021 understated overstated (b) Compute the total effect of the errors on the amount of Teal's working capital at December 31, 2021. $8,200 overstated Total effect on retained earnings (c) Compute the total effect of the errors on the balance of…
Company presents the following selected general ledger accountsshowing balances at October 1, 2017: CashFinished GoodsWork in ProcessRaw materialsPrepaid Insurance Accumulated Depreciation Accounts PayableBalances at October 31, 2017 include: Accrued payrollFinished goodsWork in ProcessRaw MaterialsP 40,000 592,000 164,000 128,0004,000 280,000 108,000P 12,000 608,000 188,000 120,000 A summary of transactions for the month of October follows: a. Cash salesb. Raw materials purchased on account c. Direct materials usedd. Direct Labore. Factory insurance expiredf. Depreciation for factory equipment g. Factory utility service on accounth. Accounts payable paidi. Factory payroll paidP420,000 168,000 156,00064,000 1,200 6,80012,000 196,000 88,000Required: Indirect materials used.Indirect laborTotal factory overhead Cost of goods manufa
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.
give the solutions and explain it
The following is a list of the accounts and balances taken from the adjusted trial balance at December 31 2021 for Meilleur Merchants. Meilleur uses a perpetual inventory system and the earnings approach for revenue recognition. The list of accounts is in alphabetical order. All accounts have normal balances. Account BalanceDec. 31 1 Accounts payable $15,000 2 Accounts receivable 30,000 3 Accumulated depreciation—building 15,500 4 Accumulated depreciation—equipment 10,000 5 Advertising expense 4,600 6 Building 84,600 7 S. Meilleur, capital 75,000 8 S. Meilleur, drawings 28,300 9 Cash 4,500 10 Cost of goods sold 235,200 11 Depreciation expense 5,800 12 Equipment 24,500 13 Freight out 620 14 Insurance expense 1,150 15 Interest expense 1,820 16 Interest revenue 1,240 17 Land 12,000 18 Merchandise inventory 105,000 19 Mortgage…