Create Progressive Payment Calculator in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will learn about three quick steps on how to create a progressive payment calculator in Excel. We will be using the Microsoft 365 version. However, you can use any version of Microsoft Excel and follow this tutorial.


Concept of Progressive Payment

When you want to buy a property that is under construction and take loans from the bank, you do not need to pay back the loans in full installments. The installment rises as the property completion rate gets higher. Moreover, you will only need to pay the interest amount for the beginning period of the project.


Create Progressive Payment Calculator in Excel: with Easy Steps

We will show you two quick steps to create a progressive payment calculator. In the first step, we will set up the dataset for our calculation. After that, we will use several formulas to complete the payment calculation process.


Step 1: Setting Up Dataset

We will type in all the fields in this first step. Firstly, we will create the loan details section. After that, we will create the section for the progressive payment calculator details.

  • To begin with, create the following fields.

Setting Up Dataset to Create Progressive Payment Calculator in Excel

  • Afterward, type the following section with the five columns consisting of “Estimated Time (Months)”, “Particulars”, “Percentage”, “Amount”, and “Monthly Payment”.

Read More: How to Create Annual Loan Payment Calculator in Excel


Step 2: Calculating Progressive Payment

We will start by calculating the total amount of bank loans obtained. After that, we will use the percentage completion amount to calculate the payment values. Additionally, we will use the SUM function in this section to calculate various values.

  • Firstly, type the property price, cash amount, interest rate, and loan tenure.
  • Secondly, insert the following formula to find the bank loan amount.

=D4-D5

Calculating Progressive Payment to Create Calculator in Excel

  • Thirdly, type the values for the first three columns.
  • Fourthly, use this formula in cell E11 and drag the Fill Handle to fill the formula downward.

=$D$4*D11

  • After that, insert this formula to calculate the monthly payment.

=$D$4*SUM($D$15:D15)*$D$7/12

Formula Breakdown

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

Read More: How to Create Snowball Payment Calculator in Excel


Download Practice Workbook

You can download the Excel file from the link below.


Conclusion

We have shown you quick steps on how to create a progressive payment calculator in Excel. If you face any problems regarding these methods or have any feedback for me, feel free to comment below.

However, remember that our website implements comment moderation. Therefore, your comments may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Thanks for reading, keep excelling!


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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

 

 

ExcelDemy
Logo