Forecast the delinquency rate on home mortgages

Assignment Help Basic Computer Science
Reference no: EM131441779

Suppose a savings and loan association wants to forecast the delinquency rate on home mortgages. Using monthly data, the following trend model is estimated where DRt = the percentage of mortgage payments delinquent in time period t, and = 1,..,48 (January 2010 through December 2013). The following estimation results are obtained:

DEPENDENT VARIABLE:

DRT

R-SQUARE

F-RATIO

P-VALUE ON F

OBSERVATIONS:

48

0.7982

181.93

0.0001

VARIABLE


PARAMETER ESTIMATE

STANDARD ERROR

T-RATIO

P-VALUE

INTERCEPT


2.60

0.74

3.51

0.0010

T


0.030

0.010

3.00

0.0043

a. Does this estimate indicate a significant upward trend in the delinquency rate on home mortgages? In the space below, perform the appropriate t-test at the 5 per­cent significance level.

b. Perform an F-test to determine if the model is statistically significant at the 5 percent level of significance.

c. Calculate the predicted delinquency rates for January 2014 and March 2014.

DRJan 2014 = ________ percent

DRMar 2014 = ________ percent

Show your work here:

The trend analysis above indicates that the delinquency rate is rapidly becoming a serious problem for this savings and loan. A management consultant suggests that the trend analysis may be overstating the upward trend because it fails to account for the fact that the months of December and January are consistently much worse months than the rest. The consultant suggests estimating the following model:

where D is equal to one for the months of December and January, and zero otherwise. The estimation results are:

DEPENDENT VARIABLE:

DRT

R-SQUARE

F-RATIO

P-VALUE ON F

OBSERVATIONS:

48

0.9876

1794.0

0.0001

VARIABLE


PARAMETER ESTIMATE

STANDARD ERROR

T-RATIO

P-VALUE

INTERCEPT


2.200

0.780

2.82

0.0071

T


0.018

0.004

4.50

0.0001

D


0.810

0.210

3.86

0.0004

d. Does the new model indicate a significant upward trend in the delinquency rate? Perform the appropriate t-test.

e. Perform a t-test to determine whether December and January are signifi­cantly worse months for mortgage payments.

f. Predict the delinquency rates for January 2014 and March 2014.

DRJan 2014 = ________ percent

DRMar 2014 = ________ percent

Show your work here:

g. Compare your forecasts in parts c and f. Explain why they differ.

Reference no: EM131441779

Questions Cloud

What is the balance in the work in process account : During the month of September, Jaycee Corporation requisitioned $2,300 of direct materials and used $3,800 of direct labor. The company applies overhead at the end of each month at a rate of 200% of the direct labor cost incurred. What is the balance..
Problems with market power in that market : any of the markets that are regulated in New Zealand. What do you think causes the problems with market power in that market?
Compute the income statement for times mirror and glass co : Using the income statement for Times Mirror and Glass Co., compute the following ratios: TIMES MIRROR AND GLASS Co. Income Statement Sales $ 209,000 Cost of goods sold 106,000.
What is your workplace policy on diversity : What is your workplace policy on diversity? How does diversity impact the work atmosphere where you work? Have you encountered any diversity-related workplace issues in your place of employment?
Forecast the delinquency rate on home mortgages : Suppose a savings and loan association wants to forecast the delinquency rate on home mortgages. Using monthly data, the following trend model is estimated where DRt = the percentage of mortgage payments delinquent in time period t, and t = 1,..,48..
Explain the management strategies addressing : Suppose you are part of Canadian Tire Management team. Please explain the management strategies addressing the political risk, government relations, alliances, decisions and control mechanisms relevant to possible entry of Canadian Tire in Mexico.
Determinants of unemployment duration : For the purpose of modelling the main determinants of unemployment duration (time spent unemployed), would it be preferable to have gathered data from a sample of workers who were recently unemployed but are now back at work rather than from a sam..
Describe the relationship between technology and risk : How does Knowles describe the relationship between technology (of nuclear power plants, or skyscrapers) and risk during disasters (man-made or not)?How does his story relate to the notion of risk and disaster in the Katrina Hurricane event in New ..
Calculate total contribution margin : Lasseter Corporation has provided its contribution format income statement for August. The company produces and sells a single product.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Distinguish distances that moved their shopping carts

Performing 200 Nm of work. Both Brian and Dawn are exerting same amount of force (20 N). Distinguish the distances that Brian and Dawn moved their shopping carts.

  Databases feed data into the data warehouse

Find an example of an actual data warehouse. For this example, describe the content, purpose, user access methods, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) - (make sure that your ..

  Success of most products and services

Q1. Ease of use is necessary for the success of most products and services. But ease of use is not always easy to define. What are some of the criteria that you would consider if you were developing a user interface?

  The preferred method of interacting with a computer

Graphical User Interface (GUI) became the preferred method of interacting with a computer system. Beginning with the Xerox-developed GUI in 1970, GUI-based platforms have evolved from the Apple Macintosh to the Microsoft Windows operating syste..

  Prompt the user for a keyword in matlab

Write a script that will prompt the user for a keyword in MATLAB, error-checking until a keyword is entered.

  Create a stem-and-leaf display or a histogram of these data

Drunk driving 2007. Accidents involving drunk drivers account for about 40% of all deaths on the nation's highways. The table tracks the number of alcohol-related fatalities for 26 years. (www.alcoholalert.com)

  Contrast mean deviation and standard deviation

Math Journal Draw a box-and-whisker plot for data you found in a newspaper or magazine. What conclusions can you derive from the plot?

  Create three classes for the linked list

Create three classes for the linked list: An abstract class called WordList which contains all the functionality of the linked list, and classes called UnsortedWordList and SortedWordList which inherit from WordList. Each of these two classes sho..

  Implementation inheritance and interface inheritance

What are implementation inheritance and interface inheritance?

  What are the estimates of the sizes of each neighborhood

Using this hash function, compute the values of R for each node and radius 1. What are the estimates of the sizes of each neighborhood? How do the estimates compare with reality?

  What values are placed in the array by the above statements

Where does the element referred to with the number zero exist in an array? What values are placed in the array by the above statements? (Show each element of the array and the value for that element.

  Principal focusing on and above-the-line

With respect to the use of information technology, is Principal focusing on and above-the-line or below-the-line initiative? Perhaps a combination of both? Justify your answer. Within the context of the RGT framework, what is Principal's focus?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd