Share Comments SB LIX V ) m Insert Format Delete Y Sart Filter v Find & Select Analyze Date V AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bady) v 10 ~ A A Wrap Text v General [G Paste B 1 I U UvA A = = $ % Merge & Center Cell Conditional Format Formatting as Table Styles 052 fx A C c D F F G G H 1 1 L M N N R 1 1 Case: T R Us -Solutions 2 3 TESHUS, setup as a pitustely held amaton, meaning as a thirretries, which of the common shares are ched by malien. Yowerhed in somministransactions for the month of February 201, mmplete mand pr. prepare the statements and perform afnant labanalysis as of the end of that month. They use perpetual entory system and use the wild med det for the bry. Its bestis w barwy 31, 2021, ni baru T P 5 T w w X 7 9 Tens Hus 10 Chcolind Balance Sheet 1 As tary 31, 2021 12 Aasuta 13 Cash $35.600 14 Accounts Receivable NON 16.870 15 Merchandise writory 12.500 16 Prepoldinranke 440 17 Tocal Ourer Assen Gs.220 18 Lorg Tem Assets 19 Equipmem 16200 20 Accumulated Depredator 20 110 21 Total Assets $179.90 22 23 Uables 24 Current Usbites 25 Nomounts Payable $12.00 26 Uneamed PUP 27 Salaries Payable $8,700 28 Cment Prankinn 11,6 29 Total Darren $37460 30 Non-Gurus 3: Nabat Particulitank to 22,840 32 Total $62,700 33 34 Shareholders' Equity 35 Common Shares 81.000 36 Retained Eamings 37 Total Shareholders' Equity 1116 38 Tocallbillies & Equity $179.370 30 40 Nataleting to be 41 42 Customers and balances Suppliers and Babinces 43 Columbia $3.200 Herley so 44 Array 56,400 JAE $750 45 Fale Case Introduction Transactions General Journal General Ledger Ready Inventory Valuation Bank Reconciliation Worksheet Financial Stalements + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Bady) v 10 ~ A A Wrap Text v General SR V X [G LIX (O) Paste B 1 OAV = = = Insert Merge & Center $ % Y Delete Format Conditional Format Cell Formatting as Table Styles v Sart Filter Find & Select Analyze Date V 052 T fx c A B C D F F G H 1 1 L M N P Q R 5 T X Y o $7.500 540 $12.000 Acosunt 400 405 410 420 430 30 40 Notes Nating to Be 41 42 Customers and balances Suppliers and Dances 43 Columbia $3,200 Herley 44 Array 56,100 4E 45 Dries Fabrica 46 Martin $2.100 Total 47 Short $920 48 Total $16,870 49 The bank loan has an amul interest rate of 5% and has monthly principal payment or $530 50 51 The inventory figure indudes 500 units purchased at $25.00 each 521 53 54 The Chartof Accoub/GL na) down below: 55 Account Description | Arra Acourt Description 56 ASSETS REVENUE 57 Cash 101 Sabates 58 Pecy 106 Bus D. 59 Al Recenalla 110 Saks Rubunits and Aluwanges GO Marchandise wertory 120 In een G: Prepaid Indra 125 |Dia Othercare G2 viement C. 140 EXPENSES G3 Accumulated Depredator 145 Cost of Good Sod G4 UABILES Employee Benetts Expanse GS Accounts Payab 200 20 Deprecation Expense 66 Interest Payable 206 Treurance Expense 67 62 CPP Payable 220 Interest Expense 68 El Payable 225 Ottice Supplies Eeerde 69 Income Tax Payable 230 Ren pense 70 20 Salaries Payable 235 Salaries Exerce 71 reamed mere 200 Bank Charges Expense 72 Tank Loan 265 Mantenance Expense 73 SHAREHOLDERS' EQUITY Entertaiment pense 74 Common Shares Shine 75 Hands Dashara 76 77 78 79 80 8 82 93 84 95 500 5.0 515 520 525 530 535 540 545 350 555 Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Statements + Ready + 100% Share Comments SRL ) Insert Y Delete Format Sart Filter Find & Select Analyze Date V T P 5 T U v Y Y 2 AutoSave OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bady) v 10 ~ A Wrap Text v General [G Paste BIU - Merge & Center $ % Conditional Farmet Cell Formatting as Table Styles A1 + x fx Transactions for the month of February A B D F F G H 1 N Q R 1 Transaction for the month of February 2 3 Feb 1 Pirel ferruary Mar $650. Chegu 3354 Febi Test dicha walisha pety anshlund furtheil. Actul $500 wasiwand Lashed. G Purchased merchande from Henicy on account, inoke 1425, 1100unt at $23ach Terms of the 7 Febs purchase wrc 4/10, nct 20,FOB Destination. The clcr paid the shipping cost amounting to $55. Update the inwentary table aftercard purchase. 9 10 Fab 2 sok medardise to Arrow, Scours 21 $75 cach with imice E2341. The invoke tema wrc 3/10, nct 20 Note. Update the lower toy Vauation Table after each sale 11 12 Some of goods purchased from Herly was the active. Hely to Salana on the wall 13 19 Feb purchased 9 14 Note: You need to update the inventory record to reflect the sllowsntes it reduces the value of the 15 Inventory . 16 Paid total ability with a chequs 43255 to Herky Fordre February 5 purchased lez the alowance from Feb. 9 . 18 Note: "cu wlined to under the Merdanielwelry.nl trany ciunt for wath 19 y las 20 21 Feb 15 The empir puids-ww.ky. Peidiw payrol furthelesculturFebruary.checue 43387. Crosspay $12,500, CIPSE38, Elia $23. and income tax is $2,500 Lethe II jumal tid 22 23 Feb 15 Becord the employer's share 'CPP (100x ans 1407) of what was deducted from emelyees 24 25 Feb 17 Amcw galdnoke 2341 on card book advantage of the early payment discount 26 17 Feb 12 Bought from Fabrica with cheque 13358,1400 units at $30 per unit. Ne: Updare wory 27 Feb 18 15 Valuation table to reflect purchase 28 Feb 20 Sokounts at 590 each within 242 10 Marth. The more term Vinet 30. FOB Sharepoint 29 Mote proteinery Valmentable 30 Feb 20 Received $3.200 from Columbiatora sale an acco.ntlastno 31 The remaining barcipally he was $150. Telulared using poyas hot . I 32 Curd this manich amount $345. In amu.nil, indust the shipping stron Feb 7 in the Fol 25 33 amer $55 and the other costs are for the office suppliers. Prepare the entry le replenibh the 34 pretty fund with Clo9 35 Mack marchly bank kan perment of $1.076 which includes $230 pridaland 5146 il 36 37 Feb 28 Note: cu tochzil the plan of the lank wanfert principal pay. The 38 portion du wil in the same as the cue cal for the loan is than 12 months from bele 35 40 42 At the end of February, the folowtracjustment had to be jumalted to properly report the balances of the company's 42 aourte : Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w + 100% AutoSave OFF AP ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Bady) v 10 General X LE Wrap Text v m SEX ) ~ A Paste BIU - Insert Merge & Center $ % Delete Format Conditional Farmet Cell Formatting as Table Styles v Sart Filter Find & Select Analyze Date V K M N P a R 5 T U v W Y Y z 2 A1 fx Transactions for the month of February A D F F G H 1 40 4. As the end of February, the tobontoga.stment had to be jumalaed to properly report the balances of the company's 42 aourte: 43 44 Prepared the papel forte second half of February to be paid on March 5. Gus popis $15,000, PPk 45 Feb 28 576, EE $282 and income taxis $3,000. The cheq.e wil be prepared later. Use the general joumalto 46 neoord this. 47 Feb 28 card mpyur's straf CIP (100% and El [140.4) fal was clean upays. 48 4s Feb 28 Habenor of Insurpris 10 marts Left on the key end the ci sment of $440 50 un math won. Feb 2B or beginning balance of named, $2,700 sulmansurname 52 53 Feb 28 Moreny Cereation on the ecuperwas $1.500 54 55 56 equired: 57 al Prepare the joumal entics for the month of February 58 binter the opening balances of the court rom the opening balance sheet and posteabejomal entries to the account 59 mphile the turkin purl. GO di Postjournal entries from the bank reconciliation to Real der acourts 61 el Complete the 10-ohm worksheet 63 Jaurnalise and past the adjustments G4 RI Prepare the mudrop income statement, calculation of retained carings, dassified balance sheet 66 Fanswer the analys's questions from to found at bottom on Financial Statements tab) 67 65 70 7: 72 73 74 75 76 77 78 79 90 8 82 93 84 85 Case Introduction Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 11 ~ Al A Wrap Text v General X [G V (O) Paste CA = = - BIU Insert $ % Delete Merge & Center Format Conditional Farrat Cell Formatting as Table Styles Sart Filter Find a Select Analyze Date V G53 + x F G H . L M N 0 P G R 5 T U V W X Z General Joumal Tacom Tode and planen E Page : CR PR DR A . 2 Date 3 2022 41 5 6 7 Feb 1 10 11 12 TDS 12 14 15 16 los T 17 18 15 21 22 22 24 Feb za 26 27 ze Feb 22 79 Y 2 51 36 36 37 39 39 20 Feb 15 42 23 44 49 F 17 FD: 06 47 Case Introduction Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 ~ A A SR LIX V ) [G Paste B 1 y Insert Format A Sart Delete Y Find & Select Filter Analyze Date V G53 x fx 0 E F G H . L M N N 0 P a R S 5 U V W X Y Z A 40 FD 4 42 43 44 03 Feb 17 OC 07 Pix Generallum Acroint The und unvon 09 Date PR Da CR 18 51 Feb 52 62 10 51 55 Teo 20 56 57 58 59 6C 61 62 F. 20 63 64 65 G F 20 07 GB DS 70 Feb 25 12 71 M 76 en 77 78 79 BO 81 Feb 201 82 82 84 89 8 FED 28 SC Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w - - + 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - - $ % Merge & Center Cell Conditional Farmet Formatting as Table Styles Calibri (Bady) X [G v 11 ~ A A V (O) Paste B 1 Insert AY A Delete Format Sart v filter Find a Select Analyze Date G53 T A B E F H L M N 0 P B 5 - U V W X Z z G2 Feb 20 64 10 Feb 20 NO 1 Feb 5 23 22 73 74 25 76 TD2 77 78 79 30 8. F.D 28 81 32 82 54 B5 Feb 28 B3 BE 2 BY B Adjusting Entries e 89 Date 0 Feb 2A ) 1 96 97 911 98 98 100 101 102 28 103 104 105 106 FED 28 107 100 Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w + 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - - Cell Conditional Farmet Merge & Center Formatting as Table Styles Calibri (Bady) v 11 VA A ) SEX Insert Delete [G Paste B B 1 DAY v A v Format Sart Filter Find a Select Analyze Date V G53 4 x fx A C E F G . L M M N 0 P a R B 5 - U V W X Y Z BC 7 By Adjusting Entries 19 De FA Feb 28 02 14 99 1 96 97 92 Feb 201 98 98 100 101 102 15 28 103 104 105 106 Feb 28 107 108 109 110 Feb? 111 117 118 114 115 116 117 118 119 120 121 122 123 124 125 126 127 125 129 130 131 12 Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready 90% Auto Save OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Cell Conditional Format Merge & Center Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) Paste Insert B 1 B1 A Delete Format Sart v Find & Select V Filter Analyze Date D117 + x C D E F G H 1 1 K 1 M. M N 0 P Q R S S 1 U W X Y PR DA CR A B 1 General Ledger Accounts 2 Aamunt Cash 3 Date Description 4 Opening Balance S 5 6 2 2 8 QN101 101 Balance for OR) 35.600.00 DR 9 10 11 12 12 14 15 Petty Cash Description Opening Balance PR DR CR GN105 Balance of ort) 0.00 DR 16 17 Amunt 18 Date 19 20 21 22 23 24 Account: 25 Date 26 27 28 2 30 Nes 110 Accounts Rechivable Description Openingslande PR DR CR Balance (DR OF CR) 1670.00 DR Merchandise Inventory Descrution Opening Babanoc PR DR CR Ne 120 Balance of ort) 12.500.00 DR 32 Namunt 33 Date 34 35 36 37 38 39 40 41 42 43 14 Manunt: Prepaid iurance Case Introduclion GN125 Gerieral Journal General Ledger Transactions Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready w - 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Conditional Format Cell Merge & Center Formatting as Table Styles Calibri (Bady) v 10 ~ A A X [G m ) V Paste B 1 Insert A Delete Format Sart v Filter Find & Select Analyze Date D117 + x fx B c D F F G 1 1 K x 1 M M N 0 0 P R R S S 1 U v W X Y DR CR GL Ne 125 Balance DR of CRL) 4ADO DA DR CR GLNC140 Balance (DR of CR) 12.00 - - - DR CR 44 Account Prepaid Insurance 45 Date Description PR 46 penting laban 47 98 49 SO Account Equipment 51 Date Description PR 52 pening talent 53 54 55 56 Account Accumulated Depredadon 57 Date Description PR 58 Opening Habar SS 60 61 Amunt: Amunt Pwywide Payable G2 Dese Description PR 63 Opening Balance 64 GS 66 67 G2 69 Menunt: Interest Payable 70 Description PH 7 Open Balance 72 73 74 75 Account CPP Payable 76 Date Description PH 77 Opening Balance 78 79 GLN145 Balance (DAR) 52.110.000 DR CR ca. Na 200 Balance (DRO CR) 12.000.000 DR CR GL NOT 205 Balance (1) 0.00 CA OH CR GL NO 220 Balance or 01) 0.00 CR 90 82 83 Account Date 85 86 El Payable Description per akan PR DR CR GLN 225 Balance Dor OR) 0.000 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) vi Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 10 ~ A A X [G Wrap Text v Number SR V LX m (O) Paste B 1 A $ % Insert Merge & Center Delete Format Conditional Farst Cell Formatting as Table Styles Sart v filter Find & Select Analyze Date V D117 + x T A B c D F F G H 1 1 1 K 1 M N 0 P Q Q R R s 1 U v W X Y 83 Account 44 Date 85 El Puyable Description Opening balan PR DR CR GLN 225 Balance (DR of CR) 0.0001 PR DA CR Nes 230 Balance IDR or CR) 0.00 97 88 85 90 91 Namunt: Income Tax Payable 92 Der Duscription 93 Opening Babanoc 94 95 96 97 98 99 100 101 102 Account Salaries Payable 103 Date Description 104 Opening Balans 103 106 107 108 Account Unearned Revenue 109 Date Description 110 Openin Blanes 111 PR OR CR GL NO 235 Balance of or CH) 5,700.000 PR OR CR GL NO 240 Balance OR CH) ( 9.000.000 112 Bank Loan Description Opening Bilano PR DR CR GLNO 245 Balance OR CH) 35.000.00 OR 113 114 Account 115 te 116 117 118 119 Account 120 Date 121 122 123 124 125 OLNE Common Shares Description in Tabance PR DR CR 300 Balance (DRO CR) 1. Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Cell Merge & Center Conditional Format $ % Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) Paste B 1 Insert A Delete Format Sart v Find & Select V Filter Analyze Date D E F G 1 1 K 1 M. M N 0 P Q R S S 1 U W X Y DR CR GLNO 305 Balance OR CR) 36.670.00 Nos 400 Balance DR OCH DR CR CR DR 0.00 GLNG 405 Balance ) LOOR) 0.00 DR DA CR GNO 1 410 Balance (Oflor) D117 + x B C 126 Account Retained Earnings 127 Date Description PR 128 Openin Blanco 129 130 131 Account: Sales Rowaru 132 Date Description PR 133 134 135 136 137 Amount: See Dienunta 138 Date Description PR 139 Feb 17 GE 140 141 142 Amunt Sales Returns and Alliances 143 Date Description PRI 144 145 146 147 118 149 150 Account Interest Revenue 151 Date Description PR 152 153 151 155 Amount: Contal Goods Sold 156 Date Description PR 157 158 159 160 161 162 163 Mamunt Employee Benefits Expense 164 Date Description PRI 163 166 167 168 169 Case Introduction GL NO 420 Balance Of or CH) DR CR DR O No 500 Balance (DRO CR) CR Ne 510 Balance (O) DA CR Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Slalements + Ready w - + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) vi Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 10 ~ A A Wrap Text v Number SR X [G V LX m (O) Paste B 1 A A $ % Insert Merge & Center Delete Format Conditional Farst Cell Formatting as Table Styles Sart v filter Find & Select Analyze Date V D117 T A B D F F G 1 1 K 1 M N 0 P Q Q R R s 1 U v W X Y GL Nes 515 Balance (DRC) PR DR CR G. No 520 Balance (OR) Bure PR DR CR GL NO 525 Balance OR CH) PR DR CR GL Net 530 Balance DR OF CR) PR DR CR 170 Account Depreciation Expanse 171 Date Description 172 173 124 175 Mamunt: INALTATO upense 176 D Description 127 178 179 190 Account Interest Expense 181 Description 182 123 181 185 Account Office Suple Experie 186 Date Description 187 188 199 190 Menunt: Rent Tapes 191 Date Description 192 19.3 194 193 196 197 198 Account Salaries Ekperse 199 Date Description 200 201 202 203 204 205 Namunt Hank Charge Txere 206 Date Description 207 208 209 210 Account Entertainment Expense 211 Date Description 212 Ne 585 Balance DAO CR) PR DA CR GL NO 540 Balance OR CR) PH OR CR Nel sas Balance DA or CR) ( PR DR CR GL No 555 Balance (DOC) PR DE CR Case Introduction Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Slalements + Ready 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Review Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Wrap Text v Number + $ % Merge & Center Conditional Format Cell Formatting as Table Styles Calibri (Bady) v 10 VA A V X [G (O) Paste B1 Insert Delete Format Sart v filter Find & Select Analyze Date V D117 T 4 x fx B A B C D E F G H 1 1 1 x 1 M N 0 P Q R S S 1 U W X Y Salaries per Description ca. Nes 500 Balance (OR OF CR) PA DR CR Bank Charges Experte Description GL Nos 545 Balance (DRO CR) PR DR CR 195 196 197 198 Mamunt: 199 Dan 200 201 202 203 204 ZOS Account 206 Date 207 208 209 210 Aamun 211 Dan 212 21.3 214 215 Mccount: 216 Date 217 218 710 220 Account 221 Date 222 223 Emertainment Expense Description PR DR ca.Net 555 Balance (DA OF CR) CR Shipping Expense Description GL NO 560 Islance) PH OR CR Cash Over and Short Description GL Ne 565 Balance (DRO CR) PR DR CR 224 225 226 227 228 229 230 231 232 233 234 235 236 237 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share 0 Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me ah Wrap Taxt v Number = = = - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) V Paste B 1 UvA A Insert Delete Format Sart Find & Select Filter Analyze Date V J17 + x A c F F G H 1 N P Q R s T U u v V w X Z AA Sales Unit Cart Quantity Wu Balance Quantity Unit Com Velus 500 2500 12.503.00 1 Use the chart to keep track of inuentory values 2 Purches Date 3 Quantity | Unit Cart 4 Jan 31 5 Feb 6 Feb 2 7 Feb 9 7 8 Feb 12 9 Feb 18 10 Feb 20 11 12 13 14 15 16 17 18 19 20 2: 22 23 24 25 26 27 28 23 30 32 33 34. 35 36 37 38 35 40 41 4 42 43 14 Case Introduction Transactions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Statements + Ready 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ~ A ) V Delete V Format v Sart Filter V Analyze Date Find a Select T 5 T U V w X X Calibri (Bady) v 10 ah Wrap Text General SR LE Paste B 1 U Merge & Center $ % - Conditional Format Cell Insert Formatting as Table Styles A1 + x fx Your accountant goes through the mail and opens the bank statement for the month of February provided by Bank of Canada. It is shown below. A B D E F H 1 L M N o P 1 Your accountant goes through the mailand opens the bank satement for the month of Februaryp wie by Bans of 2 Cnnd shown 3 4 Bank of Care 5 Prepared for Tees RUS 6 Information Withdrawal De | Balance 7 Opening Balance 24,300.00 Feb1 Paid Ont3155 Tour 23.800.00 9 Feb Deport 11,000 35,100.00 10 Feb 1 Paid ISS 28.09.50 7.410.45 11 Feb 15 Paid that3157 9,127.00 2.116.GO 12 Feb 17 Deport 56200100 13 Feb 18 CE 42.000.00 14.063.40 14 Feb 19 Chor124) 3,390.00 10.693,43 15 Feb 25 Char359 3500 10.40 16 Feb 28 A te debian peyman 1076.00 9,267.40 17 Feb 28 Servloe Charge 24.00 9.233.42 18 Feb 8 interest 28 3451 9,579,401 19 20 20 21 54 55 56 Generelle ALI Cash GL NO: 101 58 Date Description PR JOR CR Balance IDR ORD 55 Opening Balance 35,500.00 OR GC Feb1 Paid O3154 8.3 660.0 34,940.00 DR 61 Feb 1 Paid that3155 500.00 14,140 00 OR 62 Feb 13 Paid Cheras 1.3 28.021.60 S350 40 OR G3 Feb 15 Paid On 13:57 6.3 9.127.00 2.776.50 CR 64 Feb 17 Received payment 55,200.00 55,123 10 OR 65 Feb 18 Peidintory Chai 4.3 42.000.00 13,423 40 OR GG Feb 20 Received payment 6.3 2,203.00 15,523.40 OR 67 Feb 25 Pety Cash Chart 53 10.00 16,2740 OR 68 Feb 28 Paid been 4.3 1,076.00 15,197.40 OR GS 20 73 72 Anal information 73 al The 511.300 is already resorded in the lederst month 74 LC mof it comery lustly fur 14). 75 26 Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalernens Ready 57 Account + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments am V X LG LIX (O) Paste Insert Calibri (Bady) v 10 ~ A ah Wrap Text General B 1 U du Merge & Center A & $ %> 99 Cell Conditional Format Formatting as Table Styles fx Your accountant goes through the mail and opens the bank statement for the month of February provided by Bank of Canada. It is shown below. Y Delete Format v Sart Filter Find & Select Analyze Date V A1 + x B D E F G H 1 1 K L M N o P 5 1 U V X 72 Advanalinformation 73 al The $11.300 is already recorded in the led per last month 74 Chwn.mbur of the company is cnly for 14 tys. 75 76 77 Required: Prepare the February bank recorciation for Tees R Us using the bank statement and general ledger provided Compare the information in the general ledge to the bank statement. Once records, record the relevant omal entries in 78 the general omal and post the entries in the general ledger to bring the company's record up to date 79 80 82 83 84 OS 86 Tees RUS Bank Recondition Statement February , 2021 Balance per books 1519.40 Balance per Bank 4,521.40 87 88 89 90 91 Explanation 92 Halance 93 94 95 96 97 98 95 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Salernens + Ready 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Review Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Wrap Text v General $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 ~ A A SR V (O) [G Paste B 1 A = = - Insert Y Delete Format Sart O Filter Find & Select Analyze Date V 047 1 x fx C A c E 1 M N P Q R S S T u u V w X 3 4 F G H ! TeRUN Worksheet February 28, 2021 Adjustments Adustrial Balance 5 Income Statement Balance Sheet Unedjusted Trial Balance DR CR DR CR DR CR DR OR DR OR 7 7 Account The 9 Cash 10 Pocoy Cash 11 Mocounts Asceivable 12 Mentunde wur 13 Prepaid insurance 14 Eguiment 15 Audi 16 Accounts Payak 17 Interest Payable 18 CP Payable 19 El Pack 20 Income Tax Payable 21 Salaris. Pelle 22 Ureamed Reveru 23 Dank loan 24 Carmen Sans 25 Reale fanings 26 Sales Revenue 27 Sales units 28 Sales Rents and Alware 29 Interest Revenue 30 then 3: Cost of Good Soda 32 Employee Benefits Experce 1litvil arth 33 34 Insurance Eparse 35 interest Expense 36 Office Supplies Esprit 37 Rent Expert 38 Salaries Expense 39 Hank theran 40 Martenance Esperde 41 Entertainment ne 42 Stine tense 43 Cash Over and short 44 Total 45 Nutram 46 Toat Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheet Financial Slalements + Ready w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Bady) v 11 ~ A A Wrap Text v General SR V LX () [G Paste B 1 I U A y = = = -- Insert $ % Merge & Center Y Delete Format Conditional Farmet Cell Formatting as Table Styles Sart Filter Find & Select Analyze Date K203 fx 1 . K M N N AB AC AE BG AH AJ Al AK AL 4 11 116 | A B C D G H 1 Tees RUS 3 dessed Balance Sheet 4 As atuary 31, 2021 5 Assets 6 Ch Sasha $26,870 Merchandise inwentary $12500 $ 9 Pendinsan S4400 10 Tecal Durrent Asses 69,370 11 Lore Tem Assets 12 pment 162000 13 Asma Depreciel S2000 110.000 11 Total Assets $179,370 15 16 Lab 17 Current Labits 19 Nemunts Payable $12000 19 Uhamed Revere $9.000 20 Salaries Payable 55.700 21 Current Porin of Tank Loan S11 160 22 Total Duren Las $37,360 23 Non Current bites 24 Non-Durrent Portion of lank loan 23:10 25 Total 561,700 26 27 Shareholders' Equity 28 Common Shares 81,000 2 Heaned tags 11020 30 Teal Shareholders' Equity 113,570 3: Total Liabilities & Equity $179,370 32 33 Required: Ubire the land of the Law Leonis sufft. 28cm the mental statement 34 35 36 37 38 35 40 11 42 43 14 Case Introduclion Transactions General Journal General Ledger Ready Inventory Valualion Bank Reconciliation Worksheel Financial Statements + w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Bady) v 11 ~ Al A Wrap Text v General SB V LX (O) [G Paste B 1 Uy OYA = = = - - Insert $ % Merge & Center Y Delete Sart Format Conditional Format Cell Formatting as Table Styles V Filter Find a Select Analyze Date K203 fx E F G H 1 . 1 K M N N AB AC AF MG AH Al Al AK AL A B C D 43 50 11 Preparemustep inome statement 5: 52 Tees RUS 53 Income Statement 54 For the Month Finded February 28, 2001 55 Sales Revenue 56 Sales Bros 57 RSS 58 Cost of Goods Sok 58 Gross Pratt GO 60 Operates G: Employee Benefits Expere 62 Depreciation Cesene 63 Insur 64 orice Supplies Expen 65 Hent Cape 66 Salaries Expert 67 Bank Charges Eparse 68 Shoging typense 69 0.20 70 Tsal Operating Expenses 71 Other Income and expenses 72 Interest Expenie 73 Interest Ferenue 74 Tal other income and penses 75 76 Notincome 77 78 79 80 21 Prepares sabution of retained esmings 92 Calculation of Rendering 83 For the Month Ended February 28, 2021 84 Rwand Earni Benin 95 Add. Netico 86 Less thirds 87 Retained Earnings End 98 BS 90 92 92 Case Introduclion Transaclions General Journal General Ledger Inventory Valualion Bank Recoriciliation Worksheel Financial Statements + Ready 100% Share 0 Comments V LX () Y Delete Format Sart Filter Find & Select Analyze Date BG AH AJ Al AK AL AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Bady) v 11 ~ Al A Wrap Text v General SR [G Paste B 1 Uy VA = = $ % Cell Insert Conditional Farmet Merge & Center Formatting as Table Styles K203 fx A B c D F G H 1 . K M N N AB AC AE 98 99 100 Pere desilinderslevmini Samamo pre will be identi berken for the 12 mechs 101 102 Tees RUS 103 Habang Sheet 104 As ut Fabruary 28, 2021 105 Assets 106 Current ASHLE 107 Cash 108 Penys 109 Asus Real 110 Merchandise inwentary 111 Prepaid insurance 112 Tel Durant ASSA 113 Lorg Tem Assets 114 Cruipment 115 Adulte Den 116 Total ASSES 117 118 Lilit 119 Current Labits 120 Accounts Payable 121 CI Payable 122 El Perak 123 Inerme Tax Payable 124 Salaries 125 Wroamed Reverus 126 Cument Portion of Tank loan 127 Total Darren Les 128 Non Ourent Lates 129 Non-Durrent Portion of bankinn 130 Talli 131 Share oders' Ecuty 132 Common Shares 133 Hetained in 124 Tegal & Slank ders' Equity 135 136 137 138 139 140 10 Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Statements Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share 0 Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = = - - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 VA A SB V LX m () [G WS Paste B 1 Insert OYA y Y Delete Farma: Sart Filter Find a Select Analyze Date K203 1 . K M N AP AC AD AF AG AH AL Al AK AL A B C c D E F G H 142 143 144 145 146 147 Based on the information aborc.answer the rolowing questions. , 148 149 Al Calculate the current ratio as atenuary 28,2021 150 151 152 153 154 billes Tees R Us have a good ortadtment rate bain why why mert or 155 156 157 158 159 160 161 162 Cute the inventorystys on hand to 25 February 24, 2021. Since this is for the morth const muliply by 365 in the 163 formadorsed ultet 91 brys) 164 165 166 167 168 . ? di Last month, terventary cars on hand do was 29 days. Has the ratio improved? Wer why not? 169 170 171 172 173 174 175 176 Calculate the deliberate as at February 28,2021 177 178 179 180 181 Fabbr the missings at Fry 20131 182 183 184 125 Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Recoriciliation Worksheel Financial Statements + Ready 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share 0 Comments Calibri (Bady) v 11 - A Wrap Text v General SR V LX () [G WES Paste B 1 VA = = = - $ % Insert Merge & Center Delete Y Farma: Conditional Format Cell Formatting as Table Styles Sart Filter Find a Select Analyze Date K203 A B c D D F G H 1 . 1 K M N AR AC AF AG AH A Al AK AL 135 O 186 187 cl last month, the groesprott margin percentage was 7 What could have causis decrease in romargin percentage 188 189 190 191 192 193 194 195 hi Calculate the theme mwera Febrony 28.2023 196 197 198 199 200 201 illimemory tumover last month was 0.31 is de company holding on toimestory for a longerorshorter period of time? 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 Case Introduction Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Statements + Ready w 100% Share Comments SB LIX V ) m Insert Format Delete Y Sart Filter v Find & Select Analyze Date V AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bady) v 10 ~ A A Wrap Text v General [G Paste B 1 I U UvA A = = $ % Merge & Center Cell Conditional Format Formatting as Table Styles 052 fx A C c D F F G G H 1 1 L M N N R 1 1 Case: T R Us -Solutions 2 3 TESHUS, setup as a pitustely held amaton, meaning as a thirretries, which of the common shares are ched by malien. Yowerhed in somministransactions for the month of February 201, mmplete mand pr. prepare the statements and perform afnant labanalysis as of the end of that month. They use perpetual entory system and use the wild med det for the bry. Its bestis w barwy 31, 2021, ni baru T P 5 T w w X 7 9 Tens Hus 10 Chcolind Balance Sheet 1 As tary 31, 2021 12 Aasuta 13 Cash $35.600 14 Accounts Receivable NON 16.870 15 Merchandise writory 12.500 16 Prepoldinranke 440 17 Tocal Ourer Assen Gs.220 18 Lorg Tem Assets 19 Equipmem 16200 20 Accumulated Depredator 20 110 21 Total Assets $179.90 22 23 Uables 24 Current Usbites 25 Nomounts Payable $12.00 26 Uneamed PUP 27 Salaries Payable $8,700 28 Cment Prankinn 11,6 29 Total Darren $37460 30 Non-Gurus 3: Nabat Particulitank to 22,840 32 Total $62,700 33 34 Shareholders' Equity 35 Common Shares 81.000 36 Retained Eamings 37 Total Shareholders' Equity 1116 38 Tocallbillies & Equity $179.370 30 40 Nataleting to be 41 42 Customers and balances Suppliers and Babinces 43 Columbia $3.200 Herley so 44 Array 56,400 JAE $750 45 Fale Case Introduction Transactions General Journal General Ledger Ready Inventory Valuation Bank Reconciliation Worksheet Financial Stalements + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Bady) v 10 ~ A A Wrap Text v General SR V X [G LIX (O) Paste B 1 OAV = = = Insert Merge & Center $ % Y Delete Format Conditional Format Cell Formatting as Table Styles v Sart Filter Find & Select Analyze Date V 052 T fx c A B C D F F G H 1 1 L M N P Q R 5 T X Y o $7.500 540 $12.000 Acosunt 400 405 410 420 430 30 40 Notes Nating to Be 41 42 Customers and balances Suppliers and Dances 43 Columbia $3,200 Herley 44 Array 56,100 4E 45 Dries Fabrica 46 Martin $2.100 Total 47 Short $920 48 Total $16,870 49 The bank loan has an amul interest rate of 5% and has monthly principal payment or $530 50 51 The inventory figure indudes 500 units purchased at $25.00 each 521 53 54 The Chartof Accoub/GL na) down below: 55 Account Description | Arra Acourt Description 56 ASSETS REVENUE 57 Cash 101 Sabates 58 Pecy 106 Bus D. 59 Al Recenalla 110 Saks Rubunits and Aluwanges GO Marchandise wertory 120 In een G: Prepaid Indra 125 |Dia Othercare G2 viement C. 140 EXPENSES G3 Accumulated Depredator 145 Cost of Good Sod G4 UABILES Employee Benetts Expanse GS Accounts Payab 200 20 Deprecation Expense 66 Interest Payable 206 Treurance Expense 67 62 CPP Payable 220 Interest Expense 68 El Payable 225 Ottice Supplies Eeerde 69 Income Tax Payable 230 Ren pense 70 20 Salaries Payable 235 Salaries Exerce 71 reamed mere 200 Bank Charges Expense 72 Tank Loan 265 Mantenance Expense 73 SHAREHOLDERS' EQUITY Entertaiment pense 74 Common Shares Shine 75 Hands Dashara 76 77 78 79 80 8 82 93 84 95 500 5.0 515 520 525 530 535 540 545 350 555 Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Statements + Ready + 100% Share Comments SRL ) Insert Y Delete Format Sart Filter Find & Select Analyze Date V T P 5 T U v Y Y 2 AutoSave OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bady) v 10 ~ A Wrap Text v General [G Paste BIU - Merge & Center $ % Conditional Farmet Cell Formatting as Table Styles A1 + x fx Transactions for the month of February A B D F F G H 1 N Q R 1 Transaction for the month of February 2 3 Feb 1 Pirel ferruary Mar $650. Chegu 3354 Febi Test dicha walisha pety anshlund furtheil. Actul $500 wasiwand Lashed. G Purchased merchande from Henicy on account, inoke 1425, 1100unt at $23ach Terms of the 7 Febs purchase wrc 4/10, nct 20,FOB Destination. The clcr paid the shipping cost amounting to $55. Update the inwentary table aftercard purchase. 9 10 Fab 2 sok medardise to Arrow, Scours 21 $75 cach with imice E2341. The invoke tema wrc 3/10, nct 20 Note. Update the lower toy Vauation Table after each sale 11 12 Some of goods purchased from Herly was the active. Hely to Salana on the wall 13 19 Feb purchased 9 14 Note: You need to update the inventory record to reflect the sllowsntes it reduces the value of the 15 Inventory . 16 Paid total ability with a chequs 43255 to Herky Fordre February 5 purchased lez the alowance from Feb. 9 . 18 Note: "cu wlined to under the Merdanielwelry.nl trany ciunt for wath 19 y las 20 21 Feb 15 The empir puids-ww.ky. Peidiw payrol furthelesculturFebruary.checue 43387. Crosspay $12,500, CIPSE38, Elia $23. and income tax is $2,500 Lethe II jumal tid 22 23 Feb 15 Becord the employer's share 'CPP (100x ans 1407) of what was deducted from emelyees 24 25 Feb 17 Amcw galdnoke 2341 on card book advantage of the early payment discount 26 17 Feb 12 Bought from Fabrica with cheque 13358,1400 units at $30 per unit. Ne: Updare wory 27 Feb 18 15 Valuation table to reflect purchase 28 Feb 20 Sokounts at 590 each within 242 10 Marth. The more term Vinet 30. FOB Sharepoint 29 Mote proteinery Valmentable 30 Feb 20 Received $3.200 from Columbiatora sale an acco.ntlastno 31 The remaining barcipally he was $150. Telulared using poyas hot . I 32 Curd this manich amount $345. In amu.nil, indust the shipping stron Feb 7 in the Fol 25 33 amer $55 and the other costs are for the office suppliers. Prepare the entry le replenibh the 34 pretty fund with Clo9 35 Mack marchly bank kan perment of $1.076 which includes $230 pridaland 5146 il 36 37 Feb 28 Note: cu tochzil the plan of the lank wanfert principal pay. The 38 portion du wil in the same as the cue cal for the loan is than 12 months from bele 35 40 42 At the end of February, the folowtracjustment had to be jumalted to properly report the balances of the company's 42 aourte : Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w + 100% AutoSave OFF AP ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Calibri (Bady) v 10 General X LE Wrap Text v m SEX ) ~ A Paste BIU - Insert Merge & Center $ % Delete Format Conditional Farmet Cell Formatting as Table Styles v Sart Filter Find & Select Analyze Date V K M N P a R 5 T U v W Y Y z 2 A1 fx Transactions for the month of February A D F F G H 1 40 4. As the end of February, the tobontoga.stment had to be jumalaed to properly report the balances of the company's 42 aourte: 43 44 Prepared the papel forte second half of February to be paid on March 5. Gus popis $15,000, PPk 45 Feb 28 576, EE $282 and income taxis $3,000. The cheq.e wil be prepared later. Use the general joumalto 46 neoord this. 47 Feb 28 card mpyur's straf CIP (100% and El [140.4) fal was clean upays. 48 4s Feb 28 Habenor of Insurpris 10 marts Left on the key end the ci sment of $440 50 un math won. Feb 2B or beginning balance of named, $2,700 sulmansurname 52 53 Feb 28 Moreny Cereation on the ecuperwas $1.500 54 55 56 equired: 57 al Prepare the joumal entics for the month of February 58 binter the opening balances of the court rom the opening balance sheet and posteabejomal entries to the account 59 mphile the turkin purl. GO di Postjournal entries from the bank reconciliation to Real der acourts 61 el Complete the 10-ohm worksheet 63 Jaurnalise and past the adjustments G4 RI Prepare the mudrop income statement, calculation of retained carings, dassified balance sheet 66 Fanswer the analys's questions from to found at bottom on Financial Statements tab) 67 65 70 7: 72 73 74 75 76 77 78 79 90 8 82 93 84 85 Case Introduction Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 11 ~ Al A Wrap Text v General X [G V (O) Paste CA = = - BIU Insert $ % Delete Merge & Center Format Conditional Farrat Cell Formatting as Table Styles Sart Filter Find a Select Analyze Date V G53 + x F G H . L M N 0 P G R 5 T U V W X Z General Joumal Tacom Tode and planen E Page : CR PR DR A . 2 Date 3 2022 41 5 6 7 Feb 1 10 11 12 TDS 12 14 15 16 los T 17 18 15 21 22 22 24 Feb za 26 27 ze Feb 22 79 Y 2 51 36 36 37 39 39 20 Feb 15 42 23 44 49 F 17 FD: 06 47 Case Introduction Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 ~ A A SR LIX V ) [G Paste B 1 y Insert Format A Sart Delete Y Find & Select Filter Analyze Date V G53 x fx 0 E F G H . L M N N 0 P a R S 5 U V W X Y Z A 40 FD 4 42 43 44 03 Feb 17 OC 07 Pix Generallum Acroint The und unvon 09 Date PR Da CR 18 51 Feb 52 62 10 51 55 Teo 20 56 57 58 59 6C 61 62 F. 20 63 64 65 G F 20 07 GB DS 70 Feb 25 12 71 M 76 en 77 78 79 BO 81 Feb 201 82 82 84 89 8 FED 28 SC Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w - - + 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - - $ % Merge & Center Cell Conditional Farmet Formatting as Table Styles Calibri (Bady) X [G v 11 ~ A A V (O) Paste B 1 Insert AY A Delete Format Sart v filter Find a Select Analyze Date G53 T A B E F H L M N 0 P B 5 - U V W X Z z G2 Feb 20 64 10 Feb 20 NO 1 Feb 5 23 22 73 74 25 76 TD2 77 78 79 30 8. F.D 28 81 32 82 54 B5 Feb 28 B3 BE 2 BY B Adjusting Entries e 89 Date 0 Feb 2A ) 1 96 97 911 98 98 100 101 102 28 103 104 105 106 FED 28 107 100 Case Introduction Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready w + 90% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = - - Cell Conditional Farmet Merge & Center Formatting as Table Styles Calibri (Bady) v 11 VA A ) SEX Insert Delete [G Paste B B 1 DAY v A v Format Sart Filter Find a Select Analyze Date V G53 4 x fx A C E F G . L M M N 0 P a R B 5 - U V W X Y Z BC 7 By Adjusting Entries 19 De FA Feb 28 02 14 99 1 96 97 92 Feb 201 98 98 100 101 102 15 28 103 104 105 106 Feb 28 107 108 109 110 Feb? 111 117 118 114 115 116 117 118 119 120 121 122 123 124 125 126 127 125 129 130 131 12 Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheel Financial Statements + Ready 90% Auto Save OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Cell Conditional Format Merge & Center Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) Paste Insert B 1 B1 A Delete Format Sart v Find & Select V Filter Analyze Date D117 + x C D E F G H 1 1 K 1 M. M N 0 P Q R S S 1 U W X Y PR DA CR A B 1 General Ledger Accounts 2 Aamunt Cash 3 Date Description 4 Opening Balance S 5 6 2 2 8 QN101 101 Balance for OR) 35.600.00 DR 9 10 11 12 12 14 15 Petty Cash Description Opening Balance PR DR CR GN105 Balance of ort) 0.00 DR 16 17 Amunt 18 Date 19 20 21 22 23 24 Account: 25 Date 26 27 28 2 30 Nes 110 Accounts Rechivable Description Openingslande PR DR CR Balance (DR OF CR) 1670.00 DR Merchandise Inventory Descrution Opening Babanoc PR DR CR Ne 120 Balance of ort) 12.500.00 DR 32 Namunt 33 Date 34 35 36 37 38 39 40 41 42 43 14 Manunt: Prepaid iurance Case Introduclion GN125 Gerieral Journal General Ledger Transactions Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready w - 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Conditional Format Cell Merge & Center Formatting as Table Styles Calibri (Bady) v 10 ~ A A X [G m ) V Paste B 1 Insert A Delete Format Sart v Filter Find & Select Analyze Date D117 + x fx B c D F F G 1 1 K x 1 M M N 0 0 P R R S S 1 U v W X Y DR CR GL Ne 125 Balance DR of CRL) 4ADO DA DR CR GLNC140 Balance (DR of CR) 12.00 - - - DR CR 44 Account Prepaid Insurance 45 Date Description PR 46 penting laban 47 98 49 SO Account Equipment 51 Date Description PR 52 pening talent 53 54 55 56 Account Accumulated Depredadon 57 Date Description PR 58 Opening Habar SS 60 61 Amunt: Amunt Pwywide Payable G2 Dese Description PR 63 Opening Balance 64 GS 66 67 G2 69 Menunt: Interest Payable 70 Description PH 7 Open Balance 72 73 74 75 Account CPP Payable 76 Date Description PH 77 Opening Balance 78 79 GLN145 Balance (DAR) 52.110.000 DR CR ca. Na 200 Balance (DRO CR) 12.000.000 DR CR GL NOT 205 Balance (1) 0.00 CA OH CR GL NO 220 Balance or 01) 0.00 CR 90 82 83 Account Date 85 86 El Payable Description per akan PR DR CR GLN 225 Balance Dor OR) 0.000 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) vi Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 10 ~ A A X [G Wrap Text v Number SR V LX m (O) Paste B 1 A $ % Insert Merge & Center Delete Format Conditional Farst Cell Formatting as Table Styles Sart v filter Find & Select Analyze Date V D117 + x T A B c D F F G H 1 1 1 K 1 M N 0 P Q Q R R s 1 U v W X Y 83 Account 44 Date 85 El Puyable Description Opening balan PR DR CR GLN 225 Balance (DR of CR) 0.0001 PR DA CR Nes 230 Balance IDR or CR) 0.00 97 88 85 90 91 Namunt: Income Tax Payable 92 Der Duscription 93 Opening Babanoc 94 95 96 97 98 99 100 101 102 Account Salaries Payable 103 Date Description 104 Opening Balans 103 106 107 108 Account Unearned Revenue 109 Date Description 110 Openin Blanes 111 PR OR CR GL NO 235 Balance of or CH) 5,700.000 PR OR CR GL NO 240 Balance OR CH) ( 9.000.000 112 Bank Loan Description Opening Bilano PR DR CR GLNO 245 Balance OR CH) 35.000.00 OR 113 114 Account 115 te 116 117 118 119 Account 120 Date 121 122 123 124 125 OLNE Common Shares Description in Tabance PR DR CR 300 Balance (DRO CR) 1. Case Introduclion Transactions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Review View Tell me Wrap Text v Number - Cell Merge & Center Conditional Format $ % Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) Paste B 1 Insert A Delete Format Sart v Find & Select V Filter Analyze Date D E F G 1 1 K 1 M. M N 0 P Q R S S 1 U W X Y DR CR GLNO 305 Balance OR CR) 36.670.00 Nos 400 Balance DR OCH DR CR CR DR 0.00 GLNG 405 Balance ) LOOR) 0.00 DR DA CR GNO 1 410 Balance (Oflor) D117 + x B C 126 Account Retained Earnings 127 Date Description PR 128 Openin Blanco 129 130 131 Account: Sales Rowaru 132 Date Description PR 133 134 135 136 137 Amount: See Dienunta 138 Date Description PR 139 Feb 17 GE 140 141 142 Amunt Sales Returns and Alliances 143 Date Description PRI 144 145 146 147 118 149 150 Account Interest Revenue 151 Date Description PR 152 153 151 155 Amount: Contal Goods Sold 156 Date Description PR 157 158 159 160 161 162 163 Mamunt Employee Benefits Expense 164 Date Description PRI 163 166 167 168 169 Case Introduction GL NO 420 Balance Of or CH) DR CR DR O No 500 Balance (DRO CR) CR Ne 510 Balance (O) DA CR Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Slalements + Ready w - + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) vi Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Bady) v 10 ~ A A Wrap Text v Number SR X [G V LX m (O) Paste B 1 A A $ % Insert Merge & Center Delete Format Conditional Farst Cell Formatting as Table Styles Sart v filter Find & Select Analyze Date V D117 T A B D F F G 1 1 K 1 M N 0 P Q Q R R s 1 U v W X Y GL Nes 515 Balance (DRC) PR DR CR G. No 520 Balance (OR) Bure PR DR CR GL NO 525 Balance OR CH) PR DR CR GL Net 530 Balance DR OF CR) PR DR CR 170 Account Depreciation Expanse 171 Date Description 172 173 124 175 Mamunt: INALTATO upense 176 D Description 127 178 179 190 Account Interest Expense 181 Description 182 123 181 185 Account Office Suple Experie 186 Date Description 187 188 199 190 Menunt: Rent Tapes 191 Date Description 192 19.3 194 193 196 197 198 Account Salaries Ekperse 199 Date Description 200 201 202 203 204 205 Namunt Hank Charge Txere 206 Date Description 207 208 209 210 Account Entertainment Expense 211 Date Description 212 Ne 585 Balance DAO CR) PR DA CR GL NO 540 Balance OR CR) PH OR CR Nel sas Balance DA or CR) ( PR DR CR GL No 555 Balance (DOC) PR DE CR Case Introduction Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Slalements + Ready 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Review Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Wrap Text v Number + $ % Merge & Center Conditional Format Cell Formatting as Table Styles Calibri (Bady) v 10 VA A V X [G (O) Paste B1 Insert Delete Format Sart v filter Find & Select Analyze Date V D117 T 4 x fx B A B C D E F G H 1 1 1 x 1 M N 0 P Q R S S 1 U W X Y Salaries per Description ca. Nes 500 Balance (OR OF CR) PA DR CR Bank Charges Experte Description GL Nos 545 Balance (DRO CR) PR DR CR 195 196 197 198 Mamunt: 199 Dan 200 201 202 203 204 ZOS Account 206 Date 207 208 209 210 Aamun 211 Dan 212 21.3 214 215 Mccount: 216 Date 217 218 710 220 Account 221 Date 222 223 Emertainment Expense Description PR DR ca.Net 555 Balance (DA OF CR) CR Shipping Expense Description GL NO 560 Islance) PH OR CR Cash Over and Short Description GL Ne 565 Balance (DRO CR) PR DR CR 224 225 226 227 228 229 230 231 232 233 234 235 236 237 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalements + Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share 0 Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me ah Wrap Taxt v Number = = = - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 10 ~ A A SR X [G ) V Paste B 1 UvA A Insert Delete Format Sart Find & Select Filter Analyze Date V J17 + x A c F F G H 1 N P Q R s T U u v V w X Z AA Sales Unit Cart Quantity Wu Balance Quantity Unit Com Velus 500 2500 12.503.00 1 Use the chart to keep track of inuentory values 2 Purches Date 3 Quantity | Unit Cart 4 Jan 31 5 Feb 6 Feb 2 7 Feb 9 7 8 Feb 12 9 Feb 18 10 Feb 20 11 12 13 14 15 16 17 18 19 20 2: 22 23 24 25 26 27 28 23 30 32 33 34. 35 36 37 38 35 40 41 4 42 43 14 Case Introduction Transactions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Statements + Ready 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments ~ A ) V Delete V Format v Sart Filter V Analyze Date Find a Select T 5 T U V w X X Calibri (Bady) v 10 ah Wrap Text General SR LE Paste B 1 U Merge & Center $ % - Conditional Format Cell Insert Formatting as Table Styles A1 + x fx Your accountant goes through the mail and opens the bank statement for the month of February provided by Bank of Canada. It is shown below. A B D E F H 1 L M N o P 1 Your accountant goes through the mailand opens the bank satement for the month of Februaryp wie by Bans of 2 Cnnd shown 3 4 Bank of Care 5 Prepared for Tees RUS 6 Information Withdrawal De | Balance 7 Opening Balance 24,300.00 Feb1 Paid Ont3155 Tour 23.800.00 9 Feb Deport 11,000 35,100.00 10 Feb 1 Paid ISS 28.09.50 7.410.45 11 Feb 15 Paid that3157 9,127.00 2.116.GO 12 Feb 17 Deport 56200100 13 Feb 18 CE 42.000.00 14.063.40 14 Feb 19 Chor124) 3,390.00 10.693,43 15 Feb 25 Char359 3500 10.40 16 Feb 28 A te debian peyman 1076.00 9,267.40 17 Feb 28 Servloe Charge 24.00 9.233.42 18 Feb 8 interest 28 3451 9,579,401 19 20 20 21 54 55 56 Generelle ALI Cash GL NO: 101 58 Date Description PR JOR CR Balance IDR ORD 55 Opening Balance 35,500.00 OR GC Feb1 Paid O3154 8.3 660.0 34,940.00 DR 61 Feb 1 Paid that3155 500.00 14,140 00 OR 62 Feb 13 Paid Cheras 1.3 28.021.60 S350 40 OR G3 Feb 15 Paid On 13:57 6.3 9.127.00 2.776.50 CR 64 Feb 17 Received payment 55,200.00 55,123 10 OR 65 Feb 18 Peidintory Chai 4.3 42.000.00 13,423 40 OR GG Feb 20 Received payment 6.3 2,203.00 15,523.40 OR 67 Feb 25 Pety Cash Chart 53 10.00 16,2740 OR 68 Feb 28 Paid been 4.3 1,076.00 15,197.40 OR GS 20 73 72 Anal information 73 al The 511.300 is already resorded in the lederst month 74 LC mof it comery lustly fur 14). 75 26 Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Slalernens Ready 57 Account + 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments am V X LG LIX (O) Paste Insert Calibri (Bady) v 10 ~ A ah Wrap Text General B 1 U du Merge & Center A & $ %> 99 Cell Conditional Format Formatting as Table Styles fx Your accountant goes through the mail and opens the bank statement for the month of February provided by Bank of Canada. It is shown below. Y Delete Format v Sart Filter Find & Select Analyze Date V A1 + x B D E F G H 1 1 K L M N o P 5 1 U V X 72 Advanalinformation 73 al The $11.300 is already recorded in the led per last month 74 Chwn.mbur of the company is cnly for 14 tys. 75 76 77 Required: Prepare the February bank recorciation for Tees R Us using the bank statement and general ledger provided Compare the information in the general ledge to the bank statement. Once records, record the relevant omal entries in 78 the general omal and post the entries in the general ledger to bring the company's record up to date 79 80 82 83 84 OS 86 Tees RUS Bank Recondition Statement February , 2021 Balance per books 1519.40 Balance per Bank 4,521.40 87 88 89 90 91 Explanation 92 Halance 93 94 95 96 97 98 95 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 Case Introduclion Transaclions Gerieral Journal General Ledger Inventory Valuation Bank Reconciliation Worksheet Financial Salernens + Ready 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Data Review Share Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 View Tell me Wrap Text v General $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 ~ A A SR V (O) [G Paste B 1 A = = - Insert Y Delete Format Sart O Filter Find & Select Analyze Date V 047 1 x fx C A c E 1 M N P Q R S S T u u V w X 3 4 F G H ! TeRUN Worksheet February 28, 2021 Adjustments Adustrial Balance 5 Income Statement Balance Sheet Unedjusted Trial Balance DR CR DR CR DR CR DR OR DR OR 7 7 Account The 9 Cash 10 Pocoy Cash 11 Mocounts Asceivable 12 Mentunde wur 13 Prepaid insurance 14 Eguiment 15 Audi 16 Accounts Payak 17 Interest Payable 18 CP Payable 19 El Pack 20 Income Tax Payable 21 Salaris. Pelle 22 Ureamed Reveru 23 Dank loan 24 Carmen Sans 25 Reale fanings 26 Sales Revenue 27 Sales units 28 Sales Rents and Alware 29 Interest Revenue 30 then 3: Cost of Good Soda 32 Employee Benefits Experce 1litvil arth 33 34 Insurance Eparse 35 interest Expense 36 Office Supplies Esprit 37 Rent Expert 38 Salaries Expense 39 Hank theran 40 Martenance Esperde 41 Entertainment ne 42 Stine tense 43 Cash Over and short 44 Total 45 Nutram 46 Toat Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconcilialion Worksheet Financial Slalements + Ready w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Bady) v 11 ~ A A Wrap Text v General SR V LX () [G Paste B 1 I U A y = = = -- Insert $ % Merge & Center Y Delete Format Conditional Farmet Cell Formatting as Table Styles Sart Filter Find & Select Analyze Date K203 fx 1 . K M N N AB AC AE BG AH AJ Al AK AL 4 11 116 | A B C D G H 1 Tees RUS 3 dessed Balance Sheet 4 As atuary 31, 2021 5 Assets 6 Ch Sasha $26,870 Merchandise inwentary $12500 $ 9 Pendinsan S4400 10 Tecal Durrent Asses 69,370 11 Lore Tem Assets 12 pment 162000 13 Asma Depreciel S2000 110.000 11 Total Assets $179,370 15 16 Lab 17 Current Labits 19 Nemunts Payable $12000 19 Uhamed Revere $9.000 20 Salaries Payable 55.700 21 Current Porin of Tank Loan S11 160 22 Total Duren Las $37,360 23 Non Current bites 24 Non-Durrent Portion of lank loan 23:10 25 Total 561,700 26 27 Shareholders' Equity 28 Common Shares 81,000 2 Heaned tags 11020 30 Teal Shareholders' Equity 113,570 3: Total Liabilities & Equity $179,370 32 33 Required: Ubire the land of the Law Leonis sufft. 28cm the mental statement 34 35 36 37 38 35 40 11 42 43 14 Case Introduclion Transactions General Journal General Ledger Ready Inventory Valualion Bank Reconciliation Worksheel Financial Statements + w 100% AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Calibri (Bady) v 11 ~ Al A Wrap Text v General SB V LX (O) [G Paste B 1 Uy OYA = = = - - Insert $ % Merge & Center Y Delete Sart Format Conditional Format Cell Formatting as Table Styles V Filter Find a Select Analyze Date K203 fx E F G H 1 . 1 K M N N AB AC AF MG AH Al Al AK AL A B C D 43 50 11 Preparemustep inome statement 5: 52 Tees RUS 53 Income Statement 54 For the Month Finded February 28, 2001 55 Sales Revenue 56 Sales Bros 57 RSS 58 Cost of Goods Sok 58 Gross Pratt GO 60 Operates G: Employee Benefits Expere 62 Depreciation Cesene 63 Insur 64 orice Supplies Expen 65 Hent Cape 66 Salaries Expert 67 Bank Charges Eparse 68 Shoging typense 69 0.20 70 Tsal Operating Expenses 71 Other Income and expenses 72 Interest Expenie 73 Interest Ferenue 74 Tal other income and penses 75 76 Notincome 77 78 79 80 21 Prepares sabution of retained esmings 92 Calculation of Rendering 83 For the Month Ended February 28, 2021 84 Rwand Earni Benin 95 Add. Netico 86 Less thirds 87 Retained Earnings End 98 BS 90 92 92 Case Introduclion Transaclions General Journal General Ledger Inventory Valualion Bank Recoriciliation Worksheel Financial Statements + Ready 100% Share 0 Comments V LX () Y Delete Format Sart Filter Find & Select Analyze Date BG AH AJ Al AK AL AutoSave IF OFF A ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Bady) v 11 ~ Al A Wrap Text v General SR [G Paste B 1 Uy VA = = $ % Cell Insert Conditional Farmet Merge & Center Formatting as Table Styles K203 fx A B c D F G H 1 . K M N N AB AC AE 98 99 100 Pere desilinderslevmini Samamo pre will be identi berken for the 12 mechs 101 102 Tees RUS 103 Habang Sheet 104 As ut Fabruary 28, 2021 105 Assets 106 Current ASHLE 107 Cash 108 Penys 109 Asus Real 110 Merchandise inwentary 111 Prepaid insurance 112 Tel Durant ASSA 113 Lorg Tem Assets 114 Cruipment 115 Adulte Den 116 Total ASSES 117 118 Lilit 119 Current Labits 120 Accounts Payable 121 CI Payable 122 El Perak 123 Inerme Tax Payable 124 Salaries 125 Wroamed Reverus 126 Cument Portion of Tank loan 127 Total Darren Les 128 Non Ourent Lates 129 Non-Durrent Portion of bankinn 130 Talli 131 Share oders' Ecuty 132 Common Shares 133 Hetained in 124 Tegal & Slank ders' Equity 135 136 137 138 139 140 10 Case Introduclion Transaclions General Journal General Ledger Inventory Valuation Bank Reconciliation Worksheel Financial Statements Ready + 100% AutoSave IF OFF A Home Insert Draw Page Layout Formulas Share 0 Comments ACCT1100 Review Assignment Fall 2021 Student (Revised) v1 Data Review View Tell me Wrap Text v General = = = - - $ % Merge & Center Cell Conditional Format Formatting as Table Styles Calibri (Bady) v 11 VA A SB V LX m () [G WS Paste B 1 Insert OYA y Y Delete Farma: Sart Filter Find a Select Analyze Date K203 1 . K M N AP AC AD AF AG AH AL Al AK AL A B C c D E F G H 142 143 144 145 146 147 Based on the information aborc.answer the rolowing questions. , 148 149 Al Calculate the current ratio as atenuary 28,2021 150 151 152 153 154 billes Tees R Us have a good ortadtment rate bain why why mert or 155 156 157 158 159 160 161 162 Cute the inventorystys on hand to 25 February 24, 2021. Since this is for the morth const muliply by 365 in the 163 formadorsed ultet 9