Question 1185955
the future value is 20,000.
the number of quarterly payments = 17 years * 4 = 68 quarters.
the interest rate per quarter = 5% / 4 = 1.25% per quarter.


the calculator at <a href = "https://arachnoid.com/finance/index.html" target = "_blank">https://arachnoid.com/finance/index.html</a> can get the answer for you.


here are your inputs.


<img src = "http://theo.x10hosting.com/2021/101301.jpg" >

here is your output.


<img src = "http://theo.x10hosting.com/2021/101302.jpg" >


your inputs are everything except pmt.
your output is pmt.


the quarter by quarter remaining balance, payment, interest part of payment, equity part of payment, are shown below for the first few quarters and the last few quarters.


<img src = "http://theo.x10hosting.com/2021/101305.jpg" >


<img src = "http://theo.x10hosting.com/2021/101306.jpg" >


the procedure for each time period is shown by the following example:


the payment and the interest in time period 62 is added to the remaining balance in time period 61 to get the remaining balance in time period 62.


that would be 17079.43 + 188.34 + 213.49 = 17481.26.


the difference in this value plus what is shown in the spreadsheet (17481.47) has to do with rounding.
the numbers shown in the spreadsheet are rounded.
the actual calculations are done with unrounded numbers not shown in the display.


for example:
the actual remaining balance in time period 61 is equal to 17079.42849.
the actual payment amount is 188.3448429.
the actual interest is 17079.42849 * .04/5 = 213.4928561.
17079.42849 + 213.4928561 + 188.3448429 =  17481.26619.
round that to 2 decimal digits and it equals 17481.27 as shown in the excel results for remaining balance in time period 62.