Accurate Construction Loan Calculator™

Borrow or pay any amount, on any date and create an accurate construction loan payment schedule.
Please rotate to see calculator
Your device is too small to show this calculator.
Here are more calculators to select from.
Construction Loan Calculator
Construction Loan Calculator

Use this construction loan calculator for multiple, irregular borrows and exact-date interest-only or P&I payments.

  • Payments can be regular or irregular
  • Print date accurate schedules.
  • Supports interest rate changes
  • NEW: Export to XLSX/DOCX files
  • NEW: YouTube video shows you how to use it.

Suitable for bankers, accountants, attorneys and you!

What's a construction loan?

A construction loan provides financing for building costs while real estate is under development. A construction loan features multiple loan amounts advanced to the borrower at agreed-upon construction milestones.

What is a construction loan calculator?

A construction loan calculator can track multiple loan advances made at irregular intervals along with the borrower's payments. The calculator will use these inputs to calculate the loan's balance.

How do you use the Accurate Construction Loan Calculator (ACLC)?

Spend a few minutes here, and I'll explain, step-by-step, how to use this calculator so you can track loan payments exactly and know the balance due as of any date.

More below

Subscribe to the Ultimate Financial Calculator for unlimited printing and file saving.

Recent changes and enhancements

  • Jan. 10, 2024: Changed the default long and short-period interest options under "Settings." This means you will not get the same results you previously hadunless you reselect your preferred setting.
  • 2023: Save any schedule's data to Word/docx orExcel/xlsx files. Click on "Schedule" then "Continue" past the title page.
  • The calculator automatically sorts the cash flow prior to file save and calculation. This fixes the issue where the "Unknown" did not calculate due to overlapping dates in different cash flow series unless the user had clicked the "Expand" button.

Granted, if you are dealing with a reputable builder, such a scenario is unlikely. But by their nature, construction loans, do save borrowers money.

Why?

The borrower is responsible for paying interest charges as they borrow the money. By lending additional amounts over time, the debt balance gradually increases, which holds down interest costs. It may not amount to a lot, but why pay more interest when it's not necessary?

On the other hand, I would be remiss if I didn't mention that interest rates will be higher for construction loans when compared with mortgage rates. The reason for the higher rate is because the lender is taking on added risk, and lenders want additional compensation for the added risk.

What are the two types of construction loans?

  • Stand-alone construction - borrower must also apply for a mortgage as a separate step in addition to the construction loan
  • Construction-to-permanent - guaranteed to convert to a mortgage, usually when the regulators issue the certificate-of-occupancy

The loan type does not impact how we set up the calculation. However, for the borrower, the "construction-to-permanent" loan is more advantageous since there is no risk to the borrower that they won't be able to obtain a mortgage.

On the other hand, a construction-to-permanent loan contract may have language that requires the borrower to convert the loan to a mortgage with the same lender or otherwise face a penalty. This requirement is a potential disadvantage to the borrower if, during construction, interest rates fall. The interest rate for the mortgage may be locked in at a higher rate.

Plus two amortization methods

After the lender starts to make loan advances to the builder, the lender will require the borrower to make regular, periodic payments. Regardless of whether the construction loan is a stand-alone or a construction-to-permanent type, there are two ways to calculate the payment amount due:

  • payment will include both principal and interest (P&I); or
  • payment will include interest-only

The Accurate Construction Loan Calculator is easily capable of handling either payment calculation and creating an amortization schedule.

This calculator is also capable of handling either home construction loans orcommercial construction loans equally as well.

Below are the step-by-step instructions. Since interest-only construction loans are the more common, we'll start with that payment method first.


All users should work through the more detailed first tutorial to understand the Ultimate Financial Calculator's (UFC) basic concepts and settings.


A Step-by-Step Tutorial
Calculate a Construction Loan with Multiple Loan Advances - Tutorial 11
How to get an accurate construction loan payoff schedule.

Interest-Only Construction Loan

To create a construction loan amortization schedule with interest-only payments, follow these steps:

  1. Set "Schedule Type" to "Loan"
    • Or click the [New] button to remove any previous entries.
  2. Click on the {Settings} {Rounding Options}, and set "Rounding" to "Adjust the last amount to reach "0" balance"
  3. In the header section, make the following settings:
    1. For "Calculate Method" select "U.S. Rule".
      • Setting U.S. Rule prevents interest from being charged on accrued, but yet unpaid interest when a new loan is advanced. Change this to "Normal" to see the difference.
    2. Set "Initial Compounding" to "Exact/Simple".
    3. Enter 5.5 for the "Initial Interest Rate".
  1. In row one of the cash flow input area, create a "Loan" series
    1. Set the "Date" to May 16
    2. Set the "Amount" to 75,000.00
    3. Set the "# Periods" to 1
      • Note: Since the number of periods is 1, you will not be able to set a frequency. If there is a frequency set, the calculator will clear it when you leave the row.
  1. Move to the second row of the cash flow input area. We will create the anticipated payment schedule series.
    1. Select "Payment" for the "Series".
    2. Set the "Date" to July 1
    3. Set the "Amount" to "Unknown" by typing "U".
    4. Set the "# Periods" to 5
      • Why 5? We expect construction to last 5 months with payments due on the 1st.
      • You can adjust this number as construction progresses.
    5. Use the [Tab] key to tab to Frequency. Select "Monthly".
    6. The calculator will automatically calculate the "End Date."
    7. Click on "Cash Flow Options". Select "Interest-Only" and then click on "Activate 'Interest-Only' payment amount for currently selected series." Click "Save Changes."
      • If you entered "1" under "# Periods", you won't see "Cash Flow Options", so set this to 2, select the interest-only option and then set the "# Periods" back to "1" if needed.
  • Your calculator should now look like this (Fig. 1):
interest-only construction loan first borrow with payment series
Fig. 1 - First borrow and anticipated interest-only payment series.
  • Construction is moving along. Enter 3 more loan advances.
  1. Create a "Loan" event in row three of the cash flow input area
    1. Reset the "Date" to July 12
    2. Set the "Amount" to $35,000.00
    3. Set the "# Periods" to 1
  2. Move to row 4. Select "Loan" for the "Series".
    1. Set the "Date" to July 26
    2. Set the "Amount" to "$40,000.00"
    3. Set the "# Periods" to 1.
  3. Move row 5. Select "Loan" for the "Series".
    1. Set the "Date" to Sept. 10
    2. Set the "Amount" to "$90,000.00"
    3. Set the "# Periods" to 1.
  • Your screen will look like this (Fig. 2):
Construction loan add three additional loan advances
Fig. 2 - Add three additional loan advances as construction progresses
  • We expect to receive the CO, and convert the construction loan to a mortgage on November 10. Calculate the construction loan's balance due including accrued interest.
  1. Move to row 6. Select "Payment" for the "Series".
    1. Set the "Date" to Nov. 10
    2. Type "U" to set the "Amount" to "Unknown"
    3. Set the "# Periods" to 1. Fig. 3
Construction loan unknown balance setup
Fig. 3 - Setup to calculate the unknown loan balance with all accrued interest.
  • Calculate the ending loan balance, i.e. final payment due. Fig. 4
Construction loan unknown balance setup
Fig. 4 - Loan balance as of Nov. 10th, $240,330.00.
($240,000 principal plus $330.00 accrued interest)
  • After calculation, row 6 shows the balance due as of the date indicated. Change the date by even a day, set to "Unknown" and recalculate. Notice the final payment changes. (Naturally, if the loan dates change, the final payment changes as well.)
  • The periodic interest payments change as additional borrows occur. Please see the amortization schedule for details.
  • If the borrower does not make the scheduled payments, click the "Expand" button, and edit the payment dates as needed
  • If (when?) construction goes beyond the expected completion date, either:
    1. Change the number of projected payments, or;
    2. If you've already expanded the inputs and changed the dates, then add a new single interest-only payment.
  • Click [Schedule] to see the interest-only payment details. Fig. 5
Construction loan two loan advances
Fig. 5 - Construction loan amortization schedule with interest-only payments

Construction Loan with Principal and Interest Payments

To create a construction loan amortization schedule with P&I payments, follow these steps:

  1. Set "Schedule Type" to "Loan"
    • Or click the [New] button to clear any previous entries.
  2. Set "Rounding" to "Adjust the last amount to reach "0" balance" by clicking on the {Settings} {Rounding Options}
  3. In the header section, make the following settings:
    1. For "Calculate Method" select "Normal".
    2. Set "Initial Compounding" to "Monthly".
    3. Enter 7.25 for the "Initial Interest Rate".
  1. In row one of the cash flow input area, create a "Loan" series
    1. Set the "Date" to September 13
    2. Set the "Amount" to 75,000.00
    3. Set the "# Periods" to 1
      • Note: Since the number of periods is 1, you will not be able to set a frequency. If there is a frequency set, the calculator will clear it when you leave the row.
  1. Move to the second row of the cash flow input area. Select "Payment" for the "Series". The regular payment amount is unknown. We need the payment size to be a manageable amount. Therefore, we'll calculate the amount assuming a 15-year term, i.e., 180 monthly payments (of course the borrower will pay it off much sooner).
    1. Set the "Date" to October 1
    2. Set the "Amount" to "Unknown" by typing "U".
    3. Set the "# Periods" to 180
    4. Use the [Tab] key to tab to Frequency. Select "Monthly".
    5. The "End Date" will automatically be calculated
  • Your calculator should now look like this (Fig. 6):
Construction loan first borrow
Fig. 6 - Construction loan — the first borrow and first payment calculation.
  1. Calculate the unknown. The result is $683.00. Fig. 7.
Construction loan first payment
Fig. 7 - First payment calculated.
  1. Reset the "# Periods" for the first payment series to 1. We do this because only one payment is made before the next loan advance is required.
  2. Create a "Loan" event in row three of the cash flow input area
    1. Reset the "Date" to October 12
    2. Set the "Amount" to $35,400.00
    3. Set the "# Periods" to 1
  3. Move to the fourth row of the cash flow input area. Select "Payment" for the "Series". The regular payment amount is unknown
    1. Set the "Date" to November 1
    2. Set the "Amount" to "Unknown"
    3. Set the "# Periods" to 179. (180 months less the one payment already made)
  • Before the calculation, your screen will look like this (Fig. 8):
Construction loan second borrow
Fig. 8 - Second borrow and second payment calculation setup
  1. Calculate the unknown. The result is now $1006.65. Fig. 9
Construction loan second payment
Fig. 9 - Second payment calculated
  • There are two more loan events - both in November.
  1. Reset the "# Periods" for the second payment series (row four) to 1.
  2. Create a "Loan" event in row five of the cash flow input area
    1. Set the "Date" to November 8
    2. Set the "Amount" to $110,500.00
    3. Set the "# Periods" to 1
  3. 2nd loan event in November
    1. Create a "Loan" event in row six of the cash flow input area.
    2. Set the "Date" to November 29
    3. Set the "Amount" to $110,500.00
    4. Set the "# Periods" to 1
  4. Move to the seventh row of the cash flow input area. Select "Payment" for the "Series". The regular payment amount is unknown
    1. Set the "Date" to December 1
    2. Set the "Amount" to "Unknown"
    3. Set the "# Periods" to 178. (180 months less the two payments already made.) Fig. 10
  • Before the calculation, your screen will look like this.
Construction loan two loan advances
Fig. 10 - Two more loan advances
  1. Calculate the unknown. The result is now $3,029.55. Fig. 11
Construction loan third payment series
Fig. 11 - Third payment series calculation
  1. Construction completed — mortgage closing on January 16th. What's the balance due?
    1. Click on the seventh row. Set the "# Periods" to "2". (For payments due Dec. 1 and Jan. 1.
    2. Click on the eighth row. Set the "Series" to "Payment"
    3. Set the "Date" to "January 16th"
    4. Set the "Amount" to "Unknown" Fig. 12
    5. Set the "# Periods" to "1"
Construction loan unknown balance
Fig. 12 - Setting up to calculate the unknown balance
Construction loan final balance
Fig. 13 - Calculated total balance due.
  1. And, as usual, if you want to see a detailed amortization schedule showing how the monthly payment gets allocated between principal and interest, click on the "Schedule" tab above the input area.
  2. Additionally, to visualize the cash flow, click on the "Charts" tab.

A couple of notes: Construction loans are not mortgages. As already mentioned, they are utilized to provide funding for building. Due to increased risk to the lender during construction, the interest rate is higher than the prevailing rate for mortgages. Therefore, construction loans get replaced with conventional mortgages at about the time a certificate of occupancy (CO) is issued. The flexibility of the UCLC gives you the ability to precisely track the multiple borrows and payments typical of these loans.

TValue is a trademmark of TimeValue Software.

6 Comments on “Construction Loan Calculator”

Join the conversation. Tell me what you think.
  • Anthony Hosseini says:

    Hello:

    On row 2 of the cash flow, series option doesnt allow me to adjsut as the first row of the cash flow it was defaulted giving me options.
    Thank you.

    Anthony

    • Sorry, but I don’t think I understand. Are you saying that the series option/setting (the dropdown) doesn’t give you choices in the 2nd row. If you have selected "Loan" in the first row, then you should have choices for loan, payment, extra payment, etc. in the 2nd row. If this is not what you see, please provide me with all the details of all inputs for both rows.

      Just curious, if you step through the samples in the text on the page, can you do each of those steps.

      What browser are you using? Are you on a desktop computer?

      No one has reported any issues.

  • Is there a way to save results from free calculators?
    Thanks,
    Ray

  • Thank you! This is perfect. I tried creating my own spreadsheet to work this out. I could get there eventually, but it’d be pretty crude.

    Will C-Value run more or less the same way? I’d like to support you and I’d also like to be able to save my work.

Comments, suggestions & questions welcomed...

Your email address is not published. I use it only to notify you of a reply.

Let me know if you have a website. I might like to visit it.

* Required