There appears to be every financial function one could wish for - except the one I need! When one purchases a discount coupon, you pay say $8566 today and it matures in say 8.5 years for a maturity value of $14,000. My objective is to calculate the balance with accrued interest anytime between the purchase date and maturity. To do this one first needs the yield and the function RATE(FV,PV,N)calculates the rate. But now I need a formula that provides the future value of what is basically a financial instrument that does not pay interest until maturity and the accrued interest is reinvested at the IRR. Is this formual available? The mathematical formula for doing this calculation is:
VALUE = $8566x(1+i)^8.5 where the ^ sign means "to the power of". If Adagio has a key that stands for ^ the way that * stands for multiplication, my problem would also be solved. Can you help or is this an item for a future wish list.
Thanks for your help.