Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Functions
What function do I use to calculate the payout (or future value) of a
Certificate of Deposit? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Functions
"LeeB" wrote:
What function do I use to calculate the payout (or future value) of a Certificate of Deposit? You need to look at the details of the CD disclosure statement to see how interest is computed. There are several methods in practice. If interest is compounded daily, the future value of the CD can be computed by: =fv(rate/365, daysHeld, 0, -deposit) where "rate" is the interest rate, not the APY, and "daysHeld" is computed by subtracting the date of deposit from the date of maturity. I want to reiterate the fact that not all CDs work this way. Some CDs compute simple interest on the balance, reinvesting the accumulated interest periodically (weekly, monthly or quarterly). Even "daysHeld" is not determined in a uniform manner. For example, some "9-month" CDs mature in 270 days. Some CDs mature on the anniversary date 9 months late; for example, a 10/1/2005 CD maturing on 7/1/2006 -- 273 days. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Functions in Excel | Excel Worksheet Functions | |||
How do I see the formula calculation used in Excel functions box | Excel Worksheet Functions | |||
Improved Excel functions curve fitting in sheet | Excel Worksheet Functions | |||
Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |