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.