473,324 Members | 2,248 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Annuity Due formula

mshmyob
904 Expert 512MB
Alright all you math experts out there I need your help.

I have a formula for an annuity due calculation
fv = p * (((1 + i) ^ n - 1) / i) * (1 + i)

where
fv = future value
p = payments
i = interest rate
n = term

No problem there - everything is working as it should.

I now need a formula where the payements (p) change. They will change by a fixed percentage amount (ie: increase 3% a year for the term).

I need the formula ... any ideas?

cheers,
Jun 3 '08 #1
5 5639
r035198x
13,262 8TB
Alright all you math experts out there I need your help.

I have a formula for an annuity due calculation
fv = p * (((1 + i) ^ n - 1) / i) * (1 + i)

where
fv = future value
p = payments
i = interest rate
n = term

No problem there - everything is working as it should.

I now need a formula where the payements (p) change. They will change by a fixed percentage amount (ie: increase 3% a year for the term).

I need the formula ... any ideas?

cheers,
A useful hint is that
Expand|Select|Wrap|Line Numbers
  1. p(i) = p(1+r)
where r is the percentage rate.
Jun 5 '08 #2
mshmyob
904 Expert 512MB
Are you sure you meant to put p (payments) on both sides of the equation? Because if you did then the equation is not equal as far as I can see.

Assuming payments is 200 and i is 3% and r is 2% the equation won't equal out.

cheers,

A useful hint is that
Expand|Select|Wrap|Line Numbers
  1. p(i) = p(1+r)
where r is the percentage rate.
Jun 5 '08 #3
mshmyob
904 Expert 512MB
Currently what I have done is put everything into a loop (if payments increase with inflation) and calculated the future value of each payment and added them. It is only a few lines of code and seems to work but I was wondering if there is a specific formula when payment are non-regular.

cheers,
Jun 5 '08 #4
r035198x
13,262 8TB
Alright all you math experts out there I need your help.

I have a formula for an annuity due calculation
fv = p * (((1 + i) ^ n - 1) / i) * (1 + i)

where
fv = future value
p = payments
i = interest rate
n = term

No problem there - everything is working as it should.

I now need a formula where the payements (p) change. They will change by a fixed percentage amount (ie: increase 3% a year for the term).

I need the formula ... any ideas?

cheers,
Perhaps I'm misunderstanding your variables.
The formula I gave is for calculating the ith payment where the rate applied is a flat r% after for each payment.
Jun 5 '08 #5
mshmyob
904 Expert 512MB
Let me try to explain further. The formula I gave is for an Annuity Due (where payments are made at the start of a period as opposed at the end). Example if payments (p) are made monthly the payments are made on the 1st day as opposed to the last day. This formula assumes all payments are equal throughout the whole term (n).

In other words I save $200 (p) a month for 10 (n) years and get 8% (i) annually on my savings.

FV is how much the savings grows to.

That formula is a standard formula used in finance.

What I would like to do now is take into account where payments may increase in value.

Same as above where I save for 10 years and get 8% a year but now I start saving $200 a month for 1 year but the next year I increase my savings by say 3% (inflation). So in the 2nd year I am saving $206 a month for that year, in the 3rd year I save $206*1.03 = $212.18 etc. up to year 10.

The only way I can take into account the changes in payments is to calculate each year of payments seperately and sum them together. Easily done with the computer as I said a few lines of code in a loop but I was wondering if there is a formula to do the same. What I have done is known as "principal of additivity"


I hope that makes more sense. Thanks for your help so far.

cheers,


Perhaps I'm misunderstanding your variables.
The formula I gave is for calculating the ith payment where the rate applied is a flat r% after for each payment.
Jun 5 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Ernie | last post by:
Hi, I spent more than an hour wondering why the following works in my Python 2.3.4 Linux box: formula = """ def dummy(): print "This is Ok!" """
2
by: celsius | last post by:
Hi folks, Al Bowers wrote this program on comp.lang.c Date: 2001-07-09 13:41:58 PST #include <stdio.h> int isleap (unsigned yr); static unsigned months_to_days (unsigned month); static long...
0
by: RJN | last post by:
Hi I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main...
0
by: RJN | last post by:
Hi Sorry for posting this message again. I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be...
0
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the...
3
by: Mike | last post by:
Hi, I have three tables in the following structure (simplified): Table 1: Containing the customers ------------------------------------------------- create table Customers ( int...
11
by: Brian VanPelt | last post by:
I am not a very experienced VB user, but I was trying to make a form that a user could input a formula for summation. For example, I would like the user to input the beginning and end values of...
1
by: barnzee | last post by:
Hi all, newbie here, but having a go I am trying to build a stock watchlist in excel 2007 with a dynamic link to a DDE server (paid for from a broker).There is no add-in or plug-in, I just CTL ALT...
30
by: Barry L. Bond | last post by:
Greetings! I just got a new Peet Brothers Ultimeter 2100 Weather Station. This new one has a way to display the heat index, if you press the "dew point" key twice. Being aware of all the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.