Assume selected financial data for Walmart and Target, two close competitors in the retail industry, are as follows:
Required:
1. Calculate the receivables turnover ratio and average collection period for Walmart and Target. Round your answers to one decimal place. Which company has better ratios? Compare your calculations with those for Tenet Healthcare and LifePoint Hospitals reported in the chapter text. Which industry maintains a higher receivables turnover?
2. Because most companies do not separately report cash sales and credit sales, the calculations used here and in the chapter text use companies’ reported amount of net sales, which is a combination of cash sales and credit sales. How would including cash sales affect the receivables turnover ratio? How does this help to explain your answer in Requirement 1 above?
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Financial Accounting
- Which of the following best represents a positive product of a lower number of days sales in receivables ratio? A. collection of receivables is quick, and cash can be used for other business expenditures B. collection of receivables is slow, keeping cash secured to receivables C. credit extension is lenient D. the lender only lends to the top 10% of potential creditorsarrow_forwardTrue or False. 37. Horizontal analysis is the financial analysis technique that compares the balances of two accounts in one reporting period. * 21. The SoCE is prepared to help the readers understand the transactions that affected the balances of the drawing and equity accounts. * 19. The cost of transporting the merchandise purchased by the company is a reduction from the cost or merchandise purchased. * 32. Cash payment for bank loans are reported under cash flows from operating activities. *arrow_forwardIn constructing a pro forma balance sheet a manager can estimate the accounts receivable because: Select one: a. managers typically construct a pro forma income statement prior to the balance sheet. Thus, an estimate of sales has already been made and this is critical to estimating accounts receivable. O b. if the firm has already made an estimate of expected sales, then it can also estimate average daily sales. O c. if the firm maintains similar credit standards it can use the historical average age of accounts receivable to help estimate the anticipated average age of accounts receivable O d. if the firm has each piece of information as stated in the three choices above THEN they can estimate accounts receivable for the pro forma balance sheet..arrow_forward
- Using the categories of liquidity, profitability and operations management describe which ratios would be used and why to determine whether or not a loans officer at the bank would loan a business money. Your responses should not be less than 100 words.arrow_forwardWhich of the following are ways companies could use accounts receivables for earnings management? Select all that apply. Overestimate uncollectibles to reduce earnings (cookie jar reserve) Underestimate uncollectibles to reduce earnings (cookie jar reserve) Underestimate uncollectibles to increase earnings Overestimate uncollectibles to increase earningsarrow_forwardReview the select information for Liquor Plaza and Beer Buddies (industry competitors) and complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- Consider again the example introduced in Section 4.5 of a credit card company that has a database of information provided by its customers when the customers apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3). Figure 4.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? d. Recall the multiple regression in Figure 4.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts a, b, and c? What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? e. Add the coefficients of determination for the simple linear regression in parts a, b, and c, and compare the result to the coefficient of determination for the multiple regression model in Figure 4.23. What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? f. Add age, a dummy variable for gender, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 4.23. Code the dummy variable for gender as 1 if the customers gender is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?arrow_forwardWhich of the following statements are correct?I. A company's choice of accounting principles for financial reporting purposes affects net cash flow for the accounting period.II. A company's choice of accounting principles for financial reporting purposes does not affect operating cash flow.III. If a company sells its receivables, this will increase operating cash flow.IV. If a company sells its receivables, this will increase financing cash flow Select one: A. I and III B. I,II and III C. II and IV D. I and IVarrow_forwardWhich of the following statement is true ? Answer choices : I. Increase in collection of cash from customer will lead to decrease in days of payable outstanding . II . Increase in credit sales of the company will lead to increase in days of payable outstanding . III . Decrease in average accounts payable will cause decrease in accounts payable turnover ratio . IV . All the above statements are false .arrow_forward
- Consider the following transactions associated with accounts receivable and the allowance for uncollectible accounts. Required: For each transaction, indicate whether it would increase, decrease, or have no effect by leaving the cell blank, on the account totals. (Hint: Make sure the accounting equation, Assets = Liabilities + Stockholders' Equity, remains in balance after each transaction.) Stockholders' Credit Sales Transaction Cycle Assets Liabilities Revenues Expenses Equity rovide services on account Increase ease Increase 2. Estimate uncollectible accounts Decrease Decrease Increase 3. Write off accounts as uncollectible 4. Collect on account previously written offarrow_forwardThe following is a list of activities that companies perform in relation to their receivables.Match each of the activities listed below with a purpose of the activity listed below. 1. Selling receivables to a factor. select a purpose Determine to whom to extend creditEvaluate the liquidity of receivablesMonitor collectionsAccelerate cash receipts from receivable when necessaryEstablish a payment period 2. Reviewing company ratings in The Dun and Bradstreet Reference Book of American Business. select a purpose Establish a payment periodEvaluate the liquidity of receivablesMonitor collectionsDetermine to whom to extend creditAccelerate cash receipts from receivable when necessary 3. Collecting information on competitors’ payment period policies. select a purpose Establish a payment…arrow_forwardMatch each of the following terms with its definition. Terms Definitions _____ 1. Accounts receivable a. Reductions in amount owed by customers because of deficiency in products or services. _____ 2. Credit sales b. Formal credit arrangements evidenced by a written debt instrument. _____ 3. Sales allowances c. Amount of cash owed to the company by customers from the sale of products or services on account. _____ 4. Allowance method d. Recording bad debt expense at the time the account is known to be uncollectible. _____ 5. Notes receivable e. Sales on account to customers. _____ 6. Direct write-off method f. Reductions in amount owed by customers if payment on account is made within a specified period of time. _____ 7. Net revenues g. Total revenues less returns, allowances, and discounts. _____ 8. Sales discounts h. Recording an adjustment at the end of each period for the estimate of future uncollectible accounts. _____ 9. Aging method i. Estimated percentage of…arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,