Question

In: Finance

Nodhead College needs a new computer. It can either buy it for $320,000 or lease it...

Nodhead College needs a new computer. It can either buy it for $320,000 or lease it from Compulease. The lease terms require Nodhead to make six annual payments (prepaid) of $76,000. Nodhead pays no tax. Compulease pays tax at 40%. Compulease can depreciate the computer for tax purposes straight-line over five years. The computer will have no residual value at the end of year 5. The interest rate is 6%.

a. What is the NPV of the lease for Nodhead College? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole number.)

b. What is the NPV for Compulease? (Do not round intermediate calculations. Round your answer to the nearest whole number.)

c. What is the overall gain from leasing? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to the nearest whole number.)

PLEASE PROVIDE EXCEL WITH EXPLANATION

Solutions

Expert Solution

Solution:

1.NPV for Nodhead College

Since all the payment are made on prepaid basis,that means at the begining of the year,hence first payment of $76,000 is not required to be discounted.

Discount rate=6%

NPV=Present value of cash Inflows-Present value of cash ouflows

=$0-[$76000+76000/(1+.06)+76000*(1+.06)^2+76000*(1+.06)^4+76000*(1+.06)^5]

=-$396,139.65

thus,NPV for Nodhead College is -$396,139.65.

2. NPV for Compulease

Annual Depreciation=320000/5

=$64000

Annual cash inflow=[(Lease payment-depreciation)*(1-tax rate)]+Depreciation

=$76000-$64000)*(1-.40)+$64000

=$71,200

NPV=Present value of cash ouflows-Present value of cash Inflows

=$71,200+$71,200/(1+.06)+$71,200/(1+.06)^2+$71,200/(1+.06)^3+$71,200*(1+.06)^4+$71,200*(1+.06)^5-$320,000

=$371,120.30-$320,000

=$51,120.30

3.There will be no gain from leasing for Nodhead College as it result in excess cash outflow of $76139.65(i.e.$320000-$396,139.65)


Related Solutions

Nodhead College needs a new computer. It can either buy it for $250,000 or lease it...
Nodhead College needs a new computer. It can either buy it for $250,000 or lease it from Compulease. The lease terms require Nodhead to make six annual payments (prepaid) of $62,000. Nodhead pays no tax. Compulease pays tax at 35%. Compulease can depreciate the computer for tax purposes using 5-year MACRS. The computer will have no residual value at the end of year 5. The interest rate is 8%. a. What is the NPV of the lease for Nodhead College?...
Nodhead College needs a new computer. It can either buy it for $250,000 or lease it...
Nodhead College needs a new computer. It can either buy it for $250,000 or lease it from Compulease. The lease terms require Nodhead to make six annual payments (prepaid) of $62,000. Nodhead pays no tax. Compulease pays tax at 35%. Compulease can depreciate the computer for tax purposes using 5-year MACRS. The computer will have no residual value at the end of year 5. The interest rate is 8%. a. What is the NPV of the lease for Nodhead College?...
A Plc. needs a new computer that costs £750. It can either buy it or lease...
A Plc. needs a new computer that costs £750. It can either buy it or lease it from the computer leasing company. The computer will be depreciated using a five-year MACRS schedule (see details in the formula sheet) and will be worth nothing at the end of six years. A Plc. can lease the computer with the payments of £150 (pre-paid) for six years. The corporate tax rate is 23 percent and the cost of capital is 8.5 percent. Compare...
After deciding to buy a new car, you can either lease the car or purchase it...
After deciding to buy a new car, you can either lease the car or purchase it on a two-year loan. The car you wish to buy costs $36,000. The dealer has a special leasing arrangement where you pay $101 today and $501 per month for the next two years. If you purchase the car, you will pay it off in monthly payments over the next two years at an APR of 5 percent. You believe you will be able to...
Company Ginko’s can either buy or lease a printer. If thecompany chooses to buy, the...
Company Ginko’s can either buy or lease a printer. If the company chooses to buy, the printer costs $250 upfront with varying annual maintenance cost as shown below. The printer will last 3 years. Alternatively, the company can sign a 5-year lease to rent a printer for an annual cost of $180. The company’s cost of capital is 10%.(i) What is the EAC (equivalent annual cost) for buying a printer? (ii) Which option (buy or lease) is better? Show your...
You need a new car. You can either lease or buy the car for 355000 SEK....
You need a new car. You can either lease or buy the car for 355000 SEK. In both cases you expect to use the car for 5 years. It will have a residual value of 120000 SEK after 5 years. You can borrow at a rate of 1.5% APR with monthly compounding. (a) In case you buy the car you will take an annuity loan over 5 year at a borrowing rate of 1.5%. What will be your monthly payments...
7. After deciding to buy a new car, you can either lease the car or purchase...
7. After deciding to buy a new car, you can either lease the car or purchase it on a three-year loan. The car you wish to buy costs $44,000. The dealer has a special leasing arrangement where you pay $1,000 per month, at the beginning of each month, for the next three years. If you purchase the car, you will pay it off in monthly payments over the next three years at a 3.6% APR. You believe you will be...
The Strill Oil Company is trying to decide whether to lease or buy a new computer-assisted...
The Strill Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its oil exploration business. Management has decided that it must use the system to stay competitive; it will provide RM1,200,000 in annual pretax cost savings. The system costs RM6,700,000 and will be depreciated straight-line to zero over 4 years. Strill's tax rate is 35 percent, and the firm can borrow at 11 percent. Nexgain Leasing Company has offered to lease the...
The Wildcat Oil Company is trying to decide whether to lease or buy a new computer-assisted...
The Wildcat Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its oil exploration business. Management has decided that it must use the system to stay competitive; it will provide $4.1 million in annual pretax cost savings. The system costs $9.1 million and will be depreciated straight-line to zero over 5 years. Wildcat's tax rate is 22 percent, and the firm can borrow at 8 percent. Lambert Leasing Company has offered to...
The Wildcat Oil Company is trying to decide whether to lease or buy a new computer-assisted...
The Wildcat Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its oil exploration business. Management has decided that it must use the system to stay competitive; it will provide $4.1 million in annual pretax cost savings. The system costs $9.1 million and will be depreciated straight-line to zero over 5 years. Wildcat's tax rate is 22 percent, and the firm can borrow at 8 percent. Lambert Leasing Company has offered to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT