![]() |
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? |
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? |
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? |
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