Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have solved for the 1 year interest rate in excel by finding the bond price at $1000, equaling 973.52. I know to solve for

I have solved for the 1 year interest rate in excel by finding the bond price at $1000, equaling 973.52. I know to solve for the 1-year rate by doing 1000/973.52-1 to equal 2.72%

I cannot find the 2, 3, and 4 year interest rates in excel though.

The following table shows the prices of a sample of Treasury strips. Each strip makes a single payment at maturity.

Years to Maturity Price, (% of face value)

1 year; 97.352%

2 year; 93.851

3 year; 90.044

4 year; 85.980

solve for the following using excel :

a.What is the 1-year interest rate?

b. What is the 2-year interest rate?

c. What is the 3-year interest rate?

d.What is the 4-year interest rate?

e.Is the yield curve upward-sloping, downward-sloping, or flat?

  • Upward-sloping-correct
  • Downward-sloping
  • Flat

f.Is this the usual shape of the yield curve?

  • Yes-correct
  • No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting What the Numbers Mean

Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele,

9th Edition

978-0-07-76261, 0-07-762611-7, 9780078025297, 978-0073527062

More Books

Students also viewed these Accounting questions

Question

Improving creative problem-solving ability.

Answered: 1 week ago