Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compound interest
How can I calculate the future worth of a fixed amount of $, at a fixed interest rate? For instance, $5/day at 3%. How much in ten years?. Thanks Steve Grimes -- by1612 ------------------------------------------------------------------------ by1612's Profile: http://www.excelforum.com/member.php...fo&userid=8611 View this thread: http://www.excelforum.com/showthread...hreadid=314345 |
#2
|
|||
|
|||
=FV(3%/365,3650,5)
Assumimg all 10 years have 365 days and compounded daily "by1612" wrote in message ... How can I calculate the future worth of a fixed amount of $, at a fixed interest rate? For instance, $5/day at 3%. How much in ten years?. Thanks Steve Grimes -- by1612 ------------------------------------------------------------------------ by1612's Profile: http://www.excelforum.com/member.php...fo&userid=8611 View this thread: http://www.excelforum.com/showthread...hreadid=314345 |
#3
|
|||
|
|||
Look in HELP index for FV and then look at all of the financial functions.
-- Don Guillett SalesAid Software "by1612" wrote in message ... How can I calculate the future worth of a fixed amount of $, at a fixed interest rate? For instance, $5/day at 3%. How much in ten years?. Thanks Steve Grimes -- by1612 ------------------------------------------------------------------------ by1612's Profile: http://www.excelforum.com/member.php...fo&userid=8611 View this thread: http://www.excelforum.com/showthread...hreadid=314345 |
#4
|
|||
|
|||
thanks everyone! -- by1612 ------------------------------------------------------------------------ by1612's Profile: http://www.excelforum.com/member.php...fo&userid=8611 View this thread: http://www.excelforum.com/showthread...hreadid=314345 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
Compound interest calculation | Excel Discussion (Misc queries) | |||
How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) | |||
Hire purchase interest | Excel Worksheet Functions |