assets Overview Now that you've had an opportunity to practice preparing financials for a small start-up company in the first project, you will have an opportunity to take the same skill set and apply it to a large-scale company for this second project. No matter the size of the company, adherence to accounting principles and methods is top priority. As a future accountant, you must remember the foundational practices of accounting when working with clients no matter their stature. This is why, again, in this project, you will need to show your calculations as well as provide rationale for your application of methods and principles. As with any financial records, accuracy is key. It is imperative to keep accurate and complete records. You will have the opportunity to correct any errors in the Project Two Milestone Journal Entries tab. Scenario You are a professional accountant who is working with an established construction company, Lou's Crew, to prepare its financial statements for the current fiscal year. You have been given the accounts and information you need to prepare the financial statements, but you will need to use your understanding of the balance sheet accounts for long-term assets to report accurate information to the finance department. For a large company, they would more than likely use a software program to manage their finances. For purposes of this assignment, the information has been provided in Microsoft Excel. Directions Using the scenario provided, complete the following in the same file, Project Two Workbook, that includes your original work from Project Two Milestone and the feedback from your instructor. All work should be completed in the VDI. Note: You may choose to complete an assignment using a desktop program instead of SNHU's virtual desktop (VDI); however, technical support will not be provided by SNHU if you select this option./nUpload the entire completed Project Two Workbook for submission. Note: If you received a perfect score on the Project Two Milestone and do not need to correct any errors, simply note it in the designated section within the corrected Journal Entries tab. You will receive full points for those specific criteria for this assignment. Project Two Analysis Paper Complete an analysis of the information contained in the completed Project Two Workbook including your revisions. Format your paper in APA style; specific formatting can be found in the What to Submit section. Address all of the rubric criteria for the Project Two Analysis Paper below. Specifically, you must address the following rubric criteria: Project Two Workbook Correct all errors for the Journal Entries and Inventory tabs of the workbook. Highlight corrections in green. Prepare the long-term assets accurately and completely on the Ledger Accounts tab in the workbook. Prepare the long-term assets components accurately and completely on the Income Statement and Balance Sheet tabs in the workbook. Project Two Analysis Paper Determine the importance of the company having property, plant, and equipment as part of the long- term assets on its balance sheet. Consider the following questions to guide your response: What are the costs for determining what is included in the acquisition of property, plant, and equipment? What are the methods you can use to calculate depreciation? Which method makes the most sense for this company? Taking into account the disposal of property, plant, and equipment, what is the correct way to record a disposal? Determine the importance of the company having goodwill or intangibles as part of the long-term assets on its balance sheet. Consider the following questions to guide your response: How do companies acquire goodwill? What are examples of intangible assets and how are they amortized? Determine the importance of the company having long-term investments as part of the long-term assets on its balance sheet. Consider the following questions to guide your response: Should they retain long-term investments? How is the right-of-use asset determined on inception of the lease? How do you calculate the amortization the cost of a leased asset? Cite the applicable FASB Codification section for the following items as a list: property plant and equipment, investments, and intangibles. If you need writing support, access the Academic Support module of your course. What to Submit/nTo complete this project, you must submit the following: Completed Project Two Workbook Submit the same file submitted for the Project Two Milestone with your instructor feedback and the following tabs completed: Corrected Journal Entries, Ledger Accounts, Income Statement, and Balance Sheet. The Ledger Accounts, Income Statement, and Balance Sheet tabs should be based on the Corrected Journal Entries tab. This work should be completed using Microsoft Excel in the VDI. Remember to save your file on your OneDrive before exiting the VDI. The following events occurred during the first half of the year. Book the entries necessary for the corresponding transactions that have occurred. January 1: Purchased a fleet of vehicles for $350,000 via a loan from the bank. The trucks have a useful life of six years. The loan is for six years with an interest rate of 4.3%. The company already owned $200,000 of vehicles prior to this purchase with an accumulated depreciation of $80,000. February 6: It is determined that the intangible recorded for a patent is impaired by $50,000. The patent owned for two years was estimated to be worth $120,000 and has a life of 10 years. Book the journal entry for the impairment. March 25: Purchased 10-year maturity bonds as an investment for $45,000. April 5: New construction equipment was purchased for the project at the golf course for $120,000. The forklifts have a useful life of seven years. The company already owned $50,000 of construction equipment prior to this purchase with an accumulated depreciation of $22,000. May 1: A new long-term lease is entered into for a much larger corporate office which will house the company and its future acquired company. The net present value of the future lease payments is $510,800. The lease is for six years. June 14: A forklift is disposed of that had a book value of $7,500 and accumulated depreciation of $5,200. June 30: Book the depreciation for the first half of the year on the vehicles you purchased January 1. June 30: Book the depreciation for the first half of the year on the construction equipment you purchased April 5. June 30: Book the interest for the first half of the year on the fleet of vehicles you purchased January 1. June 30: Book the amortization for the first half of the year on the right-of-use leased asset from May 1. link for the excel and i already done the Milestone Journal entries' https://docs.google.com/spreadsheets/d/1KQsyhHQhulyZh2JGZU4aGsNS-3WePqA5UtvU-
Fig: 1
Fig: 2
Fig: 3