What data do you need for each loan applicant

Assignment Help Accounting Basics
Reference no: EM13910875

Imagine that you and your classmates are a research team developing an improved process for evaluating loan applicants for automobile purchases. The goal of the research is to predict which applicants will become delinquent or forfeit their loan. Those who score well on the application will be accepted, and those who score exceptionally well will be considered for lower rate loans. Prepare a brief report for your instructor addressing these questions:
a. What data do you need for each loan applicant?
b. What data might you need that is not typically requested on a loan application form?
c. Where might you get this data?
d. Take a first cut at designing a database for this application.
Using the material in this chapter on designing a database, draw the logical structure of the relational tables for this proposed database. In your design, include the data attributes you believe are necessary for this database and show the primary keys in your tables. Keep the size of the fields and tables as small as possible to minimize required disk drive storage space. Fill in the database tables with the sample data for demonstration purposes (ten records). After your design is complete, implement it using a relational DBMS.

Reference no: EM13910875

Questions Cloud

How could you use business intelligence to do a better job : How could you use business intelligence (BI) to do a better job at work? Give some specific examples of how BI can give you a competitive advantage.
Returns on large-company stocks are normally distributed : Suppose the returns on large-company stocks are normally distributed. Also suppose large-company stocks had an average return of 11.8% and a standard deviation of 20.3%. Determine the probability that in any given year you will lose money by investin..
About the restrictive covenant : Which of the following is a restrictive covenant?
What is the effective borrowing cost : A borrower is approved for a $80000 mortgage loan at 12% interest with monthly payments over 30 years. The borrower is required to pay 3.5 points. Assume the borrower repays the loan after 5 years. What is the effective borrowing cost?
What data do you need for each loan applicant : What data do you need for each loan applicant? What data might you need that is not typically requested on a loan application form?  Where might you get this data?
Capital structure-ratios to predetermined allowable value : Capital Structure- Kirsten Neal is interested in purchasing a new house given that mortgage rates are at a historical low. Her bank has specified rules regarding an applicant’s ability to meet the contractual payments associated with the requested de..
Investment has installed cost-discount rate is infinite : An investment has an installed cost of $576,382. The cash flows over the four-year life of the investment are projected to be $205,584, $249,318, $197,674, and $165,313. If the discount rate is zero, what is the NPV?  If the discount rate is infinite..
Dividend payment procedures : Dividend payment procedures- At the quarterly dividend meeting, Wood Shoes declared a cash dividend of $1.10 per share for holders of record on Monday, July 10. What valued would the key accounts have after the July 31 payment date? What effects, if ..
Dividend constraints-earnings for common stockholder : Dividend constraints- As firm has $800,000 in paid in-capital, retained earnings of $40,000 (including the current year’s earnings), and 25,000 shares of common stock outstanding. In the current year, it has $29,000 of earnings available for the comm..

Reviews

Write a Review

Accounting Basics Questions & Answers

  How tocreate a threepoint estimate for the resulting budget.

You need to determine the costs of this mailing (internal and external). You also need to determine the resource requirements and identify any conflicts. In preparation for the meeting, create a worksheet (in Excel or another spreadsheet tool) that y..

  A production departments output for the most recent month

a production departments output for the most recent month consisted of 12000 units completed and transferred to the

  The chadmark corporations budgeted monthly sales are 3000

the chadmark corporations budgeted monthly sales are 3000. in the first month 40 of its customers pay and take the 2

  Changing the break-even point

If variable costs drop to $36 per patient day, what increase in fixed costs can be tolerated without changing the break-even point as determined in part (a)?

  Kalifo comapny manufacures a line of electric garden tools

kalifo comapny manufacures a line of electric garden tools that hardware store sell the companys controller will fulton

  Assume that felde company sells the same number of units in

felde company had 140030 of net income in 2011 when the selling price per unit was 160 the variable costs per unit were

  Calculate the current book value of the machine

Viva Inc. had bought machine X for $15,500 two years ago. The machine had no residual value and had an estimated useful life of 10 years. If the company uses the straight line depreciation method, calculate the current book value of the machine.

  Variable costing income statement and conversion to

variable costing income statement and conversion to absorption costing income l.o. p2 p4 torres company began

  Review and discuss below what the general rules are under

you are the chief accounting officer of dream job corporation and have been asked for your expert opinion on the

  Mimi company is considering a capital investment of 240000

mimi company is considering a capital investment of 240000 in new equipment. the equipment is expected to have a 5-year

  What is marias dividend income

The text book says that Maria owns 100% of stock with adjusted basis of $52,000 she recieves a cash distribution of $250,000 from the company when its earnings and profits are $100,000. What is Maria's dividend income?

  Compute the break-even point in dollars under each of the

fredonia inc. had a bad year in 2013. for the first time in its history it operated at a loss. the companys income

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