In: Finance
Use PV function to find the prices now and after 4 years.
=PV(rate,nper,pmt,fv,type)
a. If you want to buy now
rate=10%
nper=30 years
pmt=coupon*face value=6%*1000=60
fv=face value=1000
=PV(10%,30,60,1000,0)=$622.92
if you wants to buy now=$622.92
b. If you want to sell after 4 years
rate=6%
nper=30-4=26 years
pmt=60
fv=1000
=PV(6%,26,60,1000,0)=$1000
The price at which you sell after 4 years=$1000