how to calculate quarterly compounded interest in ms excel

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

--
Regards,
Dave
<!--


"Shreepad" wrote:

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