|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2005, 03:51 PM
|
|||
|
|||
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 
|
|
#2
September 15th, 2005, 04:59 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| calculate interest between two dates | Arvind Khanna via OfficeKB.com | Worksheet Functions | 1 | June 1st, 2005 01:18 PM |
| How can we use Excel to calculate interest with daily compounding | Duke Carey | General Discussion | 0 | June 1st, 2005 12:08 AM |
| calculate interest on an increasing balance with variable rate | LPMastro | General Discussion | 0 | February 16th, 2005 08:13 PM |
| XIRR vs. IRR | Jen | Worksheet Functions | 6 | June 9th, 2004 03:20 AM |
| Calculate SIMPLE interest?? | Fred Smith | Worksheet Functions | 1 | February 4th, 2004 05:25 AM |
Linear Mode
