Purchase Solution

Spot Rates Calculated

Not what you're looking for?

Ask Custom Question

How would I calculate the 1 yr forward rates over the next 3 years for spot rates of Yr 1 .050
Yr 2 .054
Yr 3 .059
Yr 4 .066

I just need the formulas, not the answers.

Purchase this Solution
Solution Summary

The expert calculates the 1yr forward rates over the next 3 years for spot rates.

Solution Preview

You can use Linear Regression in Excel for this calculation. Or use the formulae in the attachment.

NOTE: x is year numbers 1, 2, 3, 4, 5 and y is spot rates for these years successively.

Linear ...

Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

View More Free Quizzes
Related BrainMass Solutions

  • Theoretical spot rates

    rates have been calculated.

  • Spot Rates

    The same principle is applied to get the three and four year spot rates. This solution calculated the spot rates given the forward rates.

  • Spot exchange rate

    . = $1 Canadian Spot exchange rate USD 0.88 / Euro x 0.70 Euro/ CAD = USD 0.62 USD/CAD The spot exchange rate rate between the U.S. dollar and the Canadian dollar has been calculated using USD/Euro and Euro/CAD spot rates.

  • Solve: Forward Rates

    81065 Solve: Forward Rates Question: Suppose Credit Suisse Quotes spot 90 day forward rates of $0.7957-60, 8-13. - What are the outright 90 day forward rates that Credit Swiss is quoting?

  • Spot Rates and Forward Rate

    The expert examines spot rates and forward rates.

  • Forward Price of a Contract on Zero-Coupon Bond

    This can be calculated using 1-year and 11-year spot interest rates. A. What is the forward price of the contract?

  • Determining Value and Expected Profit

    The current spot rate is $0.5820/SF, the three-month forward rate is $0.5640/SF, and he expects the spot rates to reach $0.6250/SF in three months. a. Calculate Christoph's expected profit assuming a pure spot market speculation strategy. b.

  • T-bill Interest Rates to Determine Future Contract Rates

    (b) Show that for the forward yield calculated in (a) the 6 month returns on (i) a 6 month spot bill and (ii) 3 month spot and 3 month futures bills are the same. (c) Explain what factors would lead to a rejection of (b).

  • Expected exchange rate

    398036 Expected exchange rate The spot rate on the Canadian dollar is 1.23. Interest rates in Canada are expected to average 4.2 percent while they are anticipated to be 3.3 percent in the U.S.

View More Related Solutions