Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 4P
To determine
Do an Excel PivotTable according to state and find out the number of rejected applications for each state. Reorder the numbers and draw a graph ordering the states and the number of rejected loans from highest to lowest. Identify whether there exist any variations among states.
Expert Solution & Answer
Explanation of Solution
The number of rejected applications for each state is as follows:
| Row Labels | Count of Loan Title |
| CA | 99,792 |
| TX | 62,049 |
| NY | 60,718 |
| FL | 60,051 |
| PA | 33,167 |
| IL | 31,488 |
| GA | 29,000 |
| OH | 28,510 |
| NJ | 27,666 |
| VA | 23,556 |
| MI | 20,696 |
| NC | 20,386 |
| MA | 18,808 |
| MD | 17,856 |
| AZ | 16,281 |
| MO | 14,605 |
| WA | 14,007 |
| CO | 13,335 |
| AL | 13,185 |
| SC | 12,146 |
| CT | 12,137 |
| LA | 11,181 |
| WI | 10,664 |
| MN | 10,400 |
| KY | 10,286 |
| NV | 9,513 |
| 9,400 | |
| OK | 8,165 |
| OR | 7,198 |
| KS | 6,336 |
| UT | 5,126 |
| WV | 4,975 |
| HI | 4,341 |
| NM | 4,329 |
| NH | 4,038 |
| RI | 3,637 |
| DE | 2,708 |
| MT | 2,102 |
| AK | 2,005 |
| DC | 1,900 |
| VT | 1,829 |
| SD | 1,620 |
| WY | 1,608 |
| IN | 1,134 |
| MS | 551 |
| TN | 449 |
| NE | 175 |
| IA | 144 |
| ME | 108 |
| ID | 69 |
| ND | 38 |
| (blank) | 21 |
| Grand Total | 755,489 |
The graph ordering the states and the number of rejected loans from highest to lowest:
There is a varaibility among the number of loans rejected in a particular state and the population of that state. The number of rejected loans varies in a different manner.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Which of the following is TRUE about Credit Score / FICO Score:
Group of answer choices
the lower the number, the better chances to obtain credit at a very low cost
randomly assigned number; Experian, Equifax, and TransUnion use to monitor Covid-19 tracing
typically between 1 and 10; calculated from the highest value assigned by the government
typically between 300 and 850; calculated from your credit report to gauge your reliability as a borrower
Which loan you would recommend llyods to take forward and why? Please read the email before you give answer to the question.
Answer and explain Which of the following is NOT a reason why financial institutions complete annual reviews on a borrower?
A. Annual reviews are best practice due diligence associated with monitoring a borrower’s loans
B. Annual reviews allow lenders to assess and meet the changing needs of borrowers
C. Annual reviews give borrowers a sense of key loan parameters such as the interest rate, time to maturity, and security
D. Annual reviews help lenders to identify early warning signs, to mitigate credit risk, and to meet regulatory requirements
Chapter 1 Solutions
Data Analytics For Accounting
Ch. 1 - Prob. 1MCQCh. 1 - Prob. 2MCQCh. 1 - Prob. 3MCQCh. 1 - Prob. 4MCQCh. 1 - Prob. 5MCQCh. 1 - Prob. 6MCQCh. 1 - Prob. 7MCQCh. 1 - Prob. 8MCQCh. 1 - Prob. 9MCQCh. 1 - Prob. 10MCQ
Ch. 1 - Prob. 1DQCh. 1 - Give an example of how Data Analytics creates...Ch. 1 - Prob. 3DQCh. 1 - Prob. 4DQCh. 1 - Prob. 5DQCh. 1 - Prob. 6DQCh. 1 - Prob. 7DQCh. 1 - Prob. 8DQCh. 1 - Prob. 9DQCh. 1 - Prob. 10DQCh. 1 - Prob. 11DQCh. 1 - Prob. 12DQCh. 1 - To address the question Will I receive a loan from...Ch. 1 - Download and consider the data dictionary file...Ch. 1 - Download and consider the rejected loans dataset...Ch. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Consider the 2013 declined loan data from...Ch. 1 - Consider the 2013 declined loan data from...
Knowledge Booster
Similar questions
- Create a spreadsheet that duplicates the shown table. Make it flexible enough that you can investigate the impact of different interest rates and principal loan amounts without changing the structure of the spreadsheet.arrow_forwardConsumers should comparison shop for credit just as they would for any other consumer good or service. How might a consumer's stage of the financial life cycle, income, net worth, or credit score affect the availability of loan sources and the associated cost of the loans offered? Question content area bottom Part 1 Which of the following statements is correct? (Select best answer below.) A. Typically, stages of the financial life cycle, income, net worth and your credit score move in unison, and the cost of the loans tends to be lower in early financial life cycle stages due to a sufficient supply of fund sources. B. Typically, stages of the financial life cycle, income, and net worth move inversely with credit score, and the cost of the loans tends to be lower in early financial life cycle stages due to a sufficient supply of fund sources. C. Typically, stages of the financial life cycle, income, net worth and your credit score move…arrow_forwardPlease help with the below minicase. Directions: The best way to do this case is to use relevant credit information and calculate some financial ratios: ROA, debt ratio, liquidity ratios, ROE, profit margin, Inventory and Asset turnover. Then look at breakeven point probability, and finally the possibility of a repeat order. What can you say about Miami Spice’s creditworthiness? What is the break-even probability of default? How is it affected by the delay before MS pays its bills? How should George Stamper’s decision be affected by the possibility of repeat orders? MiniCase: George Stamper a credit analyst with Micro-Encapsulators Corp. (MEC) needs to respond to an urgent email request from the southeast sales office. The local sales manager reported that she had an opportunity to clinch an order from Miami Spice (MS) for 50 encapulators at $10,000 each She added that she was particularly keen to secure this order since MS was likely to have a continuing need for 50 encapulators a…arrow_forward
- Please help with the below minicase. Directions: The best way to do this case is to use relevant credit information and calculate some financial ratios: ROA, debt ratio, liquidity ratios, ROE, profit margin, Inventory and Asset turnover. Then look at breakeven point probability, and finally the possibility of a repeat order. What can you say about Miami Spice’s creditworthiness? What is the break-even probability of default? How is it affected by the delay before MS pays its bills? How should George Stamper’s decision be affected by the possibility of repeat orders? MiniCase: George Stamper a credit analyst with Micro-Encapsulators Corp. (MEC) needs to respond to an urgent email request from the southeast sales office. The local sales manager reported that she had an opportunity to clinch an order from Miami Spice (MS) for 50 encapulators at $10,000 each She added that she was particularly keen to secure this order since MS was likely to have a continuing need for 50 encapulators a…arrow_forwardYou have developed a self-study certification system for those who need credit hours for recertification by your state’s social welfare office. The system operates at virtually no cost, i.e., there is no marginal cost. A marketing research team has assembled the following sales information. You are researching the options for pricing the courses. Your goal is to achieve maximum revenue to establish funding to maintain and update the system to reflect annual policy changes in licensing requirements. Complete the calculations for Total Revenue by determining how many customers will purchase at each of the segment prices. Online Self Certifications for Social Work License Certification in Online Counseling Certification as a Group Home Counselor Bundle Customers TR Counseling TR Group Home TR Bundle Segment 1 1000 $190 a $70 e $260 4a Segment 2 1000 $150 b $90 f $240 4b…arrow_forwardBefore taking out a consumer loan, you should be sure the purchase is compatible with your financial plans and budget. Discuss the loan features you would take into consideration when shopping for credit.arrow_forward
- include and explain any other ratios in your analysis table which will assist in strengthening your position for application for applying for loan from a bankarrow_forwardMini Case Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby. The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system…arrow_forwardLewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm's brokers. The system also permits customers to call up current quotes on terminals in the lobby. The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is…arrow_forward
- Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby. The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is…arrow_forwardLewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby.The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is…arrow_forwardLewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by the firm’s brokers. The system also permits customers to call up current quotes on terminals in the lobby. The equipment costs $1,000,000 and, if it were purchased, Lewis could obtain a term loan for the full purchase price at a 10% interest rate. Although the equipment has a 6-year useful life, it is classified as a special-purpose computer and therefore falls into the MACRS 3-year class. If the system were purchased, a 4-year maintenance contract could be obtained at a cost of $20,000 per year, payable at the beginning of each year. The equipment would be sold after 4 years, and the best estimate of its residual value is $200,000. However, because real-time display system technology is…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning