McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $1,912,500; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 66 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. 43.6 $ b. What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate calculations. 228,452 days c. What is the percentage cost of trade credit to customers who take the discount? Round your answers to two decimal places. 3.09 %

McEwan Industries sells on terms of 3/10, net 40. Total sales for the year are $1,912,500; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 66 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. 43.6 $ b. What is the average amount of receivables? Round your answer to the nearest cent. Do not round intermediate calculations. 228,452 days c. What is the percentage cost of trade credit to customers who take the discount? Round your answers to two decimal places. 3.09 %

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Medwig Corporation has a DSO of 17 days. The company averages $8,500 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.
Cook Security Systems has a $37,500 line of credit, which charges an annual percentage rate of prime rate plus 4%. The starting balance on October 1 was $9,300. On October 4 they made a payment of $1,800. On October 13 the business borrowed $2,500, and on October 19 they borrowed $4,400. If the current prime rate is 6%, what is the new balance (in $)? (Round your answer to the nearest cent.) $ 11,145.48
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021
Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Munoz expects sales in January year 1 to total $270,000 and to increase 15 percent per month in February and March. All sales are on account. Munoz expects to collect 69 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 7 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Munoz will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the amount of accounts receivable as of March 31, year 1. (Do not…
Please help me. Thankyou.
Bluewater, Inc. has the following estimated quarterly sales for next year. The accounts receivable period is 60 days. What is the expected accounts receivable balance to the nearest dollar at the end of the third quarter? Assume that each month has 30 days. Q2 Q3 Q4 $1,300 $1,425 $2,200 Ⓒa. $800 b. $367 c. $950 d. $733 Qe. $867 Q1 Sales $1,850
Wally has provided the information below – and asked you to create an Income Statement and Balance Sheet for AndrewCo for the year ended December 31, 2019. Sales were $1,200,000 Gross profit margin was 50% Operating margins were 10% The Bank of Toronto provided a loan on Jan 1, 2019 worth $300,000. The annual interest is 8% and is compounded annually. Interest only payments are needed – until the loan is due in 10 years, where a balloon payment for the full balance must be paid. The combined federal and provincial tax rates is 25% Wally knows that the ending cash balance in his company is 200,000. Accounts Receivables is 12% of sales Inventory is 15% of sales Accounts Payable is 5% of sales Accrued expenses payable is 5.5% of sales Capital equipment purchases were made at the start of the year. These total $50,000. These depreciate at 10% per year The owner will provide all other capital in the form of equity financing Wally has asked you to figure out his Selling General and…
Tucker Technology has current asset of $350,000 and current ratio of 2.0. Compute Tucker's current ratio after the following 4 transactions are all finished. Borrow $20,000 in a short-term note. Purchase $75,000 inventory on credit. Collect $30,000 of accounts receivable. Pay $20,000 of account payable.
Read the problem and answer the questions below. Write your answers in the worksheet 1. There are 1,000 iron bars in stock, and 1,500 are due in form orders that were placed previously. The company sells iron bars at the rate of 100 per day and observed that it takes an average pf 20 days for an order to be received. Because usage and lead times are known with certainty and because the company has determined that an order must be placed now, the desired safety stock quantity must be equal to 2. Heir Company has a plant that manufactures PSP. One of its is PSP 5. Expected demand is 5,200 of this video player in April 2021. Heir estimates the ordering cost per purchase order to be P2500. The carrying cost for one unit of PSP in stock is P50. What is the EOQ for PSP 5? 3. GameSports operates a boutique featuring sports merchandise. It uses EOQ model in making inventory decision. It is now considering inventory decisions for its UAAP jerseys product line. This is highly popular item. Data…
How much sales revenue and net income would you expect PolicePrep to have in the next fiscal year (i.e., 12 months from July, 2003 to June, 2004; see Exhibit 5 on pg. 15). Please explain how you arrived at your answer. Note that Exhibit 5 covers 1 year, with the first column reporting 6 months data from July-Dec 02’ and the next two columns reporting data on the quarterly basis for Jan-Mar 03’ and Apr-Jun 03’)? If you don’t know what EBITDA stands for, please see: http://en.wikipedia.org/wiki/Earnings_before_interest,_taxes,_depreciation_and_amortization
Your company received a $7 million order on the last day of the year. You filled the order with $3 million worth of inventory. The customer picks up the order the same day and pays $2 million up front in cash; you also issue a bill for the customer to pay the remaining balance of $5 million within 40 days. Suppose your firm’s tax rate is 0% (ignore taxes). Based on this information, complete the table below: Account Account Increase/Decrease/ No effect Value of effect ($) Revenues Earnings Receivables Inventory Cash