{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T03:40:36-04:00", "answer_date": "2024-06-28 03:40:36", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4232646", "url": "\/study-help\/questions\/hi-i-need-help-for-my-homework-instructions-using-the-4232646", "question_creation_date_js": "2024-06-28T03:40:36-04:00", "question_creation_date": "Jun 28, 2024 03:40 AM", "meta_title": "[Solved] Hi I need help for my homework. Instructi | SolutionInn", "meta_description": "Answer of - Hi I need help for my homework. Instructions Using the instructions and information located in the Microsoft Word docu | SolutionInn", "meta_keywords": "help,homework,instructions,information,located,microsoft,word,document,named,m2mpp2,complete,required", "question_title_h1": "Hi I need help for my homework. Instructions Using the instructions and information located in the Microsoft Word document named M2MPP2, complete the required tasks", "question_title": "Hi I need help for my homework. Instructions Using the instructions and", "question_title_for_js_snippet": "Hi I need help for my homework Instructions Using the instructions and information located in the Microsoft Word document named M2MPP2, complete the required tasks in the Microsoft Excel template named M2MPP2 Name the completed file as ACC121 LastNameFirstInitial M2MPP2 Bill's Lawn Care Mini Practice Part 2 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,500 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 $7,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 below, 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 BILL'S LAWN CARE CHART OF ACCOUNTS ASSETS 101 Cash 110 Accounts Receivable 120 130 150 155 Supplies Prepaid Insurance Equipment Accumulated Depreciation Equipment LIABILITIES 201 Accounts Payable 220 Notes Payable 225 Interest Payable OWNER'S EQUITY 301 Owner's Capital 305 Owner's Drawings 310 Income Summary 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 WORKSHEET Account Name CASH ACCOUNTS RECEIVABLE SUPPLIES PREPAID INSURANCE EQUIPMENT ACCUMULATED DEPRECIATION EQUIPMENT ACCOUNTS PAYABLE NOTES PAYABLE INTEREST PAYABLE OWNER'S CAPITAL OWNER'S DRAWING LAWN SERVICE REVENUE SUPPLIES EXPENSE FUEL EXPENSE REPAIR AND MAINTENANCE EXPENSE ADVERTISING EXPENSE INSURANCE EXPENSE DEPRECIATION EXPENSE INTEREST EXPENSE INTEREST EXPENSE Totals Net Income Totals Trial Balance Debit Adjustments Credit 15,575 200 600 7,800 3,500 20,000 1,500 2,700 400 75 50 26,200 26,200 Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit INCOME STATEMENT OWNER'S EQUITY STATEMENT BALANCE SHEET GENERAL JOURNAL DATE DESCRIPTION GENERAL JOURNAL DATE DESCRIPTION Page POST REF DEBIT CREDIT Page POST REF DEBIT CREDIT GENERAL LEDGER ACCOUNT Cash DATE ACCOUNT NO DESCRIPTION 2014 MAY 1 2 3 6 8 16 23 26 30 31 31 31 ACCOUNT DESCRIPTION DESCRIPTION ACCOUNT DATE ACCOUNT DATE 2014 MAY 2 3,500 800 600 50 500 700 75 800 500 400 1,500 REF DEBIT CREDIT 20,000 16,500 15,700 15,100 15,050 15,550 16,250 16,175 16,975 17,475 17,075 15,575 110 BALANCE Debit 100 400 200 Credit 100 500 700 200 500 POST REF DEBIT CREDIT Prepaid Insurance DESCRIPTION 120 BALANCE Debit Credit ACCOUNT NO POST REF J1 DEBIT CREDIT 130 BALANCE Debit 600 Credit 600 Equipment ACCOUNT NO DESCRIPTION 2014 MAY 2 3 DATE 20,000 Credit ACCOUNT NO 2014 MAY 6 ACCOUNT Debit Supplies DATE DATE BALANCE CREDIT ACCOUNT NO POST J1 J1 J2 J2 DATE ACCOUNT DEBIT Accounts Receivable 2014 MAY 16 23 30 31 ACCOUNT REF J1 J1 J1 J1 J1 J1 J1 J2 J2 J2 J2 J2 DATE ACCOUNT POST 101 POST REF J1 J1 DEBIT CREDIT 7,000 800 REF DEBIT CREDIT 155 BALANCE Debit Credit ACCOUNT NO POST REF DEBIT CREDIT Notes Payable DESCRIPTION Credit ACCOUNT NO POST Accounts Payable DESCRIPTION Debit 7,000 7,800 Accumulated Depreciation Equipment DESCRIPTION 150 BALANCE 201 BALANCE Debit Credit ACCOUNT NO POST REF J1 DEBIT CREDIT 3,500 220 BALANCE Debit Credit 3,500 ACCOUNT Interest Payable DATE ACCOUNT DESCRIPTION DESCRIPTION 2014 MAY 1 DESCRIPTION DESCRIPTION DESCRIPTION DESCRIPTION 2014 MAY 26 BALANCE Debit Credit 301 BALANCE Debit Credit 20,000 20,000 ACCOUNT NO POST REF DEBIT CREDIT 1,500 305 BALANCE Debit Credit 1,500 ACCOUNT NO POST REF DEBIT CREDIT 310 BALANCE Debit Credit ACCOUNT NO POST REF DEBIT CREDIT 401 BALANCE Debit Credit 600 1,100 1,000 Supplies Expense 600 1,700 2,700 ACCOUNT NO POST REF DEBIT CREDIT Fuel Expense 620 BALANCE Debit Credit ACCOUNT NO DESCRIPTION 2014 MAY 31 DATE CREDIT J1 J1 J2 DATE ACCOUNT DEBIT Lawn Service Revenue 2014 MAY 16 23 30 DATE REF Income Summary DATE ACCOUNT CREDIT 225 ACCOUNT NO POST J2 DATE ACCOUNT DEBIT Owner's Drawing 2014 MAY 31 ACCOUNT REF J1 DATE ACCOUNT POST Owner's Capital DATE ACCOUNT ACCOUNT NO POST REF J2 DEBIT CREDIT BALANCE Debit 400 Credit 400 Repair and Maintenance Expense DESCRIPTION 630 ACCOUNT NO POST REF J2 DEBIT CREDIT 75 640 BALANCE Debit Credit 75 ACCOUNT DATE Advertising Expense DESCRIPTION 2014 MAY 8 ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE ACCOUNT NO POST REF DEBIT J1 CREDIT ACCOUNT NO POST REF DEBIT CREDIT 660 BALANCE Debit Credit ACCOUNT NO POST REF DEBIT CREDIT Interest Expense DESCRIPTION Credit 50 Depreciation Expense DESCRIPTION Debit 50 Insurance Expense DESCRIPTION 650 BALANCE 670 BALANCE Debit Credit ACCOUNT NO POST REF DEBIT CREDIT 680 BALANCE Debit Credit POST CLOSING TRIAL BALANCE Debit Credit Credit", "question_description": "

Hi<\/p>

I need help for my homework.<\/p>Instructions

  1. Using the instructions and information located in the Microsoft Word document named M2MPP2, complete the required tasks in the Microsoft Excel template named M2MPP2.<\/li>
  2. Name the completed file as:ACC121_LastNameFirstInitial_M2MPP2<\/strong><\/li> <\/ol>\"image Bill's Lawn Care Mini Practice Part 2 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,500 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 $7,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 below, 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. BILL'S LAWN CARE CHART OF ACCOUNTS ASSETS 101 Cash 110 Accounts Receivable 120 130 150 155 Supplies Prepaid Insurance Equipment Accumulated Depreciation - Equipment LIABILITIES 201 Accounts Payable 220 Notes Payable 225 Interest Payable OWNER'S EQUITY 301 Owner's Capital 305 Owner's Drawings 310 Income Summary 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 WORKSHEET Account Name CASH ACCOUNTS RECEIVABLE SUPPLIES PREPAID INSURANCE EQUIPMENT ACCUMULATED DEPRECIATION - EQUIPMENT ACCOUNTS PAYABLE NOTES PAYABLE INTEREST PAYABLE OWNER'S CAPITAL OWNER'S DRAWING LAWN SERVICE REVENUE SUPPLIES EXPENSE FUEL EXPENSE REPAIR AND MAINTENANCE EXPENSE ADVERTISING EXPENSE INSURANCE EXPENSE DEPRECIATION EXPENSE INTEREST EXPENSE INTEREST EXPENSE Totals Net Income Totals Trial Balance Debit Adjustments Credit 15,575 200 600 7,800 3,500 20,000 1,500 2,700 400 75 50 26,200 26,200 Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debit Credit INCOME STATEMENT OWNER'S EQUITY STATEMENT BALANCE SHEET GENERAL JOURNAL DATE DESCRIPTION GENERAL JOURNAL DATE DESCRIPTION Page POST. REF. DEBIT CREDIT Page POST. REF. DEBIT CREDIT GENERAL LEDGER ACCOUNT Cash DATE ACCOUNT NO. DESCRIPTION 2014 MAY 1 2 3 6 8 16 23 26 30 31 31 31 ACCOUNT DESCRIPTION DESCRIPTION ACCOUNT DATE ACCOUNT DATE 2014 MAY 2 3,500 800 600 50 500 700 75 800 500 400 1,500 REF. DEBIT CREDIT 20,000 16,500 15,700 15,100 15,050 15,550 16,250 16,175 16,975 17,475 17,075 15,575 110 BALANCE Debit 100 400 200 Credit 100 500 700 200 500 POST REF. DEBIT CREDIT Prepaid Insurance DESCRIPTION 120 BALANCE Debit Credit ACCOUNT NO. POST REF. J1 DEBIT CREDIT 130 BALANCE Debit 600 Credit 600 Equipment ACCOUNT NO. DESCRIPTION 2014 MAY 2 3 DATE 20,000 Credit ACCOUNT NO. 2014 MAY 6 ACCOUNT Debit Supplies DATE DATE BALANCE CREDIT ACCOUNT NO. POST J1 J1 J2 J2 DATE ACCOUNT DEBIT Accounts Receivable 2014 MAY 16 23 30 31 ACCOUNT REF. J1 J1 J1 J1 J1 J1 J1 J2 J2 J2 J2 J2 DATE ACCOUNT POST 101 POST REF. J1 J1 DEBIT CREDIT 7,000 800 REF. DEBIT CREDIT 155 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Notes Payable DESCRIPTION Credit ACCOUNT NO. POST Accounts Payable DESCRIPTION Debit 7,000 7,800 Accumulated Depreciation - Equipment DESCRIPTION 150 BALANCE 201 BALANCE Debit Credit ACCOUNT NO. POST REF. J1 DEBIT CREDIT 3,500 220 BALANCE Debit Credit 3,500 ACCOUNT Interest Payable DATE ACCOUNT DESCRIPTION DESCRIPTION 2014 MAY 1 DESCRIPTION DESCRIPTION DESCRIPTION DESCRIPTION 2014 MAY 26 BALANCE Debit Credit 301 BALANCE Debit Credit 20,000 20,000 ACCOUNT NO. POST REF. DEBIT CREDIT 1,500 305 BALANCE Debit Credit 1,500 ACCOUNT NO. POST REF. DEBIT CREDIT 310 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 401 BALANCE Debit Credit 600 1,100 1,000 Supplies Expense 600 1,700 2,700 ACCOUNT NO. POST REF. DEBIT CREDIT Fuel Expense 620 BALANCE Debit Credit ACCOUNT NO. DESCRIPTION 2014 MAY 31 DATE CREDIT J1 J1 J2 DATE ACCOUNT DEBIT Lawn Service Revenue 2014 MAY 16 23 30 DATE REF. Income Summary DATE ACCOUNT CREDIT 225 ACCOUNT NO. POST J2 DATE ACCOUNT DEBIT Owner's Drawing 2014 MAY 31 ACCOUNT REF. J1 DATE ACCOUNT POST Owner's Capital DATE ACCOUNT ACCOUNT NO. POST REF. J2 DEBIT CREDIT BALANCE Debit 400 Credit 400 Repair and Maintenance Expense DESCRIPTION 630 ACCOUNT NO. POST REF. J2 DEBIT CREDIT 75 640 BALANCE Debit Credit 75 ACCOUNT DATE Advertising Expense DESCRIPTION 2014 MAY 8 ACCOUNT DATE ACCOUNT DATE ACCOUNT DATE ACCOUNT NO. POST REF. DEBIT J1 CREDIT ACCOUNT NO. POST REF. DEBIT CREDIT 660 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT Interest Expense DESCRIPTION Credit 50 Depreciation Expense DESCRIPTION Debit 50 Insurance Expense DESCRIPTION 650 BALANCE 670 BALANCE Debit Credit ACCOUNT NO. POST REF. DEBIT CREDIT 680 BALANCE Debit Credit POST CLOSING TRIAL BALANCE Debit Credit Credit", "transcribed_text": "", "related_book": { "title": "Global Strategy", "isbn": "0357512367, 978-0357512364", "edition": "5th Edition", "authors": "Mike W. Peng", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/649592eaa157d_32303.jpg", "uri": "\/textbooks\/global-strategy-5th-edition-9780357512364", "see_more_uri": "" }, "free_related_book": { "isbn": "B0CNP3S5BC", "uri": "\/textbooks\/proven-strategies-to-successfully-wholesale-your-first-home-unlock-the-secrets-to-profitable-real-estate-wholesaling-and-achieve-your-first-home-sale-with-confidence-1st-edition-979-8868078163-256263", "name": "Proven Strategies To Successfully Wholesale Your First Home Unlock The Secrets To Profitable Real Estate Wholesaling And Achieve Your First Home Sale With Confidence", "edition": "1st Edition" }, "question_posted": "2024-06-28 03:40:36", "see_more_questions_link": "\/study-help\/questions\/business-economics-2023-September-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/given-that-z-is-a-standard-normal-random-variable-find-250261", "description": "Given that z is a standard normal random variable, find z for each situation. a. The area to the right of z is .01. b. The area to the right of z is .025. c. The area to the right of z is .05. d. The...", "stars": 3 }, { "url": "\/study-help\/introduction-to-probability-statistics\/633-sunday-shopping-when-nova-scotia-lifted-its-sunday-shopping-1983273", "description": "6.33 Sunday Shopping When Nova Scotia lifted its Sunday shopping ban, retail stores of all kinds could finally open on Sundays and other holidays, the only exception being Remembrance Day. Nova...", "stars": 3 }, { "url": "\/chiam-corporation-has-300000-of-12-bonds-callable-at-102", "description": "Chiam Corporation has $300,000 of 12% bonds, callable at 102, with a remaining 10-year term, and interest payable semiannually. The bonds are currently valued on the books at $290,000, and the...", "stars": 3 }, { "url": "\/study-help\/questions\/fickle-company-purchased-a-machine-at-a-total-cost-of-9840075", "description": "Fickle Company purchased a machine at a total cost of Multiple Choice A. The cumulative effect of the change. B. Justification that the change is preferable. C. The effect of a change on any...", "stars": 3 }, { "url": "\/study-help\/questions\/why-is-some-trade-credit-called-free-while-other-credit-3446929", "description": "Why is some trade credit called free while other credit is called costly? If a firm buys on terms of 2\/10, net 30, pays at the end of the 30th day, and typically shows $300,000 of accounts payable on...", "stars": 3 }, { "url": "\/study-help\/questions\/you-are-required-to-present-a-scenario-that-happened-at-1004971", "description": "You are required to present a scenario that happened at an organizationof your choosing and illustrate how individual employee characteristics, such as personality and attitudes, motivational...", "stars": 3 }, { "url": "\/study-help\/questions\/how-covid19-impacted-and-changed-the-supply-chain-of-transportation-1002528", "description": "How COVID-19 impacted and changed the supply chain of transportation?", "stars": 3 }, { "url": "\/study-help\/questions\/jennifer-davis-is-the-bookkeeper-for-pharoah-company-inc-jennifer-1002672", "description": "Jennifer Davis is the bookkeeper for Pharoah Company, Inc. Jennifer has been trying to get the company's balance sheet to balance. She finally got it to balance, but she still isn't sure that it is...", "stars": 3 }, { "url": "\/study-help\/questions\/uber-took-the-lead-in-pointtopoint-ondemand-transportation-literally-changing-1005497", "description": "Uber took the lead in point-to-point, on-demand transportation, literally changing the way we move. It competes not by building its own fleet but by leveraging peer-to-peer coordination between...", "stars": 3 }, { "url": "\/study-help\/questions\/these-hot-topics-will-introduce-you-to-current-events-in-1005563", "description": "These HOT Topics will introduce you to current events in the industry. This is your chance to brainstorm ideas with your classmates and discuss things that are happening right now! Look at this...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/is-xbrl-the-accepted-financial-reporting-language-around-the-world-4232645", "next": "\/study-help\/questions\/this-project-should-be-completed-using-excel-with-formulas-and-4232647" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Hi I need help for my homework. Instructions Using the instructions and", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/hi-i-need-help-for-my-homework-instructions-using-the-4232646" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } } }