| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How can we use Excel to calculate interest with daily compounding
If you have an annual interest rate - say 5%, you calculate daily compounded
interest by: =((1+5%/365)^(#days)-1)*principal amount If your principal amount is $1,000 and the # of days is 60, then the interest is $8.25 vs $8.22 simple interest "Myra" wrote: Would like to create worksheet with daily compounding but without having to set a row per day. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel takes along time to calculate | Excel Worksheet Functions | |||
| Calculate a Date In Excel | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Hybrid Mode
