EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780135231906
Author: Evans
Publisher: VST
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 15PE
Use the Excel file Credit Risk Data that was introduced in this chapter to perform the following activities:
- Compute the combined checking and savings account balance for each record in the Base Data worksheet. Then sort the records by the number of months as a customer of the bank. From examining the data, does it appear that customers with a longer association with the bank have more assets?
- Apply Pareto analysis to draw conclusions about the combined amount of money in checking and savings accounts.
- Use Excel’s filtering capability to extract all records for new-car loans. How many individuals with new-car loans are single, married, and divorced?
- Use Excel’s filtering capability to extract all records for individuals employed less than
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A restaurant borrows
$15,200
from a local bank for
10
months. The local bank charges simple interest at an annual rate of
4.55%
for this loan. Assume each month is
112
of a year. Answer each part below.Do not round any intermediate computations, and round your final answers to the nearest cent. If necessary, refer to the
list of financial formulas
.
(a)
Find the interest that will be owed after
10
months.
$
(b)
Assuming the restaurant doesn't make any payments, find the amount owed after
10
months.
The first step in performing projected financial analysis is to
• prepare the projected balance sheet.
forecast sales as accurately as possible.
take an inventory of goods.
calculate the projected net income.
estimate increases in debt.
Using the data in the following table, calculate the return for investing in Boeing stock (BA) from January 2, 2008, to January 2, 2009, and also from January 3, 2011, to January 3, 2012, assuming all dividends are reinvested in the stock immediately.
Historical Stock and Dividend Data for Boeing
Date Price Dividend Date Price Dividend
1/2/2008 86.62 1/3/2011 66.40
2/6/2008 79.91 0.40 2/9/2011 72.63 0.42
5/7/2008 84.55 0.40 5/11/2011 79.08 0.42
8/6/2008 65.40 0.40 8/10/2011 57.41 0.42
11/5/2008 49.55 0.40 11/8/2011 66.65 0.42
1/2/2009 45.25 1/3/2012 74.22
Return from January 2, 2008, to January 2, 2009 is how much? (Round to two decimal places.)
Chapter 2 Solutions
EBK BUSINESS ANALYTICS
Ch. 2 - The Excel file Syringe Samples provides data for...Ch. 2 - Convert the Store and Regional Sales database to...Ch. 2 - Convert the Purchase Orders database to an Excel...Ch. 2 - Prob. 6PECh. 2 - Prob. 8PECh. 2 - In the Excel file Automobile Quality, search for...Ch. 2 - Prob. 10PECh. 2 - Conduct a Pareto analysis for the number of...Ch. 2 - Use Excels filtering capability in the Purchase...Ch. 2 - In the Sales Transactions database, use Excels...
Ch. 2 - Filter the data in the Bicycle Inventory database...Ch. 2 - Use the Excel file Credit Risk Data that was...Ch. 2 - Apply the Advanced Filter to the Credit Risk Data...Ch. 2 - Prob. 17PECh. 2 - For the Bicycle Inventory database, use database...Ch. 2 - For the Bicycle Inventory database, write a...Ch. 2 - The Excel file SP500 provides open, high, low, and...Ch. 2 - In the Purchase Orders database, we need to find...Ch. 2 - An auditor found an expense receipt for 179.24...Ch. 2 - Use PivotTables to find the number of sales...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- All financial institutions provide different financial products and services that expose them to different types of risks that require different risk mitigating practices and techniques. These risks include; credit risk liquidity risk, interest rate risk, market risk, foreign exchange risk, solvency risks, operational risks and model risk. Which of the following is not true about credit risk? Select one: a. Performance risk is similar to credit risk. The borrower´s performance on an operation or specific project determines the degree of transaction risk. b. Measures based on the credit quality of the debt. As ratings are ordinal measures, they are sufficient to value credit risk. c. The risk of the issuers and borrowers are evaluated in prices in a capital market setting and can be seen visibly, or through credit spreads, or as add-ons to the risk-free rate. d. Credit risk is similar to country risk, which is essentially the risk crisis in a country. Examples of…arrow_forwardWhat is the main reason lenders pay borrowers' property taxes through a pre-paid escrow account? It prevents a tax lien from being applied to the home. The tax lien would be senior to the mortgage lien. It prevents the borrower from refinancing with another lender because they would lose all of their escrow funds. It allows the lender to earn interest on the pre- paid tax money as itsits in the account. It allows the lender to take advantage of corporate tax deductions.arrow_forwardQueenstar Company manufactures smartphones and tablets. Its main customers are retailers who then sell to the general public. The company’s manufacturing is spread across five sits and goods are stored in its nine warehouses located across the country. You are an audit supervisor of Akof & Co and in preparation for the forthcoming audit for the year ending 30 June 20X7, you are reviewing the following notes your audit manager has provided you with in relation to the company’s internal controls. Queenstar Company has a small internal audit (IA) department. During the year, the IA started a programme of physically verifying the company’s assets and comparing the results to the non-current assets register, as this type of reconciliation had not occurred for some time. To date only 15% of assets have had their existence confirmed as IA has experienced significant staff shortages and several members of the current IA team are new to Queenstar Company. During the year, Queenstar Company…arrow_forward
- Which of the following considerations is prohibited when a mortgage loan ariginator is making a determination of a borrower's ability to repay a loan? A) Current debt obligations, including alimony and child support B) Funds to close C) Marital status D) FICO scorearrow_forwardObtain and review a credit policy and procedures document from any selected financial institution. Review the contents and write a critique on the three key areas addressed in the policy. Highlight any one area which you think was not properly addressed, making two recommendations for improvement of the document, the policy and procedures. Note: Any key area identified in the policy and procedure document should be in alignment with key theoretical concepts covered in the course unit material.arrow_forwardInformation that is used by investors for expecting future earnings is recorded in Select one: a. Annual Report b. Five Years Report c. Exchange Report d. Stock Reportarrow_forward
- How does COSO and COBIT frameworks relate to the importance of creating a control matrix for the accounts payable/cash disbursement process? Why is the control matrix important in the first place?arrow_forwardEDNA RAYMOND (84EA700%asonal Comfortu Stare dome The term "subprime or nonprime" refers to which of the following credit risk characteristics of individual borrowers? 0 0 0 0 Low loan-to-value ratios Low debt-to-income ratios High credit scores High levels of past loan delinquencies Buttarrow_forwardDiscuss the use of Predictive Analytics in computing the financial risks of healthcare facilitiesarrow_forward
- compare and contrast seven diffrent types of financial models in business analyticsarrow_forwardIn this Harvard Business Review (HBR) article entitled, "How to Finance the Scale-Up of Your Company" written by Daniel Isenberg and Daniel Lawton, the authors provide practical ways to ensure your business has sources of financing, especially when scaling-up your business. https://hbr.org/2014/08/how-to-finance-the-scale-up-of-your-company INSTRUCTION: Prepare a Reaction Paper called Reading Reflection Memo (RRM). READING REACTION MEMO FOR THIS ARTICLE: The reading reaction memo after reading the article above should: (a) compare and contrast key points that strike you from the reading(s); (b) evaluate the arguments and evidence on the point(s) you cover, identifying what was insightful, mundane, unclear, incomplete, contradictory, etc.; and (c) conclude with 3-4 questions for class discussion. The reaction memo should not merely summarize the reading(s) you consider, but it should also demonstrate an active engagement with the point(s) you select to focus on, including how it (they)…arrow_forwardWhat-If Analysis As the management accountant for the Tyson Company you have been askedto construct a financial planning model for collection of accounts receivable and then to performa what-if analysis in terms of the assumption regarding estimated uncollectible accounts. You areprovided with the following information:Collection Pattern for Credit Sales: 65% of the company’s credit sales are collected in the monthof sale, 30% in the month following the month of sale, and 5% are uncollectible.Credit Sales: January 2019, $100,000; February 2019, $120,000; March 2019, $110,000.Required1. Generate a spreadsheet model regarding estimated bad debts expense under the following assumptionsregarding the rate of uncollectible accounts: 1%, 3%, 5% (base case), and 8%. Prepare an estimate of baddebts expense for each of three months, January through March, and for the quarter as a whole.2. What is the value to Tyson Company of creating a model and then performing the what-if analysis?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License