| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Compounding Interest
How would I make a Fx. that would add $500 + 4% interest each mouth?
A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#2
|
|||
|
|||
|
Hi Jason
in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#3
|
|||
|
|||
|
that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than
add B.500, and then A+B+4%, and so on "Michael" wrote: Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#4
|
|||
|
|||
|
Sorry
In A2 put =C1+500.......then copy down as far as needed. HTH Michael "Jason" wrote: that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than add B.500, and then A+B+4%, and so on "Michael" wrote: Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#5
|
|||
|
|||
|
that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year
"Michael" wrote: Sorry In A2 put =C1+500.......then copy down as far as needed. HTH Michael "Jason" wrote: that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than add B.500, and then A+B+4%, and so on "Michael" wrote: Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#6
|
|||
|
|||
|
Jason
You did ask for 4% each month in you initial post !! In C1 put =A1*1.0033333 and copy down after 30 years you will have $348,178.96 HTH Michael "Jason" wrote: that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year "Michael" wrote: Sorry In A2 put =C1+500.......then copy down as far as needed. HTH Michael "Jason" wrote: that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than add B.500, and then A+B+4%, and so on "Michael" wrote: Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
|
#7
|
|||
|
|||
|
Jason -
Look at the function FV() in Excel's help file. Enter your payments as negatives (outflows) and you'll get a positive number as the result. Duke "Jason" wrote: that gives me 4% a mouth for a ($1,468,128,039.84) in 30 years I need 4% a year "Michael" wrote: Sorry In A2 put =C1+500.......then copy down as far as needed. HTH Michael "Jason" wrote: that is not adding the $500 add each mouth, it needs to be A.500 + 4%, than add B.500, and then A+B+4%, and so on "Michael" wrote: Hi Jason in C1 put =A1*1.04 In A2 put =C1 Copy both down as far as you ned. "Jason" wrote: How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% = |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interest Earned on Investment w/Daily Compounding | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Compound interest calculation | Excel Discussion (Misc queries) | |||
| spreadsheet for accruing interest and penalties that vary | Excel Worksheet Functions | |||
| Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) | |||
Hybrid Mode
