document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=1115525>Question 1115525</A>: <I><SPAN STYLE=\"word-break: break-all;\"> 1. <BR>\n" );
document.write( "a.) You loan a friend $200 and are repaid $30 at the end of each month for the first 3 months and $120 at the end of the fourth month.  What is your rate of return?\r<BR>\n" );
document.write( "\n" );
document.write( "b.) You loan a friend $200 and are repaid $120 at the end of the first month and $30 at the end of each month for the next three months.  What is your rate of return? </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #730412 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=730412\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> results are in the picture of my excel spreadsheet shown below.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<IMG STYLE=\"max-width:80%;\" src = \"http://theo.x10hosting.com/2018/042302.jpg\"alt=\"$$$\" >\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the net present value at the indicated rate of return is zero, as it should be.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the yearly rate of return is the nominal yearly rate of return, which is the monthly rate of return * 12.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the internal rate of return is calculated using the irr(data set)) function of excel.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the data set for cf1 is in cells d4 to d8.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the data set for cf2 is in cells f4 to f8.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the npv is calculated using the npv(rate, data set) function of excel.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the rate used for cf1 is in cell d10.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the rate used for cf2 is in cell f10.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );