标题: Formula needed??? [打印本页] 作者: hinsafdar 时间: 2011-7-11 19:48 标题: Formula needed???
An individual is creating a charitable trust to provide six annual payments of $20,000 each,
beginning today. How much money must the individual set aside now at 10 percent interest
compounded annually to meet the required disbursements?作者: thisisbrianly 时间: 2011-7-11 19:48
FV =0; N=5; PMT=-20,000; I/Y=10%
CPT "PV". PV = 75,815.74. Now add 20,000 to it because the first 20,000 is made today and not at the end of the year. Therefore PV = 75,815.74 + 20,000 = $95,815.74
This is the amount of money he needs to set aside to meet his 6 annual payments of 20k starting today.
Edited 1 time(s). Last edit at Friday, November 26, 2010 at 08:47AM by Hey_I_am_the_Dude_man.作者: JRossSter 时间: 2011-7-11 19:48
I dont know if the formula is needed I know it can be done in the Calc.... remember to put it in Beg Value作者: rkapoor 时间: 2011-7-11 19:48
no formula needed you can do it on a financial calc or in Excel in 5 sec
but TVM is a concept everybody who wants to do finance should know imo; and I also think anyone in finance does know this...
