$_______ is the Expected Price (at the end of the first year) for the 25-year discount bond in the Pacific Healthcare (A) case study. (Please round to cents.)

- In the table below, relevant information from the Case Study is presented. - Note: - Ignore the dates, e.g. maturity date column. You can imagine bonds were issued at the beginning of the current year. - The expected price is at the beginning of the second year. - We will name the bonds by how many years there are to maturity, and so the first row is named the "5-year bond." Since there are two bonds with 25 -year maturities, we will call the one in the 3rd row the 25 -year premium bond (due to the fact that its current price is higher than par value) \& the one in the 4th row the 25 -year discount bond (vice versa, respectively). Sample calculation for 5-Year Bond. Use the "Rate" formula in Excel: =RATE(10,22.5,800,1000)=4.817% Then multiply the result by 2 in order to convert the semiannual rate to the annual rate. 4.817%2=9.634% Note: number of periods is 2 times number of years, since it is semiannually. Remember to include the negative sign for PV (present value). EXPECTED PRICE (AT BEGINNING OF THE SECOND YEAR) Sample calculation for 5-Year Bond. Use the "PV" formula in Excel: =PV(4.817%,8,22.5,1000)=$832.85 - Note: at the beginning of the second year, there are only 8 more periods left (i.e. 102=8 ). Be sure to include the negative sign in front of PV formula