1. Using a Spreadsheet to Calculate T-bill Yield: What is the quoted yield of a $10,000 face value T-bill with a market price of $8,885 if there are 10, 25, 50, 100, and 250 days to maturity? Need Formula for this to put into excel.
2. What is the bond quote for a $1,000 face value bond with an 8 percent coupon rate (paid semiannually) and a required return of 7.5 percent, if the bond is 6.48574, 8.47148, 10.519, and 14.87875 years from maturity? Need Formula for this to put into excel.