Part One instructions Record the January 2023 transactions, journal entries, in an Excel Spreadsheet. An example of an Excel spreadsheet follows the transactions below. No explanation is required for the journal entries. Instead of recording the names of the accounts use the corresponding account numbers in the chart of accounts. Prepare the joumal entries as shown in an Excel Spreadsheet following the transactions below. Once you have written all the journal entries in the Excel Spreadsheet you will use the spreadsheet to enter the information into Blackboard for a grade. Once you are finished entering the journal entries into Blackboard you will upload your Excel Spreadsheet into Blackboard. Here are the instructions to turn in the documents for each part of the practice set: Step 1: Enter the journal entries in an Excel spreadsheet and when completed print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder. Step 3: Once you complete entering information into Blackboard, upload the spreadsheet into Blackboard. Transactions Dr 10.000$70.000Cr39003$70.000 Socierre \begin{tabular}{|l|l|l|l|} \hline 5. & 1/03/23 & Purchasedanewcomputersystemthatcost$5,200fromComputerinc.Foruseinthebusiness.Mr.Slantsignedasix-month,10%8instailment \\ ihe systemation \end{tabular} six-month, 10% installment note payable for the cost of use system. The computer system has an estimated $100. This will be recorded as Computer Equipment, and depreciated accordingly using straight line depreciation. Only record the purchase at this time. Signed a note payable to barrow $10,000 from Wells Fargo bank. Interest is 12% annually and the note is to be repaid with interest in twelve months. Only record the receipt of the note. \begin{tabular}{|l|l|l|l|} \hline 7. & 1/05/23 & Ck#1003 & Paid $1,100 for shipping supplies. \\ \hline 8. & 1/06/23 & Ck#1004 & Paid $14,600 for furniture and fixtures for the store. The \\ \hline \end{tabular} estimated service life of this asset is 8 years. The residual (salvage) value is $200. These ifems will be recorded as Furniture and Fixtures and will be depreciated using straight line depreciation. Only record the purchose. Arranged for Sun City Movers to make the delivery and for the setup of the computer system and paid the delivery and setup charge of $750. This charge should be added to the cost of the computer equipment purchased and depreciated on the same basis as the computer equipment. Purchased $450 of office supplies for cash from Office Supplies Company. Purchased $8,000 of merchandise inventory-skis on account. Purchased $6,000 of merchandise inventory-snow boards on account. There were no credit terms for prompt payment. Mr. Slant received and paid the $940 charge from lowyer Hit the Slopes, Inc. is now open for business, Customers will go on-line and select the merchandise they wish to purchase. Online payments will be considered cash sales. 15. 1/14/23 Deposit \#3 Sold merchandise for $7,200 cash. The cost of the Skis is $3,000 and the cost of the Snowboards is $1,100. Sales tax will be $594. The merchandise will be shipped FOB destination. \begin{tabular}{|c|l|l|l|} \hline 16. & 1/16/23 & Ck #1008 & Paid $250 to ship the merchandise. \\ \hline 17. & 1/16/23 & & Purchased additional skis on account for $4,500. \\ \hline 18. & 1/20/23 & Deposit \#4 & Recordedintemetsalesforthefirstfivedaysofoperation.Salestotaled$8,300.Salestaxis$536.The \\ \hline \end{tabular} Group Practice Chart of Accounts \begin{tabular}{|c|l|} \hline Current Assets \\ \hline 10000 & Cash \\ \hline 11000 & Accounts Receivable \\ \hline 12000 & Inventory - Skis \\ \hline 12100 & Inventory - Snowboards \\ \hline 13100 & Office Supplies \\ \hline 13200 & Shipping Supplies \\ \hline 14000 & Prepaid Rent \\ \hline 14100 & Prepaid Insurance \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Stockholders' Equity } \\ \hline 39003 & Common Stock \\ \hline 39005 & Retained Earnings \\ \hline 39007 & Dividends \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Revenue \\ \hline 40000 & Sales \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Long-Term Assets } \\ \hline 15000 & Furniture and Fixtures \\ \hline 17000 & AccumulatedDepreciation-FurnitureandFixtures \\ \hline 15100 & Computer Equipment \\ \hline 17100 & AccumulatedDepreciation-ComputerEquipment \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Current Liabilities } \\ \hline 20000 & Accounts Payable \\ \hline 21100 & NotePayable-WellsFargoBank \\ \hline 21200 & NotePayable-ComputerInc. \\ \hline 23100 & Wages Payable \\ \hline 23200 & Interest Payable \\ \hline 23300 & Sales Tax Payable \\ \hline 23400 & Utilities Payable \\ \hline Long Term Liabilities \\ \hline 27000 & Mortgage Payable \\ \hline 27100 & Note Payable \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Expenses & \\ \hline 50000 & Cost of Goods Sold \\ \hline 60100 & Legal Expense \\ \hline 60150 & Office Supplies Expense \\ \hline 60200 & ShippingSuppliesExpense \\ \hline 60300 & Insurance Expense \\ \hline 60350 & Wages Expense \\ \hline 60400 & Credit Card Expense \\ \hline 60450 & Delivery Expense \\ \hline 60500 & AdvertisingandPromotionExpense \\ \hline 60550 & Utility Expense \\ \hline 60600 & Rent Expense \\ \hline 60650 & Depreciation Expense \\ \hline 60700 & Interest Expense \\ \hline 60750 & Bank Service Fee \\ \hline 60800 & RegistrationFeeExpense \\ \hline 60850 & Gasoline Expense \\ \hline \end{tabular} 41Page 1 Step 1: Write the journal entries in an Exoel spreadsheet. Print out the spreadsheet when finished. 2 Transaction Dr coount Dollar Amount Ci ooount \# Dollar Amount . Example Part One instructions Record the January 2023 transactions, journal entries, in an Excel Spreadsheet. An example of an Excel spreadsheet follows the transactions below. No explanation is required for the journal entries. Instead of recording the names of the accounts use the corresponding account numbers in the chart of accounts. Prepare the joumal entries as shown in an Excel Spreadsheet following the transactions below. Once you have written all the journal entries in the Excel Spreadsheet you will use the spreadsheet to enter the information into Blackboard for a grade. Once you are finished entering the journal entries into Blackboard you will upload your Excel Spreadsheet into Blackboard. Here are the instructions to turn in the documents for each part of the practice set: Step 1: Enter the journal entries in an Excel spreadsheet and when completed print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder. Step 3: Once you complete entering information into Blackboard, upload the spreadsheet into Blackboard. Transactions Dr 10.000$70.000Cr39003$70.000 Socierre \begin{tabular}{|l|l|l|l|} \hline 5. & 1/03/23 & Purchasedanewcomputersystemthatcost$5,200fromComputerinc.Foruseinthebusiness.Mr.Slantsignedasix-month,10%8instailment \\ ihe systemation \end{tabular} six-month, 10% installment note payable for the cost of use system. The computer system has an estimated $100. This will be recorded as Computer Equipment, and depreciated accordingly using straight line depreciation. Only record the purchase at this time. Signed a note payable to barrow $10,000 from Wells Fargo bank. Interest is 12% annually and the note is to be repaid with interest in twelve months. Only record the receipt of the note. \begin{tabular}{|l|l|l|l|} \hline 7. & 1/05/23 & Ck#1003 & Paid $1,100 for shipping supplies. \\ \hline 8. & 1/06/23 & Ck#1004 & Paid $14,600 for furniture and fixtures for the store. The \\ \hline \end{tabular} estimated service life of this asset is 8 years. The residual (salvage) value is $200. These ifems will be recorded as Furniture and Fixtures and will be depreciated using straight line depreciation. Only record the purchose. Arranged for Sun City Movers to make the delivery and for the setup of the computer system and paid the delivery and setup charge of $750. This charge should be added to the cost of the computer equipment purchased and depreciated on the same basis as the computer equipment. Purchased $450 of office supplies for cash from Office Supplies Company. Purchased $8,000 of merchandise inventory-skis on account. Purchased $6,000 of merchandise inventory-snow boards on account. There were no credit terms for prompt payment. Mr. Slant received and paid the $940 charge from lowyer Hit the Slopes, Inc. is now open for business, Customers will go on-line and select the merchandise they wish to purchase. Online payments will be considered cash sales. 15. 1/14/23 Deposit \#3 Sold merchandise for $7,200 cash. The cost of the Skis is $3,000 and the cost of the Snowboards is $1,100. Sales tax will be $594. The merchandise will be shipped FOB destination. \begin{tabular}{|c|l|l|l|} \hline 16. & 1/16/23 & Ck #1008 & Paid $250 to ship the merchandise. \\ \hline 17. & 1/16/23 & & Purchased additional skis on account for $4,500. \\ \hline 18. & 1/20/23 & Deposit \#4 & Recordedintemetsalesforthefirstfivedaysofoperation.Salestotaled$8,300.Salestaxis$536.The \\ \hline \end{tabular} Group Practice Chart of Accounts \begin{tabular}{|c|l|} \hline Current Assets \\ \hline 10000 & Cash \\ \hline 11000 & Accounts Receivable \\ \hline 12000 & Inventory - Skis \\ \hline 12100 & Inventory - Snowboards \\ \hline 13100 & Office Supplies \\ \hline 13200 & Shipping Supplies \\ \hline 14000 & Prepaid Rent \\ \hline 14100 & Prepaid Insurance \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Stockholders' Equity } \\ \hline 39003 & Common Stock \\ \hline 39005 & Retained Earnings \\ \hline 39007 & Dividends \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Revenue \\ \hline 40000 & Sales \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Long-Term Assets } \\ \hline 15000 & Furniture and Fixtures \\ \hline 17000 & AccumulatedDepreciation-FurnitureandFixtures \\ \hline 15100 & Computer Equipment \\ \hline 17100 & AccumulatedDepreciation-ComputerEquipment \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|l|}{ Current Liabilities } \\ \hline 20000 & Accounts Payable \\ \hline 21100 & NotePayable-WellsFargoBank \\ \hline 21200 & NotePayable-ComputerInc. \\ \hline 23100 & Wages Payable \\ \hline 23200 & Interest Payable \\ \hline 23300 & Sales Tax Payable \\ \hline 23400 & Utilities Payable \\ \hline Long Term Liabilities \\ \hline 27000 & Mortgage Payable \\ \hline 27100 & Note Payable \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Expenses & \\ \hline 50000 & Cost of Goods Sold \\ \hline 60100 & Legal Expense \\ \hline 60150 & Office Supplies Expense \\ \hline 60200 & ShippingSuppliesExpense \\ \hline 60300 & Insurance Expense \\ \hline 60350 & Wages Expense \\ \hline 60400 & Credit Card Expense \\ \hline 60450 & Delivery Expense \\ \hline 60500 & AdvertisingandPromotionExpense \\ \hline 60550 & Utility Expense \\ \hline 60600 & Rent Expense \\ \hline 60650 & Depreciation Expense \\ \hline 60700 & Interest Expense \\ \hline 60750 & Bank Service Fee \\ \hline 60800 & RegistrationFeeExpense \\ \hline 60850 & Gasoline Expense \\ \hline \end{tabular} 41Page 1 Step 1: Write the journal entries in an Exoel spreadsheet. Print out the spreadsheet when finished. 2 Transaction Dr coount Dollar Amount Ci ooount \# Dollar Amount . Example