14) Which of the following statements is TRUE regarding Excel? A) Excel's "PV" function can be used to find the price of a bond. B) When using the "Rate" function to solve for a bond's YTM, if semiannual input values are used, the result must be divided by 2 in order to find the annual YTM. C) For a 20-year, 6% annual coupon bond with a par value of $1,000, you would enter $60 as the APER. input in the "PV" function D) STDEV.P is the correct Excel function to find the variance of a sample. 5) Which of the following statements is TRUE? A) As bond ratings go from AAA to AA to A, the return that investors require goes down. B) The Fisher Effect illustrates the inverse relationship between inflation and nominal interest rates. C) The penalty for spending before earning describes the interest rate from the point of view of the debtor D) Ceteris paribus, the EAR is inversely related to the frequency of compounding