Purchase Solution

# 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

##### Solution Summary

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

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