document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=1195619>Question 1195619</A>: <I><SPAN STYLE=\"word-break: break-all;\"> Suppose you invest $150 a month for 5 years into an account earning 8% compounded monthly. After 5 years, you leave the money, without making additional deposits, in the account for another 25 years. How much will you have in the end?\r<BR>\n" );
document.write( "\n" );
document.write( "$\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Suppose instead you didn't invest anything for the first 5 years, then deposited $150 a month for 25 years into an account earning 8% compounded monthly. How much will you have in the end?\r<BR>\n" );
document.write( "\n" );
document.write( "$<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #828420 by </B><A HREF=/tutors/aboutme.mpl?userid=Theo><B>Theo(13342)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=Theo><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=Theo><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=828420\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> your answers using the calculator at <a  rel=nofollow HREF= \"https://arachnoid.com/finance/\" target = \"_blank\">https://arachnoid.com/finance/</a> are:\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080701.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080702.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080703.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the same answers using an excel spreadsheet are:\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080704.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080705.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2022/080706.jpg\">\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the procedure using the calculator is as follows:\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "first you want to find the future value of monthly payments of 150 at 8% compounded monthly for 60 months (5 years).<BR>\n" );
document.write( "that value is 11021.53.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "next you want to find the future value of that amount at 8% compounded monthly for 300 months (25 years).<BR>\n" );
document.write( "that value is 80899.97.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "next you want to find the future value of monthly payments of 150 at 8% compounded monthly for 300 months (25 years).<BR>\n" );
document.write( "that value is 142653.96.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the excel spreadsheet does the same calculations month by month.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "column A shows the end of month indicated.<BR>\n" );
document.write( "column B shows the remaining balance of the first calculation which is 60 months of 150.<BR>\n" );
document.write( "column C shows the remaining balance of the results from column B being brought forward for an additional 300 months with no additional payments.<BR>\n" );
document.write( "column D shows the remaining balance of monthly payments of 150 for 300 months.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "let me know is you have any questions.<BR>\n" );
document.write( "theo\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );