Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need urgent help doing this assignment. Please see attachments. Thank you, Inna Bill's Lawn Care Module 2 Mini Practice Problem Bill has asked
Hello,
I need urgent help doing this assignment. Please see attachments.
Thank you,
Inna
Bill's Lawn Care Module 2 Mini Practice Problem Bill has asked you to prepare financial statements for his first month of operation. The following information relates to the month of May, 2014. (Round all calculations to the nearest whole dollar) 1. On May 2, Bill signed a 1 year, 6% note for $3,000 associated with the purchase of a used truck for the business. The interest will be due with the principle of the note. 2. On May 2, Bill purchased a used truck for $5,000 to use for the lawn care business. He estimates a trade-in value of $500 at the end of the estimated five-year life of the truck. 3. On May 5, Bill purchased a lawn mower for $300 and an aerator for $500. He estimates $0 salvage value for both pieces of equipment and an estimated two-year life for both. 4. On May 6, Bill writes a $600 check for a six month insurance policy that expires October 31, 2014. Instructions: 1. Using the chart of accounts provided, and the Excel template provided with this assignment, record the adjustments in the Worksheet, calculate the adjusted trial balance and complete the worksheet. 2. Prepare the Income Statement, Statement of Owner's Capital and Balance Sheet for Bill's Lawn Care for May, 2014 3. Prepare journal entries, in good form, to record the May adjusting entries. Explanations are optional. Start with Page 3 of the General Journal for the adjusting entries. 4. Post the journal entries to general ledger accounts. There are already transactions in the ledger for the month, you are adding to those transactions. 5. Prepare and post the closing entries for May, 2014. Start with Page 4 of the General Journal for the closing entries 6. Prepare a post-closing trial balance as of May 31, 2014, for Bill's Lawn Care. Classification ASSETS LIABILITIES OWNER'S EQUITY REVENUES EXPENSES Bill's Lawn Care Chart of Accounts Account Number Account Name 101 Cash 110 Accounts Receivable 120 Supplies 130 Prepaid Insurance 150 Equipment 155 Accumulated Depreciation - Equipment 201 Accounts Payable 220 Notes Payable 225 Interest Payable 301 Owner's Capital 305 310 401 620 630 640 650 660 670 680 Owner's Drawings Income Summary Lawn Service Revenue Supplies Expense Fuel Expense Repair and Maintenance Expense Advertising Expense Insurance Expense Depreciation Expense Interest Expense WORKSHEET Account Name Totals Net Income Totals Trial Balance FA17 Debit Credit - Adjustments Debit - - Adjusted Trial Balance Debit Credit Credit - - Income Statement Debit Credit - Balance Sheet Debit Credit - - - - - - - - INCOME STATEMENT FA17 OWNER'S EQUITY STATEMENT FA17 BALANCE SHEET FA17 GENERAL JOURNAL DATE DESCRIPTION Page POST. REF. DEBIT CREDIT FA17 GENERAL JOURNAL DATE 10/07/2017 DESCRIPTION Page POST. REF. DEBIT CREDIT 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 E30 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 10/07/2017 SP17 10/07/2017 GENERAL LEDGER ACCOUNT Cash DATE ACCOUNT NO. DESCRIPTION 2014 MAY 1 2 3 6 8 16 23 26 30 31 31 31 ACCOUNT J1 J1 J1 J1 J1 J1 J1 J2 J2 J2 J2 J2 DESCRIPTION 2014 MAY 16 23 30 31 DATE ACCOUNT DATE 2014 MAY 6 10/07/2017 BALANCE DEBIT CREDIT 15,000 2,000 800 600 50 500 700 50 800 500 150 1,000 Accounts Receivable DATE ACCOUNT POST REF. Debit 15,000 13,000 12,200 11,600 11,550 12,050 12,750 12,700 13,500 14,000 13,850 12,850 ACCOUNT NO. POST REF. J1 J1 J2 J2 BALANCE DEBIT CREDIT Debit 100 400 200 100 500 700 200 500 Supplies ACCOUNT NO. DESCRIPTION POST REF. BALANCE DEBIT CREDIT Prepaid Insurance DESCRIPTION Debit ACCOUNT NO. POST REF. J1 BALANCE DEBIT 600 CREDIT Debit 600 ACCOUNT DATE Equipment ACCOUNT NO. DESCRIPTION POST REF. 2014 MAY 2 3 ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE 2014 MAY 2 10/07/2017 J1 J1 BALANCE DEBIT CREDIT 5,000 800 5,000 5,800 Accumulated Depreciation - Equipment DESCRIPTION ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Accounts Payable DESCRIPTION Debit ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Notes Payable DESCRIPTION Debit Debit ACCOUNT NO. POST REF. J1 BALANCE DEBIT CREDIT 3,000 Debit ACCOUNT DATE ACCOUNT DATE Interest Payable DESCRIPTION DATE DESCRIPTION DATE 10/07/2017 BALANCE DEBIT CREDIT POST REF. BALANCE DEBIT CREDIT ACCOUNT NO. POST REF. J2 BALANCE DEBIT CREDIT 1,000 Debit 1,000 Income Summary DESCRIPTION Debit 15,000 Owner's Drawing DESCRIPTION Debit ACCOUNT NO. J1 2014 MAY 31 ACCOUNT POST REF. Owner's Capital 2014 MAY 1 ACCOUNT ACCOUNT NO. ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Debit ACCOUNT DATE Lawn Service Revenue DESCRIPTION 2014 MAY 16 23 30 ACCOUNT DATE ACCOUNT DATE DATE DATE 10/07/2017 BALANCE DEBIT CREDIT DESCRIPTION ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Fuel Expense DESCRIPTION BALANCE DEBIT CREDIT Debit 150 150 Repair and Maintenance Expense ACCOUNT NO. POST REF. BALANCE DEBIT J2 CREDIT Debit 50 50 Advertising Expense DESCRIPTION Debit ACCOUNT NO. POST REF. J2 DESCRIPTION Debit 600 1,100 1,000 Supplies Expense 2014 MAY 26 ACCOUNT POST REF. J1 J1 J2 2014 MAY 31 ACCOUNT ACCOUNT NO. ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Debit 2014 MAY 8 ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE 10/07/2017 J1 50 50 Insurance Expense DESCRIPTION ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Depreciation Expense DESCRIPTION ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Interest Expense DESCRIPTION Debit Debit ACCOUNT NO. POST REF. BALANCE DEBIT CREDIT Debit 101 Credit FA17 110 Credit 120 Credit 130 Credit 10/07/2017 150 Credit 155 Credit 201 Credit 220 Credit 3,000 10/07/2017 225 Credit 301 Credit 15,000 305 Credit 310 Credit 10/07/2017 401 Credit 600 1,700 2,700 620 Credit 630 Credit 640 Credit 650 Credit 10/07/2017 660 Credit 670 Credit 680 Credit 10/07/2017 POST CLOSING TRIAL BALANCE FA17 Debit $ 10/07/2017 Credit - $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started