ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What calculation can I use to find income on a fixed investment? (https://www.excelbanter.com/excel-discussion-misc-queries/91980-what-calculation-can-i-use-find-income-fixed-investment.html)

Ken K

What calculation can I use to find income on a fixed investment?
 
Does anyone have a calculation to find a monthly income on a fixed amount
investment?

tim m

What calculation can I use to find income on a fixed investment?
 
Need a bit more information perhaps. Are you drawing money from this fixed
amount? Is this investment making a fixed rate of interest? Is there a
specific period of time you want to draw money from the investment?

"Ken K" wrote:

Does anyone have a calculation to find a monthly income on a fixed amount
investment?


Ken K

What calculation can I use to find income on a fixed investmen
 
Thanks for the response, yes a fixed amount with a fixed interest rate and no
specific period of time. What I am trying to accomplish is how much I need to
put away at a fixed rate to replace a fixed income I now receive.

Thanks,

Ken

"tim m" wrote:

Need a bit more information perhaps. Are you drawing money from this fixed
amount? Is this investment making a fixed rate of interest? Is there a
specific period of time you want to draw money from the investment?

"Ken K" wrote:

Does anyone have a calculation to find a monthly income on a fixed amount
investment?


Fred Smith

What calculation can I use to find income on a fixed investmen
 
Calculating interest income is a simple percentage calculation. Suppose you need
$2000/month of income, and you expect to make 5%/yr on your money. The capital
you would need is:

=(2000*12)/.05

If you want to spend both the interest and principal, you would calculate the
present value required, as in:

=PV(5%/12,#months required,2000)

--
Regards,
Fred


"Ken K" wrote in message
...
Thanks for the response, yes a fixed amount with a fixed interest rate and no
specific period of time. What I am trying to accomplish is how much I need to
put away at a fixed rate to replace a fixed income I now receive.

Thanks,

Ken

"tim m" wrote:

Need a bit more information perhaps. Are you drawing money from this fixed
amount? Is this investment making a fixed rate of interest? Is there a
specific period of time you want to draw money from the investment?

"Ken K" wrote:

Does anyone have a calculation to find a monthly income on a fixed amount
investment?





All times are GMT +1. The time now is 01:33 PM.

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