Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 35 44 38 34 Sales on credit 300 320 290 270 On average, 45% of credit sales are paid for in the current month, 25% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place.
Q: Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20%…
A: Cash Budget: A cash budget plan is a report delivered to assist a business with dealing with their…
Q: Green Corporation anticipates a cash requirement of P1,000 over a 1- month period. It is expected…
A: Given, Cash requirement (1-month) = P1,000 Annual interest rate = 24% Transaction cost of borrowing…
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: Estimated sales for the next four months are as follows (in $ million): Month Cash sales Credit…
A: In accounting we often make cash budgets. A cash budget is a budget or a document that shows the…
Q: A firm has actual sales in November of $1,363 and projected sales in December and January of $2,928…
A: Credit sales refer to the sales in which the customer is given some time to pay for the goods…
Q: The Professional Service Company expects 80% of sales for cash and 20% on credit. The company…
A: The objective of the question is to calculate the total cash receipts for the Professional Service…
Q: A company's history indicates that 25% of its sales are for cash and the rest are on credit.…
A: The cash collection schedule is prepared to estimate the cash collection from the customers during…
Q: Below is a cash flow projection on a sequential-pay CMO, which has four tranches, A through D.…
A: Sequential payment CMOs are treated as collateralized mortgage obligations, including the…
Q: Limitless Styles has a 45 day accounts payable period. The firm has expected sales of $900, $1,200,…
A: Account payable period = 45 days Cost of goods sold = 70% of next quarter sales sales of quarter 3rd…
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: 25% of purchases are paid for 2 months after purchase. Rent: The firm pays rent of $9,000 per month.…
A: Note: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…
Q: Wells Company reports the following sales forecast: September, $55,000; October, $66,000; and…
A: Schedule of cash receipts: A schedule of cash receipts shows how much cash is expected from debtors…
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: Vaughn Industries expects credit sales for January, February, and March to be $268,400, $317,200,…
A: Given, 75% of credit sales collected in month of sale 25% of credit sales will be collected in the…
Q: Below is a cash flow projection on a sequential-pay CMO, which has four tranches, A through D.…
A: A principal payment is a contribution made to the loan's outstanding balance. There are various…
Q: The Professional Service Company expects 80% of sales for cash and 20% on credit. The company…
A: The budgets are prepared to estimate the requirements for the future period.
Q: Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter…
A: Cash budget is one of the important budget being prepared in business. It shows all cash inflows and…
Q: Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If…
A: The cash budget is prepared to know the estimated cash receipt and cash expenses. it helps in the…
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: Bruno Industries expects credit sales for January, February, and March to be $200,000, $260,000, and…
A: Cash collection budget :— This budget is prepared to estimate the collection of sales from customers…
Q: Frontier Ltd., a leader in solar technology, makes all sales on credit, offering terms 2/10 net 40.…
A: Cash Budget budget is to be prepared for April may and june month. Jan, Feb and march sales are…
Q: A company's history indicates that 20% of its total sales are for cash and the remaining 80% are on…
A: Cash receipts means the expected money collected by the entity during a period from the sales of the…
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: Graham Potato Company has projected sales of $10,200 in September, $13,500 in October, $20.200 in…
A: Cash budget is used to estimate cash inflows (cash receipts) and cash outflows (cash payments) of a…
Q: Here is a forecast of sales by National Bromide for the first 4 months of 2022 (figures in thousands…
A: Budgeting is a technique of estimating future sales, expenses, receipts and payments on the basis of…
Q: The Professional Service Company expects 70% of sales for cash and 30% on credit. The company…
A: Credit Sales of June: 70% will be collected in June. 25% will be collected in July. 5% are not…
Q: Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $…
A: The cash inflow calculation include calculating credit sales and cash sale . The total sales is…
Q: The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming…
A: Accounts receivable refer to the amounts owed to a company by its customers or clients for goods or…
Q: January February March The Accounts Receivable balan Prepare a schedule of cash col INN Schedul For…
A: Lets understand the basics.Management prepare budget in order to estimate future profit and loss…
Q: Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $…
A: The cash inflow calculation include calculating credit sales and cash sale . The total sales is…
Q: Assume that sales and expenses forecasts for months April, May, June, and July are as follows. 20%…
A: Pro forma cash flow It provides the estimated cash inflow and cash outflow for the coming period. It…
Q: Ballentine Company expects sales for June, July, and August of $65,000, $71,000, and $61,000,…
A: Cash sales for August (61,000 x 40%) = $24,400
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: Here is a forecast of sales by National Bromide for the first four months of 2019 (figures in $…
A: As per the given information: Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16…
Q: chedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers…
A: Cash collection schedule is prepared to estimate the total receipts of a particular period. Total…
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: Prepare a cash Collection Schedule for Producers Inc. For the months of March, April and May 2022…
A: Cash flows are the cash generated from the operation of the business organisation. In other words,…
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: The George Company has a policy of maintaining an end-of-month cash balance of at least $30,000.In…
A:
Q: The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming…
A: Collection Period:Usually in a business sales are made on both cash and credit basis. The credit…
Q: n August 1 of the current year. Projected sales for the next three months are as follows: $100,000…
A: Schedule of Expected Cash Collections: Schedule of Expected Cash Collections from the customers…
Q: Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be…
A: Total sales = Cash sales + Credit Sales The company will receive cash in February for Credit sales…
Step by step
Solved in 3 steps with 2 images
- The beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on account. The remainder are cash sales. Sixty percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $465,000. Accounts receivable from previous accounting periods totaling $11,000 will be collected in the current year. The company is required to make a $21,500 loan payment and an annual interest payment on the last day of the year. The loan balance as of the beginning of the year is $145,000, and the annual interest rate is 10%. What will be reported as 'cash' on the budgeted balance sheet?Mr. James Pastor, a financial analyst for ABC Company, has prepared the following actual sales and cash disbursement for the months of August to September 2020 and estimates for the months of October to December of the current year: Month Sales: August P5,000,000; September P6,000,000; October P4,000,000; November P2,000,000; and December P2,000,000 Cash Disbursements: August P4,000,000; September P3,000,000; October P6,000,000; November P5,000,000; and December P2,000,000. Pastor notes that historically, 30% of sales have been for cash. Of credit sales, 70% are collected 1 month after the sale, and the remaining 30% are collected 2 months after the sale. The firm wishes to maintain a monthly minimum cash balance of P250,000. Balances above this amount would be invested in short-term government securities (marketable securities) whereas any deficits would be financed through short-term bank borrowings (notes payable). The beginning cash balance at October 1 is P1,200,000.a. Prepare…Pacific Place has developed the following sales forecast for the following months. Month Sales May $500,000 June $650,000 July $380,000 August $300,000 The collection policy for customers is: 40 percent in the month of sale 60 percent in the following month after sale How much is the expected total cash collections from customers in June? Multiple Choice $610,000 $260,000 $590,000 $560,000 $300,000
- Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)Green Corporation anticipates a cash requirement of P1,500 over a 1- month period. It is expected that cash will be paid uniformly. The annual interest rate is 24 percent. The transaction cost of each borrowing or withdrawal is P30. (a) What is the optimal cash balance? (b) What is the average cash balance? CHOOSE THE CORRECT ANSWER FOR A AND B(A) P1,432.05 and (B) P566.03(A) P2,121.32 and (B) P8060.66(A) P1,121.32 and (B) P1060.66(A) P2,121.32 and (B) P1060.66(A) P1,732.05 and (B) P866.03the 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,320Star 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?Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 33 29 26 23 21 21 a. Fifty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $23 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.) b. Suppose that from the start of the year the company stretches payables by paying 50% after one month and 30% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)
- please 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…Superstar Berhad reported sales of RM70,000 in May and RM80,000 in June. The forecast sales for July, August and September are RM90,000, RM100,000, and RM110,000, respectively. The beginning cash balance on July 1 is RM3,000 and the firm wishes to maintain a minimum cash balance of RM5,000 every month. The total long-term liabilities of the company is RM25,000. Given the following data, prepare a cash budget for the months of July, August and September. The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. The firm receives other income of RM 2,000 per month. The firm’s actual or expected purchases, all made for cash, are RM65,000, RM70,000, and RM85,000 for the months of July through September, respectively. Rent is RM5,500 per month. Wages and salaries are 10% of the previous month’s sales. The net income is RM30,000. Cash dividends is 20% of the net income and will be paid in August. The…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…