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.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A loan of $17,504 was repaid at the end of 16 months. What size repayment check (principal and interest) was written, if a 7.9% annual rate of interest was charged? Question content area bottom Part 1 The amount of the repayment check was $ enter your response here. (Round to two
Please answer fast without plagiarism please will upvote
Seis
Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days for a payment to be received and recorded, and that the month is 30 days long. (Round your answers to the nearest cent.) $400 balance, 16%, $50 payment (a) previous balance method $ (b) adjusted balance method $ (c) average daily balance method $
Westmore Products has projected the following quarterly sales. The accounts receivable at the beginning of the year is $425 and the collection period is 45 days What are collections for the first quarter? Sales Q1 $ 700 Multiple Choice $350.00 $658 33 $736 67 $700.00 02 $ 755 Q3 $ 840 Help Save & Exit 04 $ 1,130 Sub
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year 01 02 04 Sales # 330 $390 a. Accounts receivable at the beginning of the year are $360. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables 03 $450 Beginning receivables Sales Cash collections Ending receivables S Beginning receivables Sales Cash collections Ending receivables 01 01 300 330 01 330 b. Accounts receivable at the beginning of the year are $360. The company has a 60-day collection period Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e-g.. 32. 02 330 02 390 Q² 390 03 350 03 450 03 c. Accounts…
Q2 Libscomb Technologies' annual sales are $5,433,041 and all sales are made on credit, it purchases $3,986,576 of materials each year (and this is its cost of goods sold). Libscomb also has $581,228 of inventory, $530,966 of accounts receivable, and $416,773 of accounts payable. Assume a 365 day year. What is Libscomb’s Inventory Period (in days)?
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…
Need Answer pls find it
How much would you need to deposit in an account each month in order to have $20,000 in the account in 9 years? Assume the account earns 6% interest. Submit Question .com/course/showcalendar.php?cid=179278 Q Search
E G H $4400 is deposited in a savings certificate at a bank at 3.5% interest. What is the effective interest rate if the money is compounded continuously? What is the effective interest rate if the money is compounded quarterly? Formatting Rules: ■Create organized tables with proper column and 0 row labeling 1 Graphs should have proper labeling for both axis 2 Formatting Rules: 13 14 Create organized tables with proper column and 15 row labeling 16 Graphs should have proper labeling for both axis 17 Formatting Rules: 18 19 Create organized tables with proper column and 20 row labeling 21 Graphs should have proper labeling for both axis 24 25 22222 L(Ctrl)

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS