document.write( "Question 1177938: https://gyazo.com/af87e081fdb88045fac3d3d64f6e24e0 \n" ); document.write( "
Algebra.Com's Answer #807184 by Theo(13342)\"\" \"About 
You can put this solution on YOUR website!
your solution is shown in the following displays.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the first 3 displays are the use of the arachnoid online financial calculator that provies the future value rsults.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the last display is a summary of the results and the inputs to the table that you needed to be created.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the general procedure for the use of the financial calculator were as follows:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "inputs to the calculator were:\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "pv = 0 for all calculator displays.
\n" ); document.write( "fv = 0 for all calculator displays.
\n" ); document.write( "np = 45 * 12 = 540 for the first calculator display.
\n" ); document.write( "np = 30 * 12 = 360 for the second calculator display.
\n" ); document.write( "np = 15 * 12 = 180 for the third calculator display
\n" ); document.write( "pmt = -59 for the first calculator display
\n" ); document.write( "pmt = -100 for the second calculator display
\n" ); document.write( "pmt = -200 for the third calculator display
\n" ); document.write( "ir = 8.5/12 = .70833333333... for all calculator displays.
\n" ); document.write( "payment at end of time period for all calculator displays.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "click on fv for all calculator displays and the results for each are as shown.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the fourth display shows the same financial analysis using excel rather than the online financial calculator.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "that display also shows the excel version of the table requested.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "everything you need should be in there.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "total amount deposited is the monthly payments multiplied by the number of months those payments were made.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "future value is the results of the financial calculations.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "earned interest is the future value minus the total amount deposited.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "all of that furture value minus the total amount deposited is the earned interest.\r
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "the arachnoid financial calculator can be found at https://arachnoid.com/finance/index.html\r
\n" ); document.write( "
\n" ); document.write( "
\n" ); document.write( "\n" ); document.write( "
\n" ); document.write( "
\n" );