1

Please use cell referencing

Home Insert Draw Page Layout Formulas DtRview View Cut Times New Roman 14 A A Copy Paste , Format Blyv v-v M13 Compiete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is ail you need. To cop paste a formula across a row or down a column, an absoiute cell reference or a mixed cell reference may be preferred. Ifa specific Excel fiunction is to be used, the directions wil specify the use of that fiunction. Do not type in numerical data into a cell or fiunction. Instead, make a reference to the cell in which the data is found. Make your computations only in the biue celis highlighted below. In ali cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. The table below summarizes prices (per $100 (expressed as a percentage of face value): face value) of various default-free zero-coupon bonds a. Compute the yield to maturity for cach bond. b. Plot the zero-coupon yield curve (for the first five years) c. Is the yield curve upward sloping, downward sloping, or flat? Maturity Face value S 100.00 10 S 95.51 $ 91.0S $86.38 $ 81.65 s 76.51 16 a. Compute the yield to maturity for cach bond. 18 YTM 1-ycar bond YTM 2-ycar bond YTM 3-year bond YTM 4-ycar bond YTM 5-ycar bond 19 b. Plot the zero-coupon yield curve (for the first five years) 34 35 c. Is the yield curve upward sloping, downward sloping, or flat? The yield curve is