Binarne This case study must be completed in Excel program using the formats provided in this book Objectives 1. Practice the steps med the counting Cycle 2. Practice electronic spreadsheet a Instructions 1. Uw the Chart of cours provided record ons te month of onese General Demet 2. Post the General 3 Peeteed Twewe 4. Joumate any contingentes in General Joumal and post to the Center Show your calculations for the users in the sense Prepare the Adjusted Titance in the Trust Prepare the closing oma ertesine General mal and post to the General Ledger 7. Prepare the Poliang Trial Batance in the Tow Butances take the come Statement and Balance Sheet cous on the Trade Prepare casted teneta ter he become the resument of Nature Componente for the period of 20000 2001 in the protect 10. Note the following formation The business began on July 1.2020 2. The pered under considerations MY 1.2000ne 30 2001 3. For the purpose of this signant. ignore me afects of cour af goods and monetan, peny, anda 4. Seregtine depreciation method is used The eles on hand June 30, 2001 were 6. Physical count of food inventory on hand June 30, 2021 w 51500 7. The telephone but for June 30, 2004 be $135 was scrivedy, 2021 The unity but for June 30, 2005 sot 5205 receivedy 2021 For the purpose of this met there for me to be 19 The wing water connected were Jy1.2000 Le Bures and her her. James eachwed 515.000 portioned to Dinar 4. Can were rund 1.500 rs of 10 y 1.2020 The 50.000 armato The were only for your staff per you want principale en years. The more prethods flowing month 2000 because this webs hered the best 1.000 metrostorih 1500 turty depository of 37.500 The business purchased equipment and future ter 20.000 inch The me te of 10 years The company purchased awy S40.000 wests.com essas pie winnerste rate of the mate. The most 1.2000 2020 Preston Heo Bed & Breakfast (B&B Oer to provide per personer Diner 6 w B8 Batteendelea rested Purmet med by 10th of the next month Paid 800 for power and she beginning er 100 A 1000 Diner ne Accounting Transactions for the Month June 2021 Dale Description June 2. 2021 Paid une fent in the amount of $4.000 Jure 2. 2021 Paid S750 or more pering June 1 one 5.2021 Food purchases in the curt of $1.200 paid in case June 6, 2021 The business punased $2.500 for supplies en account ton Jones Supplies De Ane, 2021 Payment received from Preston B&B to May 2021 June 17, 2:21 Food purchases in the cutter 60 padah June 16, 2021 Cash recepture deported in the amount $2.800 ore 16, 2021 Paid 1.200 le coyees for speared in the tratte waka tame June 22.2021 Pedunt u toes Spesco June 22, 2021 Cashmere posted in the amount of 8.500 June 25 2021 Paid bin the mount of 5366 June 28 2021 Paid iphone in the mount of $170.00 June 26 2021 Cash receipts were posted in the amount 13.000 June 23.2021 Paid for cleaning and maintenance experte for the more $1.150 June 30.2021 Truck payment med T5700 55 ( Popot 8064.73 most = 595821 June 30.2021 Cash receipts were deposited. 56.500 June 30, 2021 Sent and recorded invoice to Preston HB88 for month of June in the out of 600 June 30.2021 Paid $3.50 to the company record for the long charges Advertising S850 Uno 5.300 Repers $250 Prudin 5800 Gawin June 30, 2021 Paid to be played for wages camed Shein at June June 30, 2021 Soeso in contato contrar inch June 20121 Dividends pret to share out of $ Diner 54, Inc Chart of Account Number Account Assets C 100 110 115 125 130 135 540 150 156 160 Accounts receivable Foodtry Supplies Prepaid rent Papir Devery in Equipment and Futuna Accued depreciation Seourly depot 210 220 230 240 Liabilities Accounts payable Notesybilo on Certificates ne payable 300 310 Stockholders' Equity Common stock Retained wing 400 500 600 610 620 530 640 650 660 685 670 675 680 685 60 895 700 750 Revenue Sweet Expenses Cest of Goods Sold Advertising expense yan | Suspensie Depreciation expense espre cerpen Gesell There were Repair sense Uspense Uhlomexpense Cleaning & maintenance expense Pepere De income nary Binarne This case study must be completed in Excel program using the formats provided in this book Objectives 1. Practice the steps med the counting Cycle 2. Practice electronic spreadsheet a Instructions 1. Uw the Chart of cours provided record ons te month of onese General Demet 2. Post the General 3 Peeteed Twewe 4. Joumate any contingentes in General Joumal and post to the Center Show your calculations for the users in the sense Prepare the Adjusted Titance in the Trust Prepare the closing oma ertesine General mal and post to the General Ledger 7. Prepare the Poliang Trial Batance in the Tow Butances take the come Statement and Balance Sheet cous on the Trade Prepare casted teneta ter he become the resument of Nature Componente for the period of 20000 2001 in the protect 10. Note the following formation The business began on July 1.2020 2. The pered under considerations MY 1.2000ne 30 2001 3. For the purpose of this signant. ignore me afects of cour af goods and monetan, peny, anda 4. Seregtine depreciation method is used The eles on hand June 30, 2001 were 6. Physical count of food inventory on hand June 30, 2021 w 51500 7. The telephone but for June 30, 2004 be $135 was scrivedy, 2021 The unity but for June 30, 2005 sot 5205 receivedy 2021 For the purpose of this met there for me to be 19 The wing water connected were Jy1.2000 Le Bures and her her. James eachwed 515.000 portioned to Dinar 4. Can were rund 1.500 rs of 10 y 1.2020 The 50.000 armato The were only for your staff per you want principale en years. The more prethods flowing month 2000 because this webs hered the best 1.000 metrostorih 1500 turty depository of 37.500 The business purchased equipment and future ter 20.000 inch The me te of 10 years The company purchased awy S40.000 wests.com essas pie winnerste rate of the mate. The most 1.2000 2020 Preston Heo Bed & Breakfast (B&B Oer to provide per personer Diner 6 w B8 Batteendelea rested Purmet med by 10th of the next month Paid 800 for power and she beginning er 100 A 1000 Diner ne Accounting Transactions for the Month June 2021 Dale Description June 2. 2021 Paid une fent in the amount of $4.000 Jure 2. 2021 Paid S750 or more pering June 1 one 5.2021 Food purchases in the curt of $1.200 paid in case June 6, 2021 The business punased $2.500 for supplies en account ton Jones Supplies De Ane, 2021 Payment received from Preston B&B to May 2021 June 17, 2:21 Food purchases in the cutter 60 padah June 16, 2021 Cash recepture deported in the amount $2.800 ore 16, 2021 Paid 1.200 le coyees for speared in the tratte waka tame June 22.2021 Pedunt u toes Spesco June 22, 2021 Cashmere posted in the amount of 8.500 June 25 2021 Paid bin the mount of 5366 June 28 2021 Paid iphone in the mount of $170.00 June 26 2021 Cash receipts were posted in the amount 13.000 June 23.2021 Paid for cleaning and maintenance experte for the more $1.150 June 30.2021 Truck payment med T5700 55 ( Popot 8064.73 most = 595821 June 30.2021 Cash receipts were deposited. 56.500 June 30, 2021 Sent and recorded invoice to Preston HB88 for month of June in the out of 600 June 30.2021 Paid $3.50 to the company record for the long charges Advertising S850 Uno 5.300 Repers $250 Prudin 5800 Gawin June 30, 2021 Paid to be played for wages camed Shein at June June 30, 2021 Soeso in contato contrar inch June 20121 Dividends pret to share out of $ Diner 54, Inc Chart of Account Number Account Assets C 100 110 115 125 130 135 540 150 156 160 Accounts receivable Foodtry Supplies Prepaid rent Papir Devery in Equipment and Futuna Accued depreciation Seourly depot 210 220 230 240 Liabilities Accounts payable Notesybilo on Certificates ne payable 300 310 Stockholders' Equity Common stock Retained wing 400 500 600 610 620 530 640 650 660 685 670 675 680 685 60 895 700 750 Revenue Sweet Expenses Cest of Goods Sold Advertising expense yan | Suspensie Depreciation expense espre cerpen Gesell There were Repair sense Uspense Uhlomexpense Cleaning & maintenance expense Pepere De income nary