Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I don't know if you can't see the picture or if the question is unclear. If the question is unclear that's why I'm posting this.
I don't know if you can't see the picture or if the question is unclear. If the question is unclear that's why I'm posting this.
The following information relates to Matchbox, a venture started by Earl and Ryan Cantrell Matchbox was incorporated on November 1, 2019. Matchbox is an innovative brick and mortar barber shop that offers spa services in addition to haircuts. The service that makes Matchbox unique is that they provide a subscription service for barber supplies. Customers that sign up for a membership and are sent a box every month with barber supplies as well as new and exciting merchandise. At the time of incorporation, two venture capitalists were eager to provide startup capital for this new business. Matchbox uses the accrual method of accounting and made the following transactions during the months of November and December. Transactions for November DATE TRANSACTION 1 1 1 Ashley Johnson purchased 21,000 shares of $2.50 par value stock in exchange for an investment of $175,000 Ben Stronger purchased 13,000 shares of $2.50 par value stock in exchange for an investment of $65,000. Matchbox purchased a large building for their first location at a cost of $25,000. In addition, they prepaid the monthly rent of $3,000 on a second location for the entire year for a total of $36,000. Purchased barber equipment from Salon Express for $27,400 on the basis of a $7,400 down payment and $2,000 per month for 10 months on credit with annual interest of 10%. The first payment is due December 1. Received subscription box pre-orders for the month of November all in cash of $75,000. This subscription entitles the customer to receive a box for the next 12 months starting with a box this month. Paid the premium on a one-year repair policy that covers parts and service for the new barber equipment for $7,500. Adobe Acroba 1 9 10 12 20 25 25 30 new barber equipment for $7,500. Paid the premium on a two-year insurance policy for both locations, $21,600. Purchased packing equipment from R Company on credit for the subscription boxes, $5,500. Purchased merchandise inventory to fill the subscription boxes, $25,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550 Made a payment to R Company, $1,250 Purchased office supplies on credit from Office Depot, $2,000. Paid employees $45,000 for the entire month. Prepare the journal entries for the month of November and then prepare the adjusting entries for the month of November given the following additional information a) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. b) Mailed out the subscription boxes for the month of November. c) The remaining inventory of office supplies is $750. The remaining supply of merchandise is $5,000. d) The equipment purchased from both Salon Express and R Company has a useful life of 5 years and will be depreciated using the straight line method. The salvage value for all equipment is zero. The building has a useful life of 10 years and a salvage value of zero and straight line is also used to depreciate the building. e) Interest has accrued on the note payable. Editing Adobe Acr Transactions for December DATE TRANSACTION 1 Received subscription box pre-orders for the month of December all in cash of $70,000. Customers will receive the first box in the month of December 1 Made monthly payment to Salon Express, $2,000. 7 Purchased an additional sorting machine on credit from R Company, $3,500. 10 Purchased merchandise inventory to fill the subscription boxes, $20,000. 18 Paid for towel service from Clean Linen for the month, $650. 19 Paid utility bills, $1,550. 20 Paid R Company on account $2,800. 28 Purchased additional office supplies on credit from Office Depot, $1,500. Paid employees $40,000 for the entire month. Prepare the journal entries for the month of December and then prepare the adjusting entries for the month of December given the following additional information: f) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. g) Mailed out the subscription boxes for the month of December h) The remaining inventory of office supplies is $250. The remaining supply of inventory is $7,500. I i) Depreciation for one month must be recorded on the equipment and the building j) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) . Vou metuen Microceft veel for the ninet Con anniv 20etation Adobe Acrobat 37200 1) Depreciation for one month must be recorded on the equipment and the building. 1) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) You must use Microsoft Excel for this project. See appendix 3C, starting on page 3-46, for a template (I don't want individual journal entries, everything should be done in the worksheet). Use this spreadsheet to record all of your journal entries. You must then carry your work from the 10 column worksheet to another worksheet containing the financial statements using the relevant Microsoft Excel functions and linking capabilities. YOU MUST TURN IN ELECTRONICALLY: 1. Adjusted trial balance for the TWO months ended December 31, 2019. 2. Three financial statements for the TWO months ended December 31, 2019 (income statement, statement of retained earnings and balance sheet). The I last four columns are not enough want a set of financial statements. Adobe Acre Paragraph Styles Editing The following information relates to Matchbox, a venture started by Earl and Ryan Cantrell Matchbox was incorporated on November 1, 2019. Matchbox is an innovative brick and mortar barber shop that offers spa services in addition to haircuts. The service that makes Matchbox unique is that they provide a subscription service for barber supplies. Customers that sign up for a membership and are sent a box every month with barber supplies as well as new and exciting merchandise. At the time of incorporation, two venture capitalists were eager to provide startup capital for this new business. Matchbox uses the accrual method of accounting and made the following transactions during the months of November and December Transactions for November DATE TRANSACTION 1 1 Ashley Johnson purchased 21,000 shares of $2.50 par value stock in exchange for an investment of $175,000. Ben Stronger purchased 13,000 shares of $2.50 par value stock in exchange for an investment of $65.000. Matchbox purchased a large building for their first location at a cost of $25,000. In addition, they prepaid the monthly rent of $3,000 on a second location for the entire year for a total of $36.000. Purchased barber equipment from Salon Express for $27.400 on the basis of a $7.400 down payment and $2.000 per month for 10 months on credit with annual interest of 10%. The first payment is due December 1. Received subscription box pre-orders for the month of November all in cash of $75.000. This subscription entitles the customer to receive a box for the next 12 months starting with a box this month. Paid the premium on a one-year repair policy that covers parts and service for the new barber equipment for ST 500 uruy 1 10 12 20 25 25 30 new varer equipment IU ODVO. Paid the premium on a two-year insurance policy for both locations, $21,600. Purchased packing equipment from R Company on credit for the subscription boxes, $5,500 Purchased merchandise inventory to fill the subscription boxes, $25,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550 Made a payment to R Company, $1,250 Purchased office supplies on credit from Office Depot, $2,000. Paid employees $45,000 for the entire month. Prepare the journal entries for the month of November and then prepare the adjusting entries for the month of November given the following additional information a) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. b) Mailed out the subscription boxes for the month of November. c) The remaining inventory of office supplies is $750. The remaining supply of merchandise is $5,000. d) The equipment purchased from both Salon Express and R Company has a useful life of 5 years and will be depreciated using the straight line method. The salvage value for all equipment is zero. The building has a useful life of 10 years and a salvage value of zero and straight line is also used to depreciate the building. e) Interest has accrued on the asrable Palaylar e) Interest has accrued on the note payable. Transactions for December DATE 1 1 7 10 18 19 20 28 TRANSACTION Received subscription box pre-orders for the month of December all in cash of $70,000. Customers will receive the first box in the month of December. Made monthly payment to Salon Express, $2,000. Purchased an additional sorting machine on credit from R Company, $3,500. Purchased merchandise inventory to fill the subscription boxes, $20,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550. Paid R Company on account $2,800. Purchased additional office supplies on credit from Office Depot, $1,500. Paid employees $40,000 for the entire month Prepare the journal entries for the month of December and then prepare the adjusting entries for the month of December given the following additional information: f) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. g) Mailed out the subscription boxes for the month of December. h) The remaining inventory of office supplies is $250. The remaining supply of inventory is $7,500. 1) Depreciation for one month must be recorded on the equipment and the building, 1) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019 Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet Statement of Retained Earnings) . $7,00 1) Depreciation for one month must be recorded on the equipment and the building. 1 Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) You must use Microsoft Excel for this project. See appendix 3C, starting on page 3-46, for a template (I don't want individual journal entries, everything should be done in the worksheet). Use this spreadsheet to record all of your journal entries. You must then carry your work from the 10 column worksheet to another worksheet containing the financial statements using the relevant Microsoft Excel functions and linking capabilities. YOU MUST TURN IN ELECTRONICALLY: 1. Adjusted trial balance for the TWO months ended December 31, 2019. 2. Three financial statements for the TWO months ended December 31, 2019 (income statement, statement of retained earnings and balance sheet). The last four columns are not enough want a set of financial statements. The following information relates to Matchbox, a venture started by Earl and Ryan Cantrell Matchbox was incorporated on November 1, 2019. Matchbox is an innovative brick and mortar barber shop that offers spa services in addition to haircuts. The service that makes Matchbox unique is that they provide a subscription service for barber supplies. Customers that sign up for a membership and are sent a box every month with barber supplies as well as new and exciting merchandise. At the time of incorporation, two venture capitalists were eager to provide startup capital for this new business. Matchbox uses the accrual method of accounting and made the following transactions during the months of November and December. Transactions for November DATE TRANSACTION 1 1 1 Ashley Johnson purchased 21,000 shares of $2.50 par value stock in exchange for an investment of $175,000 Ben Stronger purchased 13,000 shares of $2.50 par value stock in exchange for an investment of $65,000. Matchbox purchased a large building for their first location at a cost of $25,000. In addition, they prepaid the monthly rent of $3,000 on a second location for the entire year for a total of $36,000. Purchased barber equipment from Salon Express for $27,400 on the basis of a $7,400 down payment and $2,000 per month for 10 months on credit with annual interest of 10%. The first payment is due December 1. Received subscription box pre-orders for the month of November all in cash of $75,000. This subscription entitles the customer to receive a box for the next 12 months starting with a box this month. Paid the premium on a one-year repair policy that covers parts and service for the new barber equipment for $7,500. Adobe Acroba 1 9 10 12 20 25 25 30 new barber equipment for $7,500. Paid the premium on a two-year insurance policy for both locations, $21,600. Purchased packing equipment from R Company on credit for the subscription boxes, $5,500. Purchased merchandise inventory to fill the subscription boxes, $25,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550 Made a payment to R Company, $1,250 Purchased office supplies on credit from Office Depot, $2,000. Paid employees $45,000 for the entire month. Prepare the journal entries for the month of November and then prepare the adjusting entries for the month of November given the following additional information a) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. b) Mailed out the subscription boxes for the month of November. c) The remaining inventory of office supplies is $750. The remaining supply of merchandise is $5,000. d) The equipment purchased from both Salon Express and R Company has a useful life of 5 years and will be depreciated using the straight line method. The salvage value for all equipment is zero. The building has a useful life of 10 years and a salvage value of zero and straight line is also used to depreciate the building. e) Interest has accrued on the note payable. Editing Adobe Acr Transactions for December DATE TRANSACTION 1 Received subscription box pre-orders for the month of December all in cash of $70,000. Customers will receive the first box in the month of December 1 Made monthly payment to Salon Express, $2,000. 7 Purchased an additional sorting machine on credit from R Company, $3,500. 10 Purchased merchandise inventory to fill the subscription boxes, $20,000. 18 Paid for towel service from Clean Linen for the month, $650. 19 Paid utility bills, $1,550. 20 Paid R Company on account $2,800. 28 Purchased additional office supplies on credit from Office Depot, $1,500. Paid employees $40,000 for the entire month. Prepare the journal entries for the month of December and then prepare the adjusting entries for the month of December given the following additional information: f) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. g) Mailed out the subscription boxes for the month of December h) The remaining inventory of office supplies is $250. The remaining supply of inventory is $7,500. I i) Depreciation for one month must be recorded on the equipment and the building j) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) . Vou metuen Microceft veel for the ninet Con anniv 20etation Adobe Acrobat 37200 1) Depreciation for one month must be recorded on the equipment and the building. 1) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) You must use Microsoft Excel for this project. See appendix 3C, starting on page 3-46, for a template (I don't want individual journal entries, everything should be done in the worksheet). Use this spreadsheet to record all of your journal entries. You must then carry your work from the 10 column worksheet to another worksheet containing the financial statements using the relevant Microsoft Excel functions and linking capabilities. YOU MUST TURN IN ELECTRONICALLY: 1. Adjusted trial balance for the TWO months ended December 31, 2019. 2. Three financial statements for the TWO months ended December 31, 2019 (income statement, statement of retained earnings and balance sheet). The I last four columns are not enough want a set of financial statements. Adobe Acre Paragraph Styles Editing The following information relates to Matchbox, a venture started by Earl and Ryan Cantrell Matchbox was incorporated on November 1, 2019. Matchbox is an innovative brick and mortar barber shop that offers spa services in addition to haircuts. The service that makes Matchbox unique is that they provide a subscription service for barber supplies. Customers that sign up for a membership and are sent a box every month with barber supplies as well as new and exciting merchandise. At the time of incorporation, two venture capitalists were eager to provide startup capital for this new business. Matchbox uses the accrual method of accounting and made the following transactions during the months of November and December Transactions for November DATE TRANSACTION 1 1 Ashley Johnson purchased 21,000 shares of $2.50 par value stock in exchange for an investment of $175,000. Ben Stronger purchased 13,000 shares of $2.50 par value stock in exchange for an investment of $65.000. Matchbox purchased a large building for their first location at a cost of $25,000. In addition, they prepaid the monthly rent of $3,000 on a second location for the entire year for a total of $36.000. Purchased barber equipment from Salon Express for $27.400 on the basis of a $7.400 down payment and $2.000 per month for 10 months on credit with annual interest of 10%. The first payment is due December 1. Received subscription box pre-orders for the month of November all in cash of $75.000. This subscription entitles the customer to receive a box for the next 12 months starting with a box this month. Paid the premium on a one-year repair policy that covers parts and service for the new barber equipment for ST 500 uruy 1 10 12 20 25 25 30 new varer equipment IU ODVO. Paid the premium on a two-year insurance policy for both locations, $21,600. Purchased packing equipment from R Company on credit for the subscription boxes, $5,500 Purchased merchandise inventory to fill the subscription boxes, $25,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550 Made a payment to R Company, $1,250 Purchased office supplies on credit from Office Depot, $2,000. Paid employees $45,000 for the entire month. Prepare the journal entries for the month of November and then prepare the adjusting entries for the month of November given the following additional information a) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. b) Mailed out the subscription boxes for the month of November. c) The remaining inventory of office supplies is $750. The remaining supply of merchandise is $5,000. d) The equipment purchased from both Salon Express and R Company has a useful life of 5 years and will be depreciated using the straight line method. The salvage value for all equipment is zero. The building has a useful life of 10 years and a salvage value of zero and straight line is also used to depreciate the building. e) Interest has accrued on the asrable Palaylar e) Interest has accrued on the note payable. Transactions for December DATE 1 1 7 10 18 19 20 28 TRANSACTION Received subscription box pre-orders for the month of December all in cash of $70,000. Customers will receive the first box in the month of December. Made monthly payment to Salon Express, $2,000. Purchased an additional sorting machine on credit from R Company, $3,500. Purchased merchandise inventory to fill the subscription boxes, $20,000. Paid for towel service from Clean Linen for the month, $650. Paid utility bills, $1,550. Paid R Company on account $2,800. Purchased additional office supplies on credit from Office Depot, $1,500. Paid employees $40,000 for the entire month Prepare the journal entries for the month of December and then prepare the adjusting entries for the month of December given the following additional information: f) One month's insurance and rent have expired as well as one month on the service plan for repair of the equipment. g) Mailed out the subscription boxes for the month of December. h) The remaining inventory of office supplies is $250. The remaining supply of inventory is $7,500. 1) Depreciation for one month must be recorded on the equipment and the building, 1) Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019 Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet Statement of Retained Earnings) . $7,00 1) Depreciation for one month must be recorded on the equipment and the building. 1 Interest has accrued on the note payable. k) The tax rate for the company is 20%, income taxes will be paid next month. Prepare an adjusted trial balance after entries for December 31, 2019. Prepare financial statements for the 2 months ending December 31, 2019. (Income Statement, Balance Sheet, Statement of Retained Earnings) You must use Microsoft Excel for this project. See appendix 3C, starting on page 3-46, for a template (I don't want individual journal entries, everything should be done in the worksheet). Use this spreadsheet to record all of your journal entries. You must then carry your work from the 10 column worksheet to another worksheet containing the financial statements using the relevant Microsoft Excel functions and linking capabilities. YOU MUST TURN IN ELECTRONICALLY: 1. Adjusted trial balance for the TWO months ended December 31, 2019. 2. Three financial statements for the TWO months ended December 31, 2019 (income statement, statement of retained earnings and balance sheet). The last four columns are not enough want a set of financial statements
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started