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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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%.
 
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...
 
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
 
Back
Top