Window Help Format Tools Data Excel Espina Minels-ACP File Edit View insert BU Insert Page Layout Data Formulas Review View Home Draw W Text Mere Dentet F5 Spring Summer 2021. Mac Accounting Cycle Project Solid Footing 130 First Name: MI Last Name: ES ID Code: 07 Project is Activated Save your project by following these directions >SAVING YO Save your proj the forme Last with the file rar As you work on your project, be sure to save your file often Instructions: You will be recording the July 2021 transactions for Lenny's Lawn Service, Inc. After recording the July transactions you will be preparing a Pre-Closing Trial Balance, Income Statement Statement of Stockholders' Equity, Balance Sheet, and Post-Closing Trial Balance Excel for Me Click File - Click Save In Save As Format mu - Before click on your Ma Click Save You are given the following: July 2021 transactions and Additional Information - Trans tan Chart of Accounts with Account Numbers and Account Names - Chart Aucts tab General Journal pages - Journal tab General Ledger - GL Assets, GL Lieb-Equity, GL Rev.Exp tabs Forms for the July 31, 2021: Pre-Closing Trial Balance (Trial Bal tab), Income Statement and Calculation of Retained Eamings (IS & RE tab). Balance Sheet (Balsht tab), and Post-Closing Trial Balance (Post Close TB tab) To Complete Your Workbook do the following: Print the July Transactions (click the Trans tab and then click the Printer Icon) Directions Chart Aceti Journal GL Assets Ready GL Liab-Equity GL Rev.eu sty Espinal Mineis-ACP Excel File Edit View insert Format Tools Data Window Help ABU insert Draw Page Layout Formulas Data Review View Mb Como ca FinStyle July 2021 Transactions Date Description of the Transaction July 1 Borrow $35.000.00 from 1st Bank by signing a 24 monthnote Infowto and post end Der and posta en la July 1 Receve $62.00000 cash from new investors, and is $82,000.00 of Common Stock to them July 1 Puchas $41,400.00 now mowing equipment, paying canh to the mower dealer July 1 Pay 5500,00 cash for the July truck July 3 Invoice a new customer 4.800.00 for a completed mowing customer wil poy in to days July 5 The Board of Directors declares a cash dividend. The total amount of the dividend is $25,000.00 The Date of Record to set as by 15. The Date of Payment is sy 31 July 7 Pay the employees $5.800.00 for work performed during the town of July July 10 Complete a mowing job for a new customer customer pays $4,200.00 cash for the job. July 12 Collect $3.000 cash from the golf course for special rush mowing is completed on May 31 July 14 pay the employees $7000.00 for work performed during the 2nd week of July July 15 Purchase $1.000.00 of suppies from the mower date the supplies are consumed mediately Lenty's will pay the mower dealer for the supplies in about 2 weeks July 15 Collect $4,000.00 on account. The cash that is received is from the new customer for the job that was completed on July 3 July 17 One of the original mowers purchased in Jawy of 2020 broke down and is repaired by the mower dealer. The cost of the Mower Repairs $450.00 Lenny wil pay the mower dealer in 30 days July 19 Purchase for cash $22.750.00 of supplies. These supplies will be consumed over the next 12 months July 20 Colect $30.000 from the property management company for work perfomed in June CA Journal AGL Libiquity OL RevExp EDU IS & SE stv Excel File Edit View Insert Format Tools Data Window Help ABG ne Insert Draw Page Layout Formules Data Review View Espina Mineis-ACP We Conditional Format H July 21 Pay the employees $7100.00 for work performed during the week of July July 21 Receive a $19,500.00 advance payment from the University. The advance payment is for months of work which will be performed from August 1.2021 to Jawy 31 2022 July 25 Complete specie mowing job for the golf course. The low price for the mowing job is $5,500.00 The golf course pays $500,00 cash this date and will pay the remainder on August 25 July 27 Complete a mowing job for a new customer-customer pays $3,000.00 cash for the July 27 Pay 51.020.00 cash to the mower dealer for the supplies purchased on account on My 15 July 28 Pay the employees 55,100.00 for work performed aning the 4th week of July July 31 Invoice the property management company $18,500.00 for July mowing work. The property management company will pay the invoice on the 20th of next month July 31 Pay the cash dividend which was declared on July 5 Additional Information Equipment The 548,000.00 beginning balance in the Equipment account relates to the mowing equipment which was purchased on January 2, 2020, For information related to this mowing equipment 300 Page 70 in the Solid Footing text (PDF 07 - Intro to Adjusting Entries) This equipment continues to be used and should be depreciated for the month of July The following information relates to the new equipment which was purchased on Juy 1.2021 - The new equipment was placed into service on July 1 2021 and should be depreciated for the month of July The estimated useful le of the new equipment is 5 year - At the end of 5 years, the new gipment will have no future value and will be scrapped The newesent will be depreciated using the straight-line method Supplies At the end of July there are 524,300.00 supplies on-hand Mowing Service at the University: The monthly mowing service was provided to the university or the contract signed on April 1, 2021 Dino Chan At Journal GEL-Equity GL Rev. Triala 15 dy &ty D Espinal Mines ACP Excel Fio Edit View Insert Format Tools Date Window Pelp @ GU Home Insert Draw Page Layout Formats Data Review View Additional Information Equipment The 18.00000 beginning balance in the Equipment accountries to the mowing ement which was purchased on January 2, 2020 Forintonation related to this mowing equipment Be Page 10 in the Sold Footing (PDF 07 - Intro to Austing Entries This montones to be med and should be depreciated for the month of July The folosing Womation relates to the new equipment which was purchased on Jy 1, 2001 - The new placed into service on July 1, 2021 and should be deputed for the month of July - The estimated use of the new equipment is 5 years - At the end of 5 years, the new equipment will have no Mature Value and will be scrapped The went will be deprecated in the right dine method Supplies Mowing Service M the University The money mowing service we provided to the university per the contracted on April 1, 2021 For information on the contact with the university and the related worce payment. 160 Pages 95 and in the Sous Footing for POF Austingen Continued Wages Due the Employees : The last we payment was made to the employees on July 20, 2021. The employees worked on Jay 28 and 1. For those days of work they cared 3.200.00 of wages These tedy of wages wit be paid to the workers during the first week of August Bank Loan The interest on the loan from tot Bank will be paid every shoe months. The first payment to the bank will be made on September 30, 2021. Lennys the bank on July 31 and the Dark indicates the forest on the loan for July is $10.00 Chat Journal GL Aasta GEL-Equity LRE T. IS & SEQUE otv Espinalines ACP Excel File Edit View Insert Format Tools Data Window Held oo Home insert Draw Page Layout Formules Data Review View Cult Pate Lenny's Lawn Service, Inc. - Chart of Accounts Account Account Name Assets 100 Cash 105 Accounts Receivable 110 Supplies 150 Equipment 155 Accumulated Depreciation Liabilities: 200 Accounts Payable 205 Wages Payable 210 Interest Payable 215 Uneamed Revenue 220 Dividends Payable 250 Note Payable Equity 300 Common Stock 305 Retained Earnings Revenues 400 Service Revenue Expenses 500 Supplies Expanse Mower Repar Expense 510 Wages Expense 515 Truck Rental Expense 520 Depreciation Expono Interest Expense Chart Journal GLAS a GL Lieb-Equity GL. R-Exp Tralal tv Espinal Mine S-ACP Excel file Edit View Insert Format Tools Data Window Help ARE Home Insert Draw Page Layout Formulas Data Review View AAF CF A Marge Care 010 XVF P#1 Acco Peste Credit 2021 Whey 7.1 Debit 35,000.00 100 250 Account Name Cash Notes Payable Borrowed on Note Payable X X 35,000.00 Direction Chart noch GL Assels OL Lab Equy O Rev.Exp Trial al tv w Excel File Edit View insert Format Tools Data Window Help 5 Home Insert Draw Page Layout Formulas Data Review View Espinal Mineis-ACP M SO Condton Normal matting xfx UNESY ESPINAL Lenny's Lawn Service, Inc. General Ledger GAUTION Enter amounts to the accounts by typing in the amount Do NOT copy cells from the General Journal into the accounts ACCORE 100 Cash Journal Page Credit 2021 Money 7-1 Beginning Balance 7-1 Debit 38,250.000 35,000.00 Balance 38,250.00 Dr 73,250.00 DE 1 Account 105 Accounts Receivable Chalets Director Journal GLA GL Lisb-liquity OL Reap S&s Excel File Edit View Insert Format Tools Data Window Help AB5- Insert Draw Page Layout Formulas Data Review Espina Minels ACP View MC x x Account # 105 Accounts Receivable 2021 Jual Pa Debit Credit Balance 33,500.00 7-1 Beginning Balance 33,500.00 Account # 110 Supplies Debut Credit 2021 Oy 741 Balance 4,375,00 DE Beginning Balance 4.375,00 Account # 150 Equipment Journal Credit 2021 Moh-Day 7.1 Debit 48,000.00 Balance 48,000.00 DE Beginning Ball TIN Diction Chart Acets Jun A LA GL Lab Equity GL RED ATB IS & SE gtv w 3 5 6 7 View insert Format Tools Data Window Help Excel Fle Edit B6 Home Insert Draw Espina Minels-ACP Page Layout Formulas DATA Review View puste S1 Con Formatting CHI of Account # 150 Equipment 2021 Morthy 7.1 Journal Papa Credit Debit 48,000.00 Balance 48.000.000 Beginning Balance Account 155 Accumulated Depreciation 2021 Journal Page Debit Credit 18,000.00 Balance 18,000.00 7-1 Beginning Balance Chat Act . al Art GL Liab-quy GL Rev.Exp Trial Bal w le 3 5 ExcelFile Edit View insert Format Tools Data Window Help BU Home Insert Draw Page Layout Formulas Data Review View O Espina Mineis-ACP NO 3. Com Cormatting C10 Account # 200 Accounts Payable ving in the amounts Do NOT oy con from the General Journal into the accounts 2021 Journal Pa Debit Balance Credit 0.00 7. Beginning Balance 0.00 Account 205 Wages Payable 2021 Money 7-1 Journal Page 1 Debit Credit 0.00 Beginning Balance Balance 0.00 Account # 210 Interest Payable 2021 Journal Debit Credit 7-1 Balance 0.00 CP Beginning Balance Account 215 Unearned Revenue 2021 Juma May Debit Credit Balance Direction Clutch Journal GLA GLR.Exp tv Format Tools Data Window Help Excel File Edit View insert BU Home Insert Draw Page Layout Espinal Minels-ACP Formulas Data Review View w Pate BT Coro > Fanning 10 xfx Account # 215 Unearned Revenue Debit 2021 North Day 7-1 Pape Credit 8,000.00 Balance 8,000.00 Beginning Bilance Account # 220 Dividends Payable Jou Debit Credit 2021 More Day 7.1 Balance 0.00 CE Beginning Balance 0.00 Account 250 Note Payable 2021 Debit Pa 741 741 Beginning Balance Credit 0.00 35,000.00 Balance 0.000 35.000.00 1 Arcane Chan Achs Jown GL Assets A OGL How Exp Trial al Stv W 3 Excel Tie Edit View insert Format Tools Data Window Help @ 5.0 Home Insert Draw Page Layout Formulas Data Review View Espina Mineis-ACP WT Pre - CIO 7.1 7.1 Beginning Balance 0.00 35,000.00 0.00 35,000.00 1 Account # 300 Common Stock Debit Credit 2020 Ver 7-1 Beginning Balance Balance 50,000.00 50,000.00 Account 305 Retained Eamings 2021 MasDay 741 JU Page Debit Beginning Balance Credit 48,125.00 Balance 48,125,00 Gr Jo GL Assets GL Esp TB Heady sty w 3 Format Tools bata Window Help Excel File Edit View Insert 000 ABU Home Insert Draw Page Layout Espinal Mineis-ACP Formulas Data Review View WT Merge For co fx SY ESPIRAL Lenny's Lawn Service, Inc. General Ledger Account 400 Service Revenue CAUTION Enter amounts to the typing in the amounts Do NOT copy olis from the Ger Journal the accounts 2021 Mathay 7-1 Journal Page Debit Balance Credit 0.00 Beginning Balance 0.00 Account 500 Supplies Expense Joma Debit 2021 Many 7-1 Credit Beginning Balance Balance 0.00 DE 0.00 Ghart Act Journal OLA OL Lab Equy Trial Ready . Atv A @w Espinal Mine s-ACP Excel Fe Edit View Insert Format Tools Data Window Help ABU Home Insert Draw Page Layout Formulas Data Review View A wat 1 Canon 10 Account 505 Mower Repair Expense Jamal Debit Credit 2021 Mathay 7.1 Beginning Balance Balance 0.00 0.00 Account # 510 Wages Expense 2021 Debit Credit Balance 0.00 DE 741 Beginning Balance 0.00 Account 515 Truck Rental Expense Debit 2021 Month Day 7-1 Credit Balance 0.000 Beginning Balance 0.001 Chant Journal OLA OL Lab Equity GL. Trial al & Sety P 5 Excel file Edit View insert Format Tools Data Window Help BBU Home Insert Draw Page Layout Formulas Data Review View Espina Mineis-ACP wa Com Pain CEO Abcount # 515 Truck Rental Expense Joma Debit Credit My 7-1 Balance 0.00 DY Beginning Balance 0.001 Account # 520 Depreciation Expense Debit Credit 2021 Way Begiving Balance Pod Balance 0.00 D 0.00 Acoount * 550 Interest Expense 2021 Debt Credit Balance 7-1 Beginning Bang 0.00 0.00 DI Chart Acuts JO OLA OLLEY TI IS A SEquit stv X 2 3 5 6 8 Excel File Edit View Insert Format Tools Osta Window Help ABU Home Draw Page Layout Formulas Date Review View Espinalines ACP Pute E6 SYESHA Lenny's July 31, 2021 Pre-Closing Trial Balance Credit SAWILON Enter amount o Pre-Closing The Blanca ty typing in the amounts Do NOT copy oils from the General Ledge Account 900 105 110 150 105 200 205 210 215 220 250 300 306 200 500 506 510 515 520 550 Account Name Cash Accounts Receivate Suci Equipment Accumulated Depreciation Accounts Payable Wees Payable Interest Pay Und Raven Dividends Payable Nolewable Common Stock HE Service Revenue Supplies Expense Mower Rapor Expo Won Expo Truck Rent Expense Depreciation Expense Herest Expres Totals 0.00 0.00 Journal GL Assets GL Lieb-Euty L. Rev.p New otv 3 5 6 8 Excel Edwirt Format Tools Date Window Halo .. Insert Draw Page Layout Formus D kevin View a Espinele AC H TER Lenny's Lawn Service, Inc. Income Statement for the Month Ende July 2021 GAUTION Enormount the ancient by your intents Do NOT code from the war of Polourg Trance Serwca Opening Supe Maa Tapas | Wago Tartal Depreciation Total Expo Income Option Interest Expert come Nowowinnon Lenny's income Statement Incene from Orion This is from the operations of the own mowing Interest Expense, which of the basta con financing the users shown below Income from periodu from income from Operation to test Income 0.00 $0.00 Lenny's Lawn Service, Inc Statement of StockholdenEquity for the Month Ended July 31, 2021 form This time you are prepared formal Statement of Stockholdere Equity for Lary. This statement on what cand the core in common stock in the Homay 1, 2021 2021. Note that the Rostained Earings Column the northe diri one to you Neve te dich aradan incertended for an Short Beginning Balance starting mountetang to you and Gas tre storing reguleren the storing point for woon becas Dividendes show linee and in com The Enting Balance in the Rained consthe balance this Coro Bloch Lang 6.00 Being Boy 1.2001 Con stock Net income Dide Ending Buy 3.2001 0.00 BODO 300 Rom G-Bap 5 6 W E Excel e Edt View insert Format Tools Data Window Help U. Home Inser Draw Page Layout Formus Date View Despins-ACP DO . LALO El amount they on the mount Do Marcos From the General Color Pre-Cosing a Bano Lenny's Lawn Service, Inc. Balance Sheet as of July 31, 2021 Asath) Current Cash Account cei Supplies Total Durres Property Eupent Accumulated Dupletion Prouty & Coment, no Total hasta 0.00 9.00 $0.00 Note the wagon Marat Total Current Assets is a total of 1000 which will cash ang tinations De consumed during the 2 The com of Totalmente to Town Lestone deacon Londy that by to pay be in the honom Property & Event, the mounted Ascow to becedine wong periode Total Currents whose wat will require payment in the 12 monIn the comment my wife by cyng mowy Liebe SchEquity Accounts Pays Wagos Payable Interest Payable Land Rover Town Lone Note Patie Tori 0.00 Common block Retained in Total Stockholm Equy Totalbis & Stockholders' Equity 0.00 GILA GL Cap P 2 3 5 E R Tools Duta Windows Help Excel Edt View Insert Form AU Home mer Draw Page Layout Form ACP Data most count Accumud Prouty & which will changes Den unge The corn of Total Tour Lisbon - ty to pay Property & Events out of water Total Asset 30.00 & Steck To Cumbia best west 12 thered www more to the 0.00 ACP We Payable Interest Payable TOEN Lorem No Payable Total SE Common Stock Radaming Tom Soldes Total Labs & Stockholders' Equity 0.00 0.00 500 GLAGELE 0 Excel File ViewInsert Format Tools Data Window Help A. U Insert Draw Page Layout Formules Data Review View Espina Mini-ACP Hoe Pa F 16 XFx MESYEN Lenny's - July 31, 2021 Post-Closing Trial Balance Debit Creo CAUTION Enter Tours into the Pos Closing Trial Bounce by typing in the amounts Do NOT copycals from the General Ledger Account 100 105 190 150 555 200 205 210 215 220 250 300 305 400 500 505 510 515 520 550 Account Name Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Accounts Payable Wazo Payable Ost Payable Unawed Revenue Dividends Payable Note Payable Common Stock Retained Emings Service Revenue Supplies Expense Mower Real Expense Wages Expense Truck Rental Expense Depreciation Expono Interest Expense Totals 0.00 0.00 Jou BOLA GE Lieb-Equily OLREnp & stv w