Hi thanks for the video. Would you mind showing an example if we use actual dates instead of N={1,2,3..}? If not, can you shed some light on: (Assuming there are a few more months until we receive our first coupon) 1. How to take into account clean/dirty price? 2. Does YearFrac function for the first cash flow solve the problem above?
You cannot discount using dates that way without doing a lot of work, since that is your exponent in the denominator. You could run a second row above that showed the dates 1/31/21, 7/31,21, 1/31/22, etc. if you wanted.
Hi thanks for the video.
Would you mind showing an example if we use actual dates instead of N={1,2,3..}?
If not, can you shed some light on:
(Assuming there are a few more months until we receive our first coupon)
1. How to take into account clean/dirty price?
2. Does YearFrac function for the first cash flow solve the problem above?
You cannot discount using dates that way without doing a lot of work, since that is your exponent in the denominator. You could run a second row above that showed the dates 1/31/21, 7/31,21, 1/31/22, etc. if you wanted.