Question

In: Finance

Precision Tool is trying to decide whether to lease or buy some new equipment for its...

Precision Tool is trying to decide whether to lease or buy some new equipment for its tool and die operations. The equipment costs $50,000, has a 3-year life and will be worthless after the 3 years. The pre-tax cost of borrowed funds is 9 percent and the tax rate is 34 percent. The equipment can be leased for $17,500 a year.

What is the net advantage to leasing?

When calculation this with Excel I keep getting the wrong answer can you help me figure out how to do this problem in excel?

Solutions

Expert Solution

Calculation is shown below

Working is shown below


Related Solutions

Precision Tool is trying to decide whether to lease or buy some new equipment for its...
Precision Tool is trying to decide whether to lease or buy some new equipment for its tool and die operations. The equipment costs $51,000, has a 3-year life and will be worthless after the 3 years. The pre-tax cost of borrowed funds is 7 percent and the tax rate is 35 percent. The equipment can be leased for $16,000 a year. What is the net advantage to leasing? (Do not round intermediate calculations.) a. $4,831 b. $6,451 c. $6,097 d....
Precision Tool is trying to decide whether to lease or buy some new equipment for its...
Precision Tool is trying to decide whether to lease or buy some new equipment for its tool and die operations. The equipment costs $55,000, has a 3-year life and will be worthless after the 3 years. The pre-tax cost of borrowed funds is 6 percent and the tax rate is 33 percent. The equipment can be leased for $17,500 a year. What is the net advantage to leasing?
Bart Simpson is trying to decide whether or not he should lease or buy a new...
Bart Simpson is trying to decide whether or not he should lease or buy a new viper. The viper can be leased for $10,000 per year (first payment made right now) for 10 years or he can buy the car outright for a cost of $65,000. Bart has located a bank that will lend him the $65000 at a cost of 15.75%. Bart will drive the car for 10 years and will abuse viper to the point that it will...
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...
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 $3.2 million in annual pretax cost savings. The system costs $9.9 million and will be depreciated straight-line to zero over its five-year life, after which it will be worthless. Wildcat's tax rate is 24 percent and the firm can borrow at 8...
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 $3.1 million in annual pretax cost savings. The system costs $7.9 million and will be depreciated straight-line to zero over 5 years. Wildcat's tax rate is 23 percent, and the firm can borrow at 7 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 already determined that the acquisition of the system has a positive NPV. The system costs $10.0 million and qualifies for a 31% CCA rate. The equipment will have a $981,000 salvage value in 5 years. Wildcat’s tax rate is 36%, and the firm can borrow at 9.6%. Southtown 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 $3.2 million in annual pretax cost savings. The system costs $9.9 million and will be depreciated straight-line to zero over its five-year life, after which it will be worthless. Wildcat's tax rate is 24 percent and the firm can borrow at 8...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT