Create Progressive Payment Calculator in Excel: 2 Steps

Step 1 – Setting Up the Dataset

  • Create the following fields.

Setting Up Dataset to Create Progressive Payment Calculator in Excel

  • Insert a table with five columns: “Estimated Time (Months),” “Particulars,” “Percentage,” “Amount,” and “Monthly Payment.”

Step 2 – Calculating the Progressive Payment

  • Type in the property price, cash amount, interest rate, and loan tenure.
  • Insert the following formula to find the bank loan amount.


Calculating Progressive Payment to Create Calculator in Excel

  • Type the values for the first three columns.
  • Use this formula in cell E11 and drag the Fill Handle down to fill the column.


  • Insert this formula to calculate the monthly payment.


Formula Breakdown

  • We are using a dynamic range inside the SUM function. This is the main step for finding the progressive payment.
  • The interest rate is provided per annum. We are dividing it by 12 to find the monthly interest rate.
  • Our cash amount is $40,000 and we do not need to pay anything until this value depletes. Calculate it from row 15. You should modify this to fulfill your requirements.
  • We multiply the above two values by the property price to return the monthly payment.

Download the Practice Workbook

Related Articles

<< Go Back to Payment Calculator | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Haq
Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF