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

Your question has been answered one minute ago.
Even if the answer doesn't help you completely, please stay in the same thread, otherwise many people might spend efforts for
something already solved.

--
Kind regards,

Niek Otten

"JR573PUTT" wrote in message
...

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