add calculations

Question 6 Present Value Calculations (10 marks: 15 minutes) Use Excel functions to calculate your answers CALC 2 3 1 An Ottawa based company, Taggurt Construction Corporation plans to lease a 5 $820,000 bulldozer to the LRT Corporation. The lease will be for 12 years. Lease 6 payments are payable at the beginning of the year. Use Excel functions calculate the 7 following: 8 9 a. If Taggurt desires a 14 percent return on its investment, how much should 20 the company make the annual lease payments for? (2 marks) 1 2 Answer: 3 b. How much would the lease payments be if the payments are to be made at the end of the year rather than at the beginning? (2 marks) Answer: c. Explain why the amount calculated in a) above differs to the amount in CC c. Explain why the amount calculated in a) above differs to the amount in calculated in b. (3 marks) 19 20 21 22 23 24 25 26 7 8 9 d. If Taggurt is able to generate $125,000 in immediate tax shield benefits on the bulldozer purchased for the lease arrangement and will pass the benefits along to the LRT Corporation in the form of lower lease payments, how much should the revised lease payments be? Assume that Taggurt still wants a 14 percent return on the 12-year lease. (3 marks) Net Cost: Answer: 05 Annual ys Effective Rate Q6 Lease Q7 PV Future Cash Flows