Use annual compounding of interest

Assignment Help Financial Management

Reference no: EM131828911

Can you show me how to figure this out with excel and a graph?

1. A US Treasury STRIP with a face value of $1000 has 9 years to maturity. In excel, compute and graph the yields for prices of $500 to $1000, in $50 increments. Use annual compounding of interest.

2. You are given the following information from a T-Note quote: Settlement date: September 15, 2017

Maturity date: September 15, 2032

Price Quote: 102:9

In excel, compute and graph the coupon rates, duration, and current yields for yields-to- maturity of 1% to 20%, in 1% increments. Duration can be on a separate chart.

Reference no: EM131828911

Questions Cloud

What was its net income for the year : Assume the company is not-for-profit, what was its net income for the year? Assume $3 million in dividends, what is the net income?

Payments of ordinary annuity on financial calculator : How do you do payments of ordinary annuity on a financial calculator.

What is the expected return of your portfolio : Imagine you have a portfolio which consists of 60% stocks, 25% bonds, and 15% in a CD. what is the expected return of your portfolio?

What is the standard deviation of the bond fund returns : There are three states of the economy: Low, Medium, and High, with probabilities 25%(Low), What is the standard deviation of the bond fund's returns?

Use annual compounding of interest : A US Treasury STRIP with a face value of $1000 has 9 years to maturity. Use annual compounding of interest.

Why it is important for firm to minimize cost of capital : Discuss why it is important for the firm to minimize their cost of capital.

Expects to live in retirement : Sarah is planning to work for the next 35 years (years 1 – 35) and expects to live in retirement for 30 years after her retire (years 36-65).

Compute the likely cash balance for the end of the year : Does his optimistic outlook for his cash position appear to be justified? Compute the likely cash balance for the end of the year.

What is the market value of manutex non-cash assets : What is the market value of ManuTeX’s non-cash assets? State your answer as a whole number without any decimal points.

User Account

All Pages