Hi I need help to solve my homework in accounting.

Instructions

1. Using the instructions and information located in the Microsoft Word document named M1MPP1, complete the required tasks in the Microsoft Excel template named M1MPP1.
2. Name the completed file as:ACC121_LastNameFirstInitial_M1MPP1

Bill's Lawn Care Mini Practice Part 1 Bill Graham started his career mowing lawns for neighbors while he was in junior high school. Bill worked summers for the local golf course while he was in high school and now that he has graduated, he is starting his own lawn care business. You are taking an accounting class at the local community college and have agreed to help Bill set up and maintain the accounting records for his new business. He has set up a checking account in the business name, Bill's Lawn Care, at the local bank. After some discussion with you, Bill has decided to set the business up as a sole proprietorship. You and Bill established a chart of accounts to be used in recording the business transactions. In May, 2014, the following activities occur at Bill's Lawn Care. May 1 Bill withdraws $20,000 from his savings account and deposits it in the business' bank account. 2 Bill purchases a used truck for $7,000 to use for the lawn care business, he writes a check for $3,500 and signs a 1 year, 6% note for the balance. 5 Bill purchases a lawn mower for $300 and an aerator for $500 and writes a check for the total amount. 6 Bill writes a $600 check for a six month insurance policy that expires October 31, 2014 7 Bill establishes a $1,000 line of credit account with Jones Fuel, a local gas station. 8 Bill writes a check for $50 for a weekly advertisement in the local newspaper. The advertisement will run every Friday through the end of May, 2014. 16 At the end of the first week, Bill has earned $600 for lawn care services. Of the $600, $500 was paid in cash and $100 was on credit. 23 At the end of the second week, Bill has earned $1,100 for lawn care services. Of the $1,100, $700 was paid in cash and $400 was on credit. 26 Bill writes a check for $75 to have the mower blade sharpened. 30 At the end of the third week, Bill has earned $1,000 for lawn care services. Of the $1,000, $800 was paid in cash and $200 was on credit. 31 Bill receives payments, on account, in the amount of $500 31 Bill receives his monthly invoice and writes a check for $400 to Jones Fuel. 31 Bill writes a check to himself for $1,500 for personal expenses. 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 May transactions. Explanations are optional. 2. Post the journal entries to general ledger accounts. 3. Prepare a trial balance as of May 31, 2014, for Bill's Lawn Care. BILL'S LAWN CARE CHART OF ACCOUNTS ASSETS 101 Cash 110 Accounts Receivable 120 Supplies 130 Prepaid Insurance 150 Equipment 155 Accumulated Depreciation - Equipment LIABILITIES 201 Accounts Payable 220 Notes Payable 225 Interest Payable OWNER'S EQUITY 301 Owner's Capital 305 Owner's Drawings REVENUES 401 Lawn Service Revenue EXPENSES 620 Supplies Expense 630 Fuel Expense 640 Repair and Maintenance Expense 650 Advertising Expense 660 Insurance Expense 670 Depreciation Expense 680 Interest Expense GENERAL JOURNAL DATE DESCRIPTION Page POST. REF. DEBIT BILL LAWN CARE 'S CREDIT CHART OF ACCOUNTS ASSETS OWNER'S EQUITY 101 Cash 301 Owner's Capital 110 Accounts Receivable 305 Owner's Drawings 120 Supplies 130 Prepaid Insurance 150 Equipment REVENUES 401 Lawn Service Revenue 155 Accumulated Depreciation - Equipment LIABILITIES EXPENSES 201 Accounts Payable 620 Supplies Expense 220 Notes Payable 630 Fuel Expense 225 Interest Payable 640 Repair and Maintenance Expense 650 Advertising Expense 660 Insurance Expense 670 Depreciation Expense 680 Interest Expense GENERAL JOURNAL DATE DESCRIPTION Page POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT Cash DATE Credit ACCOUNT DESCRIPTION DESCRIPTION DATE ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE DEBIT CREDIT 101 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 110 BALANCE Debit Credit ACCOUNT NO. DESCRIPTION POST REF. DEBIT CREDIT Prepaid Insurance DATE ACCOUNT REF. Supplies DATE ACCOUNT POST Accounts Receivable DATE ACCOUNT ACCOUNT NO. DESCRIPTION 120 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Equipment 130 BALANCE Debit Credit ACCOUNT NO. DESCRIPTION POST REF. DEBIT CREDIT Accumulated Depreciation - Equipment DESCRIPTION REF. DEBIT CREDIT Credit 155 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Notes Payable DESCRIPTION Debit ACCOUNT NO. POST Accounts Payable DESCRIPTION 150 BALANCE 201 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 220 BALANCE Debit Credit ACCOUNT Interest Payable DATE ACCOUNT DESCRIPTION DESCRIPTION DESCRIPTION DESCRIPTION DATE ACCOUNT DATE ACCOUNT DATE CREDIT DESCRIPTION 225 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 301 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 305 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Supplies Expense DATE ACCOUNT DEBIT Lawn Service Revenue DATE ACCOUNT REF. Owner's Drawing DATE ACCOUNT POST Owner's Capital DATE ACCOUNT ACCOUNT NO. 401 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Fuel Expense 620 BALANCE Debit Credit ACCOUNT NO. DESCRIPTION POST REF. DEBIT CREDIT Repair and Maintenance Expense DESCRIPTION Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Advertising Expense DESCRIPTION 630 BALANCE 640 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 650 BALANCE Debit Credit ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE 2014 Insurance Expense DESCRIPTION ACCOUNT NO. POST REF. DEBIT CREDIT Depreciation Expense DESCRIPTION Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Interest Expense DESCRIPTION 660 BALANCE 670 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 680 BALANCE Debit Credit BILL'S LAWNCARE SERVICE TRIAL BALANCE May 31, 2014 Debit Credit Credit