FInance
posted by Deanna .
Assignment 2: Lease vs. Buy
Your employer, Barnaby Well Company, is considering the acquisition of a new drill truck and your boss has asked you to evaluate the decision that she has made to buy the truck. The truck has a purchase price of $60,000 and a useful life of 4 years and a zero salvage value. Barnaby can borrow to buy the truck for $60,000 or lease the truck for $15,000 for 4 years, paid at the beginning of each year.
If debt is used to buy the truck, Barnaby can borrow at 8% annual interest, with payments at the end of each year. The marginal tax rate for the firm is 40%. The asset is classified as a 3year cost recovery asset for depreciation purposes. According to the current tax laws, Barnaby is allowed to use MACRS depreciation with 30% rate for year one, 45% for year two, 20% for year three and 5% for year four. There will be no salvage value at the end of the fourth year.
Questions:
What is the annual cost, before any tax considerations, of the lease option? Are there any tax considerations and if so, what is the after tax annual cost of the lease agreement? Explain your answer.
What is the total cost of leasing the truck today?
What are the annual cash flows if the truck is purchased with debt financing?
What is the cost of purchasing the truck with debt financing today?
Make a recommendation to your boss as to whether the company should buy or lease the truck. Justify your recommendations.
I need the excel sheet. I am so confused.
Respond to this Question
Similar Questions

algebra
Can someone please tell me if I did this problem right? 
physics
Q2. A box rests on the (frictionless) bed of a truck. The truck driver starts the truck and accelerates forward. The box immediately starts to slide toward the rear of the truck. Discuss the motion of the box, in terms of Newton’s … 
Physics
In a movie, a stuntman places himself on the front of a truck as the truck accelerates. The co efficient of friction between the stuntman and the truck is 0.65. The stuntman is not standing on anything but can “stick” to the front … 
math
a movng company wants to buy a new type of truck and needs to know the volume of the storage compartent before they can decide if they should purchase the truck. What is the volume of the storage compartment? 
Math
Suppose Meagan needs to drive the truck 10 miles to her new home. a) What is the cost of using Truck A? 
Math
The U drive rent a truck company plans to spend 13 million on 320 new vehicles. Each commercial van will cost $35000, each small truck $30000, and each large truck $80000. Past experience shows that they need twice as many vans as … 
physics
A construction worker riding in the tray of a truck traveling at 10 m/s, sees one of his friends passing and decides to jump off the truck. The magnitude of his initial speed of jumping is: (a) zero (b) Less than the truck's (c) Equal … 
math for managers
Cost analysis Te owner of a small construction business needs a new truck. He can buy a diesel truck for $38,000 and it will cost him $0.24 per mile to operate. He can buy a gas engine truck for $35,600 and it will cost him $0.30 … 
math
The UDrive RentATruck company plans to spend $8 million on 280 vehicles. Each commercial van will cost $25,000, each small truck $30,000, and each large truck $40,000. Past experience shows that they need twice as many vans as small … 
math
Beaudoin Haulage has signed a fiveyear lease with GMAC on a new dump truck. Lease payments of $4500 are made at the beginning of each month. To purchase the truck, Beaudoin would have had to borrow funds at 8.7% compounded annually. …