Build a ??calculator? in MS Excel that:a) values a bond and b) calculates a bond??s duration.For the ??calculator?, use a 3 year bond that makes

Build a â??calculatorâ? in MS Excel that:a) values a bond and b) calculates a bondâ??s duration.For the â??calculatorâ?, use a 3 year bond that makes semi-annualpayments, has a 5% coupon rate, a 2 answers