Explore BrainMass

Explore BrainMass

    Forecast model consumer loan department atCentral Union bank

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 11:47 pm ad1c9bdddf
    https://brainmass.com/math/optimization/forecast-model-consumer-loan-department-atcentral-union-bank-298012

    Attachments

    Solution Summary

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

    $2.19

    ADVERTISEMENT