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
Textbook Question
Chapter 1, Problem 6P
Consider the 2013 declined loan data from LendingClub titled “RejectStatsB2013.” Similar to the analysis done in the chapter, let’s scrub the debt-to-income data. Because our analysis requires risk scores, debt-to-income data, and employment length, we need to make sure each of them has valid data.
- a. Sort the file based on debt-to-income and remove those observations (the complete row or record) that have a missing score, a score of zero, or a negative score.
- b. Assign each valid debt-to-income ratio into three buckets (labeled DTI bucket) by classifying each debt-to-income ratio into high (>20 percent), medium (10–20 percent), and low (<10 percent) buckets. Consider using if-then statements to complete this. Or sort the row and manually input.
- c. Run a PivotTable analysis that shows the number of loans in each DTI bucket. Any interpretation of why these loans were declined based on debt-to-income ratios?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
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…
Based on the Cardinal Credit Financial Statement below, write a bulleted list analysis that includes:
a) Do you think the main changes from year to year are good or bad and why do you think so?
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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- After all the ledgers had been drawn up, the following differences and errors were identified.Indicate with a cross (X) where you would correct each of the differences and errors listed below,and explain your reasoning as so how, why and where you will make the correction:Hint: some might need to be corrected in more than one place.Difference or error Debtors control Debtors listE.g. The total sales return column inthe Debtors Allowance Journal wasposted to the debit side of the DebtorsControl Account.X Sales returns reduce the amount owing by a debtor.The error has occurred in the Debtors control accountonly, thus there will be no impact on the individualdebtor’s account. The debtors control account shouldbe credited twice.A credit invoice (issued by thebusiness) has not been recorded at all.The Debtors control column in thedebtors journal was “undercast”.Notification has been received that theoutstanding balance on one of thedebtors should be written off as thedebtor is insolvent.arrow_forwardAfter all the ledgers had been drawn up, the following differences and errors were identified. Indicate with a cross (X) where you would correct each of the differences and errors listed below, and explain your reasoning as so how, why and where you will make the correction: Hint: some might need to be corrected in more than one place. Difference or error Debtors control Debtors list E.g. The total sales return column in the Debtors Allowance Journal was posted to the debit side of the Debtors Sales returns reduce the amount owing by a debtor. Control Account. The error has occurred in the Debtors control account only, thus there will be no impact on the individual debtor's account. The debtors control account should be credited twice. A credit invoice (issued by the business) has not been recorded at all. The Debtors control column in the debtors journal was "undercast". Notification has been received that the outstanding balance on one of the debtors should be written off as the…arrow_forwardAfter all the ledgers had been drawn up, the following differences and errors were identified. Indicate with a cross (X) where you would correct each of the differences and errors listed below, and explain your reasoning as so how, why and where you will make the correction: Hint: some might need to be corrected in more than one place. Difference or error Debtors list Debtors control Eg. The totol sales return column in the Debtors Allowance Journal was posted to the debit side of the Debtors Soles returns reduce the omount owing by o debtor. Control Account. The error has occurred in the Debtors control account only, thus there wil be no impact on the individual debtor's occount. The debtors control account should be credited twice. A credit invoice (issued by the business) has not been recorded at all. The Debtors control column in the debtors journal was "undercast". Notification has been received that the outstanding balance on one of the debtors should be written off as the debtor…arrow_forward
- I submitted this question before but the wrong values were inputted for the solution given. Remember to put 244000 for the loan value in excel.arrow_forwardWhich 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 borrowerarrow_forwardOrganizations have to plan and account for uncollectible debt. Does estimating uncollectible accounts help to improve the accuracy of financial statements? If so, explain how by examining some of the factors that go into this estimation. Examine the difference between accounts receivable and notes receivable. How does each play into the previous questions?arrow_forward
- 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_forwardDefine the following terms and explain why they were important during the housing and credit crisis of 2007-2009 a.Securitization b. Subprime loan c. Asset write-downarrow_forward“Credit ratings are not very useful as they are merely a static appraisal of the financial health of an issuer at a specific point of time and are essentially backwards looking”. Discuss this statement with reference to the credit ratings assignment process and traditional credit analysis.arrow_forward
- What are some different methods that can be used for customer returns/bad debt? which way do you feel most accurately reflects these balances and why?arrow_forward1. In a Loan Management System, the loan applicant will have to submit these requirements including the loan application form. In a scenario where the loan applicant has incomplete requirements, what do you think is the error when this is translated to DFD? A. Black Hole B. Grey Hole C. Miracle D. Spontaneous Generation 2. XYZ Company has been using a records management system to track where their documents are being delivered and processed. Since the use of this system, they have saved time, have been more productive and efficient. These benefits produced by the system are known as what? A. Economic Benefits B. Intangible Benefits C. Operational Benefits D. Tangible Benefitsarrow_forwardWhat is credit risk? Discuss the more qualitative factors that creditors also consider in conjunction with quantitative ratio analysis when analyzing credit risk. PLEASE DON'T COPY AND PASTE, USE YOUR WORDS.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license