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 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.
Please, not in written form, please do it in excel
Please, not in written form, please do it in excel
Please, not in written form, please do it in excel
Step by step
Solved in 2 steps with 1 images