Financial Modeling Tutorials

- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

## What is Interest Rate?

When a lender, lend any amount to the borrower for a certain time period that is known as the principal amount over that lender charge interest that percentage of principle that percentage of principle is known as the interest rate. In simple words, the interest rate is the rate at which amount is charged by the lender over principle landed by the lender. The interest rate is directly proportional to risk as there is risk involve when a lender lends an amount to the borrower. It is also called compensation of opportunity lost.

In terms of investment, interest is paid on bank deposit investment like fixed deposit, recurring deposit and even on the amount deposited in saving bank account. Bank pay interest half yearly on saving account deposit whereas for fixed deposit and recurring deposit interest paid based on customer request which could be monthly, quarterly, half annually or yearly. And interest rate applied for one year is the annual interest.

There are two types of interest rate formula:-

- Simple Interest Formula
- Compound Interest Formula

### Simple Interest Rate Formula

Simple interest is levied when a loan is borrowed for one year or less. Simple interest is generally applied for a short term.

**Simple Interest Rate Formula = (Principle * Rate of Interest * Time Period (years))/ 100**

In simple in it also written as,

Simple Interest rate Formula = (P*R*T)/100

Let’s take a few simples to advanced examples to understand Simple Interest rate formula:

#### Simple Interest rate calculation Example #1

**A borrower, borrow $1000 from a lender for a period of 9 months and at an interest rate of 12%. Now, we will calculate simple interest rate of interest to be paid to a lender on a principal amount of $1000.**

**Simple Interest**

So from the above calculation of Simple Interest will be:

Interest payable to the lender is $90 and the principal amount is $1000. Total amount payable to a lender is $1090.

4.9 (1,067 ratings)

### Compound Interest Formula

Compound interest is called “interest on interest”. It is calculated on the principal amount and of the time period, it changes with time.

the time period, it changes with time.

**Compound Interest Rate Formula = P (1+i)**–

^{t }**P**

Where,

- P = Principle
- i= Annual interest rate
- t= number of compounding period for a year
- i =
__r__ - n = Number of times interest is compounded per year
- r = Interest rate (In decimal)

Total amount payable to be lender = P (1+i) ^{t}

Let’s take a few simples to advanced examples to understand the Compound Interest rate formula:

#### Compound Interest rate calculation example

**A borrower took a personal loan from ABC bank, he borrowed $5000 amount from a bank at the interest rate of 10%, for a time period of 5 years, compounded yearly then compound interest will be:**

Compound Interest

So from the above calculation of Compound Interest will be:

There is the logic of time value of money which is associated with compound interest.

**FV and PV using Compound Interest Rate Formula**

With change is time value money change in this scenario value of money i.e. present value and its future value can be calculated with the help of compound interest rate formula. The opposite word of compounding is discounting and its factors are reciprocal of in the interest rate.

**FV = PV (1+i) ^{t}**

**PV = FV/(1+i) ^{t}**

Where,

- FV = Future value
- PV = Present value
- i= Annual interest rate
- t= number of compounding period for a year
- i =
__r__ - n = Number of times interest is compounded per year
- r = Interest rate (In decimal)

**Let us calculate the future value of $ 5000 compounded yearly at the interest rate of 10% for 5 years.**

**Future Value**

So from the above calculation of Future Value will be:

**Present value**

So from the above calculation of Present Value will be:

### Simple Interest and Compound Interest Rate Calculation Differences

Let us see calculation difference for simple interest formula and compound interest formula. Suppose a person wants to start a yearly recurring deposit of $500 for a period of 10 years for the interest rate of 5%. Then he calculates the same and gets the below values.

Here, we can see that the amount invested was total $5000 from which he gets differences in the interest of compound interest and simple interest

### Relevance and Use of Interest Rate Formula

- Interest rate formula used to calculate repayment amount for loans.
- Interest rate formula used to calculate interest over investment on fixed deposit, mutual funds etc.
- An interest rate is also used to calculate interest on a credit card.

Interest rate formula helps one to understand loan and investment and take the decision. These days financial bodies like bank use Compound interest formula to calculate interest. Compounded annual growth rate i.e. CAGR is used mostly for financial applications where single growth for a period needs to be calculated.

### Recommended Articles

This has been a guide to Interest Rate Formula. Here we discuss how to calculate Simple and Compound Interest Rate in Excel using practical examples and downloadable templates. You can learn more about financial analysis from the following articles –

- Relevance and Use of Monthly Compound Interest Formula
- How to Use Rate Formula in Excel?
- Relevance and Use of Daily Compound Interest
- Nominal Interest Rate | Applications | Example
- Rate Function in Excel
- Real Interest Rate Calculation
- Nominal Interest Rate Calculation
- Effective Interest Rate Calculation

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion