Ejemplo de Anualidades en Excel

Hi, first of all, thank you so much for watching this video. We recently added a poll to our website to find out what kind of content you'd like to see. You can find it on the left side of every article on the page, so I invite you to vote for your favorite option. If it's

different, let me know in the comments. In the contest I recently held, you asked for a new video about annuities, and here it is!

[Music] Annuity exercises: How much money will be obtained after four years if 1800 is invested semi-annually in a fund that pays a semi-annual interest rate of 9 percent? In this problem, it is not specified that the payments are made in advance, so they are due at the end of the term. For this case, we will use the following

formula: future value equals the value of the annuity x plus the interest rate x raised to the number of periods. We subtract 1 from this and divide by the periodic interest rate. Substituting the data, we have that the future value is equal to 1800. What is this value? What is the annuity x? 1 0.09 is this interest in our

raised to the 8th power because four years have passed and it is paying semiannual interest, that is, 4 times 28, we subtract 1 and this we live over 0.09, which is equivalent to this 9% semiannual rate. This is equal to 19,851.25. Our answer then is that the money obtained is 19,851.25 cents. There are several things to keep in mind here.

The first is that we can easily replace it because this interest was already ours and the annuities are semiannual. If this interest rate were, let's say, an effective annual rate or some kind of nominal annual rate, then it would have to be some transformation, but since that is not the case, but rather