Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
I want to create a spreadsheet with multiple variables. This is a compound interest spreadsheet on a daily compound interest however it's also a reinvestment spreadsheet base on an at or above $50 calculated interest. The Interest rate changes also with the amount of money in your account.
Here are the figures:
$50 - $50,999 = .006 daily interest rate
$51,000 - 100,999 = .007 daily interest rate
$101,000 - $1,000,000 = .008 daily interest rateThe daily amount of interest can be can be reinvested if the interest amount is = or > $50.00. If the Interest is < $50 it must remain in the account non-invested until it accumulates to = or >$50, then it can be reinvested.
My excel spreadsheet has 364 rows (one for each day and I have it being reinvested because my amount is above the daily interest amount of $50. I know there is an eaiser way but I don't know it.
What I need is what happens if someone only has $50 to invest initially? He would only receive 30 cents a day until he reaches at/above the $50 threshold . I would need a spreadsheet that shows daily interest and reinvestment with any amount from $50 - $1M of investment. I would also need something if I made another deposit to the account.
Can someone help me with this? Or is this too complicated Thank-You

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |