5.- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS Lourdes Escárcega Bárcenas, a concerned housewife and manager of the most famous new car dealership in town, is considering entering into a savings plan that would net her $525,000.00 to buy the car of her dreams in 4 years (future value). The plan stipulates the payment of interest at a rate of 9.75% with monthly capitalizations. What monthly amount does she have to deposit so that at the end of the term she will have enough to buy the car? Note: In the image, this is the original exercise, it is in Spanish, but it is easy to understand. 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.
5.-
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
Lourdes Escárcega Bárcenas, a concerned housewife and manager of the most famous new car dealership in town, is considering entering into a savings plan that would net her $525,000.00 to buy the car of her dreams in 4 years (
Note:
In the image, this is the original exercise, it is in Spanish, but it is easy to understand.
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 3 steps with 2 images
