Question

In: Finance

ABC Company has projected Sales of $13181 in January. The sales are expected to grow by...

ABC Company has projected Sales of $13181 in January. The sales are expected to grow by 9% each month. ABC's collection schedule is as follows:

ABC collects 55 percent of its sales in the month of sale and the remainder is collected in the following month. What is the amount of the March cash collections?

Solutions

Expert Solution

Solution :

Solution:

As per the information given in the question we have

Projected Sales of January = $ 13,181

Sales for the further months after January are expected to Increase by 9 % .

Projected sales of February = ( Sales of January * 109 % )

= $ 13,181 * 109 % = $ 14,367.2900

Projected sales of March = ( Sales of February * 109 % )

= $ 14,367.2900 * 109 % = $ 15,660.3461

As per the information given in the question

The total cash collections of a given month = 55 % of sales made in the given month + 45 % of sales made in the month before i.e, the preceding month

Thus the total cash collections made in March = 55 % of sales made in the month of March + 45 % of sales made in Month of February

Hence the total of March cash collections = ( 55 % * $ 15,660.3461 ) + ( 45 % * 14,367.2900 )

= $ 8,613.1904 + $ 6,465.2805 = $ 15,078.4709

The amount of the March cash collections = $ 15,078.4709


Related Solutions

ABC Company currently has sales of $250 million. The company's sales are expected to grow 20%...
ABC Company currently has sales of $250 million. The company's sales are expected to grow 20% next year (year 1) and 10% during year 2. The analyst expects the company to have a net profit margin of 8% each year, a dividend payout ratio of 50%, 15 million shares of common stock outstanding over the time horizon, and sell for a p/e ratio of 15 at the end of year 2. If the required rate of return is 20%, then...
ABC company’s dividend is projected to be $2 next year (t=1) and is expected to grow...
ABC company’s dividend is projected to be $2 next year (t=1) and is expected to grow by 10% for the following years (from t=2 to ∞). 22. What is the expected dividend in year 3? $ 4.46 $ 4.72 $ 4.29 $ 2.16 23. If the discount rate is 13%, what is the estimate of the stock price? $ 66.67 $ 129.79 $ 86.58 $ 99.68 24. Marquis Jewelers has expected earnings per share of $2.80 and an expected earnings...
ABC Company has the following projected sales: Month      Sales Jan         $5,000 Feb         $14,000...
ABC Company has the following projected sales: Month      Sales Jan         $5,000 Feb         $14,000 Mar         $27,000 Apr         $56,000 14% of the sales are collected in the same month. 26% of the sales are collected after one month, 42% of the sales are collected after two months, and the remainder are collected after three month. What is the amount of the April collections? Enter your answer rounded off to two decimal points. Do not enter $ or...
Q1.ABC Company has projected sales and production in units for the second quarter of 2017 as...
Q1.ABC Company has projected sales and production in units for the second quarter of 2017 as follows Particular April May June sales 35,000 25,000 30,000 Production 30,000 25,000 40,000 Cash production costs are budgeted at SR 7 per unit produced. Of these production costs, 30% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses (all paid in cash) amount to SR 70,000 per month. The accounts payable balance...
ABC company is expected to grow at the industry constant rate of 6% and its dividend...
ABC company is expected to grow at the industry constant rate of 6% and its dividend yield is 7%. the company is as risky as the average firm in the industry, but it successfully completed some R&D work that leads to the expectation that its earnings and dividends will grow at a rate of 50% this year and 35% in the following year, after which growth return to the 6% industry average. if the last dividend was $1.00, what is...
The ABC COmpany just paid a $0.8 quarterly dividend. The dividends are expected to grow at...
The ABC COmpany just paid a $0.8 quarterly dividend. The dividends are expected to grow at 20% per year for the next 3 years. After that, the growth rate is expected to go down to the industry average of 8% per year and stay at this level forever. The required rate of return on ABC is 15% per annum. 1)Draw the time line, showing dividends of ABC. 2)Find the price of ABC stock. 3)Find the value of its growth opportunities...
ABC Inc. has projected sales and production in units for the second quarter of the coming...
ABC Inc. has projected sales and production in units for the second quarter of the coming year as follows: April May June sales....... 50,000 40,000 60,000 production..... 60,000 50,000 50,000 cash related production costs are budgeted at $5 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $100,000 per month. The accounts payable balance on March 31...
1. Ogier Incorporated currently has $900 million in sales, which are projected to grow by 8%...
1. Ogier Incorporated currently has $900 million in sales, which are projected to grow by 8% in Year 1 and by 4% in Year 2. Its operating profitability (OP) is 7%, and its capital requirement (CR) is 65%. Do not round intermediate calculations. Enter your answers in millions. For example, an answer of $1 million should be entered as 1, not 1,000,000. Round your answers to two decimal places. What are the projected sales in Years 1 and 2 (in...
ABC Company manufacture one product with the following data January February Expected sales (units)          10,000          11,000...
ABC Company manufacture one product with the following data January February Expected sales (units)          10,000          11,000 Beginning inventory (units)            2,000 The company requires to have ending inventory equals to 20% of the next month sales in units. Find the need purchases for January a. 10,000 b. 10,200 c. 10,300 d. 10,450
ABC Company limited produces coat racks. The projected sales for the first quarter of the coming...
ABC Company limited produces coat racks. The projected sales for the first quarter of the coming year and the beginning and ending inventory data are as follows: Sales 100,000 units Unit price SAR 15 Beginning inventory 8,000 units Targeted ending inventory 12,000 units The coat racks are molded and then painted. Each rack requires four pounds of metal, which cost SAR 2.50 per pound. The beginning inventory of materials is 4,000 pounds. ABC Company Limited wants to have 6,000 pounds...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT