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