Bancomer grants loans for the purchase of new automobiles, at 12½ % interest with monthly payments, for 4 years. It requests a minimum down payment of 10% and a maximum of 50% of the initial value of the car, excluding insurance and license plates. Considering the above, calculate the interest cost (effective rate) and the amount of the monthly payments considering the down payments from smallest to largest and varying from 10% to 10%. After a 30% down payment, the rate drops to 11.5%. The list cost of the car is $254,000.00.
4.
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
Bancomer grants loans for the purchase of new automobiles, at 12½ % interest with monthly payments, for 4 years. It requests a minimum down payment of 10% and a maximum of 50% of the initial value of the car, excluding insurance and license plates. Considering the above, calculate the interest cost (effective rate) and the amount of the monthly payments considering the down payments from smallest to largest and varying from 10% to 10%. After a 30% down payment, the rate drops to 11.5%. The list cost of the car is $254,000.00.
Very important Note:
It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
Step by step
Solved in 2 steps with 2 images
