SWEET TREATS PRACTICE SET Madison Carter spent much of her childhood learning the art of cookie-making from her grandmother. They spent many enjoyable hours mastering every type of cookie imaginable and later creating new recipes that were both healthy and delicious. Now at the start of her second year in college, Madison is investigating various possibilities for starting her own business as part of the requirements of the entrepreneurship program in which she is enrolled. A long-time friend insists that Madison has to somehow include cookies in her business plan. After a series of brainstorming sessions, Madison settles on the idea of operating a cookie-making school called "Sweet Treats". She will start on a part-time basis and offer her services "in-house". Now that she has started thinking about it, the possibilities seem endless. During the fall, she will concentrate on holiday cookies. She will offer individual lessons and group sessions. Madison decides to operate Sweet Treats as a sole proprietorship beginning on October 8th, with her year end at December 31st She purchased a new cell phone to use only for business operations. She also created a checklist to help her remember which elements of the accounting cycle need to be completed daily, monthly, and yearly. Daily (October) Record transactions in the general journal and post to the general ledger. (November & December) Record transactions in the four special journals, as needed -cash receipts journal, cash payments journal, purchases journal, and sales journal. Use the general journal to record anything that does not go into the special journals. (November & December) Post transactions into the two subsidiary ledgers, as needed - the accounts receivable subsidiary ledger and accounts payable subsidiary ledger. Use the general ledger to post anything that comes directly from the general journal. Monthly Journalize and post adjusting entries. Complete a worksheet for each month. (November & December) Post special journals totals to the necessary general ledger accounts. Yearly: Create financial statements for the year end December 31st - multi-step income statement, owner's equity statement, balance sheet, and statement of cash flows. Journalize and post closing entries. Prepare a post-closing trial balance. Madison continues to stay in touch with her grandmother during the first few months of operation. She appreciates that her grandmother has been so supportive of her. Madison has dreams of opening up a local Sweet Treats shop when she graduates from college. She wants to hire more employees and start offering more classes. INSTRUCTIONS 1. Record the following transactions according to Madison's checklist above. Be sure to read any new details given prior to each months' transactions 2. Prepare any necessary worksheets or forms according to Madison's checklist above. 3. Record all information in the provided spreadsheets. Be sure to include headers, dates, explanations, and totals when appropriate. Add rows as needed. 4. Follow all recording, journalizing, and posting rules provided in your textbook. The following transactions occurred during the month of October. Oct. 8 Madison cashes her U.S. Savings Bonds and receives $520, which she deposits in her personal bank account. 8 She opens a bank account under the name Sweet Treats and transfers $500 from her personal account to the new account. 11 Madison pays $65 for advertising. Check 153. She buys baking supplies, such as flour, sugar, butter, and chocolate chips, for $125 cash. Check 154. 13 14 Madison starts to gather some baking equipment to take with her when teaching the cookie classes. She has an excellent top-of-the-line food processor and mixer that originally cost her $750. Madison decides to start using it only in her new business. She estimates that the food processor is currently worth $300. She invests the food processor in the business. (Record the asset at current worth.) 16 Madison realizes that her initial cash investment is not enough. Her grandmother lends her $5,000 cash, for which Madison signs a note payable in the name of the business. Madison deposits the money in the business bank account. The note will be repaid in 24 months. 17 She buys more baking equipment for $900 cash. Check 155. 20 She teaches her first class and collects $125 cash. 25 Madison withdraws $100 from the business for personal expenditures. Check 156. 30 Madison pays $1,320 for a one-year insurance policy that will expire on November 1 of the next year. Check 157 30 A friend of Madison's asked her to teach a class at the neighborhood school, Newbury Elementary School. Madison agreed and taught a group of 35 first-grade students how to make gingerbread cookies. The next day, Madison prepared an invoice for $300 and left it with the school principal. The principal said that he will pass the invoice along the head office, and it will be paid sometime in November As of October 31, the following adjusting entry data is available. 1. A count reveals that $35 of baking supplies were used during October. 2. Madison estimates that her baking equipment depreciates $20 per month. 3. Madison's grandmother has decided to charge 8.4% interest on the note, and the loan plus interest is to be repaid in 24 months. Madison has decided to accrue the interest each month just to be sure her books correctly reflect what needs to be repaid. She will accrue a full month's interest in October, since she wouldn't even be off the ground without her grandma's help. 4. Madison had a friend assist her with the Newbury Elementary School class. She decides to hire her friend as an employee. She owes her $45 for the October 30 class, that she will pay on November 15. J1 Credit Ref. Date Oct. 8 General Journal Account Titles and Explanations Owner's Capital Cash (Amount invested in the business) Debit 500 500 Cash increased and should be the debit account | Oct. 11 Advertising Expense 65 Cash 65 (Adversting expense paid with check 153) Oct. 13 125 Baking Supplies Cash (Baking supplies for the business with check 154) 125 Oct. 14 300 Equipment Owner's Capital (Invested a food processer to the business) 300 Oct. 16 5000 Cash Note Payable (To record note payable) 5000 Oct. 17 900 Eglupment Cash (Purchased bakinf equipment with cash) 900 Oct. 20 125 Cash Service Revenue (Recorded earned revenue) 125 Oct. 25 100 Owner's Drawings Cash (For personal withdrawl) 100 Oct. 30 1320 Prepaid Insurance Cash (To record prepaid Insurance) 1320 Oct. 30 300 Accounts Receivable Service Revenue (Invoice for elementary school class) 300 General Ledger Ref. Credit Debit 500.00 65.00 125.00 Cash Date Oct. 8 Oct. 11 Oct. 13 Oct. 16 Oct. 18 Oct. 20 Oct. 25 Oct. 30 Explanation Owner's Capital Advertising Expense Supplies Note Payable Equipment Service Revenue Owner's Drawing Prepaid Insurance No. 101 Balance 500.00 435.00 310.00 5,310.00 4,410.00 4,535.00 4.435.00 3,115.00 5,000.00 900.00 125,00 100.00 1,320.00 Accounts Receivable Date Explanation Oct. 30 Service Revenue Ref. Credit Debit 300.00 No. 112 Balance 300.00 Inventory Date No. 120 Balance Explanation Ref. Debit Credit Ref. Credit Baking Supplies Date Explanation Oct. 13 Cash Oct. 31 Supplies Expense Debit 125.00 No. 126 Balance 125.00 95.00 SI 35.00 Check your math Prepaid Insurance No. 130 Ref. Debit Service Revenue Date Explanation Oct. 20 Cash Oct. 30 Accounts Recievable Credit 100.00 300.00 No. 400 Balance 100.00 400.00 Dolsn't match the General Journal - Sales Revenue Date No. 401 Balance Explanation Ref. Debit Credit Cost of Goods Sold Date No. 505 Balance Explanation Ref. Debit Credit Advertising Expense Date Oct. 11 Cash Explanation Ref. Credit Debit 35.00 No. 610 Balance 35.00 Docan't match the entry in the General Ledger No. 631 - 1 Baking Supplies Expense Date Oct. 31 Baking Supplies Explanation Ref. Credit Debit 35.00 Balance 35.00 Depreciation Expense Date Explanation Oct. 31 Accumulated Depreciation Ref. Credit Debit 20.00 No. 711 Balance 20.00 Insurance Expense Date No. 722 Balance Explanation Ref Debit Credit ........ Salaries and Wages Expense Date Explanation No. 726 Balance Ref Debit Credit TE } Missing ento ry from General hedgek Rent Expense Date No. 729 Balance Explanation Ref Debit Credit Utilities Expense Date No. 732 Balance Explanation Ref Debit Credit Interest Expense Date No. 905 Balance Explanation Ref. Debit Credit October Worksheet Adjustments Adjusted Trial Bal. Income Statement Dr. Cr Dr. Cr. Dr. Cr. Balance Sheet Dr. Cr. Trial Balance Dr Cr. 3,115.00 300.00 The fast th -3 -3 3 3 column is an Uradjusted Trial Balance so it should be 95.00 1,320.00 1,200.00 20.00 5,000.00 the balanced before Account Titles Cash Accounts Receivable Inventory Baking Supplies Prepaid Insurance Equipment Accum. Depr.-Equipment Notes Payable Accounts Payable Salaries and Wages Payable Interest Payable Owner's Capital Owner's Drawings Service Revenue Sales Revenue Cost of Goods Sold Advertising Expense Baking Supplies Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Rent Expense Utilities Expense Interest Expense 45.00 35.00 800.00 adjustments 100.00 400.00 35.00 35.00 20.00 45.00 35.00 6,300.00 6,300.00 TOTALS Net Income TOTALS SWEET TREATS PRACTICE SET Madison Carter spent much of her childhood learning the art of cookie-making from her grandmother. They spent many enjoyable hours mastering every type of cookie imaginable and later creating new recipes that were both healthy and delicious. Now at the start of her second year in college, Madison is investigating various possibilities for starting her own business as part of the requirements of the entrepreneurship program in which she is enrolled. A long-time friend insists that Madison has to somehow include cookies in her business plan. After a series of brainstorming sessions, Madison settles on the idea of operating a cookie-making school called "Sweet Treats". She will start on a part-time basis and offer her services "in-house". Now that she has started thinking about it, the possibilities seem endless. During the fall, she will concentrate on holiday cookies. She will offer individual lessons and group sessions. Madison decides to operate Sweet Treats as a sole proprietorship beginning on October 8th, with her year end at December 31st She purchased a new cell phone to use only for business operations. She also created a checklist to help her remember which elements of the accounting cycle need to be completed daily, monthly, and yearly. Daily (October) Record transactions in the general journal and post to the general ledger. (November & December) Record transactions in the four special journals, as needed -cash receipts journal, cash payments journal, purchases journal, and sales journal. Use the general journal to record anything that does not go into the special journals. (November & December) Post transactions into the two subsidiary ledgers, as needed - the accounts receivable subsidiary ledger and accounts payable subsidiary ledger. Use the general ledger to post anything that comes directly from the general journal. Monthly Journalize and post adjusting entries. Complete a worksheet for each month. (November & December) Post special journals totals to the necessary general ledger accounts. Yearly: Create financial statements for the year end December 31st - multi-step income statement, owner's equity statement, balance sheet, and statement of cash flows. Journalize and post closing entries. Prepare a post-closing trial balance. Madison continues to stay in touch with her grandmother during the first few months of operation. She appreciates that her grandmother has been so supportive of her. Madison has dreams of opening up a local Sweet Treats shop when she graduates from college. She wants to hire more employees and start offering more classes. INSTRUCTIONS 1. Record the following transactions according to Madison's checklist above. Be sure to read any new details given prior to each months' transactions 2. Prepare any necessary worksheets or forms according to Madison's checklist above. 3. Record all information in the provided spreadsheets. Be sure to include headers, dates, explanations, and totals when appropriate. Add rows as needed. 4. Follow all recording, journalizing, and posting rules provided in your textbook. The following transactions occurred during the month of October. Oct. 8 Madison cashes her U.S. Savings Bonds and receives $520, which she deposits in her personal bank account. 8 She opens a bank account under the name Sweet Treats and transfers $500 from her personal account to the new account. 11 Madison pays $65 for advertising. Check 153. She buys baking supplies, such as flour, sugar, butter, and chocolate chips, for $125 cash. Check 154. 13 14 Madison starts to gather some baking equipment to take with her when teaching the cookie classes. She has an excellent top-of-the-line food processor and mixer that originally cost her $750. Madison decides to start using it only in her new business. She estimates that the food processor is currently worth $300. She invests the food processor in the business. (Record the asset at current worth.) 16 Madison realizes that her initial cash investment is not enough. Her grandmother lends her $5,000 cash, for which Madison signs a note payable in the name of the business. Madison deposits the money in the business bank account. The note will be repaid in 24 months. 17 She buys more baking equipment for $900 cash. Check 155. 20 She teaches her first class and collects $125 cash. 25 Madison withdraws $100 from the business for personal expenditures. Check 156. 30 Madison pays $1,320 for a one-year insurance policy that will expire on November 1 of the next year. Check 157 30 A friend of Madison's asked her to teach a class at the neighborhood school, Newbury Elementary School. Madison agreed and taught a group of 35 first-grade students how to make gingerbread cookies. The next day, Madison prepared an invoice for $300 and left it with the school principal. The principal said that he will pass the invoice along the head office, and it will be paid sometime in November As of October 31, the following adjusting entry data is available. 1. A count reveals that $35 of baking supplies were used during October. 2. Madison estimates that her baking equipment depreciates $20 per month. 3. Madison's grandmother has decided to charge 8.4% interest on the note, and the loan plus interest is to be repaid in 24 months. Madison has decided to accrue the interest each month just to be sure her books correctly reflect what needs to be repaid. She will accrue a full month's interest in October, since she wouldn't even be off the ground without her grandma's help. 4. Madison had a friend assist her with the Newbury Elementary School class. She decides to hire her friend as an employee. She owes her $45 for the October 30 class, that she will pay on November 15. J1 Credit Ref. Date Oct. 8 General Journal Account Titles and Explanations Owner's Capital Cash (Amount invested in the business) Debit 500 500 Cash increased and should be the debit account | Oct. 11 Advertising Expense 65 Cash 65 (Adversting expense paid with check 153) Oct. 13 125 Baking Supplies Cash (Baking supplies for the business with check 154) 125 Oct. 14 300 Equipment Owner's Capital (Invested a food processer to the business) 300 Oct. 16 5000 Cash Note Payable (To record note payable) 5000 Oct. 17 900 Eglupment Cash (Purchased bakinf equipment with cash) 900 Oct. 20 125 Cash Service Revenue (Recorded earned revenue) 125 Oct. 25 100 Owner's Drawings Cash (For personal withdrawl) 100 Oct. 30 1320 Prepaid Insurance Cash (To record prepaid Insurance) 1320 Oct. 30 300 Accounts Receivable Service Revenue (Invoice for elementary school class) 300 General Ledger Ref. Credit Debit 500.00 65.00 125.00 Cash Date Oct. 8 Oct. 11 Oct. 13 Oct. 16 Oct. 18 Oct. 20 Oct. 25 Oct. 30 Explanation Owner's Capital Advertising Expense Supplies Note Payable Equipment Service Revenue Owner's Drawing Prepaid Insurance No. 101 Balance 500.00 435.00 310.00 5,310.00 4,410.00 4,535.00 4.435.00 3,115.00 5,000.00 900.00 125,00 100.00 1,320.00 Accounts Receivable Date Explanation Oct. 30 Service Revenue Ref. Credit Debit 300.00 No. 112 Balance 300.00 Inventory Date No. 120 Balance Explanation Ref. Debit Credit Ref. Credit Baking Supplies Date Explanation Oct. 13 Cash Oct. 31 Supplies Expense Debit 125.00 No. 126 Balance 125.00 95.00 SI 35.00 Check your math Prepaid Insurance No. 130 Ref. Debit Service Revenue Date Explanation Oct. 20 Cash Oct. 30 Accounts Recievable Credit 100.00 300.00 No. 400 Balance 100.00 400.00 Dolsn't match the General Journal - Sales Revenue Date No. 401 Balance Explanation Ref. Debit Credit Cost of Goods Sold Date No. 505 Balance Explanation Ref. Debit Credit Advertising Expense Date Oct. 11 Cash Explanation Ref. Credit Debit 35.00 No. 610 Balance 35.00 Docan't match the entry in the General Ledger No. 631 - 1 Baking Supplies Expense Date Oct. 31 Baking Supplies Explanation Ref. Credit Debit 35.00 Balance 35.00 Depreciation Expense Date Explanation Oct. 31 Accumulated Depreciation Ref. Credit Debit 20.00 No. 711 Balance 20.00 Insurance Expense Date No. 722 Balance Explanation Ref Debit Credit ........ Salaries and Wages Expense Date Explanation No. 726 Balance Ref Debit Credit TE } Missing ento ry from General hedgek Rent Expense Date No. 729 Balance Explanation Ref Debit Credit Utilities Expense Date No. 732 Balance Explanation Ref Debit Credit Interest Expense Date No. 905 Balance Explanation Ref. Debit Credit October Worksheet Adjustments Adjusted Trial Bal. Income Statement Dr. Cr Dr. Cr. Dr. Cr. Balance Sheet Dr. Cr. Trial Balance Dr Cr. 3,115.00 300.00 The fast th -3 -3 3 3 column is an Uradjusted Trial Balance so it should be 95.00 1,320.00 1,200.00 20.00 5,000.00 the balanced before Account Titles Cash Accounts Receivable Inventory Baking Supplies Prepaid Insurance Equipment Accum. Depr.-Equipment Notes Payable Accounts Payable Salaries and Wages Payable Interest Payable Owner's Capital Owner's Drawings Service Revenue Sales Revenue Cost of Goods Sold Advertising Expense Baking Supplies Expense Depreciation Expense Insurance Expense Salaries and Wages Expense Rent Expense Utilities Expense Interest Expense 45.00 35.00 800.00 adjustments 100.00 400.00 35.00 35.00 20.00 45.00 35.00 6,300.00 6,300.00 TOTALS Net Income TOTALS