| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need Excel sheet-calc compounded future value of quarterly flows
Looking for a spreadsheet that will allow me to calculate a series of
quarterly cash flows compounding at a fixed rate |
|
#2
|
|||
|
|||
|
Need Excel sheet-calc compounded future value of quarterly flows
"golfnut" wrote:
Looking for a spreadsheet that will allow me to calculate a series of quarterly cash flows compounding at a fixed rate If the quarterly cash flows are equal and if the fixed rate is the nominal rate (not the APR), the answer is simple: =FV(rate/4,4*years,-cashFlow,,1) (Or replace "4*years" with the number of quarters.) If the quarterly cash flows are unequal or if the fixed rate is an APR, please be more specific. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel - automatic information from one sheet to another?? | Excel Discussion (Misc queries) | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
