Interest rate in excel with example

Nominal interest rate = 5.06%. Relevance and Use. It can be calculated based on the effective annual rate of interest and the number of compounding periods per year.; From an investor’s point of view, it is an indispensable part of investing as it is the interest rate stated on the face of a bond or loan. Daily Compound Interest = $122. Example #3. Let us know to try to understand how to calculate daily compound interest with the help of another example. A sum of $35000 is borrowed from the bank as a car loan where the interest rate is 7% per annum and the amount is borrowed for a period of 5 years.