An introductory finance course will give you the opportunity to use several Excel tools related to the valuation and characteristics of corporate and government bonds. These Excel tools include (1) PRICE (2) YIELD (3) TBILLYIELD (4) COUPNUM. Explore what each of these functions are designed to perform and select the most appropriate description of their purpose: Excel Function Description This function helps you find the percentage return that an investor will earn from a security that pays interest. This function helps you find the percentage return that an investor will earn from a Treasury bill. This function helps you find the price per $100 face value of a security that pays periodic interest. This function helps you find the number of coupons payable between the settlement date and maturity date. Consider that you have all the data you need to calculate the yield on a fixed income security: Consider that you have all the data you need to calculate the yield on a fixed income security: Hint: Enter value rounded to two decimal places. A B 1 Data Description 2 Settlement date of the bond sale September 15, 2014 3 Maturity date of the bond August 15, 2018 4 4.7% Rate at which coupons will be paid Price you paid for the bond per $100 face value 5 $95.23 6 Redemption value $100 7 Frequency of coupon payments 2 8 Basis 0 9 YIELD 10 % Suppose you did not have data for price an investor paid for the bond but you knew that the bond generated a yield of 5%. Calculate the price you would pay on the bond using the corresponding function. Suppose you did not have data for price an investor paid for the bond but you knew that the bond generated a yield of 5%. Calculate the price you would pay on the bond using the corresponding function. Hint: Enter value rounded to two decimal places. B 1 Data Description 2 Settlement date of the bond sale September 15, 2014 3 Maturity date of the bond August 15, 2018 4.7% 4 5 Rate at which coupons will be paid Yield (yld) Redemption value 5% 6 $100 7 Frequency of coupon payments 2 8 Basis 0 9 PRICE = 10