how to calculate quarterly compounded interest in ms excel

G

Guest

How to calculate quarterly compounded interest on cumulative deposit with
bank or company in ms excel
 
G

Guest

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

how calculate a loan amount with quarterly compounded interest 1
How do I calculate interest? 1
calculate compounded daily interest 3
calculation of future value between two dates 2
Calculation of Compounded Interest on a debt 6
how to calculate interest on payments 2
Calculating interest due on late loan payments 1
How do you calculate an interest only loan 2

Top