Purchase Solution

Forecast model consumer loan department atCentral Union bank

Not what you're looking for?

Ask Custom Question

The consumer loan department at Central Union bank and Trust wants to develop a forecasting model to help determine it's potential loan application volume for the coming year. Because adjustable-rate home mortgages are based on government long-term treasury not rates, the department collected the following data for 3- to 5 - year treasury note interest rate for the past 24 years. (see word doc for Years and Rates)

Year Rate Year Rate Year Rate
1 5.77 9 9.71 17 7.68
2 5.85 10 11.55 18 8.26
3 6.92 11 14.44 19 8.55
4 7.82 12 12.92 20 8.26
5 7.49 13 10.45 21 6.80
6 6.67 14 11.89 22 6.12
7 6.69 15 9.64 23 5.48
8 8.29 16 7.06 24 6.09

Develop an appropriate forecast model for the bank to use to forecast Treasury note rates in the future and indicate how accurate it appears to be compared to historical data.

Need solution in an excel spreadsheet and the answer in a word doc or under need the problem in excel

Purchase this Solution

Solution Summary

Step by step method for developing a Forecast model consumer loan department at Central Union bank.

Purchase this Solution

Free BrainMass Quizzes
Exponential Expressions

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

Multiplying Complex Numbers

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

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.