Page 2 Below is the post-closing trial balance at June 30, 2022: Bright Landscapes, Inc. Post-Closing Trial Balance 6/30/2022 Debit Credit $14,285 $58,020 $2,150 Cash Accounts Receivable Allowance for Bad Debts Inventory Prepaid Insurance Office Supplies Land Property, Plant and Equipment Accumulated Depreciation Accounts Payable Interest Payable Notes Payable Common Stock Paid in Capital in Excess of Par Retained Earnings $41,000 $6,120 $645 $140,000 $275,000 $150,000 $21,070 $1,100 $80,000 $60,000 $152,500 $68,250 Totals $535,070 $535,070 Below is the Chart of Accounts for Bright Landscapes: Chart of Accounts Bright Landscapes Page 3 Acc No. Name Acc. No Name Assets: Liabilities and Equity: 101 Cash 210 Accounts Payable 110 Account Receivable 221 Interest Payable 111 Allowance for Bad Debts 245 Notes Payable 120 inventory 301 Common Stock 130 Prepaid Insurance 305 Paid in Capital in Excess of Par 131 Prepaid Rent 135 Office Supplies 330 Retained Earnings 150 Land 160 Property, Plant and Equipment Revenues: 170 Accumulated Depreciation 401 Sales Revenue 402 Sales Returns and Allowances Expenses: 403 Sales Discounts 501 Cost of Goods Sold 410 Interest Income 502 Purchase Discounts 503 Purchase Returns and Allow. 506 Advertising Expense 507 Wages Expense 511 Depreciation Expense 513 Bad Debt Expense 514 Utilities Expense 516 Insurance Expense 517 Rent Expense 518 Office Supplies Expense 519 Repair Expense 522 Interest Expense Below is other pertinent information about Bright Landscapes. Page 4 Accounts Receivable at June 30, 2022: Customer Date of Sale Amount Anderson's Rentals Bluegrass Property Elaine and Sons Grilled Steaks Jenkins and Sons Smith and Jones Watson Properties 9/21/2020 5/21/2022 6/23/2022 6/10/2022 4/9/2022 3/2/2022 6/28/2022 $2,850 $9,850 $14,100 $10,850 $7,495 $8,150 $4,725 Total $58,020 Accounts Payable at June 30, 2022: Vendor Invoice Date Amount Chesterfield Office Supplies Hi's Garden Shop Smithville Nurseries Johnson Company Carriage National Telephone 6/5/2022 6/23/2022 6/28/2022 5/28/2022 4/1/2022 5/25/2022 $825 $6,180 $4,275 $2,800 $1,150 $5,840 Total $21,070 Record the journal entries for the following transactions for the month of July, 2022 July 2 July 2 July 2 Sold 10,000 additional shares of common stock for $5.65 per share. Entered into a leasing agreement for office space for twelve months at $ 800 per month and paid the entire amount due. Purchased inventory on credit from Greenland Nurseries, $16,000, terms 2/10, n/30, invoice #1891. Paid $ 5,800 on the Note Payable, plus interest accrued at 6/30/02.1 July 5 July 5 Paid 850 for office supplies. July 10 July 10 July 15 Sold merchandise to various individuals of $ 14, 250. Paid for minor repairs to office furniture of_249. Sold merchandise on credit to Thompsonville Technological School $ 13,800, terms 2/10,n/30, invoice #1148. Received payment from Thompsonville Technological School for merchandise sold on July 15. Paid for inventory purchased from Greenland Nurseries on July 2. July 20 July 22 July 26 Paid for inventory purchased on credit from His Garden Shops Cash sales from the month of $_4, 675 July 31 Page 6 Information for Adjusting Entries: Note Payable at June 30, 2022: The payee is Quality Bank, with an original principal of $200,000, but the current amount owed at June 30, 2022 is $80,000. Interest is payable each six months at a 2.75% rate and interest has been accrued at June 30 of $1,100 for six months. Interest is charged on the unpaid balance of the note. Prepaid Insurance at June 30, 2022: Type Length Amount Truck Property Liability Worker's Compensation 1/1/2022 to 1/1/2022 9/01/2021 to 9/01/2022 8/1/2021 to 8/1/2022 4/1/2022 to 4/1/2023 $1,400 $1,200 $1,210 $2,310 $6,120 Property, Plant and Equipment at June 30, 2022: All property, plant and equipment is depreciated using the straight line method (with no estimated salvage value). Record the adjusting journal entries based on the following information: Adjusting Entries: 1. Record one month interest (for July) due to the bank for the note payable. 2. If applicable, expense one month of prepaid office rental space. 3. Expense one month of prepaid insurance. 4. The count of office supplies indicates $ 140 left in supplies inventory. of Accounts Receivable are considered 5. It is has been determined that a total of 3100 to be uncollectible. 6. The physical count of inventory of merchandise shows $ in merchandise inventory. 44350 still 7. Prepare the depreciation expense entry for the month of July assuming the Property, Plant, and Equipment is depreciated over 32 years. account Use the information shown below and the Bright Landscapes Practice Set Excel Workpapers in blackboard to complete Bright Landscapes' accounting cycle for the month of July, 2022, by 1. Recording the transactions (on page 5 of this packet) in the general journal (sheet 1 of excel) 2. Posting the above journal entries to the general ledger accounts (sheet 2 of excel; and totalling each 3. Preparing an unadjusted trial balance at July 31, 2020 on the worksheet (Sheet 3 of excel) by taking the totals from the general ledger accounts 4. Recording and posting the adjusting journal entries (information on page 7 of this packet) in the general journal (Sheet 1 of excel) and general ledger accounts (Sheet 2 of excel). 5. Completing Bright Landscapes' worksheet (Sheet 3 of excel), including an adjusted trial balance, income statement and balance sheet. 6. Preparing July 31, 2022, financial statements: a. Income Statement b. Statement of Retained Earnings C. Balance Sheet Students should first prepare the approximately 10 necessary journal entries (information on page 5 of this packet) for the month, post them and prepare the unadjusted trial balance before preparing the adjusting entries. You should use the adding mechanisms through excel to add and complete the worksheet, and the related financial statements An appropriate adjusting entry to record cost of goods sold is required. The perpetual inventory method is to be used, but inventory is not adjusted for each sale. It is only necessary to adjust inventory at the end of the month. (The entry at the end of the month would be a debit to cost of goods sold and a credit to inventory.) Submit the excel worksheets to blackboard by class time on Friday, October 29, 2021. This assignment is worth 60 points. This assignment is worth 10% of your total grade, so please do not procrastinate! Background: In March 2001, a group of individuals formed the Bright Landscapes Corporation. At the time of incorporation, Bright was given authorization to sell 100,000 shares of common stock with a 54 par value. As of June 30, 2022, 15,000 shares were issued and outstanding The goal of Bright Landscapes is to provide quality trees and shrubs, as well as law and garden tools, to its customers at low prices. To keep these low prices, Bright sells the landscapes materials but does not provide planting services. Although Bright has some over-the-counter cash sales of merchandise to individuals, its largest amount of business results from credits sales to contractors and businesses Bright has a calendar year end, however, a one month period of time will be used in this practice set with adjusting entries prepared at month end of July 31, 2022. Bright uses a perpetual inventory system, but will record the cost of items sold at the end of the month through an adjusting entry. Not all accounts will have transactions in the month of July
