Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Calculation based on a condition | Excel Worksheet Functions | |||
find calculation function | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Fixed Duration-strange calculation | New Users to Excel |