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

  What should the transfer price be on the transaction

What should the transfer price be on this transaction? What should Kelly Hoffman do? Do the reward systems for the division managers support the best interests?

  Examine the cash flow statement for procter and gamble

examine the cash flow statement for procter and gamble company shown in real-world case 21-6 in chapter 21 and discuss

  At the end of 2010 keil company reports a pretax operating

at the end of 2010 keil company reports a pretax operating loss of 80000 for both financial reporting and income tax

  Determining short-term capital loss

During the year, Loon Corporation has the following trancastions: $ 400,000 operation income, $355,000 operating expenses, $25,000 municipal bond interest, $ 60,000 long-term capital gain, and $ 95,000 short-term capital loss.

  Prepare the journal entry for the wages and salaries paid

Prepare the journal entry for the wages and salaries paid.

  Impact of the proposed change

History and background of the project - identify the relevant GAAP and current standards involved. Discuss the proposed change (i.e., what will be different?) and the reasons for the change.

  Computing year-end earnings per share

On January 1, Toga Corporation granted stock options to top management. The options are exercisable within 4 years from the date of grant only if the employees are still in Toga's employ. When computing year-end earnings per share at December 31, ..

  Value per share of the company stock

Boehm Inc is expected to pay a $1.50 per share dividend at the end of the year. The dividends is expected to grow to a constant grow at a constant rate of 7 year. The required rate of return on the stock rs, is 15%. What is the value per share of ..

  Sales level required in both dollars and units

Compute the sales level required in both dollars and units to earn $210,000 of after-tax income in 2010 with the machine installed and no change in unit sales price. Assume that the income tax rate is 30%.

  What is an agency cost

Which one of the following is an agency cost? a) accepting an investment opportunity that will add value to the firm b) increasing the quarterly dividend

  Briefly explain the difference between adjusting entries

on may 31 2014 the following data were accumulated to assist the accountant in preparing the adjusting entries for

  A manufacturing company producing medical devices reported

a manufacturing company producing medical devices reported 60000000 in sales over the last year. at the end of the same

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