How to Calculate Daily Interest1
How to Calculate Daily Interest
Gather the information needed to calculate interest.
hours
longer
Launch a computer spreadsheet application to help you calculate interest.
minutes
hours
Assign labels in column A rows 1-4 for the Principal Interest Rate Periods and Daily Interest.
days
minutes
Enter the details for your specific transaction in column B rows 1-3 to coincide with the labels.
days
hours
Create a function in cell B4 to calculate the annual interest as a daily amount.
hours
minutes