| Author |
Message |
W. Wells
Guest
|
 Posted:
Sat Nov 12, 2005 11:10 pm Post subject:
Valuating present value of I Bond? |
|
|
What is the formula to determine the present value of an I Bond?
|
|
| Back to top |
|
 |
Bucky
Guest
|
| Posted:
Sun Nov 13, 2005 9:00 am Post subject:
Re: Valuating present value of I Bond? |
|
|
Actually, there is a formula (the lookup table has to be calculated
somehow). I spent many, many hours trying to figure out how to
duplicate the values in the lookup table, but I couldn't. =) Finally, I
emailed the Treasury Direct customer service, and they gave me the
formula. Now I can match up my Excel sheet exactly with the online
tool:
http://wwws.publicdebt.treas.gov/BC/SBCPrice
If you're curious how they calculate the values, here's the formula:
For every 6 month period,
PV = A (1+ r/2)^(i/6)
where A = starting amount for each 6 month period.
r = composite rate
i = ith month of the period (1, 2, 3, ... 6)
Special rules:
For the initial period, set A = $25. Round to the nearest cent. Then
scale to your bonds value. So if you have a $100 bond, multiply by 4.
You will have to do this calculation for every 6 month period. It gets
pretty tedious, so you're better off just using the calculator tool. |
|
| Back to top |
|
|
Rich Carreiro
Guest
|
| Posted:
Sun Nov 13, 2005 9:00 am Post subject:
Re: Valuating present value of I Bond? |
|
|
| Quote: | What is the formula to determine the present value of an I Bond?
|
You mean what a particular I-Bond purchased on a particular day in the
past is worth today, in today's dollars?
If so, there is no formula. It's all a big lookup table (seriously).
See http://www.publicdebt.treas.gov/sav/savprice.htm for some
"calculators" to tell you what your I-Bonds are currently worth.
--
Rich Carreiro rlcarr@animato.arlington.ma.us
|
|
| Back to top |
|
|
Rich Carreiro
Guest
|
| Posted:
Sun Nov 13, 2005 5:00 pm Post subject:
Re: Valuating present value of I Bond? |
|
|
| Quote: | somehow). I spent many, many hours trying to figure out how to
duplicate the values in the lookup table, but I couldn't. =) Finally, I
emailed the Treasury Direct customer service, and they gave me the
formula. Now I can match up my Excel sheet exactly with the online
tool:
|
Right, but it's still fundamentally a lookup table :) because that
formula they gave you is useless without (drum roll :) the big lookup
table of the semi-annual composite rates.
--
Rich Carreiro rlcarr@animato.arlington.ma.us |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in