Google Sheets

ACCRINTM: Google Sheets Formulae Explained

How do you use ACCRINTM in Google Sheets?

The ACCRINTM function in Google Sheets calculates the accrued interest for a given investment over a given period of time. You can use this function to calculate the amount of interest that has accrued on a loan, for example, or on an investment. The syntax for the ACCRINTM function is:

=ACCRINTM(rate,nper,pmt,pv,fv,type)

where:

rate is the annual interest rate

nper is the number of periods over which the interest will be accrued

pmt is the periodic payment amount

pv is the present value

fv is the future value

type is the type of interest calculation to use: 0 for periodic, 1 for continuous

What is the syntax of ACCRINTM in Google Sheets?

The syntax for ACCRINTM in Google Sheets is:

=ACCRINTM(B3,D3,G3,I3)

Where B3 is the starting balance, D3 is the number of periods, G3 is the annual interest rate, and I3 is the number of payments per year.

What is an example of how to use ACCRINTM in Google Sheets?

The ACCRINTM function in Google Sheets can be used to calculate the accrued interest for a given period of time. The function takes three input arguments: the principal amount, the interest rate, and the number of periods. The accrued interest is returned as a decimal value. For example, the following formula calculates the accrued interest for a loan of $10,000 with an annual interest rate of 5%:

=ACCRINTM(10,000,0.05,12)

This formula returns the value 0.5, which indicates that the accrued interest for the 12-month period is $500.

When should you not use ACCRINTM in Google Sheets?

There are a few occasions when you should not use the ACCRINTM function in Google Sheets. One such situation is when you have a date range that is not divisible by the frequency of the data set. For example, if you are attempting to calculate the interest accrued on a bank account for the past six months, but your date range is from January 1st to December 31st, the function will return an incorrect result. Another time you should not use the function is when you have a data set that is missing values. In this case, the function will return a #VALUE! error.

What are some similar formulae to ACCRINTM in Google Sheets?

There are a few similar formulae to ACCRINTM in Google Sheets. The first is ACCRINT. This function calculates the accrued interest for a given period of time. The second is PMT. This function calculates the payment for a loan or investment over time. The third is NPER. This function calculates the number of payments for a loan or investment over time. The fourth is PPMT. This function calculates the payment for a loan or investment for a given period of time. Finally, the fifth is IPMT. This function calculates the interest for a given period of time for a loan or investment.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.