Overview

This template will help you calculate loan and interest balances, accrued interest at any point in time on loans granted or issued.

 

I have tried to make this tool as flexible as possible. As such, it allows you to:

 

  • Choose the calculation period (1, 3 etc. month). This is the period for which the calculations are performed and accrued interest amounts and loan and interest balances are provided.
  • Set the interest period (1 month, 3 months etc.). This is the period at the end of which accrued interest is treated in some way (see below)
  • Specify interest treatment at the end of each interest period (repay, capitalize or include into accumulated interest balance)
  • Select the daycount method (30/360, actual/actual, actual/365 etc.)
  • Set varying interest rates for different periods
  • Include several loan drawdowns at different dates
  • Implement various repayment schedules (regular repayments for the same amount or a customized schedule with different amounts and dates)
  • Include accrued interest into the repayment amount or make interest repayments on top of it
  • Provide an interest-free period, skip principal and interest repayments for a certain period in the beginning

 

The template includes a summary grouping the amounts by larger intervals (annual, quarterly) and indicating:

 

  • Opening and closing principal and interest balances
  • Accrued and capitalized/repaid interest during the period
  • Principal drawn and repaid during the period

 

The template can be used on a stand-alone basis (to perform just loan calculations) or as part of a larger budgeting package. It can also be incorporated into investment analysis models. Finally, you can use it as a learning tool to understand the real-life loan calculations.

 

The publication includes an Excel file and a text guide with explanations.

Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Hotel Acquisition Financial Model
280
0
This is a detailed, well-structured and transparent cash flow model for an acquisition of a hotel. The model includes the…
Hotel Development Financial Model
314
1
This is a detailed, well-structured and transparent cash flow model for the development of a hotel. The model includes the…
Rent Roll Analysis and Stacking Plan
1,876
2
I. RENT ROLLA rent roll is a table listing the tenants of a real estate asset, showing how much area…
Complete Three-Statement Quarterly Budget
1,959
1
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Quarterly Budget with Scenarios
1,716
4
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
Complete Three-Statement Monthly Budget
1,644
0
This is a comprehensive set of templates which will help you build your budgets. The templates are built based on…
See All