An account executive at Santander branch CETYS, receives a deposit from an important client-student, surnamed Cuevas Ronchas for $30,000.00; in an account that generates 6% interest, capitalizable monthly. After two years, he decides to make new deposits at the end of each year, so that after three years from this decision, he has $200,000.00 at the time of the last deposit. Find the amount of annual deposits he has to make for the last 3 years. The solution involves calculating a future value and then a present value.
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
Problem 5:
An account executive at Santander branch CETYS, receives a deposit from an important client-student, surnamed Cuevas Ronchas for $30,000.00; in an account that generates 6% interest, capitalizable monthly. After two years, he decides to make new deposits at the end of each year, so that after three years from this decision, he has $200,000.00 at the time of the last deposit. Find the amount of annual deposits he has to make for the last 3 years. The solution involves calculating a
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.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps