Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #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



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


Not what I am looking for


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Calculate Interest Rate when payment changes! huntermcg Excel Worksheet Functions 2 October 25th 05 08:32 AM
How can we use Excel to calculate interest with daily compounding Duke Carey Excel Discussion (Misc queries) 0 June 1st 05 12:08 AM
Vlookup and Indexing in excel CLSCHWIES Excel Worksheet Functions 2 December 4th 04 01:57 AM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"