Computing.Net > Forums > Office Software > Excel Spreadsheet

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Spreadsheet

Reply to Message Icon

Name: gminsterjr
Date: April 2, 2009 at 14:20:32 Pacific
OS: Windows Vista
Subcategory: Microsoft Office
Comment:

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 rate

The 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



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

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


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel Spreadsheet

Excel Spreadsheet Formula www.computing.net/answers/office/excel-spreadsheet-formula/9360.html

Linking to open excel spreadsheet www.computing.net/answers/office/linking-to-open-excel-spreadsheet/6074.html

read write excel spreadsheets www.computing.net/answers/office/read-write-excel-spreadsheets/3109.html