Nine years ago, Elite Elements issued a 20-year bond with a $1,000 face value and an 8 percent coupon rate of interest (
Posted: Thu May 19, 2022 6:18 am
Nine years ago, Elite Elements issued a 20-year bond with a
$1,000 face value and an 8 percent coupon rate of interest
(paid semiannually). If investors require a return
equal to 10 percent to invest in similar bonds, what is the current
market value of Elite's bond? Do not round intermediate
calculations. Round your answer to the nearest cent.
I would like to see this question worked both
mathematically on paper and in excel. (More importantly, would be
an excel setup.)
$1,000 face value and an 8 percent coupon rate of interest
(paid semiannually). If investors require a return
equal to 10 percent to invest in similar bonds, what is the current
market value of Elite's bond? Do not round intermediate
calculations. Round your answer to the nearest cent.
I would like to see this question worked both
mathematically on paper and in excel. (More importantly, would be
an excel setup.)