After nearly destroying the city of Springfield USA because of many near nuclear melt downs caused...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
After nearly destroying the city of Springfield USA because of many near nuclear melt downs caused by Homer Simpson, Mr. Burns decided to go into selling cookies. On January 2, 2020, Mr. Burn continued his Good Old Fashion Cookies Empire. The company is still a merchandise company and still uses a net perpetual inventory system. 1. Prepare all the journal entries on a document. 2. Post all journal entries to the worksheet 3. Post all adjusting journal entries to the worksheet 4. In good form, produce a multi step income statement, statement of retained earnings, balance sheet, statement of cash flow, and bond amortization tables for Bond #1, and Bond #2 (for the life of the bonds). Instructions: 1. Post the journal entry amounts in columns F and H, post adjusting journal entry amounts in columns N and P, and post the closing entry amounts in columns V and Y. 2. Do not touch the columns with the account balances for they are formula driven. You will not have to calculate anything! 3. For tracking purposes post the journal entries as they appear. The regular transaction numbers will be posted in columns E and G. The adjusting transaction numbers will be posted in columns M and O. The closing transaction numbers will be posted in columns U and W. Regular transactions will have just the number (1, 2, 3, ECT). Adjusting transactions will have A in front of the number (A1, A2, A3, and ECT). Closing transactions will have C in front of the number (C1 and C2). 4. For the statements: use only the cells marked in yellow to put in numbers. The totals will calculate for you. You will not be required to do any formatting. 5. Failure to follow any of these instructions will result in 25 point non-negotiable penalty. 6. Working with a tutor is not allowed. 8. No late assignments will be accepted for any reason. Must do each portion on time to receive credit for the entire project. See dates on Moodle for uploads. Misc. Information: Mr. Smithers performed the necessary entries to get the books up to date; this included the reduction of the mortgage payable. However, you will calculate interest expense, bad debt expense, and depreciation expense. These amounts will not be given to you. Good luck and time manage appropriately. ***For any note/mortgage payable, you find interest expense the same way you find interest revenue. *** Check Figures: Unadjusted Net Loss: ($80,251) Adjusted Net Loss: ($257,310) Journal Entries: 1. January 2: After from returning from exile, Mr. Burns invested $500,000 of personal funds directly in the business to strengthen his grip on the cookie market and received preferred stock. 2. January 3: In order to keep the IRS off his trail, Mr. Burns transferred money from his personal account into a Cayman Island secret account for $10,000,000 3. January 3: In order to expand his cookie factory and be able to dump toxic waste without being impeded by the Feds, Mr. Burs bought land for cash for $400,000. The bald children in the park was drawing attention from the Environmental Protection Agency 4. January 4: Being threatening to block out the sun, Mr. Burns was able to expedite the collection of the beginning 2020 balance of Accounts Receivable 5. January 5: In order to ease his beginning of the year cash flow crunch, Mr. Burns issued Common Stock (1,000,000 shares at $2.00 per share, par value $1.00 per share) 6. February 1: In order to keep up with being 104 year old hip evil billionaire, Mr. Burns decided to purchase a new truck. The truck cost $40,000. Mr. Burns put a down payment on the truck of $10,000 and took out a note for the rest (long term). The interest rate of the note is 8%. The truck will depreciated by miles. The expected life of the truck is 100,000 miles. 7. February 20: Mr. Burns sold his delicious cookies to candy store on account $200,000. Mr. Burns offered terms 2/10, n30. The cost of merchandise sold was $100,000. 8. February 28: Mr. Burns bought cookie dough to keep the cookie assembly line going. Mr. Burns paid cash for the cookie dough $250,000 9. March 1, Mr. Burns reclassed $50,000 from the long term note payable to current Insert Table Chart Text Shape Media Comment 6. Teoroary 20. Mi. Durns bougit cookie dougar to keep the cookie assemory ime going Mr. Burns paid cash for the cookie dough $250,000 9. March 1, Mr. Burns reclassed $50,000 from the long term note payable to current 10. March 5: Mr. Burns paid for the following expenses that came in: Sales Salary $70,000, Advertising Expense $50,000, and Delivery Expense $40,000. Use only one cash transaction 11. March 6: Mr. Burns collected $30,000 of the 1/1/2020 balance of the note receivable from Mayor Quimby. The interest rate was 15% and the Note was written on July 6th, 2019 12. March 7: The Candy Store paid Mr. Burns what they owed him on account. 13. March 15: Mr. Burns paid income tax payable owed from last year. 14. April 1: Not liking being accountable to outside shareholders, Mr. Burns decided to buy back some treasury stock. Mr. Burns bought the $1.00 per value shares back (200,000 shares) at $.50 per share. 15. April 10: Mr. Burns paid for the following expenses: Advertising $110,000, Office Salaries $60,000, Wages $30,000, and Utility Expense $10,000. Only use one entry for cash 16. May 01: The Grocery Store bought $300,000 of cookies on account. Mr. Burns was still angry that his casino got shutdown so there were no discount terms. The cost of the inventory was $150,000 17. June 1: Having its own cash flow crunch, The Grocery Store paid Mr. Burns $100,000 and issued a note for $200,000. Against their better judgment, they agreed to the terms of 14% 18. June 2: Mr. Burns issued a 2:1 Stock Split ET insert Table Chart Text Shape Media Comant 17. June 1: Having its own cash flow cninch, The Grocery Store paid Mr. Burns $100,000 and issued a note for $200,000. Against their better judgment, they agreed to the terms of 14% Q 18. June 2: Mr. Burns issued a 2:1 Stock Split 19. June 3: Mr. Burns bought back an additional 200,000 shares of Treasury Stock at $.50 per share 20. June 21: The following expenses accrued and are to be paid in a later month: Pension Expense $60,000, Health Insurance Expense $50,000, and Professional Fees $10,000. 21. July 1. Mr. Burns issued $500,000, 10 years (semi annual payments) coupon rate of 10%, market rate of 12%. Mr. Smithers gave this bond the code name Bond #1 22. July 1. Mr. Burns issued $400,000 bond (Bond #2) 10 years (semi-annual payments) coupon rate of 12%, market rate of 10% 23. September 8: Mr. Barns paid the expenses accrued on June 21. 24 October 5: The Grocery Store paid the principle of the note and the interest. 25 October 15: Mr. Burns wrote off the amount sitting in allowance for doubtful account because Abe Simpson refused to pay for the cookies he bought in 2019. Mr. Burns used $50,000 of personal funds to hire a hit squad to go after Abe Simpson, 26 November 1: After being advised by legal counsel and Mr. Smithers that killing off competition was considered murder, Mr. Burns decided to get a patent to keep from his secrets from being used by his rivals. He paid $100,000 for his patent which will be amortized for 10 years. 80 27. December 1: Mr. Burns bought Cookie Dough and paid for the amount up front to get a bulk (trade) discount. The amount paid is $400,000 DOD 000 F4 A F 00 FT DI FB DD 99 EB 24 insert Table Chart Text Shape Media Comment 26. November 1: After being advised by legal counsel and Mr. Smithers that killing off competition was considered murder, Mr. Burns decided to get a patent to keep from his secrets from being used by his rivals. He paid $100,000 for his patent which will be amortized for 10 years. 27. December 1: Mr. Burns bought Cookie Dough and paid for the amount up front to get a bulk (trade) discount. The amount paid is $400,000 28. December 8: Mr. Burns bought office supplies on account from Staples for $30,000. 29. December 9 Mr. Burs sold $450,000 of cookies on account to Shelbyville. The cost of sales was $250,000 30. December 25: Mr. Burns paid a cash dividend after being visited by the three ghosts of Christmas to the Shareholder $500,000 31. December 31: Mr. Burns made interest payment on Bond #1. Use effective interest method 32. December 31: Mr. Burns made interest payment on Bond #2 Use effective interest method Adjusting Entries: At December 31, 2020, Mr. Burns Good Old Fashion Cookies made the following adjusting entries. Al. Mr. Burns recorded the depreciation for the fixed assets. The truck had 40,000 miles at December 31 and has an expected life of 3 years. Round to the nearest dollar. The other assets used double-declining balance A2. Half of Mr. Burns Prepaid Rent Expired On non 90 DII 99 A3. After Physical Inventory Conducted: Balance in plant supplies at year end: $700. Balance in office supplies at year end: $4,000 A4. Income Taxes accrued $50,000. This is to be paid March 15, 2020 AS. Office Salaries accrued $20,000. Wages accrued $15,000 A6. Mr. Burns uses the balance sheet approach to estimate how money he will lose in uncollectible accounts. Since the city of Springfield is in a serve recession, Mr. Smithers estimated for Mr. Burns that 7% of this year ending accounts receivable will be uncollectible. A7. Two months of the patent have expired. A8. Mr. Smithers discovered a sale on account earned by not yet recorded, $50,000. Since this amount was discovered after the estimate for uncollectible account, this amount WILL not be included in adjusting entry A6. There were no discount terms A9. All unearned revenue was eamed (sales revenue) in 2020 A10 Physical Inventory count results $270,000. The amount is considered immaterial and can be adjusted to Cost of Goods Sold Closing Entries: C1. Close Revenues & Expenses directly to Retained Earnings C2. Close Cash Dividends to Retained Earnings 20 DOO 44 DII After nearly destroying the city of Springfield USA because of many near nuclear melt downs caused by Homer Simpson, Mr. Burns decided to go into selling cookies. On January 2, 2020, Mr. Burn continued his Good Old Fashion Cookies Empire. The company is still a merchandise company and still uses a net perpetual inventory system. 1. Prepare all the journal entries on a document. 2. Post all journal entries to the worksheet 3. Post all adjusting journal entries to the worksheet 4. In good form, produce a multi step income statement, statement of retained earnings, balance sheet, statement of cash flow, and bond amortization tables for Bond #1, and Bond #2 (for the life of the bonds). Instructions: 1. Post the journal entry amounts in columns F and H, post adjusting journal entry amounts in columns N and P, and post the closing entry amounts in columns V and Y. 2. Do not touch the columns with the account balances for they are formula driven. You will not have to calculate anything! 3. For tracking purposes post the journal entries as they appear. The regular transaction numbers will be posted in columns E and G. The adjusting transaction numbers will be posted in columns M and O. The closing transaction numbers will be posted in columns U and W. Regular transactions will have just the number (1, 2, 3, ECT). Adjusting transactions will have A in front of the number (A1, A2, A3, and ECT). Closing transactions will have C in front of the number (C1 and C2). 4. For the statements: use only the cells marked in yellow to put in numbers. The totals will calculate for you. You will not be required to do any formatting. 5. Failure to follow any of these instructions will result in 25 point non-negotiable penalty. 6. Working with a tutor is not allowed. 8. No late assignments will be accepted for any reason. Must do each portion on time to receive credit for the entire project. See dates on Moodle for uploads. Misc. Information: Mr. Smithers performed the necessary entries to get the books up to date; this included the reduction of the mortgage payable. However, you will calculate interest expense, bad debt expense, and depreciation expense. These amounts will not be given to you. Good luck and time manage appropriately. ***For any note/mortgage payable, you find interest expense the same way you find interest revenue. *** Check Figures: Unadjusted Net Loss: ($80,251) Adjusted Net Loss: ($257,310) Journal Entries: 1. January 2: After from returning from exile, Mr. Burns invested $500,000 of personal funds directly in the business to strengthen his grip on the cookie market and received preferred stock. 2. January 3: In order to keep the IRS off his trail, Mr. Burns transferred money from his personal account into a Cayman Island secret account for $10,000,000 3. January 3: In order to expand his cookie factory and be able to dump toxic waste without being impeded by the Feds, Mr. Burs bought land for cash for $400,000. The bald children in the park was drawing attention from the Environmental Protection Agency 4. January 4: Being threatening to block out the sun, Mr. Burns was able to expedite the collection of the beginning 2020 balance of Accounts Receivable 5. January 5: In order to ease his beginning of the year cash flow crunch, Mr. Burns issued Common Stock (1,000,000 shares at $2.00 per share, par value $1.00 per share) 6. February 1: In order to keep up with being 104 year old hip evil billionaire, Mr. Burns decided to purchase a new truck. The truck cost $40,000. Mr. Burns put a down payment on the truck of $10,000 and took out a note for the rest (long term). The interest rate of the note is 8%. The truck will depreciated by miles. The expected life of the truck is 100,000 miles. 7. February 20: Mr. Burns sold his delicious cookies to candy store on account $200,000. Mr. Burns offered terms 2/10, n30. The cost of merchandise sold was $100,000. 8. February 28: Mr. Burns bought cookie dough to keep the cookie assembly line going. Mr. Burns paid cash for the cookie dough $250,000 9. March 1, Mr. Burns reclassed $50,000 from the long term note payable to current Insert Table Chart Text Shape Media Comment 6. Teoroary 20. Mi. Durns bougit cookie dougar to keep the cookie assemory ime going Mr. Burns paid cash for the cookie dough $250,000 9. March 1, Mr. Burns reclassed $50,000 from the long term note payable to current 10. March 5: Mr. Burns paid for the following expenses that came in: Sales Salary $70,000, Advertising Expense $50,000, and Delivery Expense $40,000. Use only one cash transaction 11. March 6: Mr. Burns collected $30,000 of the 1/1/2020 balance of the note receivable from Mayor Quimby. The interest rate was 15% and the Note was written on July 6th, 2019 12. March 7: The Candy Store paid Mr. Burns what they owed him on account. 13. March 15: Mr. Burns paid income tax payable owed from last year. 14. April 1: Not liking being accountable to outside shareholders, Mr. Burns decided to buy back some treasury stock. Mr. Burns bought the $1.00 per value shares back (200,000 shares) at $.50 per share. 15. April 10: Mr. Burns paid for the following expenses: Advertising $110,000, Office Salaries $60,000, Wages $30,000, and Utility Expense $10,000. Only use one entry for cash 16. May 01: The Grocery Store bought $300,000 of cookies on account. Mr. Burns was still angry that his casino got shutdown so there were no discount terms. The cost of the inventory was $150,000 17. June 1: Having its own cash flow crunch, The Grocery Store paid Mr. Burns $100,000 and issued a note for $200,000. Against their better judgment, they agreed to the terms of 14% 18. June 2: Mr. Burns issued a 2:1 Stock Split ET insert Table Chart Text Shape Media Comant 17. June 1: Having its own cash flow cninch, The Grocery Store paid Mr. Burns $100,000 and issued a note for $200,000. Against their better judgment, they agreed to the terms of 14% Q 18. June 2: Mr. Burns issued a 2:1 Stock Split 19. June 3: Mr. Burns bought back an additional 200,000 shares of Treasury Stock at $.50 per share 20. June 21: The following expenses accrued and are to be paid in a later month: Pension Expense $60,000, Health Insurance Expense $50,000, and Professional Fees $10,000. 21. July 1. Mr. Burns issued $500,000, 10 years (semi annual payments) coupon rate of 10%, market rate of 12%. Mr. Smithers gave this bond the code name Bond #1 22. July 1. Mr. Burns issued $400,000 bond (Bond #2) 10 years (semi-annual payments) coupon rate of 12%, market rate of 10% 23. September 8: Mr. Barns paid the expenses accrued on June 21. 24 October 5: The Grocery Store paid the principle of the note and the interest. 25 October 15: Mr. Burns wrote off the amount sitting in allowance for doubtful account because Abe Simpson refused to pay for the cookies he bought in 2019. Mr. Burns used $50,000 of personal funds to hire a hit squad to go after Abe Simpson, 26 November 1: After being advised by legal counsel and Mr. Smithers that killing off competition was considered murder, Mr. Burns decided to get a patent to keep from his secrets from being used by his rivals. He paid $100,000 for his patent which will be amortized for 10 years. 80 27. December 1: Mr. Burns bought Cookie Dough and paid for the amount up front to get a bulk (trade) discount. The amount paid is $400,000 DOD 000 F4 A F 00 FT DI FB DD 99 EB 24 insert Table Chart Text Shape Media Comment 26. November 1: After being advised by legal counsel and Mr. Smithers that killing off competition was considered murder, Mr. Burns decided to get a patent to keep from his secrets from being used by his rivals. He paid $100,000 for his patent which will be amortized for 10 years. 27. December 1: Mr. Burns bought Cookie Dough and paid for the amount up front to get a bulk (trade) discount. The amount paid is $400,000 28. December 8: Mr. Burns bought office supplies on account from Staples for $30,000. 29. December 9 Mr. Burs sold $450,000 of cookies on account to Shelbyville. The cost of sales was $250,000 30. December 25: Mr. Burns paid a cash dividend after being visited by the three ghosts of Christmas to the Shareholder $500,000 31. December 31: Mr. Burns made interest payment on Bond #1. Use effective interest method 32. December 31: Mr. Burns made interest payment on Bond #2 Use effective interest method Adjusting Entries: At December 31, 2020, Mr. Burns Good Old Fashion Cookies made the following adjusting entries. Al. Mr. Burns recorded the depreciation for the fixed assets. The truck had 40,000 miles at December 31 and has an expected life of 3 years. Round to the nearest dollar. The other assets used double-declining balance A2. Half of Mr. Burns Prepaid Rent Expired On non 90 DII 99 A3. After Physical Inventory Conducted: Balance in plant supplies at year end: $700. Balance in office supplies at year end: $4,000 A4. Income Taxes accrued $50,000. This is to be paid March 15, 2020 AS. Office Salaries accrued $20,000. Wages accrued $15,000 A6. Mr. Burns uses the balance sheet approach to estimate how money he will lose in uncollectible accounts. Since the city of Springfield is in a serve recession, Mr. Smithers estimated for Mr. Burns that 7% of this year ending accounts receivable will be uncollectible. A7. Two months of the patent have expired. A8. Mr. Smithers discovered a sale on account earned by not yet recorded, $50,000. Since this amount was discovered after the estimate for uncollectible account, this amount WILL not be included in adjusting entry A6. There were no discount terms A9. All unearned revenue was eamed (sales revenue) in 2020 A10 Physical Inventory count results $270,000. The amount is considered immaterial and can be adjusted to Cost of Goods Sold Closing Entries: C1. Close Revenues & Expenses directly to Retained Earnings C2. Close Cash Dividends to Retained Earnings 20 DOO 44 DII
Expert Answer:
Related Book For
Posted Date:
Students also viewed these organizational behavior questions
-
The City of Springfield is considering the installation of downtown parking meters. Use the Coase Theorem to discuss the steps that should be taken to make the program a success.
-
Based on Eaton et al. (1985). The city of Springfield has been divided into eight districts. The time (in minutes) it takes an ambulance to travel from one district to another is shown in the file...
-
On October 1, 2010 Mardy Corporation issued 5%, 10-year bonds with a face value of $1,000,000 at 108 (a 4% yield). Interest is paid on October 1 and April 1, with any premiums or discounts amortized...
-
Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as follows: Selling price per fireplace Manufacturing costs: Variable per unit produced: Direct materials Direct labor...
-
How much larger will the value of an RRSP be at the end of 20 years if the contributor makes month-end contributions of $500, instead of year-end contributions of $6000? In both cases the RRSP earns...
-
1. The separate incomes of Pil Corporation and Sil Corporation, a 100 percent-owned subsidiary of Pil, for 2012 are $2,000,000 and $1,000,000, respectively. Pil sells all of its output to Sil at 150...
-
Continuing to focus on evidence associated with the act, concealment, and conversion, use the evidentiary material to continue the examination. In addition, the examiner also starts to think of terms...
-
Examine the tests of controls and substantive tests of transactions results, including the sampling application in Case 18-32, for Ward Publishing Company. Assume that you have already reached...
-
Find the value of an investment of $14,771 for 14 years at an annual interest rate of 5.27% compounded continuously.
-
Lakey International is a foreign corporation that maintains its books of record in foreign currency (FC), although its functional currency is the U.S. dollar. Lakey originally began operations on...
-
In all the negotiating you will do as a recruiter, what will best test your ability as a negotiator? Select an answer: negotiating with a top talent prospect to fill out an application negotiating...
-
Anthony and Matt are connected to the internet. Anthony is located in India and Matt is located in Kenya. The Web Server is located in US and the DNS Server in Singapore. Anthony types www . ....
-
A user has an Azure subscription named SUBS1. The user VM1 using SUBS1. The user needs to monitor the metrics and the logs of VM1, what should the u use? a Linux virtual machine namec -2024 Lin...
-
The price of a good will fall if a. demand for the good increases. b. supply of the good decreases. C. supply of the good increases. demand for the good remains constant. supply of the good remains...
-
4. Let the L language be defined by the following regular expression: L = (aa* + c(bb)*)*dd a) Construct the transition diagram of the finite automata (NFA) that recognizes the L language. (in the...
-
Why does Israel want Gaza?
-
In the early 1980's the debt to GNP ratio of South Korea was the same as the debt to GNP ratio of Argentina. Yet while Argentina was embroiled in a "debt crisis", South Korea (with the same amount of...
-
You are planning to purchase your first home five years from today. The required down payment will be $50,000. You currently have $20,000. but you plan to contribute $500 each quarter to a special...
-
What are the five allocative decisions that must be made within each economic system?
-
Stock of XYZ Corp. is listed daily in the financial press. Three columns of the listing for XYZ on a recent day are shown below: a. What was the closing price of XYZ on this day? b. What are the...
-
An important part of the farm service sector is the Cooperative Extension Service with an office in virtually every county of the U.S. Contact the local office of your Cooperative Extension Service...
-
A candlestick chart is similar to a bar chart except that the candlestick chart: A. Represents upward movements in price with Xs. B. Also graphically shows the range of the periods highs and lows. C....
-
What considerations might encourage a market analyst to rely more on a top-down or bottom-up forecast of S&P 500 operating earnings?
-
Which of the following advantages listed by Ryan with respect to the earnings-based approach studied by Atkinson is most likely correct? The model A. Can be used for non-U.S. equity markets. B....
Study smarter with the SolutionInn App