how to calculate quarterly compounded interest in ms excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to calculate quarterly compounded interest on cumulative deposit with
bank or company in ms excel
 
Given an APR to get the Yearly Effective Rate based on quarterly compoundings
use the formula:

=(1+APR/4)^4-1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FV annuity re: compounding 3
How do I calculate interest? 1
Annual vs Quarterly Rates 2
how calculate a loan amount with quarterly compounded interest 1
Formula to calculate compound interest on increasing principal 1
compound interest 3
Compounding Interest 1
calculation of future value between two dates 2

Back
Top