Answered step by step
Verified Expert Solution
Question
1 Approved Answer
THE COMPANY:Aylmer Industries Inc. ( Aylmer ) has been in business since 2 0 2 1 . Aylmer has two main business segments. This first
THE COMPANY:Aylmer Industries Inc. Aylmer has been in business since Aylmer has two main business segments. This first segment is the construction of largescale projects. In Aylmer had two large construction projects in process. The other segment is the purchase and sale of small machines needed for the construction industry.There are common shares outstanding of this publicly traded company. Since Aylmer is a publicly traded company, it follows IFRS.There are no preferred shares outstanding.The trial balance at December and December are provided for comparison purposes on the tab Trial Balance in the excel file. Use this excel worksheet to post journal entries required, to ensure that you remain in balance. The worksheet should also be used to provide a basis of preparing the financial statements at December Ignore income taxes for this project.Aylmer posted transactions throughout the year and the trial balance in excel was prepared. Aylmers fiscal yearend is December st As a yearend review, management of Aylmer discovered that the following items have NOT been recorded and are NOT reflected in the trial balance provided at December :Analyze and review the following items a n and determine the appropriate journal entry. Record the journal entry in the excel file labelled journal entries. Use the various tabs in the excel file to record calculations and support for your journal entries.TRANSACTIONS NOT INCLUDED IN THE TRIAL BALANCE:Calculate bad debtOn December after many attempts at collecting the outstanding balance of Copper Gallery, the controller decided to write off that balance. Aylmer calculates bad debt on trade receivables only, not on project receivables. Bad debt is estimated to be: days days days days Over days In the excel spreadsheet, see the tab labelled Trade Accounts Receivable Detail to perform any necessary calculations. Be sure to write off the balance of Copper Gallery referenced above before doing these calculations. FVNI InvestmentsAt December ; the fair value of the shortterm investments were: Redemption Corp $ per share ALM Corp $ per share In the excel spreadsheet, see the tab FVNI Investments to perform any necessary calculations.Prepaid InsuranceThe prepaid amount on the trial balance consists of a payment made to State Farm Insurance on October The policy lasts months.Inventory LCMThe company has the policy of stating all inventory on hand at the lower of cost and net realizable value. The company uses the direct method for any adjustments to inventory.NOTE on the income statement use Cost of Goods Sold from the trial balance do not calculate the cost of goods sold.In the excel spreadsheet, see the tab Inventory Detail to perform any necessary calculations.Record Depreciation on assetsDepreciate the fixed assets according to the schedule. Depreciation is calculated on an annual basis.In the excel spreadsheet, see the tab Fixed Asset Details to perform any necessary calculationsTrade a vehicleOn December after depreciation was recorded; the company traded the Toro lawn mower which was acquired on February asset # for a Ford F In addition to the trade, the company paid $ cash for the new truck. The fair value of the Toro lawn mower on this date was $ Assume that this transaction HAS commercial substance. Once this new asset is purchased, do not depreciate it since it was purchased on the last day of the year.In the excel spreadsheet, see the tab Fixed Asset Details to perform any necessary calculations; and update the schedule as needed.Investments FVOCIOn December the fair value per share of Hub Cap Company was $ per share. Aylmer decided to sell its shares in Hub Cap Company at that time sale was not recorded on the trial balance Hint: after you record the sale, be sure to close the gain or loss on sale to retained earnings similar to how the sale was accounted for in TR in class.In the excel spreadsheet, see the tab FVOCI Investments to perform any necessary calculations.Bank LoanThe loan for $ was borrowed at January Interest on the bank loan is annually. Interest has to be paid every January so the first interest payment is due January No principal payments were made during the year. Of the bank loan, $ is due June with the remainder due June Notes PayableThis is a shortterm note. The company borrowed money from JRT Investments on October for months. The principle, along with interest is to be repaid on January The interest rate is Longterm contractsThe company uses the percentage of completion method for recording longterm contracts. The company has two longterm contracts with details below provided for one of the projects.Project Downtown Hotel & Shopping CentreContract price is $Expected completion date is in In the excel spreadsheet, see the tab Revenue Recognition to perform any necessary calculations related to the revenue earned on this project. The other project has already been accounted for properly and the accounting for Project s outstanding billings is already reflected in the unadjusted trial balance.Accrue wagesEmployees work Monday to Friday and employees are paid weekly. December is a Thursday. Assume that hourly employees work hours per day and that there are weeks a year for salaried employees.In the excel spreadsheet, see the tab Payroll Details to perform any necessary calculations.Intangible AssetsAmortize the intangibles according to the schedule. Amortization is recorded on an annual basis. In the excel spreadsheet, see the tab Intangible Assets to perform any necessary calculationsDividendsOn December a dividend of $ was declared to shareholders of record on January to be paid January Taxes To be ignored for this project REQUIRED:See the excel spreadsheet all information should be recorded using the excel template. Update tabs in excel as needed SHOW ALL WORK.Prepare journal entries for the above transactions.Post transactions to the worksheet and complete the worksheet.Prepare:Classified Statement of Financial PositionMultistep income statementStatement of Retained EarningsNotes to the financial statements for the assets section of the Statement of Financial Position ONLYNotes should include any reconciliation schedules or detailed schedules for assets.OTHER IMPORTANT INFORMATIONRound financial statements to the nearest dollar.Show ALL calculations.
THE COMPANY:Aylmer Industries Inc. Aylmer has been in business since Aylmer has two main business segments. This first segment is the construction of largescale projects. In Aylmer had two large construction projects in process. The other segment is the purchase and sale of small machines needed for the construction industry.There are common shares outstanding of this publicly traded company. Since Aylmer is a publicly traded company, it follows IFRS.There are no preferred shares outstanding.The trial balance at December and December are provided for comparison purposes on the tab Trial Balance in the excel file. Use this excel worksheet to post journal entries required, to ensure that you remain in balance. The worksheet should also be used to provide a basis of preparing the financial statements at December Ignore income taxes for this project.Aylmer posted transactions throughout the year and the trial balance in excel was prepared. Aylmers fiscal yearend is December st As a yearend review, management of Aylmer discovered that the following items have NOT been recorded and are NOT reflected in the trial balance provided at December :Analyze and review the following items a n and determine the appropriate journal entry. Record the journal entry in the excel file labelled journal entries. Use the various tabs in the excel file to record calculations and support for your journal entries.TRANSACTIONS NOT INCLUDED IN THE TRIAL BALANCE:Calculate bad debtOn December after many attempts at collecting the outstanding balance of Copper Gallery, the controller decided to write off that balance. Aylmer calculates bad debt on trade receivables only, not on project receivables. Bad debt is estimated to be: days days days days Over days In the excel spreadsheet, see the tab labelled Trade Accounts Receivable Detail to perform any necessary calculations. Be sure to write off the balance of Copper Gallery referenced above before doing these calculations. FVNI InvestmentsAt December ; the fair value of the shortterm investments were: Redemption Corp $ per share ALM Corp $ per share In the excel spreadsheet, see the tab FVNI Investments to perform any necessary calculations.Prepaid InsuranceThe prepaid amount on the trial balance consists of a payment made to State Farm Insurance on October The policy lasts months.Inventory LCMThe company has the policy of stating all inventory on hand at the lower of cost and net realizable value. The company uses the direct method for any adjustments to inventory.NOTE on the income statement use Cost of Goods Sold from the trial balance do not calculate the cost of goods sold.In the excel spreadsheet, see the tab Inventory Detail to perform any necessary calculations.Record Depreciation on assetsDepreciate the fixed assets according to the schedule. Depreciation is calculated on an annual basis.In the excel spreadsheet, see the tab Fixed Asset Details to perform any necessary calculationsTrade a vehicleOn December after depreciation was recorded; the company traded the Toro lawn mower which was acquired on February asset # for a Ford F In addition to the trade, the company paid $ cash for the new truck. The fair value of the Toro lawn mower on this date was $ Assume that this transaction HAS commercial substance. Once this new asset is purchased, do not depreciate it since it was purchased on the last day of the year.In the excel spreadsheet, see the tab Fixed Asset Details to perform any necessary calculations; and update the schedule as needed.Investments FVOCIOn December the fair value per share of Hub Cap Company was $ per share. Aylmer decided to sell its shares in Hub Cap Company at that time sale was not recorded on the trial balance Hint: after you record the sale, be sure to close the gain or loss on sale to retained earnings similar to how the sale was accounted for in TR in class.In the excel spreadsheet, see the tab FVOCI Investments to perform any necessary calculations.Bank LoanThe loan for $ was borrowed at January Interest on the bank loan is annually. Interest has to be paid every January so the first interest payment is due January No principal payments were made during the year. Of the bank loan, $ is due June with the remainder due June Notes PayableThis is a shortterm note. The company borrowed money from JRT Investments on October for months. The principle, along with interest is to be repaid on January The interest rate is Longterm contractsThe company uses the percentage of completion method for recording longterm contracts. The company has two longterm contracts with details below provided for one of the projects.Project Downtown Hotel & Shopping CentreContract price is $Expected completion date is in In the excel spreadsheet, see the tab Revenue Recognition to perform any necessary calculations related to the revenue earned on this project. The other project has already been accounted for properly and the accounting for Project s outstanding billings is already reflected in the unadjusted trial balance.Accrue wagesEmployees work Monday to Friday and employees are paid weekly. December is a Thursday. Assume that hourly employees work hours per day and that there are weeks a year for salaried employees.In the excel spreadsheet, see the tab Payroll Details to perform any necessary calculations.Intangible AssetsAmortize the intangibles according to the schedule. Amortization is recorded on an annual basis. In the excel spreadsheet, see the tab Intangible Assets to perform any necessary calculationsDividendsOn December a dividend of $ was declared to shareholders of record on January to be paid January Taxes To be ignored for this project REQUIRED:See the excel spreadsheet all information should be recorded using the excel template. Update tabs in excel as needed SHOW ALL WORK.Prepare journal entries for the above transactions.Post transactions to the worksheet and complete the worksheet.Prepare:Classified Statement of Financial PositionMultistep income statementStatement of Retained EarningsNotes to the financial statements for the assets section of the Statement of Financial Position ONLYNotes should include any reconciliation schedules or detailed schedules for assets.OTHER IMPORTANT INFORMATIONRound financial statements to the nearest dollar.Show ALL calculations.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started