document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=167256>Question 167256</A>: <I><SPAN STYLE=\"word-break: break-all;\"> HI,<BR>\n" );
document.write( "It's been decades since I last worked in serious algebra but have hit a mathematical problem that I cannot solve.  Your help would be tremendously appreciated.\r<BR>\n" );
document.write( "\n" );
document.write( "Starting Amount = 3,000,000 (- variable c)<BR>\n" );
document.write( "Ending Amount = 0<BR>\n" );
document.write( "Number of Years to withdrawl amounts = 10 (- variable y)<BR>\n" );
document.write( "Withdrawl Amounts increase annually by 3% [inflation rate] (- variable f)<BR>\n" );
document.write( "Each years remaining amount (- variable r) increases by 3.75% [interest rate] (- variable i) = interest (- variable z)<BR>\n" );
document.write( "Each annual withdrawal amount so far is unknown. (- variable x)<BR>\n" );
document.write( "Solve for the initial [first year] withdrawal amount (x).<BR>\n" );
document.write( "Provide a formula to calculate the first x with theb given values above.\r<BR>\n" );
document.write( "\n" );
document.write( "Known Formulas I have figured out that do work with these values:<BR>\n" );
document.write( "Note c = 0.00 in year <IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=last+y+%2B+1 ALIGN=MIDDLE  ALT=\"last+y+%2B+1\"   DISABLED_style= \"max-width:90%; height:auto;\" >\r<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=c+-+x+=+r ALIGN=MIDDLE  ALT=\"c+-+x+=+r\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=r+%2A+i+=+y ALIGN=MIDDLE  ALT=\"r+%2A+i+=+y\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=r+%2B+z+=+next+c ALIGN=MIDDLE  ALT=\"r+%2B+z+=+next+c\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=+next+x+=+x+%2B+%28x+%2A+f%29 ALIGN=MIDDLE  ALT=\"+next+x+=+x+%2B+%28x+%2A+f%29\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=c+=+%28next+c+%2B+x+%2B+%28i+%2A+x%29%29%2F%281+%2B+i%29 ALIGN=MIDDLE  ALT=\"c+=+%28next+c+%2B+x+%2B+%28i+%2A+x%29%29%2F%281+%2B+i%29\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=+last+x+=+first+x+%2A+%281+%2B+f%29%5E%28y+-+1%29 ALIGN=MIDDLE  ALT=\"+last+x+=+first+x+%2A+%281+%2B+f%29%5E%28y+-+1%29\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=+last+c+in+year+10+=+last+x+in+year+10+ ALIGN=MIDDLE  ALT=\"+last+c+in+year+10+=+last+x+in+year+10+\"   DISABLED_style= \"max-width:90%; height:auto;\" ><BR>\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=+last+r+=+0+ ALIGN=MIDDLE  ALT=\"+last+r+=+0+\"   DISABLED_style= \"max-width:90%; height:auto;\" >\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "A sample table with accurate figures doing the same mathematical calculations as needed above but for 3 years instead of 10 is shown below. For this data, all other constants from above remain unchanged.  \r<BR>\n" );
document.write( "\n" );
document.write( "y____Funds (c)___Withdrawal(x)__Balance (r)____interest(z)<BR>\n" );
document.write( "1__3,000,000.00__1,007,263.88__1,992,736.12__74,727.60<BR>\n" );
document.write( "2__2,067,463.72__1,037,482.80__1,029,981.93__38,624.32<BR>\n" );
document.write( "3__1,068,606.25__1,068,606.25_____0.00)_______(0.00)<BR>\n" );
document.write( "4_____(0.00)\r<BR>\n" );
document.write( "\n" );
document.write( "As you can see, I have the figures.  What I need is the formula so that I can do this in excel.\r<BR>\n" );
document.write( "\n" );
document.write( "Again, many thanks for your help if your able.<BR>\n" );
document.write( "Rick </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #123281 by </B><A HREF=/tutors/aboutme.mpl?userid=oscargut><B>oscargut(2103)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=oscargut><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/cgi-bin/show-face.mpl?user=oscargut><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=123281\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> Hi, it is a nice problem, i solved.<BR>\n" );
document.write( "If you want more details please contact me<BR>\n" );
document.write( "( solution is too long to put it here)<BR>\n" );
document.write( "If you want i can do excel file too<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );