Can you please show the furmula and I don't want it on excel.

Marriot Corporation has two bond issues outstanding, each with a par value of $1,000. Information about each is listed below. Suppose market interest rates rise 1

percentage point across the yield curve. What will be the change in price for each of the bonds? Does this tell us anything about the relationship between coupon rate and interest rate risk?

Bond A: 10 years to maturity, 0 percent coupon, market interest rate is 9.62 percent.

Bond B: 10 years to maturity, 10 percent coupon, market interest rate is 9.62 percent.

Experts say that the baby boom generation (born 1946-1960) cannot count on a company pension or Social Security benefits to provide a comfortable retirement. It is recommended that they start to save regularly and early. Michael, a baby boomer, has decided to deposit $200 each quarter in an account that pays 8% compounded quarterly for 20 years.

a) How much money will be in the account at the end of the 20 years?

b) Suppose Michael has determined he needs to accumulate $130,000 from this annuity. What rate would achieve this goal?

c) If he cannot get the higher rate, what amount would his payments need to be in order to achieve the goal?

d) Suppose Michael cannot get the higher interest rate, nor increase his payments. How many months would he need to invest in order to achieve his goal?

The dollar cost of the Euro is $1.19.

a. You are planning a trip to Europe and read that hotel charges 125 euros per night. What is the cost to you in dollars?

b. Your dollar will buy how many dollars?

c. After completing your trip, you have 100 euros that you want to convert back to dollars. How many dollars will you receive?