View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR573PUTT
 
Posts: n/a
Default Financial formula to calculate interest income


I have the following spreadsheet:

column a
Year
2006

column b
Beginning balance
25000

column c
yearly contribution
10000

column d
Interest Rate
15%

column e
Interest Income
??

column f
Ending Balance
Beg bal + yr contr + Int income

Contributions would be made at the beginning of year. Interest rate is
annual interest rate.

WHAT IS THE FORMULA FOR THE INTEREST INCOME?


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=524970