I Have a spreadsheet that needs to be filled in for balance sheet and a ledger. B&L Landscapes, Inc. Mini Practice Part 2 Bill Graham and Larry Miller incorporated B&L Landscapes, Inc. on July 1, 2016. The business consists of lawn care and sprinkler system installations. In addition, they also sell two types of fertilizer. Bill and Larry are concerned about ensuring a steady supply of high-quality PVC pipe for the sprinkler installations jobs they do and have come up with a plan to issue bonds to several of their family members. These funds will enable them to acquire a significant portion of the stock of a local PVC manufacturer. At the end of July, 2017, the company has the following adjusted trial balance: B&L Landscapes, Inc. Adjusted Trial Balance July 31, 2017 DEBIT CREDIT Cash $ 47,750 Accounts Receivable 11,500 Allowance for Doubtful Accounts 400 Prepaid Insurance 1,700 Inventory 79,000 Land 9,000 Building 35,000 Accumulated Depreciation - Building 1,750 Equipment 37,600 Accumulated Depreciation - Equipment 3,500 Accounts Payable 11,500 Notes Payable 45,000 Preferred Stock 7,000 Common Stock 35,100 Retained Earnings 117,300 Total $221,550 $221,550 Not included in the adjusted trial balance are the following transactions that occur on July 31, 2017. 1. B&L Landscapes, Inc. issued $50,000 worth of 5%, 10 year bonds at face value. 2. B&L Landscapes, Inc. purchased 30% of the outstanding common stock of Crestline Pipe, Inc. for $70,000 Instructions: 1. Using the chart of accounts provided below, and the Excel template provided with this assignment, prepare journal entries, in good form, to record the issuance of bonds and the investment transactions. Start with Page 3 of the General Journal. Explanations are optional. Round all journal entries to two decimal places. 2. Post the entries to the general ledger provided. You only need to create ledgers for the accounts in Part 1. Record any existing account balances as beginning balances using the values from the adjusted trial balance. 3. Prepare a classified balance sheet for B&L Landscapes, Inc. for July 31, 2017. 4. On December 15, 2017, Crestline Pipe, Inc. pays a $5,000 dividend. Prepare the journal entry, in good form, to record B&L's receipt of their share of the dividend. Record this on Page 4 of the General Journal. Explanations are optional. 5. Crestline Pipe, Inc. reports total net income of $21,500 for the year ending December 31, 2017. 6. Record the necessary adjusting journal entries for B&L Landscapes, Inc. investments and bonds on Page 5 of the General Journal. Explanations are optional.