You need to prepare the financial statement and the adjusting entries for the December31st year end...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You need to prepare the financial statement and the adjusting entries for the December31st year end (using EXCEL) for a company that follows IFRS and has a December 31st year end. The company has a 25% tax rate. The following unadjusted trial balance at December 31st, 2023 has been provided to you. Account name Cash Land Accounts receivable Accounts payable Note payable Accumulated depreciation - manufacturing equipment Accumulated depreciation - warehouse Accumulated OCI Allowance for doubtful accounts Common shares Cost of goods sold Dividend income Debit Credit 59,000 750,000 165,000 121,200 800,000 224,000 625,000 17,000 11,500 1,200,000 970,000 80,000 Inventory finished goods 980,000 Inventory raw materials 205,600 Long term investments (FVOCI) 49,000 Unrealized loss on FVOCI investments 15,000 Manufacturing equipment 560,000 Other operating expenses 22,200 Preferred shares 200,000 Prepaid insurance Retained earnings Salaries expense 30,000 1,128,600 Sales returns Sales revenue 368,000 50,500 1,805,000 Social activities expense Warehouse Total You also have obtained the following information from the company: The warehouse was purchased in 2018 and is also accounted for using the historical cost model. The warehouse has a useful life of 15 years and, when it was purchased, the salvage value was determined to be $100,000. However, the warehouse is showingmore "wear and tear" than anticipated so management now believes that $40,000 is a more accurate salvage value. On April 30th, 2023, thecompany repurchased 12,000 common shares for $5 ea ch. 13,000 1,975,000 6,212,300 6,212,300 On November 1st, 2023, the company received a 5%, $800,000 loan from the bank. The contract states that the principal must be repaid in full on November 1st, 2027. Interest isdue each year on November 1st The "Prepaid insurance" relates to an insurance policy the company purchased for $36,000 on September 1st, 2022. The policy provides the company with insurance fortheir warehouse and inventory for two years, so until August 30th, 2024. On January 10th, 2024, you received an electricity bill of $2,000. The bill relates to thelast quarter of 2023 and has not yet been paid. No journal entry has been recorded related to this bill. The manufacturing equipment is accounted for using the historical cost model and is depreciated on a straight-line basis. The equipment has a useful life of 5 years. No newequipment was purchased in the year. To do (Using EXCEL): Prepare (1) Statement of Financial Position, (2) Statement of Changes in Equity and (3) Statement of Comprehensive Income (multi step, operating expenses grouped byn ature), for the Company's December 31st, 2023, year-end. Also Explain in great details all the calculations on how to obtain each figure. (Hint: If you are having trouble balancing the Statement of Financial Position, make sure you have included current year's Net Income in Retained Earnings. Also make sure to include both sides of the tax entry, so both income tax expense on the Statement of Comprehensive Income and income tax payable on your Statement ofFinancial Position) You need to prepare the financial statement and the adjusting entries for the December31st year end (using EXCEL) for a company that follows IFRS and has a December 31st year end. The company has a 25% tax rate. The following unadjusted trial balance at December 31st, 2023 has been provided to you. Account name Cash Land Accounts receivable Accounts payable Note payable Accumulated depreciation - manufacturing equipment Accumulated depreciation - warehouse Accumulated OCI Allowance for doubtful accounts Common shares Cost of goods sold Dividend income Debit Credit 59,000 750,000 165,000 121,200 800,000 224,000 625,000 17,000 11,500 1,200,000 970,000 80,000 Inventory finished goods 980,000 Inventory raw materials 205,600 Long term investments (FVOCI) 49,000 Unrealized loss on FVOCI investments 15,000 Manufacturing equipment 560,000 Other operating expenses 22,200 Preferred shares 200,000 Prepaid insurance Retained earnings Salaries expense 30,000 1,128,600 Sales returns Sales revenue 368,000 50,500 1,805,000 Social activities expense Warehouse Total You also have obtained the following information from the company: The warehouse was purchased in 2018 and is also accounted for using the historical cost model. The warehouse has a useful life of 15 years and, when it was purchased, the salvage value was determined to be $100,000. However, the warehouse is showingmore "wear and tear" than anticipated so management now believes that $40,000 is a more accurate salvage value. On April 30th, 2023, thecompany repurchased 12,000 common shares for $5 ea ch. 13,000 1,975,000 6,212,300 6,212,300 On November 1st, 2023, the company received a 5%, $800,000 loan from the bank. The contract states that the principal must be repaid in full on November 1st, 2027. Interest isdue each year on November 1st The "Prepaid insurance" relates to an insurance policy the company purchased for $36,000 on September 1st, 2022. The policy provides the company with insurance fortheir warehouse and inventory for two years, so until August 30th, 2024. On January 10th, 2024, you received an electricity bill of $2,000. The bill relates to thelast quarter of 2023 and has not yet been paid. No journal entry has been recorded related to this bill. The manufacturing equipment is accounted for using the historical cost model and is depreciated on a straight-line basis. The equipment has a useful life of 5 years. No newequipment was purchased in the year. To do (Using EXCEL): Prepare (1) Statement of Financial Position, (2) Statement of Changes in Equity and (3) Statement of Comprehensive Income (multi step, operating expenses grouped byn ature), for the Company's December 31st, 2023, year-end. Also Explain in great details all the calculations on how to obtain each figure. (Hint: If you are having trouble balancing the Statement of Financial Position, make sure you have included current year's Net Income in Retained Earnings. Also make sure to include both sides of the tax entry, so both income tax expense on the Statement of Comprehensive Income and income tax payable on your Statement ofFinancial Position)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since Y4. Aylmer has two main business segments. This first segment is the construction of large-scale projects. In Y7, Aylmer had...
-
When we create our own Market Limitations In the mid-1960s a new electronics company was founded with a unique high-tech product a new type of computer. Thanks to its engineering know-how LOCKDOWN...
-
The College Entrance Examination Board writes that "for the SAT Achievement Tests, your score would fall in a range [between] about 30 points above [and| below your actual ability about two-thirds of...
-
The standard DECISION-TREE-LEARNING algorithm described in the chapter does not handle cases in which some examples have missing attribute values. a. First, we need to find a way to classify such...
-
Explain the role of polymorphism in the user interface.
-
A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this...
-
Two clay balls collide and stick. Ball 1 has a mass of 10 kg and an initial velocity of 5 m/s in the positive x direction. Ball 2 has a mass of 20 kg and an initial velocity of 5 m/s in the negative...
-
Explain the assignment and what topics that are easier and i can research Students are expected to consume 30-60 minutes of (legitimate) news media weekly. Reflection Journal entries are expected to...
-
The temporal lobes receive and interpret all auditory sensory data. Interestingly, the left temporal lobe specializes in interpreting the sounds of language while the right temporal lobe specializes...
-
With respect to the Assurance of Learning Process, consider the following questions Who are the customers in this process?
-
1. The remaining lifetime of an individual in years is discrete uniform with a = 1 and b = 50. If an insurance product offers k if the individual dies in discrete year k (e.g., if they die in the...
-
Critically examine the various curriculum development approaches with regard to their focus areas. [ 1 2 Marks ] .
-
Critically discuss how leaders can create an effective digital culture within the farming sector?
-
Answer the following questions: 1. What are externalities? 2. Explain positive externalities. 3. Explain the term Price Floor. 4. What are the 4 possible reactions to raising the minimum wage? 5....
-
The senior management at Davis Watercraft would like to determine if it is possible to improve firm profitability by changing their existing product mix. Currently, the product mix is determined by...
-
In Fig. 1130, there is no explicit invariant that states that a Transaction cannot be linked to movements that are linked to the same account, because the structure of the model already demands is....
-
Apply the Account/Transaction pattern to the parallel financial transactions of the example shown in Figs. 1131 to 1135. As the bills may be paid forward, it may be necessary to use memo entries....
-
Look at Fig. 1119 and create a new discount strategy that gives a percentage of discount for sales with more than a certain number of products. Order | < > < > +nr: Natural = < > +date: Date...
Study smarter with the SolutionInn App