Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
What is the function I use for showing me how much a fixed 6% annually will
yield over the years. For instance, on $100,000 the first year would yield $106,000, the second year, how much, the fifth year, tenth, etc. -- Rene - Do appreciate your help. I have had simply the best help with these groups, and it's where I turn to for serious help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
You can use the Future Value FV function
Things to note: Your interest rate must match your "periods" (years, months, etc) Use negative values for money leaving you, positive for money coming in. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Rene" wrote in message ... What is the function I use for showing me how much a fixed 6% annually will yield over the years. For instance, on $100,000 the first year would yield $106,000, the second year, how much, the fifth year, tenth, etc. -- Rene - Do appreciate your help. I have had simply the best help with these groups, and it's where I turn to for serious help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
Bernard, I'm very thankful for your time, but I didn't express myself
clearly. There will be no additional payments to the original sum. It's like the appreciation in a real estate deal, in a way. I've paid 100 and I'd like to know how much this sum will be worth in 2, 5, or 10 years time if the appreciation is constant at, say, 6% a year, compounded. -- Rene - Do appreciate your help "Bernard Liengme" wrote: You can use the Future Value FV function Things to note: Your interest rate must match your "periods" (years, months, etc) Use negative values for money leaving you, positive for money coming in. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Rene" wrote in message ... What is the function I use for showing me how much a fixed 6% annually will yield over the years. For instance, on $100,000 the first year would yield $106,000, the second year, how much, the fifth year, tenth, etc. -- Rene - Do appreciate your help. I have had simply the best help with these groups, and it's where I turn to for serious help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
On Oct 2, 8:11 am, Rene wrote:
What is the function I use for showing me how much a fixed 6% annually will yield over the years. For instance, on $100,000 the first year would yield $106,000, the second year, how much, the fifth year, tenth, etc. =fv(6%,A1,0,-100000) where A1 is the number of years (1, 2, 5, 10). |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
=100000*(1+6%)^ROW(A1) in your first row will give the answer for 1 year.
Copy down as far as necessary. -- David Biddulph "Rene" wrote in message ... What is the function I use for showing me how much a fixed 6% annually will yield over the years. For instance, on $100,000 the first year would yield $106,000, the second year, how much, the fifth year, tenth, etc. -- Rene - Do appreciate your help. I have had simply the best help with these groups, and it's where I turn to for serious help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compound Interest over the years
On Oct 2, 9:04 am, "David Biddulph" <groups [at] biddulph.org.uk
wrote: =100000*(1+6%)^ROW(A1) in your first row will give the answer for 1 year. Copy down as far as necessary. Or simply put 100000 into A1, =A1*(1+6%) in to A2, and copy down A2 as needed. Besides being more efficient, arguably it is less error-prone. With "^row(A1)", move the table afterwards (other than left or right), and everything is fubar. That might seem obvious to you. But if the OP cannot figure out how to use FV based on Bernard's response, he/she probably could not begin to fathom the chaos brought on by the misuse of row(A1). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compound interest | Excel Worksheet Functions | |||
Compound Interest | Excel Worksheet Functions | |||
Compound Interest | Excel Worksheet Functions | |||
compound interest | Excel Worksheet Functions | |||
compound interest | Excel Worksheet Functions |