Problem 1: ABC Corporation is preparing its sales and receivable budget for the year 2022. Details are as follows: The sales during the 4" quarter of 2021 is 30,000 units and the selling price per unit is PS00 per unit. Units to be sold is forecasted to increase by 5% per quarter while the sales price for 2022 will be 2% higher than the previous PS00 per unit. • Of the sales per quarter, 55% are cash sales while the remaining credit sales. The credit sales are expected to be settled as follows: 5/9 will be collected during month of sales, 3/9 will be collected the month after month of sales, and the remaining will be written off two months after month of sale. • The forecasted receivable balance on Jan. 1, 2022 is P3,500,000, 90% of which is expected to be collected during the first quarter while the remaining will be written off during the second quarter of 2022. Required 3d Quarter 4* Quarter 1" Quarter 2d Quarter Sales 1. 2. 3. 4. Receivable balance as of the end of 5. 6. 7. 8. Cash collections 9. 10. 11. 12.

Problem 1: ABC Corporation is preparing its sales and receivable budget for the year 2022. Details are as follows: The sales during the 4" quarter of 2021 is 30,000 units and the selling price per unit is PS00 per unit. Units to be sold is forecasted to increase by 5% per quarter while the sales price for 2022 will be 2% higher than the previous PS00 per unit. • Of the sales per quarter, 55% are cash sales while the remaining credit sales. The credit sales are expected to be settled as follows: 5/9 will be collected during month of sales, 3/9 will be collected the month after month of sales, and the remaining will be written off two months after month of sale. • The forecasted receivable balance on Jan. 1, 2022 is P3,500,000, 90% of which is expected to be collected during the first quarter while the remaining will be written off during the second quarter of 2022. Required 3d Quarter 4* Quarter 1" Quarter 2d Quarter Sales 1. 2. 3. 4. Receivable balance as of the end of 5. 6. 7. 8. Cash collections 9. 10. 11. 12.

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

3
The following forecasted information was taken from the books of Pakhama Enterprises. Month 2020 Budgeted Sales(R)January 120 000February 140 000March 168 000April 144 000May 128 000June 100 000 The following information is also provided for Pakhama Enterprises:60% of all sales is on credit.Debtors are expected to pay their debts as follows:• 70% in the first month after the sale (after 30 days)• 20% in the second month after the sale (after 60 days)• 7 % in the third month after the sale (after 90 days)• 3% is irrecoverable Credit losses are written off at the end of the month in which the last instalment is received.Debtors will amount to R104 994 on 1 Jan…
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
Subject: accounting
Mooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,100 $1,400 $1,450 $1,250 $1,500 Total cash collections $1,100 $1,150 $1,200 $1,200 You also have the following information about Mooney Equipment: • In any given period, Mooney’s purchases from suppliers generally account for 72% of the expected sales in the next period, and wages, supplies, and taxes are expected to be 15% of next period’s sales. • In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 million investment. • Every quarter, Mooney pays $60 million in interest and…
Buffalo Company’s budgeted sales and budgeted cost of goods sold for the coming year are $149,520,000 and $103,320,000, respectively. Short-term interest rates are expected to average 10%. If Buffalo can increase inventory turnover from its present level of 9 times a year to a level of 12 times per year.Compute its expected cost savings for the coming year.
The following are the total sales of Top Class Ltd for the past three months of 2021Month April May JuneTotal Sales R900 000 R700 000 R500 000The budgeted sales figures for the next three months are expected as followsMonth July August SeptemberTotal Sales R825 000 R760 000 R920 000Additional information1) 40% of all sales are made in cash.2) Credit sales for October 2021 are expected to be R450 000.3) Debtors are collected as follows.• 15% of outstanding amounts are collected during the month following the month of sale(i.e.: 30 days). A discount of 4,5% is offered for early settlement of accounts.• 60% is collected in the subsequent month (i.e.: 60 days).• 20% is collected in the subsequent month (i.e.: 90 days).• The balance is irrecoverable and needs to be written off.REQUIRED:Prepare a schedule of forecasted receipts from customers (cash and credit) for the period 1 July 2021to 31 October 2021.Show all workingsRound to the nearest Rand
Capital budgeting 21. An investment of $894,168 promises to return $180,000 each year for the next eight years. If taxes are ignored, what is the internal rate of return?A. less than 9%B. 10%C. 12%D. more than 14% 22. An investment is expected to generate returns of $60,000 per year for each of the next six years. If the initial amount invested is $240,000 and taxes are ignored, which of the following is closest to the internal rate of return?A. 15%B. 13%C. 10%D. 7%
The Company produces widgets. The sales forecast for 2022 is as follows: Quarter 1 3,000 Quarter 2 8,000 Quarter 3 5,000 Quarter 4 6,000 The unit selling price of the widgets is $200 each. Prepare a Sales Budget for 2022, including the annual total.
None
Cash budget for each month, information attached.
Prepare a sales budget including a column for each year in and a column for the total. The budgets should also include a schedule of expected cash collection, by year and in total.Make your assumptions about the type of sales (cash versus credit) and your credit terms clear.