R
roter789
Here is my problem in Excel: This is a recurrence problem. I was doin
the Capital Growth which calculates the amount of the investment as i
is compounded by the addition of interest for each period.
here is the formula:
=IF(ISNUMBER(Period(C3*(1+Interest_Rate*Interest_Period))),"")
here is the outcome:
Period Capital
0 $30,000.00
1 FALSE
2
3 FALSE
4 FALSE
5 FALSE
6 FALSE
7 FALSE
8 FALSE
9 FALSE
10 FALSE
11 FALSE
12 FALSE
13 FALSE
14 FALSE
15 FALSE
16 FALSE
17 FALSE
18 FALSE
19 FALSE
20 FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
This is the parameter:
Initial Capital:$30,000
Investment Date: 1/31/1993
Maturity Date:1/31/2003
Interest Rate:8.00%
Interest Period:0.5
Term:10.00
Number of Periods:20
I want the capital growth be visible ONLY to the period correspondin
to it. i dont know what is wrong with my formula becuase it is sayin
FALSE..
Thanks for the help in advance
the Capital Growth which calculates the amount of the investment as i
is compounded by the addition of interest for each period.
here is the formula:
=IF(ISNUMBER(Period(C3*(1+Interest_Rate*Interest_Period))),"")
here is the outcome:
Period Capital
0 $30,000.00
1 FALSE
2
3 FALSE
4 FALSE
5 FALSE
6 FALSE
7 FALSE
8 FALSE
9 FALSE
10 FALSE
11 FALSE
12 FALSE
13 FALSE
14 FALSE
15 FALSE
16 FALSE
17 FALSE
18 FALSE
19 FALSE
20 FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
This is the parameter:
Initial Capital:$30,000
Investment Date: 1/31/1993
Maturity Date:1/31/2003
Interest Rate:8.00%
Interest Period:0.5
Term:10.00
Number of Periods:20
I want the capital growth be visible ONLY to the period correspondin
to it. i dont know what is wrong with my formula becuase it is sayin
FALSE..
Thanks for the help in advance