AggieMike88
Touchdown! Greaser!
- Joined
- Jan 13, 2010
- Messages
- 20,805
- Location
- Denton, TX
- Display Name
Display name:
The original "I don't know it all" of aviation.
I've RTFM'd this many ways and still not quite getting the answer or help in a way I can understand. And since a few folk here had other good answers to Excel questions, I turn to you guys once again.
I want to perform a time value of money calculation to show me present value when employing compound interest. I have two columns, representing the date of the "deposit" and the amount of the "deposit" into an account.
If it helps with your demonstration, let's go with the following data set and assumptions.
Interest = 6% APR, compounded monthly
DATE:....................Amount $
06/01/12................$1850.00
06/16/12................$1850.00
07/01/12................$1850.00
07/16/12................$1850.00
08/01/12................$1850.00
08/16/12................$1650.00 <<< note amount change
09/01/12................$1650.00
09/16/12................$1650.00
10/01/12................$1650.00
10/16/12................$1950.00 <<< note amount change
11/01/12................$1950.00
Straight sum of the amounts is $19,750. But if I'm trying to determine PV when the compound interest is figured in.
Figure the dates to be in column A and the values in Column B. What is the correct function set up to achieve the desired result. (write it out if possible so I can copy/pate)
I want to perform a time value of money calculation to show me present value when employing compound interest. I have two columns, representing the date of the "deposit" and the amount of the "deposit" into an account.
If it helps with your demonstration, let's go with the following data set and assumptions.
Interest = 6% APR, compounded monthly
DATE:....................Amount $
06/01/12................$1850.00
06/16/12................$1850.00
07/01/12................$1850.00
07/16/12................$1850.00
08/01/12................$1850.00
08/16/12................$1650.00 <<< note amount change
09/01/12................$1650.00
09/16/12................$1650.00
10/01/12................$1650.00
10/16/12................$1950.00 <<< note amount change
11/01/12................$1950.00
Straight sum of the amounts is $19,750. But if I'm trying to determine PV when the compound interest is figured in.
Figure the dates to be in column A and the values in Column B. What is the correct function set up to achieve the desired result. (write it out if possible so I can copy/pate)