Purchase Solution

# Spot Rates Calculated

Not what you're looking for?

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.

##### 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 ...

##### Free BrainMass Quizzes

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.