ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2018. Aylmer has two main business segments. This first segment is the construction of large-scale projects. In 2020, Aylmer had two large construction projects in process. The other segment is the sale of construction equipment. Details of the construction projects and the sale of construction equipment can be found later in this document and in the accompanying Excel file. Aylmer had 100,000 common shares outstanding and the shares are publicly traded. Since Aylmer is a publicly traded company, it follows IFRS. There are no preferred shares outstanding. Aylmer posted accounting transactions throughout the year. The Excel unadjusted trial balance was prepared from the recorded transactions. Aylmer's fiscal year-end is December 31". As a year-end review, management of Aylmer discovered that the following items have NOT been recorded and are NOT reflected in the unadjusted trial balance provided at December 31, 2020. For any journal entries, use December 31 as the date for the entries. The accompanying Excel spreadsheet has important information and requirements. Please review the entire file carefully. The unadjusted trial balance at December 31, 2020 and final trial balance at December 31, 2019 are provided in the Excel file for comparison purposes. Please see the Excel tab labelled "Trial Balance". Use this Excel file and this tab to post journal entries as required, and to ensure that the worksheet remains in balance. You should use the worksheet to provide the ending balances needed to prepare the financial statements at December 31, 2020. Ignore income taxes for this project. REQUIRED (please read the entire document before starting the project) Analyze and review the following items (a -r) and determine the appropriate journal entry, if any, required. Record the appropriate journal entry in the Excel tab labelled "journal entries. Use the various tabs in the Excel file to perform calculations and use the tabs as support for your journal entries, financial statement preparation, and notes to the financial statements. Read the transactions below very carefully and the requirements that follow. This project accounts for 15% of your final grade and is due on Friday August 6, 2021 @11:59 pm. You should complete this project on your own but please ask questions as you progress through the project. If there is time, virtual classes may be allocated to questions related to the project. NOTE - before you begin the Excel work, enter your student ID number on the Excel tab "Students First Step" as indicated. See the "REQUIRED" section below for important information ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT TRANSACTIONS NOT INCLUDED IN THE UNADJUSTED TRIAL BALANCE at DECEMBER 31, 2020: a. Cash & Equivalents In the Excel spreadsheet, see the details for the cash equivalents in order to accrue interest earned, if needed. b. Calculate bad debt On December 31, 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: 0-30 days 1.25% 31 - 60 days 5.60% 61 - 90 days 7.50% 91 - 120 days 12.00% Over 120 days 21.00% In the Excel spreadsheet, see the tab labelled Trade Accounts Receivable Detail to perform any necessary calculations c. FV-NI Investments At December 31, 2020; the fair value of the short-term investments were: Redemption Corp $13.50 per share ALM Corp $24.02 per share In the Excel spreadsheet, see the tab "FV-NI Investments" to perform any necessary calculations. d. Prepaid Insurance A payment to State Farm Insurance was made on October 1, 2020, with the entire amount posted to Prepaid Insurance. The policy lasts 18 months. There are no other amounts included in Prepaid Insurance. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT e. Inventory The 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 Statement of Earnings 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. f. Inventory on Consignment At December 31, 2020; the company received the following information for inventory on consignment: 1. All X10S machines were sold for $12,500 cach. 2. Three of the J050 machines were sold for $7.200 each. The consignee received 6% commission on each sale and was allowed a 2% allowance for advertising. The consignee will pay the company the amount owed on January 15, 2021. In the Excel spreadsheet, see the tab "Inventory on Consignment" to perform any necessary calculations. Use "Other Accounts Receivable" if needed for this transaction & Record Depreciation on assets Depreciate the fixed assets according to the schedule. Depreciation is calculated on an annual basis using the straight-line method. For assets purchased during the year, round to the nearest month when calculating depreciation. Note-two assets were purchased during the year. In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations. Details on asset 2020-18 are provided below. h. Traded a vehicle On December 31, 2020 (after recording depreciation); the company traded asset #2018-03 for a 2012 Ford F150. In addition to the trade, the company paid $2,000 cash for the new truck. The fair value of asset # 2018-03 was $9,000. Assume that this transaction HAS commercial substance. Once this new asset is purchased, do not depreciate it. NOTE: This transaction has not been recorded and is NOT reflected in the Unadjusted Trial Balance (on the Cash & Equivalents tab, the amount paid should flow thru the BMO Chequing account) In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations, and update the schedule as needed. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT i. Revalue an Asset On December 31, 2020 (after recording depreciation), the company reviewed assets for revaluation. The building at 410 Main Street was appraised with a new value of $146,000. The company uses the revaluation asset adjustment method to account for revaluations. In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations, and update the schedule as needed. j. Investments -FV-OCI On December 31, 2020, the fair value per share of Hub Cap Company was $11.32 per share, Aylmer decided to sell it's shares in Hub Cap Company at that time. NOTE: This transaction has not been recorded and is NOT reflected in the Unadjusted Trial Balance (on the Cash & Equivalents tab, the amount paid should flow thru the BMO Deposit account). In the Excel spreadsheet, see the tab "FV-OCI Investments" to perform any necessary calculations, k. Bank Loan Interest on the bank loan is 2.40% annually. Interest has to be paid on January 7, 2021; for 2020. The entire amount of the loan ($4,000,000) was outstanding during the entire year. No payments were made during the year. Of the bank loan, S1,000,000 is due June 30, 2021 with the remainder due June 30, 2026. 1. Notes Payable This is a short-term note. The company borrowed money from JRT Investments on October 31, 2020 for 3 months. The principal, along with interest is to be repaid on January 31, 2021. The interest rate is 1.3%. m. Long-term contracts The company uses the percentage of completion method for recording long-term contracts. The company has two long-term contracts with details below Project 1- Downtown Hotel & Shopping Centre Contract price and details are in the excel file. Expected completion date is in 2022 Project 2 - Factory & Warehouse Contract price and details are in the excel file. Expected completion date is in 2023 In the Excel spreadsheet, see the tab "Revenue Recognition to perform any necessary calculations. More detailed information is provided on that tab. You only need to record the transactions for revenue and expense recognition - not billing and not cash collections. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT n. Accrue wages December 31, 2020 is a Thursday. All (salaried and hourly) employees are paid weekly (Monday - Friday) each Friday for a five-day work week. Assume that hourly employees in December work 8 hours per day. In the Excel spreadsheet, see the tab "Payroll Details" to perform any necessary calculations and accruals. 0. Write down goodwill Goodwill was a result of a combination of activities in 2019. After an analysis, the following information relating to goodwill was determined: Value in use $603,000 Fair value less cost to sell $580,000 There is no Excel tab for goodwill - you can add a tab to show your calculations. p. Intangible Assets During 2020, a trademark and a patent were purchased. For details, see the Excel file tab "Intangible Assets". The intangible assets are amortized on a straight-line method. To test for impairment, the following items were determined regarding the trademark: Value in use $110,000 FV less costs to sell $115,500 In the Excel spreadsheet, see the tab "Intangible Assets" to perform any necessary calculations 9. Dividends On December 31, 2020 a dividend of $0.70 was declared to shareholders of record on January 10, 2021 to be paid January 29, 2021. Use the direct method and flow the dividend declaration through retained earnings. r. Taxes To be ignored for this project 5. Closing Entries Closing entries are NOT required for this project. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT REQUIRED: 1. See the Excel spreadsheet "ACCT 3036 Project S21" - all information should be recorded using the Excel template. Update the tabs in Excel as needed - SHOW ALL WORK and CALCULATIONS. The Excel tabs are protected, use the GREEN area of each tab for your calculations and notes. Protection is required to maintain integrity of the spreadsheet 2. Be sure to enter your student ID number in the "STUDENTS - FIRST STEP" tab. Enter as a number (no "quotation marks"). If your student ID number is 00123; just enter 123. 3. Prepare journal entries for the above transactions. 4. Post transactions to the trial balance worksheet and complete the worksheet. 5. Prepare for 2019 and 2020: 1. Classified Statement of Financial Position 2. Multi-step Statement of Comprehensive Income 3. Statement of Retained Earnings 4. Notes to the Financial Statements (for the assets section of the Statement of Financial Position ONLY - see list on tab "Notes to the Financials"). a. Notes should include (for 2020 only): i. Reconciliation schedules or detailed schedules for assets. ii. Description of the account and relevant policies. iii. Other information you feel should be disclosed. OTHER IMPORTANT INFORMATION 1. Round financial statements to the nearest dollar. 2. Show ALL calculations The project should be completed individually, Please leave your completed project in the FOL submission folder - labelled - PROJECT There are 115 potential points to this project and accounts for 15% of your final grade. Due date is August 6, 2021. Late assignments will be accepted with an automatic 50% penalty for the first day late and another 50% penalty for the second day late. Please email your instructor with any questions or concerns. Don't wait to begin this project - start as soon as possible to avoid an end-of-semester rush. Your instructor will check in with all of you on your progress. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2018. Aylmer has two main business segments. This first segment is the construction of large-scale projects. In 2020, Aylmer had two large construction projects in process. The other segment is the sale of construction equipment. Details of the construction projects and the sale of construction equipment can be found later in this document and in the accompanying Excel file. Aylmer had 100,000 common shares outstanding and the shares are publicly traded. Since Aylmer is a publicly traded company, it follows IFRS. There are no preferred shares outstanding. Aylmer posted accounting transactions throughout the year. The Excel unadjusted trial balance was prepared from the recorded transactions. Aylmer's fiscal year-end is December 31". As a year-end review, management of Aylmer discovered that the following items have NOT been recorded and are NOT reflected in the unadjusted trial balance provided at December 31, 2020. For any journal entries, use December 31 as the date for the entries. The accompanying Excel spreadsheet has important information and requirements. Please review the entire file carefully. The unadjusted trial balance at December 31, 2020 and final trial balance at December 31, 2019 are provided in the Excel file for comparison purposes. Please see the Excel tab labelled "Trial Balance". Use this Excel file and this tab to post journal entries as required, and to ensure that the worksheet remains in balance. You should use the worksheet to provide the ending balances needed to prepare the financial statements at December 31, 2020. Ignore income taxes for this project. REQUIRED (please read the entire document before starting the project) Analyze and review the following items (a -r) and determine the appropriate journal entry, if any, required. Record the appropriate journal entry in the Excel tab labelled "journal entries. Use the various tabs in the Excel file to perform calculations and use the tabs as support for your journal entries, financial statement preparation, and notes to the financial statements. Read the transactions below very carefully and the requirements that follow. This project accounts for 15% of your final grade and is due on Friday August 6, 2021 @11:59 pm. You should complete this project on your own but please ask questions as you progress through the project. If there is time, virtual classes may be allocated to questions related to the project. NOTE - before you begin the Excel work, enter your student ID number on the Excel tab "Students First Step" as indicated. See the "REQUIRED" section below for important information ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT TRANSACTIONS NOT INCLUDED IN THE UNADJUSTED TRIAL BALANCE at DECEMBER 31, 2020: a. Cash & Equivalents In the Excel spreadsheet, see the details for the cash equivalents in order to accrue interest earned, if needed. b. Calculate bad debt On December 31, 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: 0-30 days 1.25% 31 - 60 days 5.60% 61 - 90 days 7.50% 91 - 120 days 12.00% Over 120 days 21.00% In the Excel spreadsheet, see the tab labelled Trade Accounts Receivable Detail to perform any necessary calculations c. FV-NI Investments At December 31, 2020; the fair value of the short-term investments were: Redemption Corp $13.50 per share ALM Corp $24.02 per share In the Excel spreadsheet, see the tab "FV-NI Investments" to perform any necessary calculations. d. Prepaid Insurance A payment to State Farm Insurance was made on October 1, 2020, with the entire amount posted to Prepaid Insurance. The policy lasts 18 months. There are no other amounts included in Prepaid Insurance. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT e. Inventory The 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 Statement of Earnings 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. f. Inventory on Consignment At December 31, 2020; the company received the following information for inventory on consignment: 1. All X10S machines were sold for $12,500 cach. 2. Three of the J050 machines were sold for $7.200 each. The consignee received 6% commission on each sale and was allowed a 2% allowance for advertising. The consignee will pay the company the amount owed on January 15, 2021. In the Excel spreadsheet, see the tab "Inventory on Consignment" to perform any necessary calculations. Use "Other Accounts Receivable" if needed for this transaction & Record Depreciation on assets Depreciate the fixed assets according to the schedule. Depreciation is calculated on an annual basis using the straight-line method. For assets purchased during the year, round to the nearest month when calculating depreciation. Note-two assets were purchased during the year. In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations. Details on asset 2020-18 are provided below. h. Traded a vehicle On December 31, 2020 (after recording depreciation); the company traded asset #2018-03 for a 2012 Ford F150. In addition to the trade, the company paid $2,000 cash for the new truck. The fair value of asset # 2018-03 was $9,000. Assume that this transaction HAS commercial substance. Once this new asset is purchased, do not depreciate it. NOTE: This transaction has not been recorded and is NOT reflected in the Unadjusted Trial Balance (on the Cash & Equivalents tab, the amount paid should flow thru the BMO Chequing account) In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations, and update the schedule as needed. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT i. Revalue an Asset On December 31, 2020 (after recording depreciation), the company reviewed assets for revaluation. The building at 410 Main Street was appraised with a new value of $146,000. The company uses the revaluation asset adjustment method to account for revaluations. In the Excel spreadsheet, see the tab "Fixed Asset Details" to perform any necessary calculations, and update the schedule as needed. j. Investments -FV-OCI On December 31, 2020, the fair value per share of Hub Cap Company was $11.32 per share, Aylmer decided to sell it's shares in Hub Cap Company at that time. NOTE: This transaction has not been recorded and is NOT reflected in the Unadjusted Trial Balance (on the Cash & Equivalents tab, the amount paid should flow thru the BMO Deposit account). In the Excel spreadsheet, see the tab "FV-OCI Investments" to perform any necessary calculations, k. Bank Loan Interest on the bank loan is 2.40% annually. Interest has to be paid on January 7, 2021; for 2020. The entire amount of the loan ($4,000,000) was outstanding during the entire year. No payments were made during the year. Of the bank loan, S1,000,000 is due June 30, 2021 with the remainder due June 30, 2026. 1. Notes Payable This is a short-term note. The company borrowed money from JRT Investments on October 31, 2020 for 3 months. The principal, along with interest is to be repaid on January 31, 2021. The interest rate is 1.3%. m. Long-term contracts The company uses the percentage of completion method for recording long-term contracts. The company has two long-term contracts with details below Project 1- Downtown Hotel & Shopping Centre Contract price and details are in the excel file. Expected completion date is in 2022 Project 2 - Factory & Warehouse Contract price and details are in the excel file. Expected completion date is in 2023 In the Excel spreadsheet, see the tab "Revenue Recognition to perform any necessary calculations. More detailed information is provided on that tab. You only need to record the transactions for revenue and expense recognition - not billing and not cash collections. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT n. Accrue wages December 31, 2020 is a Thursday. All (salaried and hourly) employees are paid weekly (Monday - Friday) each Friday for a five-day work week. Assume that hourly employees in December work 8 hours per day. In the Excel spreadsheet, see the tab "Payroll Details" to perform any necessary calculations and accruals. 0. Write down goodwill Goodwill was a result of a combination of activities in 2019. After an analysis, the following information relating to goodwill was determined: Value in use $603,000 Fair value less cost to sell $580,000 There is no Excel tab for goodwill - you can add a tab to show your calculations. p. Intangible Assets During 2020, a trademark and a patent were purchased. For details, see the Excel file tab "Intangible Assets". The intangible assets are amortized on a straight-line method. To test for impairment, the following items were determined regarding the trademark: Value in use $110,000 FV less costs to sell $115,500 In the Excel spreadsheet, see the tab "Intangible Assets" to perform any necessary calculations 9. Dividends On December 31, 2020 a dividend of $0.70 was declared to shareholders of record on January 10, 2021 to be paid January 29, 2021. Use the direct method and flow the dividend declaration through retained earnings. r. Taxes To be ignored for this project 5. Closing Entries Closing entries are NOT required for this project. ACCT 3036 - Intermediate Accounting 1: Summer 2021 PROJECT REQUIRED: 1. See the Excel spreadsheet "ACCT 3036 Project S21" - all information should be recorded using the Excel template. Update the tabs in Excel as needed - SHOW ALL WORK and CALCULATIONS. The Excel tabs are protected, use the GREEN area of each tab for your calculations and notes. Protection is required to maintain integrity of the spreadsheet 2. Be sure to enter your student ID number in the "STUDENTS - FIRST STEP" tab. Enter as a number (no "quotation marks"). If your student ID number is 00123; just enter 123. 3. Prepare journal entries for the above transactions. 4. Post transactions to the trial balance worksheet and complete the worksheet. 5. Prepare for 2019 and 2020: 1. Classified Statement of Financial Position 2. Multi-step Statement of Comprehensive Income 3. Statement of Retained Earnings 4. Notes to the Financial Statements (for the assets section of the Statement of Financial Position ONLY - see list on tab "Notes to the Financials"). a. Notes should include (for 2020 only): i. Reconciliation schedules or detailed schedules for assets. ii. Description of the account and relevant policies. iii. Other information you feel should be disclosed. OTHER IMPORTANT INFORMATION 1. Round financial statements to the nearest dollar. 2. Show ALL calculations The project should be completed individually, Please leave your completed project in the FOL submission folder - labelled - PROJECT There are 115 potential points to this project and accounts for 15% of your final grade. Due date is August 6, 2021. Late assignments will be accepted with an automatic 50% penalty for the first day late and another 50% penalty for the second day late. Please email your instructor with any questions or concerns. Don't wait to begin this project - start as soon as possible to avoid an end-of-semester rush. Your instructor will check in with all of you on your progress