Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 27 3 4 30 26 160 180 150 130 Month 3 Month 4 2 36 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. Expected Cash Collections

Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands of dollars): Month: Cash sales Sales on credit 1 27 3 4 30 26 160 180 150 130 Month 3 Month 4 2 36 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that What are the expected cash collections in months 3 and 4? Note: Enter your answers in whole dollars not in thousands of dollars. Expected Cash Collections

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

0. Swetres Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Roleg Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Roleg's gross margin for 2019? 12.…
Wildcat, Incorporated, has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $170 $185 $200 $225 Sales for the first quarter of the year after this one are projected at $180 million. Accounts receivable at the beginning of the year were $71 million. Wildcat has a 45-day collection period. Wildcat's purchases from suppliers in a quarter are equal to 45 percent of the next quarter's forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $14 million per quarter. Wildcat plans a major capital outlay in the second quarter of $85 million. Finally, the company started the year with a $54 million cash balance and wishes to maintain a $30 million minimum balance. Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can Invest any excess funds in short-term marketable securities at a rate of 2 percent per…
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september 195,000 october 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. vi) the company plans to pay rm 6,500 in cash for a brand-new computer in august. vii) a quarterly dividend of rm 10,000 will be paid to ABC…
Neha Wholesalers supplied you with the following projected information:1. Expected sales are as follows:August R350 000September R280 000October R300 0002. Cash sales are expected to be 50% of total sales. The balance is on credit.3. Debtors are expected to settle their accounts as follows:40% in the month of the sale60% one month after the sale4. Expected purchases are as follows:August R100 000September R 40 000October R 50 0005. All purchases are on credit. Creditors are paid one month after the purchases less 10%discount.6. Rent expenses amount to R7 000 per month, Rent will increase by 15% from 1 October.7. Selling expenses are expected at 1% of total sales and are paid during the month of sales.8. Insurance amounts to R360 000 per annum, payable monthly.9. The owner intends making a cash drawings of R5 000 each month.10. Interest on fixed deposit of R2 000 is due on 1 September.11. The bank balance on 31 July is expected to be R25 000 favourable.Required:1.1 The Debtors…
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
JoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750
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…
15. On December 31,2021, the Denjay Gift Shop had outstanding accounts receivable balance of P20,000. Denjay's sales are roughly evenly split between credit and cash sales, with half the credit sales collected in the month after sale and the remainder two months after the sale. historical and projected sales for the gift shop are: Month Sales October 2021 150,000 November 2021 200,000 December 2021 300,000 January 2022 (projected) 400,000 Under the circumstances what should the balance in accounts receivable be at the end of January 2022?
INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 0006. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000. Salaries are expected to increase by 9% with…
A courier service has revenue ranges with probabilities shown in the table. Monthly capacity is 60,000 parcels and monthly O$M costs are $8,000. MARR is 12%, compounded monthly. What is the present worth of the expected revenue over 12 months? Revenue per parcel Probability $2.95 $3.25 $3.50 $4.00 $5.00 0.1 0.35 0.3 0.15 0.1 Note: Precise values were used for calculating PW. You have to account for the effect of rounding if you do the calculations manually. O PW=$2,435,599 O PW-$2,217,321 O PW=$2,329,238

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