Need Formula Help... To Hard for me!!! LOL

[Guest]

Is there a formula that I can use to compound interest daily like this?


(A1) (B1) (C1) (D1) (E1)
Total
Average
Capital Todays Days 100% Compounded Daily
Rate Daily Interest Interest

1000 .012 240 16511.49 =D1/240


I dont know if this is correct for (D1) Total.

_______________________________________________________


Then I need it this way also...


(A) (B) (C) (D)

Daily
1 Capital Todays Days Interest
Rate

2 1000 calulated 240 Entered daily
daily

3 =A1+D1 (same) =C1-1 (same)

But I looking for no errors in the cells... until the next day is
entered in D2 & D3.

Thanks for your time!!!
Joe

 

[Guest]

Well, in order to "hide" the errors, you could put a conditional format on
the subsequent days entry row something like this:

Select the cells in the row of interest
Let's assume you are doing this for Row 3


Format -> Conditional Formula
Formula is =isblank($B3) '<~~~change to match the cells you need.
Change the font color to be the same color as the background.

 

[Fred Smith]

Compounding interest daily is easy. You just use the regular financial
functions, in this case, FV. For example:

=fv(b1,c1,0,-a1)

This will give you the future value after 240 days, or $17,511.49. To get the
total interest charged, subtract the original principal.

BTW, your heading of "100% Compounded Daily Interest" is misleading, because the
interest rate used is actually 1.2%.

 

[Guest]

Hi Fred...
It may be helpful I'll try it out...
But I can also need to change the (100% daily compounded rate) too. From
100% to like 50% or 60% compounded daily...
Do you follow what I mean?
So like this...

Day 1
$1000 @ 1.2% Daily is $12 But the following day I looking for the
investment + 50% of the $12

Day 2
investing $1006 or 50 % if the interest made on day 1...

 

[Fred Smith]

I'm not sure I follow, but if you are investing only 50% of the interest on day
1, simply multiply your interest rate by 50%. What you are really doing is
changing your interest rate.

$1000 @ (1.2% x 50%) = $1006