![]() |
yield of a security
How do I calculate the yield of a security with an odd first AND last period.
|
yield of a security
There are add-ins for Excel that will calculate all sorts of investment
yields. Try a Google or MSN search, Or You can do it yourself in Excel, but you'll need to carefully schedule the coupons and day counts, then do a present value - using the correct day count convention of course - and then use Goal Seek to find the yield (discount rate) that sets the present value equal to the cost of the investment. "Securities Auditor" wrote: How do I calculate the yield of a security with an odd first AND last period. |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com