is there an easy way to do this sort of question in excel? if so, please show it.

First solved here, not in excel sadly: https://www.chegg.com/homework-help/questions-and-answers/two-non-callable-1-000-bonds-pay-semi-annual-interest-one-15-year-maturity-30-year-maturit-q76226142

If there are two non-callable $1,000 bonds that pay semi-annual interest, one with a 15-year maturity and the other with a 30-year maturity and both with a coupon rate of 8%, what will happen to their values if market interest rate rises to 12%? A. The value of the 15-year bond will be $47.93 higher than the 30-year bond B. The value of the 30-year bond will be $47.93 higher than the 15-year bond C. The value of the 15-year bond will be $49.77 higher than the 30-year bond D. The value of the 30-year bond will be $49.77 higher than the 15-year bond E. Their values will be the same because their coupon rates are the same