Answer:
Microsoft Excel, pmt function.
Explanation:
Microsoft Excel is a spreadsheet application used to manipulate and analyse data. It has several functions and tools to work with. An excel workbook can contain multiple worksheets. It has columns (or field) labelled alphabetically and also numbered rows ( or record).
The PMT function is a financial function used to calculate the periodic payment of loans. It's syntax is;
=PMT(interest rate increase, loan period, loan amount).
For example, if the interest rate increase is annual, and the value is a cell B7, the input would be B7/12. If the value of the loan period and amount are referenced in cells B6 and B5 respectively, the function would be ;
=PMT(B7/12, B6, B5).
But this will give a negative result. For positive result;
=PMT(B7/12, B6, -B5)
Now to make excel pick values from a specified group of cells, they are made absolute by adding the '$' to the columns and rows.
=PMT($B$7/12, $B$6, -$B$5).
The result would positive values spanning to twelve months with interest rate.
