Charles Price, a connoisseur of fine chocolate, opened Charles' Fine Chocolate Co. in Stowe, VT February 1, 2020, by investing $30,000 in cash into the business. The shop specializes in a selection of gourmet chocolate candies and a line of gourmet ice cream. You have been hired as manager. Your duties include maintaining the store's financial records. On February 1, Charles paid three months rent for the store in advance at $2,000 per month. That same day. Charles purchased supplies for the store in the amount of $450 in cash from the Stowe Supply Co. The store received a delivery of candy from the Green Mountain Chocolate Factory worth $10,000 on February 1. just in time to open the store. Charles placed the order January 15. Because the store is just starting up, Charles purchased the candy on credit. The bill for the candy is due in 60 days. Charles took out an insurance policy to cover the storelin the amount of $2,400. This is an annual policy that Charles paid for all at once on February 1. In order to have enough cash to pay employees and to purchase additional supplies and equipment for the store, Charles took out a loan from the Chittenden County bank in the amount of $24,000 on February 2. The loan is due in 2 years. As the new employee responsible for maintaining the store's accounting records, you realize that you will need a computer for recordkeeping and tracking inventory. You express your concern to Charles, and on February 3, he purchases a computer costing $5,000. Charles pays cash for the computer. That same day, Charles purchases furniture and fixtures for the store (shelving to display the chocolates, other display cases, etc.) for $18,500. You determine that the useful life of the computer is 3 years, and the useful life of the furniture and fixtures is 5 years. Charles decides to pay cash for the fumiture and fixtures as well. In order to let people in Stowe know about his new store, Charles takes out an advertisement in the Stowe Gazette on February 3 announcing the grand opening of the store. The advertisement cost $1,000. Because the Stowe Gazette is a small business, they do not accept credit. Charles therefore had to pay cash for the advertisement Journal entries to record sales are entered into the general journal weekly. On February 8 week 1 sales were recorded. Week one sales were $5,500. Of this amount, $2,000 was in cash, the remainder on credit. Cost of chocolate sold was $1,500. The inventory account is updated at the same time sales are recorded. On February 10 Charles paid $500 to the Green Mountain Chocolate Factory for the chocolate received on February 1. Foco hable o References Heview VIEW Mailings Journal entries to record sales are entered into the general journal weekly. On February 8, week 1 sales were recorded. Week one sales were $5,500. Of this amount, $2,000 was in cash, the remainder on credit. Cost of chocolate sold was $1,500. The inventory account is updated at the same time sales are recorded. On February 10 Charles paid $500 to the Green Mountain Chocolate Factory for the chocolate received on February 1. Wages were paid on February 15 in the amount of $1,500. These wages covered the first fifteen days of February. Employees in total earn $100 per day. Sales for week 2 were recorded on February 15. Sales for week two totaled S2,500. Of this amount, $1,300 was in cash, the remainder was on credit. Cost of chocolate sold was $1,125. PAGE OF On February 16, Charles ordered additional supplies from the Stowe Supply Co. in the amount of $350. On February 19, the supplies were received. The supplies were purchased on credit and the bill for the supplies is due in 60 days. On February 20, one of the display cases was damaged. The cost to repair the damage was $215. Charles paid for the repair with cash On February 20, the store received payment of $100 from a customer who purchased chocolate on credit during week 2. On February 21, a customer retumed an un-opened box of chocolate. Charles gave the customer a full refund, in the amount of $50 in cash. The box of chocolate cost Charles $35, On February 22, a customer paid $100 in advance for a basket of gourmet chocolates that will be prepared and delivered to the customer's home on March 14. On February 22, week 3 sales were recorded. Sales for week 3 totaled $4,445. Of this amount, $2,250 was in cash, the remainder on credit. Cost of chocolate sold was $2,050. On February 25, Charles paid the Green Mountain Chocolate Factory S1,000. On February 29, the store received a heating bill for the month of February. The amount of the bill is $1,000, which is not surprising given the cold Vermont winters. The bill is due on March 10. You perform an inventory of the supplies on February 29. The inventory reveals that there is $275 worth of supplies left on lund at the end of the month Wages for the last two weeks of February will be paid on March 5. On February 29, week 4 sales are recorded. Sales for week 4 totaled 55.000 $1,800 was . able chocolate sold was S2 On February 25, Charles paid the Green Mountain Chocolate Factory $1,000. On February 29, the store received a heating bill for the month of February. The amount of the bill is $1,000, which is not surprising given the cold Vermont winters. The bill is due on March 10. You perform an inventory of the supplies on February 29. The inventory reveals that there is $275 worth of supplies left on hand at the end of the month. Wages for the last two weeks of February will be paid on March 5. On February 29, week 4 sales are recorded. Sales for week 4 totaled $5,000 $1,800 was in cash, the remainder on credit. Cost of chocolate sold was $2,750, Required: For the month of February 1. Prepare journal entries for all transactions. Make sure to include the date and explanations. 2. Prepare T-accounts for all accounts and post the amounts from the journal entries to the T. accounts 3. Prepare a worksheet with the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet 4. Update the worksheet to reflect the unadjusted trial balance. 5. Prepare all necessary month-end adjusting entries, 6. Post the adjusting entries to the T-accounts 7. Complete the worksheet. 8. Prepare an Income Statement, Statement of Owners' Equity, and a Balance Sheet in good form 9. Prepare closing entries 10. Post closing entries to the T-accounts. All work must be performed in Excel. Formal financial statements can be prepared with a word. processing program (MS Word, for example). A completed assignment will include: All journal entries that have been recorded, including adjusting entries and closing entries Make sure to include the date and explanations Completed T-accounts. Completed worksheet with the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet. The Income Statement, Statement of Owners' Equity and Balance Sheet . du Copy BTW A- Menge r Center $% -% insert Delete for Conditional Formatas Cell Formatting Table Styles She Font 5 Algement Number 55 Cele f Captial A B C D E E G H 0 0 0 Notes Payable Fixed Asset Computer Fixed Asset Fixtures 0 0 0 Advertising Expenst Cost of Goods Sold Salary Expense 0 0 0 Repair Expense Sales Return Uneamed Revenue 0 Rent Expense Insurance Expense 6 -7 58 9 20 Depreciation Expen T.Accounts Tral Banc Adjusting southal Entries Adjusted Trial Balance Income State Type here to search o O lije Number Format Printer poud Sly Font Alignment Captial D C E 5 F G Sales Retur Unearned Revenue Repair Expense 0 Rent Expense Insurance Expense Depreciation Expense 0 2 54 Accumulated Depreciation Utility Expense Utility Payable 0 0 66 62 GB 69 70 71 72 73 74 75 16 77 Page 2 . Supply pense Salary Payable Captial T.Accounts TA Balance Austing ournal Entries Adjusted Trainer income State wy H12 B A C D E F G H All Ladies Enjoy Reading Everyday Trial Balance Account Name Debit Credit 1 2 3 4 5 All Ladies Enjoy Reading Everyday Assets Liabilities Equity Revenue Expenses 6 7 9 10 11 12 13 14 16 17 18 19 20 21 22 73 24 25 Total 1- Accounts Trial Balance 0 0 Adjusting journal Entries Adjusted Trial Balance income State Ready Type here to search o O EI * Format Painter 5 Cliebbard For Algement Member S H12 A B C D E G H Trial Balance Account Name Debit All Ladies Enjoy Reading Everyday Credit All Ladies Enjoy Reading Everyday Assets Liabilities Equity Revenue Expenses 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Total Accounts 0 Trial Balance 0 Adjusting Journal Entries Adjusted al balance Income States . Type here to search o E B4 A D F G 1 B Adjusted Journal Entries Date Debit Credit Amount 1 2 3 4 5 Purpose: Prepaid Rent Adjustment 2 Purpose: Prepaid Insurance Adjustment 3 Purpose: Depreciation of Computer 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Purpose: Depreciation of Fixtures 5 Purpose: Supplies Leftover 61 Purpose: Salaries 2A 25 26 1hccounts Trallalace Adjusting Zurnal Entries Adjusted Tillance Income state Type here to search O O D37 A E F G 1 B D Adjusted Trial Balance Account Name Credit Debit 2 3 All Ladies Enjoy Reading Everyday 4 All Ladies Enjoy Reading Everyday Assets Liabilities Equity Revenue Expenses S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Account Trial balance Adjusting Journal Adjusted Trial Balance income state BN Type here to search o O K32 H A B D Income Statement 1 Revenue 2 3 4 SO 7. Total 8 9 Expenses 10 11 12 13 14 15 16 12 18 Total 19 20 Net Income 21 Net Income 22 23 24 25 SO $0 Trial Balance Adjusting Journal Entries Adjusted Trio Balonce Income Statement Stater Real TH Type here to search O . E - B 11 1 li = = 3 0010 Formatting Table Format Painter Clipbond Tont Alignment Number H23 A B C D E H Statement of Owner's Equity DOWN- 3 Beginning Balance 4 Add: Net Income 5. Less: Dividends 6 Ending Balance 0 $0 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Adjusting lournal Entries Adjusted that Balance income Statement Statement of OE A B H Balance Sheet 1 2 3 Assets Liabilities 4 5 6 7 8 9 10 11 Total: SO Equity $0 Total: SO Total Liabilities Owner's Equity $0 12 13 14 Total: 15 16 17 18 19 20 21 22 23 24 25 26 SWN Adjusted Trial Balance Income Statement Statement of on Balance Sheet Closing Entr's Reads Type here to search Balance Sheet 1 2 3 Assets Liabilities 4 5 6 7 8 9 Total: SO Equity $0 Total: $0 10 11 12 13 14 Total: 15 16 12 18 19 20 21 22 23 24 25 26 15 Total Liabilities Owner's Equity $0 Adjusted Trial Balance income Statement Statement of OE Balance Sheet Closing Entry's FI Tune beach D 1 HE C D ER G B A Closing Entries Debit Credit Amount Date Feb-29 1 2 Feb-29 3 Feb-29 4 Feb-29 5 Feb-29 6 Feb-29 7 Feb-29 8 Feb-29 3 1 2 3 14 15 16 17 18 19 20 21 22 23 24 25 26 9 Feb-29 10 Feb-29 11 Feb 29 Income Statement Statement of OE Balance Sheet Closing Entries Type here to search OBI