Problem No. 2 Receivables Investment McEwan Industries sells on terms of 3/10, net 25. Total sales for the year are $1,465,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 80 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the days sales outstanding? Round your answer to two decimal places. b. What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate calculations. c. What is the percentage cost of trade credit to customers who take the discount? Round your answers to two decimal places. d. What is the percentage cost of trade credit to customers who do not take the discount and pay in 80 days? Round your answers to two decimal places. Do not round intermediate calculations. e. What would happen to McEwan's accounts receivable if it toughened up on its collection policy with the result that all non-discount customers paid on the 25th day? Round your answers to two decimal places. Do not round intermediate calculations.

Problem No. 2 Receivables Investment McEwan Industries sells on terms of 3/10, net 25. Total sales for the year are $1,465,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 80 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. a. What is the days sales outstanding? Round your answer to two decimal places. b. What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate calculations. c. What is the percentage cost of trade credit to customers who take the discount? Round your answers to two decimal places. d. What is the percentage cost of trade credit to customers who do not take the discount and pay in 80 days? Round your answers to two decimal places. Do not round intermediate calculations. e. What would happen to McEwan's accounts receivable if it toughened up on its collection policy with the result that all non-discount customers paid on the 25th day? Round your answers to two decimal places. Do not round intermediate calculations.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter21: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 9P: Grunewald Industries sells on terms of 2/10, net 40. Gross sales last year were 4,562,500 and...

See similar textbooks

Similar questions

eBook Baxley Brothers has a DSO of 38 days, and its annual sales are $10,585,000. What is its accounts receivable balance? Assume that it uses a 365-day year. Round your answer to the nearest dollar.
Assume that you start with a balance of $610 on your credit card.During the first month you charge $180 and make a payment of $400. During the second month you charge $100 and make a payment of $280. Assume that your credit card charges a 24% APR. Complete the following take table. Round your answer to the nearest cent. Table 1 month- Previous balance- Finance charge- Purchase- Payments- New balance 2 month- Previous balance- Finance charge- Purchase- Payments- New balance You have a credit card with an APR of 28%. The minimum amount payment is 12% of the balance. Suppose you have a balance of $1050. You decide to stop charging and make only the minimum payment. Complete the table. Round your answers to the nearest cent Table 1 month- Previous balance- Finance charge- Purchase- Payments- New balance 2 month- Previous balance- Finance charge- Purchase- Payments- New balance
Assume that you start with a balance of $3900 on your credit card.During the first month you charge $400. During the second month you charge $650 and make a payment of $280. Assume that your credit card charges a 29% APR and each month you make the minimum payment of 2.5% of the balance. Complete the following table. Round your answer to the nearest cent. Month 1 Previous balance- $3900 Finance charge- $94.25 Purchase- 400 Payment ?97.50 New balance? Month 2 Previous balance- finance charge- purchase- payments- New balance
Receivables Investment Medwig Corporation has a DSO of 37 days. The company averages $9,750 in sales each day (all customers take credit). What is the company's average accounts receivable? Assume a 365-day year. Round your answer to the nearest dollar.
Finance Calculating the Cost of Credit Card Purchases Directions Use the interest rate of 18% and an annual fee of $49 to complete this chart. In Month 1, there was a balance due of $3,000. The borrower will make a monthly payment of $200 and keep new purchases of goods and services at $115 per month for the year. Month 1 Calculate the interest for each month (balance x 1.5%). To obtain the balance for the next month, subtract the payment from the balance and add cost of new purchases plus monthly interest and fee. For example: $3,000 - $200 = $2800+ $115 + $94 = $3,009. (NOTE: The annual fee of $49 is paid only once.) 2 3 4 5 6 7 8 9 10 11 Interest rate: 18% (APR); 1.5% monthly 12 Balance $3,000 $3,009 $2,969.14 Payments $200 $200 Purchases $115 $115 E $49 $45 67-20112.2011 CARD WALICH FRACTORES 2017-12-221. PARTS TAPER Annual fee: $49 Interest & Fee $45.14 Interest & Fee (Cumulative) $94 $139.14 101
H2X Excavating LLC has a $100,000 line of credit at its bank. During the past 31-day month, the company has used $80,000 of this line of credit. The interest rate is 7% APR. a. What will the interest charge be for this month? b. For the upcoming 30-day month, management is projecting that for the first 10 days of the month the balance on the line of credit will be $80,000 and for the last 20 days of the month the balance will be $50,000. How much interest expense should management budget for the upcoming month? c. If the interest rate increased to 9%, what would the interest charge be for a 28-day month, if the entire line of credit was used for the entire month?
McEwan Industries sells on terms of 3/10, net 35. Total sales for the year are $1,947,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 74 days after their purchases. Assume 365 days in year for your calculations. a. What is the days sales outstanding? Round your answer to two decimal places. days b. What is the average amount of receivables? Do not round intermediate calculations. Round your answer to the nearest cent. c. What is the percentage cost of trade credit to customers who take the discount? If your answer is zero, enter zero. Round your answer to two decimal places. d. What is the percentage cost of trade credit to customers who do not take the discount and pay in 74 days? If your answer is zero, enter zero. Do not round intermediate calculations. Round your answers to two decimal places. Nominal cost: Effective cost: % e. What would happen to McEwan's accounts receivable if it toughened up on its collection policy with…
You have a credit card with an APR of 15%. You begin with a balance of $800. In the first month you make a payment of $300 and you make charges amounting to $100. In the second month you make a payment of $200 and you make new charges of $500. Determine all values in the given table. (Enter all answers to the nearest cent.) Month 1 Month 2 Previous Balance mil m21 Payments m12 m22 Purchases m13 M23 Finance Charge m14 m24 New Balance m15 m25
Assume that you start with a balance of $3900 on your credit card. During the first month you charge $400 and during the second month you charge $650. Assume that your credit card charges a 29% APR and that each month you make only the minimum payment of 2.5% of the balance . Complete the following table. Round to nearest cent Table Month 1 Previous balance- Finance charge - Purchase- Payments- New balance Month 2 Previous balance- Finance charge - Purchase- Payments- New balance
Problem #1. You have a Visa credit card account with a 26.49% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on April 1 was $552. On April 10th you made a $119 purchase. You made another purchase, a $25 gift card, on April 24th. You made a $150 payment on April 29th. Show your work for all parts of the problem. (a) What is the average daily balance for April? (b) What is your finance charge on the account as of May 1st? (c) What is your new credit card balance?
choose the letter of the correct answer Log Company’s credit sales are P300,000, and the collection period is 90 days. Cost is 70 percent of selling price. Determine Log's average investment in accounts receivable. a. P32,500.00b. P42,500.00c. P52,500.00d. P62,500.00e. P72,500.00
The Coffee Hut has an ACP of 30 days, and its annual sales are $5 million. What is its account receivable balance? Multiple Choice $551,781 $410.959 $592,098 $459,021