DeeDee Double Entry, Incorporated creates accounting games and literature to enhance accounting education and financial literacy. Their business has been quite successful since their incorporation in January 1, 2012. DeeDee recently lost their accountant but luckily they have arranged for a fine accounting/finance student from Oakland University to assist in the closing process. They have provided you with the unadjusted trial balance for DeeDee Double Entry Incorporated as of 12/31/13. The previous accountant recorded all original entries involving cash, etc. during the year. However, at year-end the previous accountant would make all necessary adjusting/reclassification journal entries so that the principles of US GAAP were followed. Your task will be to create and record all necessary adjusting, correcting, and reclassification entries so that 2013 financial statements in accordance with US GAAP can be issued. The below information was discovered by reviewing contracts, agreements, correspondence and discussions with management. Your required tasks are as follows: 1. Read the below information and follow steps #2 through #9 2. On the "Adjusting Journal Entries" worksheet, prepare in journal entry form all adjusting and correcting journal entries based on the following information. All information was provided to you as of 12/31/2019. (Round all numbers to the nearest dollar). Label journal entries a through u. a. DeeDee does banking at three different financial institutions. The details are as follows: Bank Account # Balance Coterica 123456 85,000 Coterica 123457 (5,000) 4th Bank 345689 90,000 Bank Two 397567 (10.000) b. DeeDee properly wrote off uncollectible accounts during the year. Based on an aging schedule, they have determined that $85,000 of Accounts Receivable will not be collectible. c. On May 1, 2019, DeeDee renewed a 12-month insurance policy for $6,000. All cash was paid at the time the policy was signed and prepaid insurance was increased. All other transactions involving insurance were properly recorded. d. On November 1, 2019 DeeDee paid ABC Advertising $12,000 for a three month campaign of advertising services. Equal services are provided each month. All other advertising paid for during the year has been consumed. e. Because of strong demand and a need for additional inventory, DeeDee needed some temporary additional storage space so on July 1 2019 they rented a unit for an annual rate of $24,000 and they paid the entire amount up front. The entire amount was expensed on July 1st. Per a physical count of office supplies, $6,000 supplies remained at the end of 2019. The balance on the worksheet in the office supplies account represents last years ending balance. During the year, $17,500 of office supplies were purchased and immediately expensed. g. On July 1, 2019, DeeDee loaned a key supplier, $180,000. A promissory note was signed and issued. The agreed upon interest rate was 4.5% and the key supplier has agreed to pay interest and the note receivable on July 1, 2020. The note was recorded in Notes Receivable and is the only note outstanding. At December 31, 2019, no interest has been accrued. h. The office building was bought in January 1, 2017 by DeeDee and DeeDee plans to use the building for 40 years with no estimated salvage value. DeeDee depreciates the building on a straight line basis. i. DeeDee uses the DDB method to depreciate office equipment. No office equipment was added during 2019. It is estimated that the office equipment has a useful life of 20 years with a salvage value of $4,000. Prior depreciation was correctly calculated based on period of time held. As of 12/31/2019 the Available for Sale Equity Investments have a fair value of $385,000 and the fair value of the Available for Sale Debt Investments have a fair value of $110,000. Due to the market conditions, the company does not plan on selling the assets in 2020, but their intent is to sell at some point in time. You can ignore the tax effect on unrealized gains and losses. (Hint: Unrealized Gains and Losses - OCI are closed to Accumulated Other Comprehensive Income at the end of the year.) p. DeeDee has been authorized to issue 1,000,000 shares of S1 par Common Stock At the end of 2018, they had issued 50,000 shares for $25. They had properly accounted for this issuance. On January 2, 2019, they issued an additional 30,000 shares of Common Stock for $25 per share. The previous account recorded this transaction as a debit to Cash for $750,000 and a credit to Common Stock $750,000 4. DeeDee has a straight tax rate of 28%. Income tax expense is Net Income before taxes times 28%. (Hint: Prepare the Income Statement up to Net Income before Taxes and then record this adjusting journal entry.) 3. After the above adjusting entries are entered on the adjustment worksheet, the cells should be linked to the adjustments column of the worksheet. Your adjustment amounts in the worksheet column should be linked to the adjustment sheet so if you change the debit/credit amount in the adjusting entry, the column amount will automatically change. All adjustments should be labeled a-q and be in the order of the information provided. 4. Complete the adjusted columns by the use of a formula. Think about the best way to do this. Your last two columns should never contain constant numbers but will include formulas only. (Maximum points are given for using an 'if" statement, but the majority of the points are just given for having a proper formula). 5. Prepare a multiple-step income statement on the proper worksheet. Your Income Statement should be in good form (proper titles, etc., use examples from your book) and well formatted. Do your best designating between selling and administrative expenses. Judgement is involved in creating your income statement and there is no one correct answer. You should use formulas in all cells, not constant numbers. (That means, your income statement should be linked to the adjusted numbers on your worksheet.) 6. Prepare a Comprehensive Income Statement on the proper worksheet. DeeDee Double Entry Inc. uses the Second Income Statement Approach. (See Chapter 4) 7. Prepare a Statement of Changes in Stockholder's Equity. You should use formulas in all cells, not constant numbers. (See class notes for an example.) 8. Prepare a Classified Balance Sheet on the proper worksheet as of 12/31/19. Your Statement should be formatted. You should use formulas in all cells, not constant numbers. 9. Prepare closing entries on the proper tab. You may close directly to Retained Earnings (if you wish) A 13 Probolic Insurancentory C D E F 10 Interest Receivable LSINNE . EST 11 Merchandise Inventory MMILISINILIHIN THE 372,500 - 12 Prepaid Insurance LI L LELLT 6.000 13 Prepaid Advertising 12,000 14 Prepaid Rent IIIIMII LILLEMETLER 15 Office Supplies 5,000 16 Not Receivable MMIL L 80,000 17 Available for Sale Debt Investments 100,000 18 Available for Sale Equity Investments A LLERLEI 400,000 19 Office Building 3,100,000 20 Accumulated Depreciation - Office Building 155,000 121 Land 850,000 122T OffiCA Equipment 250.000 T 23 Accumulated Depreciation - Office Equipment 25,000 24 Copyrights 150,000 25 Accounts Payable 345,000 26 Sales Tax Payable SELLE 27 Salaries Payable 28 Payroll Taxes Payable HET DIE 29 Interest Payable - 130 Income Tax Payable - - 31 Uneamed Revenue - EST RE 32 Loan Payable - Coldstar Bank 1.500.000 33 Common Stock 800.000 34 Additional Paid in Capital 1.200.000 35 Retained Earnings- 889 420 36 Accumulated Other Comprehensive Income 8.500 37 Dividends 240.000 T 138 Sales 4.683.750 39 Sales Returns and Allowances HH21.700 . HERE 40 Sales Discounts 17 200 41 Cost of Goods Sold 1.757 200 5 42 Sales Salaries Expense 476,400 - 43 Office Salaries Expense 434.000 44 Advertising Expenso 54.000 . 45 Depreciation Expense - Office Building 46 Depreciaton Expense. Office Equipment 47 Leasing Expense - Stores 244.000 48 Miscellaneous Soling Expense 16,950 49 Research & Development Expense 50 Rent Expense - Storage Facility 24,000 2.000 T L 51 Insurance Expense 52 Office Supplies Expense 17500 . 53 Miscellaneous Administrative Expense 9,220S . L T 54 Rent Rovenue - 48.000 TL 55 Interest Revenue on Not Receivable 56 Unrealized Gain/Loss -Income R 57 Unrealized GOINLOSS OC E 4 000 58 Interest Revenue on Dobt Investments 12.000 59 Dividend Revenue on Equity Investments 60 Interest Expenso 6 BO DOBI Expense 62 Amortization Expense 63 Income Tax Expense 64 967007019 670 670 L 16 166 67 Adjusting Journal Entries Income Statement Comprehensive in Worksheet - Trial Balance Normal View Ready |||||||||||| 68 DeeDee Double Entry, Incorporated creates accounting games and literature to enhance accounting education and financial literacy. Their business has been quite successful since their incorporation in January 1, 2012. DeeDee recently lost their accountant but luckily they have arranged for a fine accounting/finance student from Oakland University to assist in the closing process. They have provided you with the unadjusted trial balance for DeeDee Double Entry Incorporated as of 12/31/13. The previous accountant recorded all original entries involving cash, etc. during the year. However, at year-end the previous accountant would make all necessary adjusting/reclassification journal entries so that the principles of US GAAP were followed. Your task will be to create and record all necessary adjusting, correcting, and reclassification entries so that 2013 financial statements in accordance with US GAAP can be issued. The below information was discovered by reviewing contracts, agreements, correspondence and discussions with management. Your required tasks are as follows: 1. Read the below information and follow steps #2 through #9 2. On the "Adjusting Journal Entries" worksheet, prepare in journal entry form all adjusting and correcting journal entries based on the following information. All information was provided to you as of 12/31/2019. (Round all numbers to the nearest dollar). Label journal entries a through u. a. DeeDee does banking at three different financial institutions. The details are as follows: Bank Account # Balance Coterica 123456 85,000 Coterica 123457 (5,000) 4th Bank 345689 90,000 Bank Two 397567 (10.000) b. DeeDee properly wrote off uncollectible accounts during the year. Based on an aging schedule, they have determined that $85,000 of Accounts Receivable will not be collectible. c. On May 1, 2019, DeeDee renewed a 12-month insurance policy for $6,000. All cash was paid at the time the policy was signed and prepaid insurance was increased. All other transactions involving insurance were properly recorded. d. On November 1, 2019 DeeDee paid ABC Advertising $12,000 for a three month campaign of advertising services. Equal services are provided each month. All other advertising paid for during the year has been consumed. e. Because of strong demand and a need for additional inventory, DeeDee needed some temporary additional storage space so on July 1 2019 they rented a unit for an annual rate of $24,000 and they paid the entire amount up front. The entire amount was expensed on July 1st. Per a physical count of office supplies, $6,000 supplies remained at the end of 2019. The balance on the worksheet in the office supplies account represents last years ending balance. During the year, $17,500 of office supplies were purchased and immediately expensed. g. On July 1, 2019, DeeDee loaned a key supplier, $180,000. A promissory note was signed and issued. The agreed upon interest rate was 4.5% and the key supplier has agreed to pay interest and the note receivable on July 1, 2020. The note was recorded in Notes Receivable and is the only note outstanding. At December 31, 2019, no interest has been accrued. h. The office building was bought in January 1, 2017 by DeeDee and DeeDee plans to use the building for 40 years with no estimated salvage value. DeeDee depreciates the building on a straight line basis. i. DeeDee uses the DDB method to depreciate office equipment. No office equipment was added during 2019. It is estimated that the office equipment has a useful life of 20 years with a salvage value of $4,000. Prior depreciation was correctly calculated based on period of time held. As of 12/31/2019 the Available for Sale Equity Investments have a fair value of $385,000 and the fair value of the Available for Sale Debt Investments have a fair value of $110,000. Due to the market conditions, the company does not plan on selling the assets in 2020, but their intent is to sell at some point in time. You can ignore the tax effect on unrealized gains and losses. (Hint: Unrealized Gains and Losses - OCI are closed to Accumulated Other Comprehensive Income at the end of the year.) p. DeeDee has been authorized to issue 1,000,000 shares of S1 par Common Stock At the end of 2018, they had issued 50,000 shares for $25. They had properly accounted for this issuance. On January 2, 2019, they issued an additional 30,000 shares of Common Stock for $25 per share. The previous account recorded this transaction as a debit to Cash for $750,000 and a credit to Common Stock $750,000 4. DeeDee has a straight tax rate of 28%. Income tax expense is Net Income before taxes times 28%. (Hint: Prepare the Income Statement up to Net Income before Taxes and then record this adjusting journal entry.) 3. After the above adjusting entries are entered on the adjustment worksheet, the cells should be linked to the adjustments column of the worksheet. Your adjustment amounts in the worksheet column should be linked to the adjustment sheet so if you change the debit/credit amount in the adjusting entry, the column amount will automatically change. All adjustments should be labeled a-q and be in the order of the information provided. 4. Complete the adjusted columns by the use of a formula. Think about the best way to do this. Your last two columns should never contain constant numbers but will include formulas only. (Maximum points are given for using an 'if" statement, but the majority of the points are just given for having a proper formula). 5. Prepare a multiple-step income statement on the proper worksheet. Your Income Statement should be in good form (proper titles, etc., use examples from your book) and well formatted. Do your best designating between selling and administrative expenses. Judgement is involved in creating your income statement and there is no one correct answer. You should use formulas in all cells, not constant numbers. (That means, your income statement should be linked to the adjusted numbers on your worksheet.) 6. Prepare a Comprehensive Income Statement on the proper worksheet. DeeDee Double Entry Inc. uses the Second Income Statement Approach. (See Chapter 4) 7. Prepare a Statement of Changes in Stockholder's Equity. You should use formulas in all cells, not constant numbers. (See class notes for an example.) 8. Prepare a Classified Balance Sheet on the proper worksheet as of 12/31/19. Your Statement should be formatted. You should use formulas in all cells, not constant numbers. 9. Prepare closing entries on the proper tab. You may close directly to Retained Earnings (if you wish) A 13 Probolic Insurancentory C D E F 10 Interest Receivable LSINNE . EST 11 Merchandise Inventory MMILISINILIHIN THE 372,500 - 12 Prepaid Insurance LI L LELLT 6.000 13 Prepaid Advertising 12,000 14 Prepaid Rent IIIIMII LILLEMETLER 15 Office Supplies 5,000 16 Not Receivable MMIL L 80,000 17 Available for Sale Debt Investments 100,000 18 Available for Sale Equity Investments A LLERLEI 400,000 19 Office Building 3,100,000 20 Accumulated Depreciation - Office Building 155,000 121 Land 850,000 122T OffiCA Equipment 250.000 T 23 Accumulated Depreciation - Office Equipment 25,000 24 Copyrights 150,000 25 Accounts Payable 345,000 26 Sales Tax Payable SELLE 27 Salaries Payable 28 Payroll Taxes Payable HET DIE 29 Interest Payable - 130 Income Tax Payable - - 31 Uneamed Revenue - EST RE 32 Loan Payable - Coldstar Bank 1.500.000 33 Common Stock 800.000 34 Additional Paid in Capital 1.200.000 35 Retained Earnings- 889 420 36 Accumulated Other Comprehensive Income 8.500 37 Dividends 240.000 T 138 Sales 4.683.750 39 Sales Returns and Allowances HH21.700 . HERE 40 Sales Discounts 17 200 41 Cost of Goods Sold 1.757 200 5 42 Sales Salaries Expense 476,400 - 43 Office Salaries Expense 434.000 44 Advertising Expenso 54.000 . 45 Depreciation Expense - Office Building 46 Depreciaton Expense. Office Equipment 47 Leasing Expense - Stores 244.000 48 Miscellaneous Soling Expense 16,950 49 Research & Development Expense 50 Rent Expense - Storage Facility 24,000 2.000 T L 51 Insurance Expense 52 Office Supplies Expense 17500 . 53 Miscellaneous Administrative Expense 9,220S . L T 54 Rent Rovenue - 48.000 TL 55 Interest Revenue on Not Receivable 56 Unrealized Gain/Loss -Income R 57 Unrealized GOINLOSS OC E 4 000 58 Interest Revenue on Dobt Investments 12.000 59 Dividend Revenue on Equity Investments 60 Interest Expenso 6 BO DOBI Expense 62 Amortization Expense 63 Income Tax Expense 64 967007019 670 670 L 16 166 67 Adjusting Journal Entries Income Statement Comprehensive in Worksheet - Trial Balance Normal View Ready |||||||||||| 68