Final class project to complete program. I have attached the project I am working on. I have completed part one and looking to complete part 2 and 3 please.

AC2799 Project PROJECT: FINANCIAL ANALYSIS Project Introduction: This project will be an ongoing, term-long project that will cover concepts related to balance sheets, journal entries, budgeting, problem solving, and the use of financial data to analyze and solve business problems. The business scenario and financial data that you will use for your project begins in Module 1 with submissions in Modules 3, 5, and 6. You will analyze the data for a fictitious company called Landscapes R Us (LRU) Inc. and come up with recommendations to improve its cash flow. Course Learning Objectives Covered: Resolve a substantial business problem by applying generally accepted accounting practices. Research the details of the project to build facts necessary to make good business decisions toward the problem solution. Analyze the data and recommend a specific approach to resolve the business problem. Recommend the solution and action items that must be addressed and implemented to resolve the business problem. Write a formal report with a problem statement, all data and sources of data, recommendations based on the business analysis, and conclusions for the business. 1 AC2799 Project PROJECT SUBMISSION PLAN Project Description/Requirements of Project Part Part Evaluation Criteria Project Assessment Preparation Checklist: The following criteria Part 1 To prepare for Project Part 1: will be considered for Revisit the assigned readings for Modules 1 through 3. assessing your Review the lessons for Modules 1, 2, and 3 that present performance: important points that you need to consider before submitting Project Part 1. correctly Title: Balance Sheet and Journal Entries arrange the Landscapes R Us is an S-Corp that specializes in Landscapes sales balance sheet and installation. There are three owners who are all equal in accounts for ownership. LRU utilizes a calendar year and accrual-based the given accounting. It originated and was incorporated in January of 2009. LRU carries some inventory of trees, bushes, and mulch and has some equipment as well. scenario? Did you arrange the journal entries Task 1: Correctly arrange the balance sheet accounts and under the complete the corresponding journal entries, in the balance sheet relevant template, using the data given below. headings? AccountsBalances as of 12/1/2013 CashChecking $38,886 Accounts Receivable $38,125 Have you taken all the entries into account for Accounts Receivable Office Supplies 12,500 PurchasesTree inventory $344,105 PurchasesBush inventory $199,250 PurchasesMulch inventory 2 Did you $96,600 the balance sheet and journal? AC2799 Project Project Description/Requirements of Project Part Part Evaluation Criteria Accounts Receivable Land $172,000 Building $235,000 Equipment 1 $4,000 Accumulated Depreciation $3,500 Equipment 1 2010 Equipment 2 $12,000 2009 Truck $24,000 Back Hoe $8,000 Trailer $4,000 Accumulated DepreciationTrailer $1,600 Accumulated DepreciationBack 0 Hoe Accumulated DepreciationTruck 0 Accumulated Depreciation $2,000 Equipment 2 Utility expense $8,900 Rent expense $27,500 Accounts Payable Note payable Long-Term Note payable Sales Tax payable Salestrees, bushes, mulch 0 $11,200 $6,200 $985,000 Installation revenue $38,000 Advertising expense $12,500 Accounts Payable Capital AccountJones 3 $173,914 AC2799 Project Project Description/Requirements of Project Part Part Evaluation Criteria Capital AccountSmith $173,914 Capital AccountClark $173,914 COGS 7% Sales tax expense $62,300 Wage expense $111,241 Office supplies $12,500 Insurance payable Insurance expense $3,800 Unearned installation revenue Fuel expense $174,750 Repair expenseBuilding Repair expenseEquipment $8,500 $10,750 Interest expense Phone expense $5,750 Bank Fee expense $3,810 Gain on the sale of equipment Loss on the sale of equipment Task 2: Refer to the data in the table and correctly create the journal entries in the journal entry template. Journal entries: 12/6 Sales of 10 trees for $1,400cash and carry Paid insurance bill for one-year policy, effective 12/7 for $1,200 will need the adjusting entry. 12/10 Received $4,000 for work to be done over approximately four months Sales of $10,000, $6,000 in cash, balance on account Sale on account of 12/6 pays $500 4 AC2799 Project Project Description/Requirements of Project Part Part 12/11 Paid the full amount due on AP of 12/8 Paid wages of $8,200, includes tax payment wages done by ADP Sales of 75 trees @ 250 each, 25 yards mulch @ $50 each, $20,000 paid in cash Purchase 1,500 yards of mulch for $30,000, on account 12/15 Sales of 11 bushes for $1,100, paid in cash Fuel expense of $1,300 Purchased office supplies for $125, on account 12/18 Sales of $9,000, $5,000 in cash, balance on account Paid for newspaper ad$800 Rented equipment$150 12/22 Sales of $14,000, $4,000 in cash, balance on account Paid for repair of truck$450 Installation revenue collected$2,500 12/23 Sales of $14,000, on account Purchased 1,000 bushes for $30,000, on account Paid fuel expense of $2,100 Paid phone bill of $200 Bank fees of $320 12/26 Sales of 10 yards of mulch for $500, paid in cash Paid $300 principle payment and $50 interest on long term note, due 12/31 Repaired the building front door$1,000 on account Sales of $29,000, on account 5 Evaluation Criteria AC2799 Project Project Description/Requirements of Project Part Part 12/27 Evaluation Criteria Paid wages of $7,450, includes tax payment wages done by ADP Paid November sales tax of $6,200 Installation revenue paid$2,500 Submission Requirements: Submit the updated balance sheet and journal entry templates to your instructor for evaluation. Due: Module 3 Grading Weight: 11.66% Project Assessment Preparation Checklist: The following criteria Part 2 To prepare for Project Part 2: will be considered for Revisit the assigned readings for Modules 4 through 5. assessing your In addition, revisit the lessons for Modules 4 through 5 performance: that present the important points that you need to Did you correctly consider before submitting Project Part 2. Title: Goods Sold, Depreciation, and Year-End Entries calculate the Task 1: Calculate the annual depreciation for the following assets depreciation for the entire lifespan of each asset. Each asset will have a for all the different method to utilize. In addition, complete the applicable assets? journal entries for each asset for tax year 2014 and submit using the journal entry template. Did you use the correct depreciation Year 3. Land: 58 acres valued at $172,000, inherited, currently in method for Building: Built in 2011started to use on 1/1/2012, basis each asset? $225,000, residual value $10,000, 30-year life uses straight-line depreciationcurrently in Year 3. 6 Did you complete all AC2799 Project Project Description/Requirements of Project Part Part Evaluation Criteria the value, five-year lifepurchased 10/1/2012, currently in adjustments Year 3. Equipment 2: Straight line cost $12,000, $2,000 residual and year end TruckSum of Years Digit: Cost $24,000, no residual entries? value, five years, purchased and started using on 1/1/2013currently Year 2. Back HoeUnits Of Production: Cost $8,000, no residual value, total use hours 10,000 or six years, used of 2,500 hours in 2013started using on 1/1/2013currently in Year 2. TrailerDouble Declining Balance: Cost $4,000, no residual value, five-year lifestarted to use 6/1/2012 currently in Year 3. Cost of Goods Sold: Calculate the cost of goods sold using LIFO for the trees, bushes, and mulch, independently using the following information. Use those cumulative amounts to calculate the gross income for 2014. 1. Trees: 2014 Annual sales of 6,430 units. Ending inventory is 1,825 units. Units Total Cost Beginning Inventory 3,895 45 $175,275 Purchase 1 2,910 43 $125,130 Purchase 2 950 46 $43,700 Purchase 3Dec 7 Unit Cost 500 40 $20,000 AC2799 Project Project Description/Requirements of Project Part Part 2. Bushes: 2013 Annual sales of 5175 units. Ending inventory is 1,350. Units Unit Cost Total Cost Beginning Inventory 1,575 40 $63,000 Purchase 1 2,750 35 $96,250 Purchase 2 1,000 40 $40,000 Purchase 3Dec 200 35 $7,000 Purchase 4Dec 1,000 30 $30,000 3. Mulch: 2013 Annual sales of 3,475 units. Ending inventory is 1,775. Units Unit Cost Total Cost Beginning Inventory 650 18 $11,700 Purchase 1 1,100 21 $23,100 Purchase 2 1,400 21 $29,400 Purchase 3 600 24 $14,400 Purchase 4Dec 1,500 20 $30,000 Task 2: Using the business scenario of LRU and the adjustment data provided below, complete the end-of-year adjusting and closing entries. Adjustments needed: 8 DepreciationEquipment 2 DepreciationTruck Evaluation Criteria AC2799 Project Project Description/Requirements of Project Part Part DepreciationBackhoe DepreciationTrailer Prepaid Insurance Unearned income 40% completed Wage expense due$3,200 Cash reserve Office supplies remaining$75 Calculate sales tax payabledue 1/28 Interest payable COGSTrees COGSBushes Evaluation Criteria COGSMulch Be sure to keep a copy of your completed journal entries, because you will use them in Project Part 3. Submission Requirements: Submit the updated journal entry template to your instructor for evaluation. Due: Module 5 Grading Weight: 11.66% Project Assessment Preparation Checklist: The following criteria Part 3 To prepare for Project Part 3: will be considered for Revisit the assigned readings for Modules 1 through 6. assessing your In addition, revisit the lessons for Modules 1 through 6 performance: that present the important points that you need to consider before submitting Project Part 3. 9 Did you correctly AC2799 Project Project Description/Requirements of Project Part Part Evaluation Criteria Title: Financial Analysis compile the Task: Use the resulting data from Project Part 1 and 2 to create Post-Closing the following: Balance Sheet Post-Closing Balance Sheet and Income Income Statement Statement? Ratio Analysis Annual Budget complete the Cash Analysis Ratio Analysis Did you based on the relevant data? You will use all of the data created in Project Parts 1 and 2, to create a Post-closing Balance Sheet and then to perform Ratio Have you created a Analysis for Landscapes R Us. workable You will also create a budget, based on your knowledge of budget for the Landscapes R Us financials and operations. Develop and submit company? an annual budget, using what you know about the company. Have you Landscapes R Us is cash poor, and must do a better job of completed the budgeting else the business will fail. Create a budget that will put cash analysis LRU in a better cash position. for the company, Finally, you will further analyze the Landscapes R Us cash taking into situation and write a narrative analysis, recommending potential account all solutions to remedy the cash balance situation. This should take cash flow the form of a technical report, documenting various cash components, strategies, the advantages and disadvantages of each, and a final in your recommendation to Landscapes R Us. recommendati ons? 10 AC2799 Project Project Description/Requirements of Project Part Part For your project, complete the following: A final balance sheet using the balance sheet template An income statement, using the income statement template A ratio analysis as an Excel worksheet A budget as an Excel worksheet An analysis of the Landscapes R Us cash situation as a Word file Submission Requirements: Submit the balance sheet, the income statement, the ratio analysis, and the budget as Excel worksheets. The analysis of the cash situation should be submitted as a Word document, with the following formatting: Font: Arial, 12 point Line spacing: Double Due: Module 6 Grading Weight: 11.66% 11 Evaluation Criteria