afael Robles goes to his financial advisor and asks him to calculate the interest to be earned on a deposit for the amount of 730,000.00; when the current interest rate is 9.75%, capitalized quarterly, and it was invested for 5 years, 9 months and 27 days. The Finance Company reinvests at simple interest when there are not complete capitalization periods. Note:
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
2.- Mr. Rafael Robles goes to his financial advisor and asks him to calculate the interest to be earned on a deposit for the amount of 730,000.00; when the current interest rate is 9.75%, capitalized quarterly, and it was invested for 5 years, 9 months and 27 days. The Finance Company reinvests at simple interest when there are not complete capitalization periods.
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.
TO CONSIDER THE YEAR AS 360 DAYS (WHICH IS COMMERCIAL) (only if required)
Step by step
Solved in 2 steps with 1 images
