ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Financial formula to calculate interest income (https://www.excelbanter.com/excel-discussion-misc-queries/78735-financial-formula-calculate-interest-income.html)

JR573PUTT

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


Niek Otten

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




JR573PUTT

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com