the first 3 displays are the use of the arachnoid online financial calculator that provies the future value rsults.
the last display is a summary of the results and the inputs to the table that you needed to be created.
the general procedure for the use of the financial calculator were as follows:
inputs to the calculator were:
pv = 0 for all calculator displays.
fv = 0 for all calculator displays.
np = 45 * 12 = 540 for the first calculator display.
np = 30 * 12 = 360 for the second calculator display.
np = 15 * 12 = 180 for the third calculator display
pmt = -59 for the first calculator display
pmt = -100 for the second calculator display
pmt = -200 for the third calculator display
ir = 8.5/12 = .70833333333... for all calculator displays.
payment at end of time period for all calculator displays.
click on fv for all calculator displays and the results for each are as shown.
the fourth display shows the same financial analysis using excel rather than the online financial calculator.
that display also shows the excel version of the table requested.
everything you need should be in there.
total amount deposited is the monthly payments multiplied by the number of months those payments were made.
future value is the results of the financial calculations.
earned interest is the future value minus the total amount deposited.
all of that furture value minus the total amount deposited is the earned interest.
