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

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

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

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.
--
HTH,
Barb Reinhardt



"j5b9721" wrote:

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

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

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

--
Regards,
Fred


"j5b9721" wrote in message
...
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

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

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" wrote:

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

--
Regards,
Fred


"j5b9721" wrote in message
...
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

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

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

--
Regards,
Fred


"j5b9721" wrote in message
...
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" wrote:

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

--
Regards,
Fred


"j5b9721" wrote in message
...
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