Loan and mortgage repayment calculator worksheet with answers

GCSE: Higher Tiers are typical for England, Wales and Northern Ireland specifications. Boards differ, so check your own specification.

10 practice questions on loan and mortgage repayment calculator. Print the questions on their own, or with the answers. Worked solutions for any question are one click away in the solver.

Open the Worksheet Studio
  1. monthly payment on a mortgage of 200000 at 5% over 25 years
  2. monthly payment on a loan of 10000 at 0% over 2 years
  3. monthly payment on a loan of 5000 at 7% over 3 years
  4. monthly payment on a loan of 11656 at 0% over 3 years
  5. monthly payment on a loan of 4805 at 9% over 6 years
  6. monthly payment on a mortgage of 195748 at 5% over 24 years
  7. monthly payment on a loan of 10351 at 0% over 1 years
  8. monthly payment on a loan of 4051 at 4% over 3 years
  9. monthly payment on a mortgage of 195931 at 5% over 23 years
  10. monthly payment on a loan of 8593 at 0% over 4 years

Answers

  1. monthly payment on a mortgage of 200000 at 5% over 25 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  2. monthly payment on a loan of 10000 at 0% over 2 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  3. monthly payment on a loan of 5000 at 7% over 3 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  4. monthly payment on a loan of 11656 at 0% over 3 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  5. monthly payment on a loan of 4805 at 9% over 6 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  6. monthly payment on a mortgage of 195748 at 5% over 24 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  7. monthly payment on a loan of 10351 at 0% over 1 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  8. monthly payment on a loan of 4051 at 4% over 3 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  9. monthly payment on a mortgage of 195931 at 5% over 23 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

  10. monthly payment on a loan of 8593 at 0% over 4 years
    Show the working
    1. Monthly rate and number of payments
      The yearly rate is split into 12 equal monthly rates.
    2. Repayment formula
      P is the amount borrowed, r the monthly rate and n the number of months.
    3. Substitute
    4. Monthly payment
      Rounded to the nearest penny.
    5. Total repaid and interest
    6. Check: pay the loan off month by month
      Each month: balance × (1 + r) − payment. It ends at zero, so the payment is right.

    Open this question in the solver

Learn the method: Loan and mortgage repayment calculator solver and worked examples. All worksheets: worksheet index.