how to calculate quarterly compounded interest in ms excel

S

Shreepad

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

David Billigmeier

Given an APR to get the Yearly Effective Rate based on quarterly compoundings
use the formula:

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