I am trying to calculate the unpaid balance of a mortgage for a given payment period, using a spreadsheet function. For example, on a loan of £200,000 with an interest rate of 5.4% and a repayment period of 25 years, how could I calculate the amount to be repaid in the 24th month of the [...]

Can somone show me how to calculate a mortgage payment like for example what is the monthly payment on a $200,000 mortgage at 6% interest over 25 years? Can somone show me how to calculate a mortgage payment like for example what is the monthly payment on a $200,000 mortgage at 6% interest over 25 [...]