USING EXCEL-1.You are considering buying a bond in the secondary market place. The bond has a yield to maturity of 8.5%, has a $1,000 par value, has 18 years remaining until maturity, and has a coupon rate of 10.5%. This bond pays annual coupon payments. As an investor, how much would you be willing to pay for this bond?

2.You are considering buying a bond in the secondary market place. The bond has a yield to maturity of 8.5%, has a $1,000 par value, has 18 years remaining until maturity, and has a coupon rate of 10.5%. This bond pays annual coupon payments. As an investor, how much would you be willing to pay for this bond?

3.A bond is currently priced at $834.99. This bond has 12 years remaining to maturity, has a $1,000 par value, has a 5.5% coupon rate, and pays $55 annual coupon payments. What is the current yield of this bond?

4.A firm needs to buy a new piece of machinery that costs $34,200. The firm chooses to finance the entire amount with a bank loan. The firm signs a loan contract agreeing to pay back the loan over 5 years at 7.5% annual interest. What is the MONTHLY payment on this loan? (Don't forget to convert you number of periods and interest rate to reflect a monthly framework)

5.A corporation gets a $200,000 loan to finance an asset. The company agrees to make 120 monthly payments over the next 10 years of $2,024.90, based on a 4% annual interest rate. When the company if finished paying back the loan, how much will the company have paid in Total Finance Charges (TFC)?