There is no downloaded able template. This is page 3-46 and is what template we're suppose to use.

Uptown Cabinet Corp. Insert Page Layout Formulas Data B C D F G H I 1 Dr. Dr. Dr. Dr. Cr. Uptown Cabinet Corp. Ten-Column Worksheet For the Year Ended December 31, 2020 Adjusted Trial Balance Adjustments Income Balance Trial Balance Statement Sheet Account Titles Gr. Dr. Cr. 8 Cash 1,200 1,200 1,200 9 Notes receivable 16,000 16,000 16,000 10 Accounts receivable 41,000 41,000 41,000 11 Allowance for doubtful accounts 2,000 (b) 1,000 3,000 3,000 12 Inventory 40,000 40,000 40,000 13 Prepaid insurance 900 (c) 360 540 540 14 Equipment 67,000 67,000 67,000 15 Accumulated depreciation- equipment 12,000 (a) 6,700 18,700 18,700 16 Notes payable 20,000 20,000 20,000 17 Accounts payable 13,500 13,500 13,500 18 Bonds payable 30,000 30,000 30,000 19 Common stock 50,000 50,000 50,000 20 Retained earnings, Jan. 1, 2020 16,200 16,200 16,200 21 Dividends 2,000 2,000 2,000 22 Sales revenue 400,000 400,000 400,000 23 Cost of goods sold 316,000 316,000 316,000 24 Salaries and wages expense (sales) 20,000 20,000 20,000 25 Advertising expense 10,200 10,200 26 Salaries and wages expense (general) 19,000 19,000 19,000 27 Telephone and Internet expense 600 600 600 28 Rent expense 4,800 (e) 500 4,300 4,300 29 Property tax expense 3,300 (1) 2,000 5,300 5,300 30 Interest expense 1,700 1,700 1,700 31 Totals 543,700 543,700 32 Depreciation expense (a) 6,700 6,700 6,700 33 Bad debt expense (b) 1,000 1,000 1,000 34 Insurance expense (c) 360 360 360 35 Interest receivable (d) 800 800 800 36 Interest revenue (d) 800 800 800 37 Prepaid rent (e) 500 500 500 38 Property taxes payable (f) 2,000 2,000 2,000 39 Income tax expense (g) 3,440 3,440 3,440 40 Income taxes payable (g) 3,440 3,440 3,440 41 Totals 14,800 14,800 557,640 557,640 388,600 400,800 169,040 156,840 42 Net income 12,200 12,200 43 Totals 400,800 400,800 169,040 169,040 10,200 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 A 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 V 1 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. 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. 10 12 20 25 25 30 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. 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. 1500 250 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) 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) 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. Uptown Cabinet Corp. Insert Page Layout Formulas Data B C D F G H I 1 Dr. Dr. Dr. Dr. Cr. Uptown Cabinet Corp. Ten-Column Worksheet For the Year Ended December 31, 2020 Adjusted Trial Balance Adjustments Income Balance Trial Balance Statement Sheet Account Titles Gr. Dr. Cr. 8 Cash 1,200 1,200 1,200 9 Notes receivable 16,000 16,000 16,000 10 Accounts receivable 41,000 41,000 41,000 11 Allowance for doubtful accounts 2,000 (b) 1,000 3,000 3,000 12 Inventory 40,000 40,000 40,000 13 Prepaid insurance 900 (c) 360 540 540 14 Equipment 67,000 67,000 67,000 15 Accumulated depreciation- equipment 12,000 (a) 6,700 18,700 18,700 16 Notes payable 20,000 20,000 20,000 17 Accounts payable 13,500 13,500 13,500 18 Bonds payable 30,000 30,000 30,000 19 Common stock 50,000 50,000 50,000 20 Retained earnings, Jan. 1, 2020 16,200 16,200 16,200 21 Dividends 2,000 2,000 2,000 22 Sales revenue 400,000 400,000 400,000 23 Cost of goods sold 316,000 316,000 316,000 24 Salaries and wages expense (sales) 20,000 20,000 20,000 25 Advertising expense 10,200 10,200 26 Salaries and wages expense (general) 19,000 19,000 19,000 27 Telephone and Internet expense 600 600 600 28 Rent expense 4,800 (e) 500 4,300 4,300 29 Property tax expense 3,300 (1) 2,000 5,300 5,300 30 Interest expense 1,700 1,700 1,700 31 Totals 543,700 543,700 32 Depreciation expense (a) 6,700 6,700 6,700 33 Bad debt expense (b) 1,000 1,000 1,000 34 Insurance expense (c) 360 360 360 35 Interest receivable (d) 800 800 800 36 Interest revenue (d) 800 800 800 37 Prepaid rent (e) 500 500 500 38 Property taxes payable (f) 2,000 2,000 2,000 39 Income tax expense (g) 3,440 3,440 3,440 40 Income taxes payable (g) 3,440 3,440 3,440 41 Totals 14,800 14,800 557,640 557,640 388,600 400,800 169,040 156,840 42 Net income 12,200 12,200 43 Totals 400,800 400,800 169,040 169,040 10,200 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 A 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 V 1 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. 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. 10 12 20 25 25 30 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. 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. 1500 250 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) 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) 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