You are a credit analyst of a growing commercial bank and have recently received loan applications from two companies of relatively similar size. Show below are selected financial data for these two applicants at the end of the current year: RED CO BLUE CO. Net credit sales P700,000.00 P650,000.00 Cost of goods sold P500,000.00 P490,000.00 Cash P60,000.00 P20,000.00 Accounts receivable (net) P77,000.00 P60,000.00 Inventory P94,000.00 P180.000.00 Current liabilities P110|200.00 P105,000.00 Assume that the year-end balances for accounts receivable and for inventory approximate the average balances of these items throughout the year. A. Compute the following on BLUE 1. Working capital 2. Current ratio 3. Acid test ratio

You are a credit analyst of a growing commercial bank and have recently received loan applications from two companies of relatively similar size. Show below are selected financial data for these two applicants at the end of the current year: RED CO BLUE CO. Net credit sales P700,000.00 P650,000.00 Cost of goods sold P500,000.00 P490,000.00 Cash P60,000.00 P20,000.00 Accounts receivable (net) P77,000.00 P60,000.00 Inventory P94,000.00 P180.000.00 Current liabilities P110|200.00 P105,000.00 Assume that the year-end balances for accounts receivable and for inventory approximate the average balances of these items throughout the year. A. Compute the following on BLUE 1. Working capital 2. Current ratio 3. Acid test ratio

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter6: Accounting Quality

Section: Chapter Questions

Problem 3DIC

See similar textbooks

Similar questions

The following select financial statement information from Vortex Computing. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days sales in receivables ratio is 85 days?
The following select financial statement information from Candid Photography. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Candid Photography if industry average for accounts receivable turnover ratio is 3 times and days sales in receivables ratio is 150 days?
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?
Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then 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.
You are an investor looking to contribute financially to either company A or Company B. The following, select financial information as follows. Company A and company B, respectively: Beginning Account Receivable $ 50,000, 60,000; Ending Account Receivable $ 80,000, 90,000; Net credit sales $ 550,000, $460,000. Based on the information provided: compute the account receivable turnover ratio. Compute the number of days sales in receivables ratio for both companies A and company B ( round all answers to two decimals places) Interpret the outcomes stating which company you would invest in and why.
The following are excerpts from the financial statements of 2018 and 2019 of Mandela Corporation. 2019 2018 Sales $187,600 $195,000 Accounts Receivable (net): Beginning of Year 68,100 66,500 End of Year 60,200 68,100 A newly hired manager has started implementing new credit policies. Required: a. As a consultant, you are contracted to analyze Accounts Receivable Turnover and Number of Days’ Sales in Receivable and provide opinion as to whether Mandela’s credit policy changes are working b. What conclusions does your analysis suggest. Are the new credit policies working?
Use the information provided below to prepare the following for January and February 2023 as per guide lines on theouc4.1 Debtors Collection Schedule INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 000 6. Fifty percent…
d. Bowers’ sales are seasonal, and her company produces on a seasonal basis, just aheadof sales. Without making any calculations, discuss how the company’s current anddebt ratios would vary during the year if all financial requirements were met withshort-term bank loans. Could changes in these ratios affect the firm’s ability to obtainbank credit? Explain.
Use the information provided below to prepare the following for January and February 2023:Debtors Collection Schedule The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 0004.26. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000.…
The Simmons Company is planning to request a line of credit from its bank. The following sales forecasts have been made for parts of 2017 and 2018:In RsMay 2017 150,000June 150,000July 300,000August 450,000September 600,000October 300,000November 300,000December 75,000January 2018 150,000Collection estimates obtained from the credit and collection department are as follows: collected within the month of sale, 5 percent; collected the month following the sale, 80 percent; collectedthe second month following the sale, 15 percent. Payments for labor and raw materials are typically made during the month following the month in which these costs are incurred. Total labor and raw materials costs are estimated for each month as follows:In RsMay 2017 75,000June 75,000July 105,000August 735,000September 255,000October 195,000November 135,000December 75,000General and administrative salaries will amount to approximately Rs 22,500 a month; lease payments under long-term lease contracts will be Rs…
Assuming an economy have only two commercial banks in it banking system, Classic Bank and Prudent Bank. The following shows the balance sheet of the two banks as at 2019.Classic BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 1,000 Deposits 3,000Securities 2,000 Equity 7,000Loans & Advances 1,000Property, Plant and Equipment 6,000 .10,000 10,000Prudent BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 600 Deposits 2,500Securities 1,500 Equity 4,400Loans & Advances 800Property, Plant and Equipment 4,000 .6,900 6,900Assume a required reserve ratio of 10%.What is the amount of excess reserves in this commercial banking system?
Assuming an economy have only two commercial banks in it banking system, Classic Bank and Prudent Bank. The following shows the balance sheet of the two banks as at 2019.Classic BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 1,000 Deposits 3,000Securities 2,000 Equity 7,000Loans & Advances 1,000Property, Plant and Equipment 6,000 .10,000 10,000Prudent BankBalance sheet as at December, 2019GHSm GHSmAssets: Liabilities & Equity:Reserves 600 Deposits 2,500Securities 1,500 Equity 4,400Loans & Advances 800Property, Plant and Equipment 4,000 .6,900 6,900Assume a required reserve ratio of 10%.(a) What is the amount of excess reserves in this commercial banking system?…………………………….………………………………………………………………………………………………………………………………………………….……………………………………..……………………………………………………………………………….…………………………………………………………………………………………………………………………………………………(b)What is the maximum amount that the money supply can be expanded?What would be the effect of a fall in…