Daily Compounding Loan Calculator
Download a spreadsheet for analyzing and tracking a Daily Compounding Loan. This calculator is based on our simple interest loan calculator, which accrues interest on a daily basis and allows you to track your payments by entering the actual dates and amounts paid. However, in the daily compounding calculator, interest compounds daily AND unpaid interest is added to the principal balance (like a credit card).
Important: Unless you are absolutely sure that you have a daily compounding loan, do not use this spreadsheet. Vertex42 provides many different loan calculators, but they are all designed for specific types of loans and it is important that you don't use the incorrect one.
Daily Compounding Loan Calculator
for Excel
Template Details
(not for distribution or resale)
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Description
This spreadsheet includes two different worksheets. The first one lets you create an estimated amortization schedule for a daily compounding loan, with assumptions such as payment frequency, interest rates, etc.
The second worksheet shown in the image to the right lets you enter actual payment dates and amounts. The interest is calculated based on the dates you enter (using a daily compounding formula). To see how daily compounding works, you can enter a row for every day. This will show that interest is being added to the principal every day.
If your credit card charges interest based on daily compounding (or using an average daily balance), then this spreadsheet may provide a way to analyze and track your credit card. Add new purchases by entering negative values into the Payment column. Enter a date with a zero payment to calculate the balance on a specific date (such as your credit card statement date).
References
- Negative Amortization at Vertex42.com - Read this article if you are planning to use the above spreadsheet. Negative amortization (paying interest on interest) applies here because the compound period (daily) is shorter than the payment period (monthly).
