I mean if the market rate is fixed let say 4% then I can find bond value using TVM worksheet in calculator.
PMT=3
N=4
FV=100
I/Y=4
But in spot rate case I/Y is chanaging every year.
I have to perform above step 4 times with different I/Y value.
Case 1: Write all 4 values which has been calculated vis TVM sheet in a piece of paper and then add them when you done with discount calculation. (I am able to do this)
Case 2: Side by Side I mean Without writing anywhere I want calculator BA 2 Plus to do this for me.