Loan Ledger Building Excel Template

Loan ledger Building template basically do the function of making record of the loan and its interest payments on loan in different periods. On loan, we give interest payments additional to the loan payments. There is specifically a stated rate of interest given when the creditor gives the loan to the debtor.

With the stated rate of interest the loan amount will be return to the creditor as loan payment+ Interest payment on loan. The loan payments gradually retire in the different periods, months or may be the years by the debtor. In other words, Loan Ledger building is also called the loan amortization table.

Advantages of using Loan Ledger Building Excel Template:

  1. This templates helps to track the information
  2. Can see how much payment retired and how much is left.
  3. You can also use this anywhere you want
  4. You can daily add the entries of the loan in the schedule template
  5. Effective way to record keeping.
  6. Printable

Guide to PRACTICE this template:

First of all, you must fill the upper section rows & columns. To Proceed Further you have to fill the upper section. Upper section Includes the following:

  1. Loan Amount: the amount you have withdrawn.
  2. Annual Interest Rate: annual % OF INTEREST rate
  3. Loan length in years: duration of the loan.
  4. Number of payments in year: how many payments occur in a year.
  5. Started Date Of loan: The date on which the loan payment withdrawn.

Then we must fill the upper right corner of the template with the data required to continue further:

Loan Ledger Building Excel Template

Scheduled Monthly Payments: of how much amount payments are given after a month that amount must be shown in this column.

Scheduled number of payments:

Actual Number of Payments: Actual Number of payments allowed in a year

Total Early Payments: the payments before Maturity

Total Interest: Interest amount on loan must be mentioned

Total Principal & Interest: Total principal loan payment plus the total interest payment.

After entering the all data above now we must move on to the lower section.

Monthly/Daily Expense Budget Planner Spreadsheet Excel Template

Lower Section of the Template:

In the lowest section, there are shown 10 columns in the template that are Following:

  1. Payment number (the number of payment as first, second, fifth etc.)
  2. Date of payment: the date on which payment is made.
  3. Beginning balance: The total Loan amount balance is the beginning balance for the first payment for the second it would be the total remaining amount of loan.
  4. Scheduled payment: the payment we enter in the upper section it would be the same for the whole year.
  5. Extra payment
  6. Total payment: total payment before interest amount addition it also remains the same whole year.
  7. Principal amount:
  8. Interest
  9. Ending balance
  10. Cumulative interest (Optional)

By entering this all the ending balance section automatically generates by the loan ledger building excel template as well as the cumulative interest.


Leave a Reply

Your email address will not be published. Required fields are marked *