Generic filters

Line of Credit Tracker Excel Template

Are a small business owner or small-time lender wanting to track a line of credit? If you have tried our other line of credit calculator. You will find that it is design for estimating costs is fairly general assumptions about when payments and draws are made. Our new Line of Credit Tracker below is design particularly for tracking when payments, draws, and changes in interest rate occur.

Line of credit tracker excel

This line of credit tracker is use to track payments and draws a line of credit that accrues interest daily on the current principal balance.

BETA Version: This spreadsheet can be considered a “beta” version as it has not yet been used enough to guarantee that it is free of errors.

Note to Lenders: If you are using this spreadsheet to service an account that you are offering a client, make sure that the calculations and assumptions match what you have specified in your contract.

Estimating an Interest Reserve:

1. Enter the planned or actual disbursements by including the dates and draw amounts.

2. If your line of credit transitions to a loan at any date, enter the date the loan converts to a standard loan.

3. The Total Interest Accrued amount would then be an estimate of what you need in an Interest Reserve account.

What to do when the interest rate changes:

Any time the interest rate changes, you should enter the date and also a 0 payment. This will update the accrued interest and consequently calculations will use the new rate.

Assumptions built into this spreadsheet

  • Interest accrues on a daily basis, like other lines of credit. The Days in Year value should be 365 or 360 depends on how the lender calculates “per diem” interest.
  • Interest are calculated using the simple interest formula will not add to the principal balance. The Total Owned is the Principal Balance plus the Unpaid Interest Balance.
  • Payments can apply at the end of the previous day. A payment is applicable FIRST to the Interest Accrued and Interest Balance, and then to the Principal.
  • The Interest Accrued amount is round to the nearest cent.
  • Interest is charge on a Draw on the day it is prepared.
  • Principal-Only payments is stimulate by entering a negative draw amount.
Download Line of Credit Tracker Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: