ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   yield of a security (https://www.excelbanter.com/excel-worksheet-functions/121971-yield-security.html)

Securities Auditor

yield of a security
 
How do I calculate the yield of a security with an odd first AND last period.

Duke Carey

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