Question

In: Finance

Project 4: Buy or Lease Project description Becky’s company is considering an investment project. To start,...

Project 4: Buy or Lease

Project description

Becky’s company is considering an investment project. To start, Becky just needs to purchase an equipment priced at $5,000. The equipment will follow a straight-line depreciation over 10 years. Each year’s depreciation is $500. The project will last 3 years. If Becky purchases the equipment for the project, the expected EBIT is $1000 each year in year 1-3. At the end of the year 3, the expected after-tax salvage value of the equipment is $4,200. The tax rate is 20%.

Becky can also lease the same equipment for year 1-3 and the annual leasing cost is $600 paid at the end of each year.

Becky’s company has an optimal capital structure of 50% debt. Its cost of equity is 10% and before-tax cost of debt is 6%.

Is the project worth doing? If yes, should Becky buy or lease the equipment?

Requirements

1. Present the case solution in an Excel file with clear labels, functions and descriptions.

2. Starting with the data provided, show each step of your work that leads to the conclusion.

3. Due in D2L by 11:59PM Sunday June 14.

Hints

1. You may need the following equations:

FCF=EBIT×(1-T)+DP-net CAPX-ΔNWC

WACC=wd×rd×(1-T)+ws×rs

    Excel functions: NPV, PV  

2. Since the cash flows from buy and lease have different risks, it is not good to discount them with the cost of debt or use NAL. I recommend student to consider the value of the project separately for the buy and the lease scenarios. Since Becky’s company has an optimal capital structure, the WACC approach is acceptable. However, leasing is equivalent to borrowing and may force the company to borrow less elsewhere, losing interest shield benefits.

Grading

7 points in total

Finished and submitted on time: 3 points

0-25% correct: +1

25%-50% correct: +2

50%-75% correct: +3

75%-100% correct: +4

***Please include all excel functions in answer***

Solutions

Expert Solution

Based on the given data, pls find below calculations:

Based on the below workings, it is recommeded to opt for leasing option as the NPV of the leasing option is higher than that of the purchase option;


Related Solutions

You are considering a project that needs $50,000 investment to start. This is a 5 year...
You are considering a project that needs $50,000 investment to start. This is a 5 year project and you are expecting that the project generates annual cash flows after taxes of $10,000, $50,000, $90,000, $20,000 and -$30,000 respectively. What is the EAA of this project if the required rate of return is 8%? Round to the penny. Do not include the dollar sign. If there are multiple answers, then type NA.
Iris Company is considering a new investment project. The initial investment for the project is $200,000....
Iris Company is considering a new investment project. The initial investment for the project is $200,000. Iris is trying to estimate the net cashflows after tax for this investment. She has already figured out that the investment will generate an annual after-tax cash inflow of $54,000 from the operation. For tax purposes, the projected salvage value of the investment is $25,500. The government requires depreciating the vehicles using the straight-line method over the investment's life of 8 years. q1) Iris...
You are considering whether to buy or lease a car. If you lease, you have to...
You are considering whether to buy or lease a car. If you lease, you have to pay a refundable security deposit of $5 hundred, and a monthly lease payment of $424 for 3 years, with payments due at the beginning of the month. If you buy, you will pay a downpayment of $21 hundred, and a monthly loan payment of $565, over the same period of time, with payments due at the end of the month. The car is estimated...
Your company is considering a 4-year expansion project that requires an initial fixed asset investment of...
Your company is considering a 4-year expansion project that requires an initial fixed asset investment of $157,000. The fixed asset will be depreciated straight-line to zero over its 4-year life. The project is estimated to generate $150,000 in annual sales, with costs of $52,000. The project requires an initial investment in net working capital of $15,000, and the fixed asset will be sold for $13,000 at the end of the project. The tax rate is 25%, and the required return...
Your company is considering a new 4-year project that requires an initial fixed asset investment of...
Your company is considering a new 4-year project that requires an initial fixed asset investment of $3.25 million. The fixed asset is eligible for 100 percent bonus depreciation in the first year (which means can all be depreciated in year 1). At the end of the project, the asset can be sold for $440,000. The project is expected to generate $3.05 million in annual sales, with annual expenses of $955,000. The project will require an initial investment of $490,000 in...
A company is considering a long term investment project. It will require an investment of $128,300....
A company is considering a long term investment project. It will require an investment of $128,300. Useful life is 4 years. No salvage value. Annual cash inflows would increase $80,300 and annual cash outflows would increase $40,400. The company's required rate of return is 9 percent. Calculate the net present value of this project
Company XYZ is considering project A. Project A requires an initial investment of $75,000.
Company XYZ is considering project A. Project A requires an initial investment of $75,000. It generates $35,000 each year for the coming 3 years. What is the discounted payback period for this project if the proper discount rate is 18%?
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an initial investment of $4 million. It has a target capital structure of 45% debt, 4% preferred stock, and 51% common equity. Kuhn has noncallable bonds outstanding that mature in five years with a face value of $1,000, an annual coupon rate of 10%, and a market price of $1,050.76. The yield on the company’s current bonds is a good approximation of the yield on any new bonds that it...
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an initial investment of $4 million. It has a target capital structure of 35% debt, 2% preferred stock, and 63% common equity. Kuhn has noncallable bonds outstanding that mature in five years with a face value of $1,000, an annual coupon rate of 10%, and a market price of $1,050.76. The yield on the company’s current bonds is a good approximation of the yield on any new bonds that it...
Kuhn Co. is considering a new project that will require an initial investment of $4 million....
Kuhn Co. is considering a new project that will require an initial investment of $4 million. It has a target capital structure of 45% debt, 4% preferred stock, and 51% common equity. Kuhn has noncallable bonds outstanding that mature in 15 years with a face value of $1,000, an annual coupon rate of 11%, and a market price of $1555.38. The yield on the company’s current bonds is a good approximation of the yield on any new bonds that it...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT