September 2023 Instructions Use a spreadsheet such as Excel to answer requirements A E below Then write

2024 Calculations Shown Assignment Help

Instructions Use a spreadsheet such as Excel to answer requirements A E below Then write 2023

Instructions: Use a spreadsheet such as Excel to answer requirements A-E below. Then write your comments to answer requirement F. Print your results to parts A-E, and then on a separate page print the formulas. The answer to part F may be handwritten. Bristol Company leased machinery from Harvard Leasing Company on January 1, 2010. The noncancellable lease term is 4 years. The following data relate to this lease: 1. Harvard purchased the equipment for $363,950 at a cost equal to its fair market value. 2. The economic life of the machinery is 6 years with no salvage value at the end of 6 years. 3. Payments are on January 1 of each year starting in 2010 (an annuity due) 4. The annual rental payment is $100,000 which includes $8,000 per year to cover executory costs paid by Harvard Leasing. (i.e. the minimum lease payment is $92,000) 5. At the end of the lease term the equipment will be returned to Harvard Leasing with an estimated residual value of $40,000. 6. Bristol’s incremental borrowing rate per year is 10% 7. Future costs associated with this lease are completely predictable and no uncertainties exist about collectability of the lease payments. Required: A. How much is the implicit annual interest rate for Harvard Leasing for this lease? Use column A for descriptive titles. Use column B to enter data and formulas. In rows 2-5 enter as data: the fair market value of the leased machinery, the minimum lease payment, the residual value, and the number of years in the lease term. In row 6 Paste the RATE function and refer to the data in rows 2-5 as arguments. The residual value is “FV”. The present value is the fair market value of the equipment multiplied by -1 (to make it an outflow of cash). Enter “1” for the annuity due type. Format the result as a % to two decimal places. B. Develop an amortization table for Bristol similar to the Table shown below assuming that the residual value is guaranteed and that Bristol knows Harvard’s implicit interest rate. Rental Executory Minimum Date Payment Cost in Rent Lease Payment Interest Amortization Present Value C. Develop a capital vs. operating leasing schedule similar to illustration 21-8 shown in your textbook starting with the year 2010. Note that the guaranteed residual value is like a salvage value for the depreciation part. Straight-line depreciation should be used. D. Develop an amortization table for Harvard Leasing Co. similar to Part B above. If it is the same amortization schedule you can refer to the amortization schedule in B. E. Now assume that the residual value is not guaranteed by Bristol Company and also that Bristol does not know Harvard’s implicit interest rate. Perform the 90% test for Harvard and for Bristol. Use the PV function to calculate the present value of the minimum lease payments for both parties. Divide the present value by the fair market value of the equipment and report your results as percentages. F. Comment on your results in part E. Hint: check figures A. Implicit Rate Cost & Fair Value of Equipment 363950 Minimum Lease Payment 92000 Estimated Residual Value 40000 Term of Lease 4 Implicit rate (annuity due) 7.00%

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational