| sinking fund calculator???? |
|
|
|
|
|
edvosnc
New Poster
Cash: $ 0.45
Posts: 2
Joined: 09 Jan 2011
Location: Raleigh, North Carolina
|
| sinking fund calculator???? |
 |
|
Hi,
I am looking for what I think is called a sinking fund calculator, however none of the sinking fund calculators I have found have all of these inputs and this output if you know of any online calculators that will answer these questions please post the link. - Thanks
To summarize using below example amounts: if I have 500k today and it earns 4% I want to know what amount I can withdraw each month for 30 years and leave nothing left over.
A Starting amount, INPUT for example 500k
B anticipated earnings INPUT 4%
C amount left over INPUT 0
D how many months withdraws last to reach amount C INPUT 360 nmonths
The answer I am looking for is:
E - MONTHLY AMOUNT that can be withdrawn for (D) months starting with $A earning B% a year and leaving this amount C
An inflation component would be nice to.
|
Sun Jan 09, 2011 11:14 pm |
|
|
coaster
Senior Advisor
Cash: $ 1357.80
Posts: 6686
Joined: 11 Oct 2005
Location: Wisconsin
|
Actually, that sounds more like an annuity than a sinking fund. Excel has a number of functions that handle annuity scenarios. Also found a number of annuity calculators online, though beware, many of them are on sites trying to sell you an annuity. This one here looks interesting; let me know if it answers your scenario:
immediate annuity calculator
That one looks like it has the inputs/outputs you want, though if not, I think that to be more precise what you want to look for is a calculator for "term certain fixed annuity"
|
|
Mon Jan 10, 2011 4:25 pm |
|
|
edvosnc
New Poster
Cash: $ 0.45
Posts: 2
Joined: 09 Jan 2011
Location: Raleigh, North Carolina
|
| Thanks! |
|
|
That seems correct - Thank You. I'm guessing it assumes $zero left at the end of the period and thats what I want t anyway. That is true I am not looking to buy an annuity I just want to know how much I can withdraw monthly, expecting some growth and realizing I will eventually use all of the principal - Thanks again - Ed
|
|
Mon Jan 10, 2011 5:44 pm |
|
|
coaster
Senior Advisor
Cash: $ 1357.80
Posts: 6686
Joined: 11 Oct 2005
Location: Wisconsin
|
Ah, OK ... that's a retirement income calculator!! 
Heh heh ... they're all pretty much the same math, whatever you care to call it, just making different assumptions and different inputs/outputs. If it is for retirement income in your case, you'll want a life expectancy calculation built in to the model.
|
|
Mon Jan 10, 2011 10:43 pm |
|
|
|
