Method of calculating monthly interest rate and annual interest rate by using rate function

Source: Internet
Author: User

First, Rate function syntax

function function: Returns the interest rate for each period of an annuity. The function rate is calculated by iterative method, and may have no solution or multiple solutions.

function syntax: RATE (nper,pmt,pv,fv,type,guess)

Parameter introduction:

NPer is the total investment period (i.e. total payment period for the investment);

PMT for each period payment amount

PV is present value (principal)

FV for future value

Type Specifies whether the payment time for each period is at the beginning or the end of the period (1). 0 is the end of the term).

Ii. Conditions of assumption

If deposited in the Bank 3600 Yuan deposit, and the future monthly deposit of 500 yuan, in advance of 10 years to make the amount of deposit reached 100000 Yuan, calculate its monthly interest rate and annual interest rate.

Condition Analysis:

Investment period (year): 10, corresponding to B2 cell

Amount paid at end of month:-500, corresponding to B3 cell

Cash:-3600, corresponding to B4 cell

Future value: 100000, corresponding to B5 cell

Three, the rate function uses the method

Calculated monthly interest rate: =rate (B2*12,B3,B4,B5) function returns 0.67%

Calculated annual interest rate: =rate (B2*12,B3,B4,B5) *12 function returns 8.09%

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.