document.write( "Question 1108784: You have $100000 to invest at 4% interest.if you wish to withdrawal equal annual payments for 4 years, how much couid you withdrawal each year and leaves $0 in the investment account? \n" ); document.write( "
Algebra.Com's Answer #724016 by Theo(13342)\"\" \"About 
You can put this solution on YOUR website!
100,000 is invested at 4% interest peryear.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "you wish to withdraw money at the end of each year, for 4 years and have 0 in the account at the end of the fourth year.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "your withdrawal amount would be equal to 27,549.00454 each month.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the year by year calculations are shown below:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\"$$$\"\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the calculation of the withdrawal was done using the TI-BA-II financial calculator.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "in this calculator, the entries were made as follows:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "N = 4
\n" ); document.write( "I/Y = 4 (% is assumed by the calculator).
\n" ); document.write( "PV = -100,000 (no comma)
\n" ); document.write( "FV = 0\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "then 2nd PMT gets you the withdrawal amount.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the calculator shows the withdrawal as 27,549.00454.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "that's a rounded number.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the actual number goes out for more digits.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the excel printout uses a similar formula, only it carries out the result to more decimal digits.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the formula in excel is =PMT(rate,nper,pv,[fv],[type])\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "if fv is 0 and type is end of time period payments/withdrawals, then the formula used can be PMT(rate,nper,pv), which is what i used, because fv is assumed to be 0 and end of time period payments are assumed.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "there is also a manual formula that can be used to calculate the withdrawal.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "that formula is shown below:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "ANNUITY FOR A PRESENT AMOUNT WITH END OF TIME PERIOD PAYMENTS \r
\n" ); document.write( "\n" ); document.write( "a = (p*r)/(1-(1/(1+r)^n)) \r
\n" ); document.write( "\n" ); document.write( "a is the annuity.
\n" ); document.write( "p is the present amount.
\n" ); document.write( "r is the interest rate per time period.
\n" ); document.write( "n is the number of time periods. \r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "with this formula:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "a is what you want to find.
\n" ); document.write( "p is the present amount = 100,000 (without the comma).
\n" ); document.write( "r is the interest rate per year = .04 (not the interest rate percent).
\n" ); document.write( "n is the number of year = 4\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "formula of a = (p*r)/(1-(1/(1+r)^n)) becomes:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "a = (100000*.04)/(1-(1/(1+.04)^4)) \r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "solve for a to get a = 27549.00454.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "when you enter the formula in your calculator, make sure the parentheses are entered exactly as shown in the formula.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "your solution, rounded to 2 decimal digits, is that you would withdraw 27,459.00 at the end of each year.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "
\n" ); document.write( "
\n" );