Download Line of Credit Tracker Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Gantt Chart Conditional Formatting

One terrific, undervalued feature of a spreadsheet application like Microsoft Excel in its Gantt Chart …

Read More

Gantt Project

A Gantt Project chart is a commonly used graphical description and the portrait of a …

Read More

Girl Scout Attendance Sheet

A young lady’s experience as a Girl Scout can create some wonderful memories. So, The …

Read More

2021 Monthly Calendar Landscape

We all have different strengths, and while some of us flow through computer task with …

Read More
Search
Generic filters

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

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Line of Credit Tracker Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. 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 PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: