Melody Inc. had a November ending cash balance of $15,000. As well, it had sales of $10,000 in November, $20,000 in December, and projects sales of $25,000 for January, $30,000 for February, and $35,000 for March. The firm collects its receivables in the month after the sale. Given this information, calculate its cash balance at the end of March. Assume that every month has 30 days. $75,000 $80,000 $90,000 $100,000 $110,000
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: onth's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30%…
A: Income statement reports the company income and expenses. It reports income and expenses on accrual…
Q: Cash Accounts receivable Inventory Budgeted Balance Statemen July 31, 2021 Assets
A: *Estimated account receivable turnover: Credit sales = 345000×80% = $276000 Out of $276000, 30% will…
Q: A firm has actual sales of $69,000 in April and $57,000 in May. It expects sales of $74,000 in June…
A: Part 2: Explanation:Step 1: Calculate the cash portion of sales for each month:- April: $69,000 / 2…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: The time that inventory remains in storage before being sold is known as the inventory period…
Q: Crane Company management wants to maintain a minimum monthly cash balance of $20,000. At the…
A: Cash BudgetCash Budget is prepared to know the cash collections received and cash payments in the…
Q: Romper Company expects its November sales to be 20% higher than its October sales, which were…
A:
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: Knyok Co budgeted the following cash receipts (excluding cash receipts from loans received) and cash…
A: The cash budget is prepared to estimate the cash requirements and cash balance during the period.
Q: Marcel Company projects the following sales for the first three months of the year: $13,500 in…
A: Cash budget: It implies to a financial estimation that reflects all the inflows and outflows of cash…
Q: Foyert Corporation requires a minimum $7,400 cash balance. Loans taken to meet this requirement cost…
A: Budgeting anticipates revenue and expenditures for a future period based on the past performance and…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: Cash flow statement: The statement that shows an increase or decrease in the cash and cash…
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: alley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: The balance sheet is one of the financial statements of the business. It represents the business's…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: Income Statement :— It is one of the financial statement that shows profitability, total revenue and…
Q: crane company management wants to maintain a minimum monthly cash balance of $26,500. At the…
A: The cash budget is an estimate of cash receipts and their payment during a future period of time.
Q: Suppose that the Sales in December 2019 were 78,893. The sales are expected to grow by 15% in…
A: In the month of June. 56% (100%-22%-22%) of April sales cash is collected, 22% of May sales and 22%…
Q: The Dilly Company (DC) began operations on December 1, 2021. All sales are credit sales with 50%…
A: cash collection is calculated by multiplying the collection % with the respective month sales.
Q: Oriole Company management wants to maintain a minimum monthly cash balance of $20,100. At the…
A: The cash budget is prepared to estimate the financing requirements for the period. The cash receipts…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales…
A: The cash budget estimates the excess of cash balance available over the cash disbursements during…
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: ty Company expects sales for the first three months of next year to be $205,000, $240,000 and…
A: Schedule of cash collection includes collection of sales based on their % of collection in…
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: Calculate the expected total cash collections for July
A: Cash and cash equivalents (CCE) - is one of the important elements of the balance sheet which are…
Q: Fine Co. has the following sales forecasts for the third quarter of 2021: P85,000 (July), P88,000…
A: Cash budget is one of the budget of the business, which shows beginning and ending cash balance,…
Q: Miller Company expects its November sales to be 25% higher than its October sales of $170,000. All…
A: Budgeting is a method of estimating expected future outcomes based on past events. Budgeting…
Q: Grit Company was formed on May 1, 2023. During May, 2023, the company reported sales on account of…
A: Sales Data:May 2023 Sales: $750,000June 2023 Sales: $800,000Collection Pattern:40% collected in the…
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: $75,000 $80,000 $90,000 $100,000 $110,000
A: To calculate Melody Inc.'s cash balance at the end of March, we need to consider the cash inflows…
Q: Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost…
A: Budget means the expected value of future. Budget will be compared with actual value and variance is…
Q: A company requires a minimum $12,400 cash balance at each month-end. If necessary, a loan is taken…
A: Budgeting is a method of estimating expected future outcomes based on past events. Budgeting…
Q: Graham Company projects the following sales for the first three months of the year: $10,600 in…
A: The cash collection schedule is prepared to estimate the amount of cash to be collected from…
Q: Suppose that the Sales in December 2019 were 41,498. The sales are expected to grow by 5% in January…
A: Computation of cash collection for the month of July 2020: Excel spread sheet:
Q: Millen’s managers have made the following additional assumptions and estimates Estimated sales for…
A: ACCOUNT RECEIVABLE; An account receivable is defined as it is money that has not been paid by…
Q: Prince Charles Island Company has expected sales of $6,000 in September, $10,000 in October, $16,000…
A: A cash budget is a budget that provides information about the company's projected cash inflows and…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: The budget is prepared to estimate the requirements for the current period. The purchases budget is…
Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales for…
A: Accounts Receivable Turnover :— It is calculated by dividing credit sales by average accounts…
Q: Budgeted cash receipts February March
A: Schedule of cash collection includes collection of sales based on their % of collection in…
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…
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: Valley's managers have made the following additional assumptions and estimates: Estimated sales…
A: Ratio Analysis -The ratio is the technique used by the prospective investor or an individual or…
Q: Shalom Company expects credit sales for April, May, and June to be P200,000, P260,000, and P300,000,…
A: calculation of cash collection in may are as follows
Step by step
Solved in 3 steps
- Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell any plant and…Medwig Corporation has a DSO of 17 days. The company averages $8,500 in sales each day (all customers take credit). What is the company's average accounts receivable? Assume a 365-day year. Round your answer to the nearest dollar.Assume that sales and expenses forecasts for months April, May, June, and July are as follows. month, 60% are paid in the next month, and 20% are paid in the second month after. All expenses in a month are paid in the same month. There is a $20,000,000 minimum required cash balance at the end of each month, and any shortage from this minimum requirement will be covered by obtaining a loan. Any excess over $20,000,000 will be used to reduce or pay off cumulative loan. Initial cash balance in June is $6,000,000 and there is no cumulative loan at this time. Monthly prorated tax rate is 2%, and monthly interest rate on cumulative loan is 1%. Requirements: Prepare cash budget proforma for months June and July and interpret the result in detail.
- Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell any plant and…Suppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?Fine Co. has the following sales forecasts for the third quarter of 2021: ₱85,000 (July), ₱88,000 (Aug), ₱82,000 (Sep). All sales are on credit. Seventy-five percent are collected in the month of sales and remainder is collected the following month. Minimum cash balance is ₱10,000. How much cash would be collected in August from sales?
- 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?Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.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…
- Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell…Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…Prince Charles Island Company has expected sales of $6,000 in September, $10,000 in October, $16,000 in November, and $12,000 in December. Cash sales are 20 percent and credit sales are 80 percent of total sales. Historically, 40 percent of receivables are collected in the month after the sale, and the remaining 60 percent collected two months after. Assume that the company's cash payments for November are $13,000, and December $6,000. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Sales Credit sales Cash sales Collections in the month after credit sales Collections two months after credit sales Total cash receipts Prince Charles Island Company Cash Receipts Schedule September S Cash receipts Cash payments Net cash flow Prince Charles Island Company Cash Budget November Beginning cash balance Cumulative cash balance. Monthly loan or (repayment). Cumulative loan balance. Ending cash…