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,000.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

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,000.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

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 9E

See similar textbooks

Similar questions

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. P700,000.00 P650,000.00 Net credit sales 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 P94,000.00 P180,000.00 Inventory Current liabilities P110,D00.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 RED 1. Working capital 2. Current ratio 3. Acid test ratio 4. Accounts receivable turnover
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?
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.
Consider again the example introduced in Section 7.5 of a credit card company that has a database of information provided by its customers when they 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 post-high school education (x3). Figure 7.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 is explained by this simple linear regression model? 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 is explained by this simple linear regression model? 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 is explained by this simple linear regression model? d. Recall the multiple regression in Figure 7.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 post-high 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 7.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 7.23. What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? f. Add age, a dummy variable for sex, 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 7.23. Code the dummy variable for sex as 1 if the customer 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?
Starlight Enterprises has net credit sales for 2019 in the amount of $2,600,325, beginning accounts receivable balance of $844,260, and an ending accounts receivable balance of $604,930. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Starlight Enterprises if the industry average is 1.5 times and the number of days sales ratio is 175 days?
Using the following select financial statement information from Mover Supply Depot, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Mover Supply Depot if the industry average is 4 times?
Millennial Manufacturing has net credit sales for 2018 in the amount of $1,443,630, beginning accounts receivable balance of $588,900, and an ending accounts receivable balance of $624,450. A. Compute the accounts receivable turnover ratio and the number of days' sales in receivables ratio for 2018. Round answers to two decimal places. times days B. What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of day's sales ratio is 180 days? Accounts receivable turnover ratio Sales in receivables ratio a. Millennial Manufacturing collects its accounts more quickly than its competitors. b. A lender may favour Millennial Manufacturing over its competitors because of its faster collection period. c. Without prior years' data it is hard to tell if Millennial Manufacturing is really more efficient than its competitors. d. All of the above statements may be correct.
Problem Solving. Raymar Alison Trading has the following transactions during the fiscal year 2021. Cash sales 100,0000. Credit Sales 200,000. Total Sales 300,000. Cost of Goods Sold 150,000. Gross Margin 150,000. Beg. Accounts Receivable 25,000. End. Accounts Receivable 15,000. Beg. Inventory 35,000. End. Inventory 25,000. Total Expenses 50,000. 30. What is Return on Income? 16.67% 33.33% 50.00% 66.67%
Hi,how to use the excel function (IRR and Effect) to determine which money lender offers a better rate: 1. Ah Long Finance: Loan amount: $20,000; instalment $600 per month x 36 months 2. Sharky Finance: Loan amount: $30,000; instalment $555 per month x 60 months 3. Ah Beng Finance: Loan amount: 40,000; instalment $ 760 per month x 59 months 4. Barracuda Finance: Loan amount: $50,000; instalment $925 per month x 60 monthsThanks.
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…
PLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take screenshots) La Resolana, S.A., has credit sales of $180,000 per year, with net payment terms of 30 days, which is also the average collection period. La Resolana does not currently offer any cash discounts, so customers take the 30 days to pay. What is the average accounts receivable balance? What is the accounts receivable turnover?