Wednesday
November 26, 2014

Homework Help: FInance

Posted by Deanna on Saturday, November 10, 2012 at 12:24am.

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 3-year 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.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

business - A company has the following alternatives on some real estate that it ...
business - A company has the following alternatives on some real estate that it ...
Finance - Cascade Mining ($28Mil Assets) has an estimated beta of 1.6. The ...
Finance - I need help with this finance homework question PLEASE! Any help ...
Finance - Templeton Extended Care Facilities, Inc. is considering the ...
finance - templeton extended care facilities inc is considering the acquisition ...
finance - Templeton Extended Care Facilities, Inc. is considering the ...
finance - Templeton Extended Care Facilities, INC. is considering the ...
QSO 51O - The Newox Company is considering whether or not to drill for natural ...
finance - Templeton Extended Care Facilities, Inc. is considering the ...

Search
Members