Download Article
Determine daily and compounding daily interest rates with simple math
Download Article
Loans, savings accounts, and credit cards all accrue interest over time. If you’re paying back a credit card bill or looking for the best time to take out a loan, calculating daily interest can give you a better idea of your finances. To calculate daily interest, multiply the balance of your account or principal of the loan by the interest rate or APR, then divide by 365. There are different kinds of interest, however, so we made an easy-to-follow guide that goes over how to calculate daily compounding interest, as well as daily interest.
Steps
-
Divide your percent interest rate by 365. Loans, savings accounts, and credit cards often have annual interest rates. If you have a credit card, you may want to divide by your APR (Annual Percentage Rate), instead. [1] X Research source
- APR takes fees into account, as well as interest, and is often 0.1 - 0.5% higher than your interest rate. [2] X Research source
- An annual interest rate of 0.5% is 0.00137% daily.
-
Multiply the principal by the decimal form of the daily interest rate. Divide your interest rate by 100 to convert it into a decimal. [3] X Research source For example, 0.00137% becomes 0.0000137.
- If the principle is $10,000, the daily interest is 10,000 * 0.0000137 = $.1370. Rounded up, this account will earn approximately $.14 per day. [4] X Research source
Advertisement -
Check your math. Multiply the principal, $10,000, by the annual percentage rate of .5 percent or .005 to calculate interest manually. The answer is $50.00. Multiply the daily interest amount of $.1370 by 365 days; the answer is also $50.00.
Advertisement
-
Gather the information needed to calculate interest. This includes the amount of money you will be investing or saving, the length of the term, and the proposed interest rates. You may have several sets of variables if your intention is to compare alternatives. [5] X Research source
- You will need to prepare a calculation for each alternative to complete your comparison.
-
Label your data in the first column of a spreadsheet. Assign labels in column A, rows 1-4, for the Principal, Interest Rate, Periods, and Daily Interest. These labels are for your reference only. [6] X Research source
- You can expand the cell by clicking on the right line of the column number, A, B, or C, etc., then using the arrows to drag the edges of the cell.
-
Enter your data in column B, rows 1-3, to coincide with the labels. Convert the percent interest to a decimal by dividing it by 100, then divide it by 365 to get the daily rate. Use the number of days of your investment or loan as your period. Leave cell B4 (Daily Interest) blank for now. [7] X Research source
- The interest rate is usually shown as an annual figure; which is why it needs to be divided by 365 to reach the daily interest rate.
- For example, if your principal to invest is $10,000, and your savings account offers .5 percent annual interest, enter "10000" in cell B1 and "=.005/365" in cell B2.
- The number of periods determines how long your investment will remain in the account untouched, except for the added compounding interest.
-
Create a function in cell B4 to calculate the annual interest as a daily amount. Click on cell B4 to select it, then click inside the formula bar. Type =IPMT(B2,1,1,-B1)" in the formula bar. Press the Enter key. [8] X Research source
- The daily interest earned on this account, for the first month, is $.1370 per day.
Advertisement
-
Enter your principal, interest rate, and number of years on a spreadsheet. Assign labels in column A, rows 1-5, for the Principal, Interest Rate, Period (days in a year), Number of Years and Compound Interest Balance. Enter the data for each in cells B1-B4. The period is 365, and the number of years is how long you plan to keep money in the account. [9] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- For example, principal = $2,000, interest rate = 8% or .08 (divide percentages by 100 to get their decimal value), compounding periods = 365 and the number of years is 5.
-
Write =B1*(1+B2/B3)^(B4*B3) in cell B5 and click enter. This is the daily compound interest formula. [10] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source Compounded daily, the total principal and interest earned balance is $2983.52 after 5 years. This shows how beneficial it can be to reinvest your interest.
- The formula breakdown is: Initial investment * (1 + Annual interest rate / Compounding periods per year) ^ (Years * Compounding periods per year). The ^ indicates an exponent. [11]
X
Research source
- For example, using the same information from Step 3, principal = $2,000, interest rate = 8% or .08, compounding periods = 365 and the number of years is 5. Compound interest =2,000 * (1 + .08/365) ^ (5 * 365) = $2983.52.
- The formula breakdown is: Initial investment * (1 + Annual interest rate / Compounding periods per year) ^ (Years * Compounding periods per year). The ^ indicates an exponent. [11]
X
Research source
Advertisement
Daily Interest Cheat Sheets
Expert Q&A
Search
-
QuestionHow do I calculate the compound annual growth rate?Paridhi Jain is a Certified Public Accountant and the Co-Founder of Seva Ltd, a CPA firm operating in Maryland and Alabama. She has over 10 years of professional experience in the financial sector and has built a reputation for assisting small business owners navigate the intricacies of regulatory compliance, encompassing areas from company structuring and entity formation to detailed nexus determinations for income and sales tax. She is an active member of the Alabama Society of CPAs and has a certification in pre-professional accounting. She graduated Magna Cum Laude from the University of Maryland, Baltimore County with a major in Information Systems.The compound annual growth rate (CAGR) concept involves envisioning yourself as a bank that has invested $100 in someone else, expecting a return of $110 by the end of the year. On December 31, when you indeed have $110, the subsequent day's earnings are based on the 10% return on the new total, not just the original $100. This compounding occurs annually, signifying that in the first year, you earn $10 (10% of the initial investment), and in the second year, you earn 10% of the updated amount, which is now $110. Consequently, you earn $11 in the second year. This process continues, representing the annual growth of your invested money.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
- You can use the IPMT function to determine daily interest on a mortgage. If you sell your house in the middle of a month, your final payoff balance will change every day. The daily interest amount can tell you what your exact payoff would be.Thanks
- You can also use the IPMT function to determine daily interest on late customer payments.Thanks
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
Advertisement
Warnings
- Laws vary by state about the limits of interest rates and how much interest can compound. For business applications, fully research the state laws where you do business before setting and incorporating a policy for charging interest on late payments.Thanks
Advertisement
Expert Interview
Thanks for reading our article! If you’d like to learn more about interest, check out our in-depth interview with Paridhi Jain .
References
- ↑ https://www.credit.org/blogs/blog-posts/what-are-interest-rates-how-does-interest-work
- ↑ https://www.credit.org/blogs/blog-posts/what-are-interest-rates-how-does-interest-work
- ↑ https://sciencing.com/multiply-number-percent-8129879.html
- ↑ https://www.cnbc.com/select/how-to-calculate-credit-card-interest/
- ↑ https://www.credit.org/blogs/blog-posts/what-are-interest-rates-how-does-interest-work
- ↑ https://www.techonthenet.com/excel/formulas/ipmt.php
- ↑ https://www.techonthenet.com/excel/formulas/ipmt.php
- ↑ https://www.techonthenet.com/excel/formulas/ipmt.php
- ↑ https://support.microsoft.com/en-us/office/how-to-calculate-compound-interest-for-an-intra-year-period-in-excel-dc752788-2c5b-4ba6-a008-bba79ef45e74
About This Article
Article Summary
X
To calculate daily interest, first convert the interest rate percentage into a decimal by dividing it by 100, then divide that number by 365. Multiply this rate by the principal investment to get the amount that your money will earn each day. Finally, check your math to be sure you didn’t make any calculation errors. If you want to calculate daily interest using a spreadsheet, keep reading for more information from our Financial reviewer.
Did this summary help you?
Thanks to all authors for creating a page that has been read 1,011,265 times.
Reader Success Stories
- "This page was extremely helpful, especially because I use a spreadsheet daily to calculate my budget and spending. I discovered that I can make 5x the interest on a special deal offered by the bank that holds my mortgage for my RRSP. Even if it's only for a limited time, it will be worth it to invest. The step-by-step instructions with screen shots are most helpful and easy to follow. Fantastic job. " ..." more
Advertisement
100%
of readers found this article helpful
.
Click a star to add your vote
% of people told us that this article helped them.
"This page was extremely helpful, especially because I use a spreadsheet daily to calculate my budget and spending. I discovered that I can make 5x the interest on a special deal offered by the bank that holds my mortgage for my RRSP. Even if it's only for a limited time, it will be worth it to invest. The step-by-step instructions with screen shots are most helpful and easy to follow. Fantastic job. "
..."
more
"Logically set out, easy to follow and learn from. Most impressed."
