McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $971,500;...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $971,500; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 52 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. Open spreadsheet a. What is the days sales outstanding? Round your answer to two decimal places. days 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 52 days? Round your answers to two decimal places. Do not round intermediate calculations. Nominal cost: Effective cost: % % e. What would happen to McEwan's accounts receivable if it toughened up on its collection policy with the result that all nondiscount customers paid on the 20th day? Round your answers to two decimal places. Do not round intermediate calculations. DSO - days Average receivables $ McEwan Industries sells on terms of 3/10, net 20. Total sales for the year are $971,500; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 52 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. Open spreadsheet a. What is the days sales outstanding? Round your answer to two decimal places. days 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 52 days? Round your answers to two decimal places. Do not round intermediate calculations. Nominal cost: Effective cost: % % e. What would happen to McEwan's accounts receivable if it toughened up on its collection policy with the result that all nondiscount customers paid on the 20th day? Round your answers to two decimal places. Do not round intermediate calculations. DSO - days Average receivables $
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Prepare budgetary and proprietary journal entries to record the following year- end adjustments: 1. An accrual of $ 60,000 was made for salaries earned the last week of September, to be paid in...
-
If the total energy stored in the circuit in figure 80mJ, what is the value of L? 50 N 200 a 80 F2 1. A
-
In 2015, Firm K paid $129,000 real property tax to Jurisdiction J and deducted the payment. In 2016, it successfully contested the property tax assessment. As a result, Jurisdiction J refunded...
-
What are three basic methods for allocating factory overhead costs?
-
David and Cheryl Allen are in their mid-30s and have two children, ages 8 and 5. They have combined annual income of $95,000 and own a house in joint tenancy with a market value of $310,000, on which...
-
Federal Semiconductors issued 11% bonds, dated January 1, with a face amount of $720 million on January 1, 2024. The bonds sold for $665,831,880 and mature on December 31, 2043 (20 years). For bonds...
-
Am trying to make a subquery, where the first query finds every entity with a specific first name, and then a subquery that limits said entities to a specific last name. Here are the relevant table:...
-
Watch the two videos on cultural development in Kenya. Question: Where Kenya is located in Africa, and can you name three African nations that are currently focusing on community development projects...
-
Imagine you are traveling in a wide open space. You walk 2 0 . 0 m due north, and then 1 7 . 0 m due east. what is your displacement start to finish?
-
You recently received a scholarship from the CEO of a company called Scott's Bots. The CEO, Mr. Scott, has taken a personal interest in your studies. He has suggested that you should major in...
-
Provide an example of how you can provide a rights based care approach? Provide an example of how you can provide a consumer directed care approach?
-
1. (25 points) In this problem, we show that optimal solutions are strongly structured by the form of the objective function, independent of the distribution of the data for three common cases of...
-
Q21) (Input / Output) A personal computer salesman visiting a university in South-West Amsterdam remarked during his sales pitch that his company had devoted substantial effort to making their...
-
The test statistic in the NeymanPearson Lemma and the likelihood ratio test statistic K are intimately related. Consider testing H 0 : = 0 versus H a : = a , and let * denote the test statistic...
-
This problem can be solved analytically or with a spreadsheet. Two identical large glass bulbs are filled with gases and connected by a capillary tube that is \(\delta=0.0090\) \(\mathrm{m}\) long....
-
Estimate \(\mathrm{Sc}_{\mathrm{V}}\) for a saturated vapor mixture that is \(80 \mathrm{~mol} \%\) ethanol and \(20 \mathrm{~mol} \%\) water at \(1.0 \mathrm{~atm}\).
-
PhotoMax, Inc., plans to prepare a sales budget schedule and a purchases budget schedule for 20X3. Management has set a sales goal of 250,000 units. After reviewing price trends, the sales manager...
Study smarter with the SolutionInn App