Question

In: Finance

You are trying to decide whether to keep your current car or buy a new car....

You are trying to decide whether to keep your current car or buy a new car. If you keep your current car you will pay $400 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments for 10 years.
Alternatively, you can buy a new car and pay $28,000 today and $350 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments for for 10 years.

If your investments earn 5% APR (compounded monthly), which alternative is cheaper in present value terms and by how much?

Group of answer choices

keep existing car saves $22,608

get new car, saves $24,515

keep existing car saves $24,450

keep existing car saves $23,286

Solutions

Expert Solution

Present value of keeping existing car = present value of monthly payments

Present value of monthly payments is calculated using PMT function in Excel :

rate = 5% / 12 (converting annual rate into monthly rate)

nper = 120 (10 years with 12 monthly payments each year = 10 * 12 = 120)

pmt = -400 (monthly payment)

PV is calculated to be $37,713

Present value of new car = present value of monthly payments + immediate payment

Present value of monthly payments is calculated using PMT function in Excel :

rate = 5% / 12 (converting annual rate into monthly rate)

nper = 120 (10 years with 12 monthly payments each year = 10 * 12 = 120)

pmt = -350 (monthly payment)

PV is calculated to be $32,998

Present value of new car =  $32,998 + $28,000 = $60,998

Amount saved by keeping existing car = $60,998 - $37,713 = $23,286

jeff jeffy answered 4 months ago
Next > < Previous

Related Solutions

You are trying to decide whether to keep your current car or buy a new car....
You are trying to decide whether to keep your current car or buy a new car. If you keep your current car you will pay $350 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments for 10 years. Alternatively, you can buy a new car and pay $28,000 today and $300 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments...
You are trying to decide whether to keep your current car or buy a new car....
You are trying to decide whether to keep your current car or buy a new car. If you keep your current car you will pay $350 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments for 10 years. Alternatively, you can buy a new car and pay $28,000 today and $300 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments...
You are trying to decide whether to keep your current car or buy a new car....
You are trying to decide whether to keep your current car or buy a new car. If you keep your current car you will pay $350 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments for 10 years. Alternatively, you can buy a new car and pay $28,000 today and $300 per month (starting next month) on average for maintenance, gas, property tax and insurance. You will make these payments...
the management of flasher is trying to decide whether to buy a new team of mules...
the management of flasher is trying to decide whether to buy a new team of mules at a cost of $1.000 or a new tractor at a cost of $10.000 they will perform the same job but because the mules require more laborers the annual return ıs only $250 of net cash ınflows the tractor will return $2.000 of net cash ınflows per year the mules have a working life of 8 years and the tractor has aworking life of...
the management of flasher is trying to decide whether to buy a new team of mules...
the management of flasher is trying to decide whether to buy a new team of mules at a cost of $1.000 or a new tractor at a cost of $10.000 they will perform the same job but because the mules require more laborers the annual return ıs only $250 of net cash ınflows the tractor will return $2.000 of net cash ınflows per year the mules have a working life of 8 years and the tractor has aworking life of...
A recent college grad is trying to decide whether he should keep his presently owned car...
A recent college grad is trying to decide whether he should keep his presently owned car or purchase a new one. A new car will cost $26,000 and have annual operation and maintenance costs of $1200 per year with an $8000 salvage value in 5 years, which is its economic service life. The presently owned car has a resale value now of $5000; 1 year from now it will be $3000, 2 years from now $2500, and 3 years from...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT