Data Analytics For Accounting
19th Edition
ISBN: 9781260375183
Author: RICHARDSON
Publisher: MCG
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
- Shimmer Products is considering which bad debt estimation method works best for its company. It is deciding between the income statement method, balance sheet method of receivables, and balance sheet aging of receivables method. If it uses the income statement method, bad debt would be estimated at 5.6% of credit sales. If it were to use the balance sheet method, it would estimate bad debt at 13.7% percent of accounts receivable. If it were to use the balance sheet aging of receivables method, it would split its receivables into three categories: 0–30 days past due at 5%, 31–90 days past due at 21%, and over 90 days past due at 30%. There is currently a zero balance, transferred from the prior years Allowance for Doubtful Accounts. The following information is available from the year-end income statement and balance sheet. There is also additional information regarding the distribution of accounts receivable by age. Prepare the year-end adjusting entry for bad debt, using A. Income statement method B. Balance sheet method of receivables C. Balance sheet aging of receivables method D. Which method should the company choose, and why?arrow_forwardOrganics Plus is considering which bad debt estimation method works best for its company. It is deciding between the income statement method, balance sheet method of receivables, and balance sheet aging of receivables method. If it uses the income statement method, bad debt would be estimated at 4% of credit sales. If it were to use the balance sheet method, it would estimate bad debt at 12% of accounts receivable. If it were to use the balance sheet aging of receivables method, it would split its receivables into three categories: 0–30 days past due at 6%, 31–90 days past due at 19%, and over 90 days past due at 26%. There is currently a zero balance, transferred from the prior years Allowance for Doubtful Accounts. The following information is available from the year-end income statement and balance sheet. There is also additional information regarding the distribution of accounts receivable by age. Prepare the year-end adjusting entry for bad debt, using A. Income statement method B. Balance sheet method of receivables C. Balance sheet aging of receivables method. D. Which method should the company choose, and why?arrow_forwardUsing just the information below from a Debt Schedule within a financial model, calculate 2018 interest expense. Make sure to enter your answer as a positive numerical value, i.e. $250 should be entered as 250. Using just the information below from a Debt Schedule within a financial model, calculate 2019 interest expense. Make sure to enter your answer as a positive numerical value, i.e. $250 should be entered as 250 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
- Organics Plus is considering which bad debt estimation method works best for its company. It is deciding between the income statement method, balance sheet method of receivables, and balance sheet aging of receivables method. If it uses the income statement method, bad debt would be estimated at 4 percent of credit sales. If it were to use the balance sheet method, it would estimate bad debt at 12 percent of accounts receivable. If it were to use the balance sheet aging of receivables method, it would split its receivables into three categories: 0–30 days past due at 6 percent, 31–90 days past due at 19 percent, and over 90 days past due at 26 percent. There is currently a zero balance, transferred from the prior year’s Allowance for Doubtful Accounts. The following information is available from the year-end income statement and balance sheet. 2018 Year-End Total for Organics Plus Credit Sales $1,810,000 Accounts Receivable 600,000 There is also additional information…arrow_forwardYou now need to calculate the cost of debt for Harvey Norman. Go to www.westpac.com.au and find the current business loan rates equivalent for each of Harvey Norman’s debts. What is the weighted average cost of debt for Harvey Norman using the book-value weights and the market-value weights? Does it make a difference in this case if you use book-value weights or market-value weights?arrow_forwardA lending officer at C Bank has insisted that your firm improve the current ratio of 0.8 before the bank will consider a loan. Which of the following actions would INCREASE the ratio? Group of answer choices: Selling some of the existing inventory at cost Using cash to pay off current liabilities Borrowing long-term debt to pay off short-term bank loan Paying off long-term debt. Collecting some of the current accounts receivablearrow_forward
- I'm studying for a test and I want to know how to do each question for it, can you walk me through step by step how to solve this one? The following data concern XYZ Corporation for 2018:Bad debts expense for the year 11,000Accounts receivable—December 31, 2018 235,000Credit sales during the yearAllowance for doubtful accounts—December 31, 20181,600,00018,000 Calculate the net realizable value of the accounts receivable.arrow_forwardHarmon, Inc. uses the aging of receivables method to account for the allowance of doubtful accounts and the recording of bad debt expense. Below is the aging of the accounts receivable along with the associated estimation of uncollectibility. a. Calculate the amount estimated to be uncollectible at the end of 2021. b. Record the year-end entry to record the bad debt expense if there was a credit balance of $12,000 in the Allowance for Doubtful Accounts at the end of 2021 before the year-end entry. c. Record the year-end entry to record the bad debt expense if there was a debit balance of $3,500 in the Allowance for Doubtful Accounts at the end of 2021 before the year-end entry. Harmon, Inc - Accounts Receivable Aging Balances - December 31, 2021 Total 1-30 Days 31-60 Days 61-90 Days 91-120 Days…arrow_forwardCreate a ledger of Account Receivable and ledger of AFDD to find the bad debt by using this information; Alpha Company's accounts receivable and allowance for doubtful accounts balances were RM100000 and RM14000 (credit) respectively, at the beginning of 2012. During 2012, a customer defaults on a RM12000 balance related to goods purchased during 2011. By the end of the year, the company had mad credit sales of RM2400000 and collected RM2200000 on account. Estimates 1 percent of its credit sales will default.arrow_forward
- 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_forwardhi Can you assist me in undertanding better how you calculated the written off amount ? Why is the formula addind the opening and closing balance of the allowance for doubtful accounts and substract the allowance estimated ? You mentionned the bad debt was equal to total estimated allowance for doubtful accounts- balance in allowance for doubtful account . Is this the same formula to use for the write off ? Many thanksarrow_forwardWhich one of the following statements concerning bad debt expenses is correct? Select one: a. When you write off an accounts receivable, you debit bad debt expense and credit accounts receivable. b. You record bad debt expense when individual accounts receivable becomes uncollectible. c. Under the percentage of receivables method, bad debt expense is the year-end receivables multiplied by the % of uncollectible accounts. d. When the allowance method is used, bad debt expense is recorded before the accounts are written off.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