Forecast model consumer loan department atCentral Union bank
Not what you're looking for?
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.