Black Corporation has forecasted sales in 2020 as follows: Jan-P120,000 Feb-P160,000 Mar-P180,000 Apr-P240,000. December 2019 sales is P100,000. Sales are collected 25% for the month, 50% the following month and balance for the month again. What is the total cash receipts for the first quarter of 2020? P540,000 P420,000 P630,000 P400,000
Q: Martin Corporation’s expected sales revenue for the 4th quarter of 2023 is as follows: Oct…
A: The objective of the question is to calculate the expected cash collections for Martin Corporation…
Q: The Corado Company has predicted sales for the first three quarters of 2024. The predictions are: 1…
A: The objective of the question is to calculate the expected cash inflows for the Corado Company in…
Q: Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands…
A: Cash collection refers to the amount that is collected form the customer after selling goods and…
Q: Smith Company was organized on August 1 of the current year. Projected sales for the next three…
A: Particulars August September October Projected sales (a) 250000 200000 275000…
Q: Star Co. was organized on August 1 of the current year. Projected sales for the next three months…
A: Schedule of Expected Cash Collections: Schedule of Expected Cash Collections from the customers…
Q: As an example, say a company expects $1M in May sales and they forecasted they would receive $500k…
A: Cash budget is one of the useful budget being prepared in business. It shows all cash receipts and…
Q: A company forecasts that the following sales: in May, 321 BD in June and 243 in JulySales will be…
A: Sales in June = 321 Sales in July = 243 30% sales paid in cash, 30% after one month and 40% paid…
Q: Dora Distribution has projected the following quarterly sales. The accounts receivable at the…
A: The average number of days needed to gather the due amount from clients or customers can be defined…
Q: Sheridan Corporation is projecting a cash balance of $32,100 in its December 31, 2019, balance…
A: Cash budget means the statement which shows the expected cash available for distribution including…
Q: Byanong prepares the cash budget for the month of November 2022. Estimates for the month include the…
A: Cost of goods sold = Sales x (1 - gross profit rate) = P250000 x (1 - 0.50) = P125,000
Q: Johnson Corporation has the following sales forecasts for the first three months of the current…
A: Computation of the cash balance at the end of January:Cash balance, January 1$25,000Add: Cash…
Q: The accountant of Turn Key (Pty) Ltd instructs you to prepare a monthly cash budget for August. You…
A: Cash Budget shows the expected inflows and outflows of cash in a particular time period, which then…
Q: The Guitar Shoppe reports the following sales forecast: August, $120,000; September, $210,000. Cash…
A: Cash receipt budgets used by the entity to identify the amount of cash collected every month from…
Q: A firm has projected sales in May, June, and July of P10,000, P20,000, and P30,000, respectively.…
A: Usually, the Firm needs to assess the cash position to assess the cash requirement from time to…
Q: Homer Company expects credit sales for January to be $50,000. Cash sales are expected to be $30,000.…
A: Given, Credit sales for January = $50,000 Cash sales for January = $30,000 Increase in sales = 10%…
Q: Assume that we have the following estimations of the sales units for the 2024 sales, and that there…
A: Calculation of Cash sales, Cash purchase and Cash wages
Q: lion company expects $650,000 of credit sales in march and $800,000 of credit sales in april. lion…
A: The cash budget keeps the records of cash requirements in the business.
Q: The directors of Kingston & Co. were concerned about the company's cash flow. They requested their…
A: All amounts are in (RM).
Q: June sales were $20,000, while projected sales for July and August were $50,000 and $71,000,…
A: The cash collection schedule is prepared to estimate the cash collection during the given period.…
Q: Transformers, Inc. prepared cash estimates for the 3rd quarter of 2022 (3-months). The following…
A: Budgeting - Budgeting is a technique of estimating sales and expenses to be incurred in the later…
Q: Serendipity, Inc. prepared cash estimates for the 3rd quarter of 2021 (3-months). The following…
A: The budget is prepared to estimate the future requirements for the business.
Q: Suppose that the Sales in December 2019 were 64,566. The sales are expected to grow by 6% in January…
A: Cash outflow will be sales – purchase – general administrative expenses – interest expense for the…
Q: Avani Goldcoast Sdn. Bhd. is estimating its need for funds for the second and third quarter of the…
A:
Q: Snow Use Inc had the following sales budget for Q1 2022. January sales £160,000: February sales…
A: A budget is used by corporations, governments, and people of all economic levels and is an…
Q: Adeline Sdn Bhd has engaged you to prepare its cash budget for July 2021. The following is the…
A: Cash Budget: It is the estimation of the cash in flows and outflows of an enterprise during a…
Q: How much are anticipated Cash collections during the month of February?
A:
Q: 1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month…
A: The accounts receivables represent the amount due from customers for sales made by the company on…
Q: Use the information provided below to prepare the following for January and February 2023:…
A:
Q: In 2021, Chatsworth Company expects sales of $40,000 in July, $50,000 in August, and $30,000 in…
A: July sales = $40,000 July Cash sales = 40% July Credit sales = 60% Uncollectble amount = 5% of…
Q: Deitz Corporation is projecting a cash balance of $33,000 in its December 31, 2019, balance sheet.…
A: CASH BUDGET Cash Budget is a detailed budget of cash income and cash expenditure incorporating both…
Q: Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands…
A: In this we have to calculate cash flow in 3 and 4 months.
Q: Blue Devil Inc. expects the following cash receipts and disbursements during the first quarter of…
A: Cash budgets are the budgets that are prepared to estimate the future cash outlays and incomes.
Q: Pink Martini Corporation is projecting a cash balance of $32,000 in its December 31, 2019, balance…
A: Cash budget is the statement prepared by managerial accountants to estimate the future cash revenues…
Q: 1. How much is the net cash flow for December?= 2. How much is the excess cash balance for…
A: All the expected net outflows and inflows are considered while calculating net cash flows. It helps…
Q: Vertical Ladder Company (VLC) forecasts its sales for January through April will be $60,000,…
A: A cash budget refers to the document that is prepared for helping the business for managing the…
Q: The beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on…
A: Lets understand the basics.Budget is an estimation of future profit and loss in the…
Q: A firm has projected sales in May, June, and July of $100, $200, and $300, respectively. The firm…
A: A quantity of money given to a company in exchange for goods or services: We add the cash receipts…
Q: Mr. James Pastor, a financial analyst for ABC Company, has prepared the following actual sales and…
A: In this problem we will start with opening cash balance of Oct 2020…
Q: Pacific Place has developed the following sales forecast for the following months. Month…
A: Introduction Cash budget: Cash budget is an estimate of cash receipts and cash payments for a future…
Q: During September 2020, ABC Corporation is preparing for its 2021 sales and receivables forecast. The…
A: Budgeting is forecasting of various future events. In accounting , it is used to forecast Income ,…
Step by step
Solved in 3 steps with 2 images
- The Runner Antique Mall expects to make purchases in the first quarter of 2021 as follows: January $85,500 February 108,000 March 76,500 Purchases in December 2020 are expected to be $82,600. The company expects that 50 percent of a month's purchases will be paid in the month of purchase and 50 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2021.From the following information, prepare a monthly cash budget for the three months ending 31st December 2023. Month June July August September October November December Materials Wages 1,800 650 2,000 750 2,400 750 2,250 750 2.300 800 2,500 2,600 900 1,000 The credit terms are as follows: 10% of sales are in cash. 3 months to debtors. 2 months from Creditors. Sales 3,000 3,250 3,500 3,750 4,000 4,250 4,500 The lag in payment for wages is 1/4 month and 1/2 month for overheads. The cash and bank balance on 1st October is expected to be RO 1,500. Other information is given as follows: Admin. Selling, etc 160 160 175 175 200 200 225 Production 225 225 250 300 300 350 350 Preference share dividends @ 5% on RO 50,000 are to be paid on 1st December. Calls on 250 equity shares @RO 2 per share are expected on 1st November. Dividends from investments amounting to RO 250 are expected on 31st December. Income tax (advance) is to be paid in December RO 1,500 Plant and machinery are to be installed…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,320Mooney 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…Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
- Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?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,750please answer within 30 minutes. Projected Cash Receipts,Romaris Brothers Inc. needs a cash receipts schedule for the months of April, May, and June. Actual Sales: February = $500,000, March = $500,000. Forecast Sales: April =$560,000, May= $610,000, June= $650,000, July= $650,000, Assuming that sales are the only source of cash inflows and that 30% of them are for cash and the remainder are collected evenly over the following 2 months. Prepare a schedule of projected cash receipts for April, May and June. Projected Cash Disbursements Romaris Brothers Inc. needs a cash disbursement schedule for the months of April, May, and June. The following information was collected from financial records: Purchases: Purchases are calculated as 50% of the next month’s sales, 15% of purchases are made in cash, 60% of purchases are paid for 1 month after purchase, and the remaining 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month. Wages and…
- The Martin Company expects its total sales in the first quarter of 2024 will be $200,000 . Martin estimates that , in each subsequent quarter , total sales will increase by 10 % of the sales in the immediately preceding quarter . Martin estimates that 60 % of each quarter's sales will be on account , and 40 % will be for cash . Of the amount on account , 75% will be collected in the same quarter the sale occurred , and 25 % will be collected in the following quarter . Assume Martin will have no accounts receivable at the beginning of 2024. The balance in the Accounts Receivable account at the end of the third quarter is expected to be: $42,000 $ 30,000 $36,300 $ 60,000 $108,900NuParts, Inc., has estimated quarterly sales for next year, starting with Quarter 1, of $15,900, $16,800, $17,500, and $16,400. Purchases are equal to 67 percent of the following quarter's sales and the accounts payable period is 60 days. Assume 30 days in each month. How much will the firm owe its suppliers at the end of Quarter 3? $7,066.67 $7,506.67 $7,816.67 $6,933.33 $7,325.33The beginning cash balance is $18,000. Sales are forecasted at $860,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $95,000, and the annual interest rate is 8%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $