March | April | May | June | July | |
Sales | $50,400 | $60,200 | $69,500 | $80,200 | $100,300 |
Cash sales (0.23) | $11,592 | $13,846 | $15,985 | $18,446 | $23,069 |
Lag 1 month (0.65) | $39,130 | $45,175 | $52,130 | ||
Lag 2 months (0.12) | $6,048 | $7,224 | $8,340 | ||
Other income | $2,300 | $2,300 | $2,300 | ||
Total cash receipts | $63,463 | $73,145 | $85,839 | ||
Disbursements | |||||
Purchases | $49,700 | $69,500 | $79,800 | ||
Rent | $3,500 | $3,500 | $3,500 | ||
Wages & salaries | $6,622 | $7,645 | $8,822 | ||
Dividends | $3,400 | ||||
Principal & interest | $3,500 | ||||
Purchase of new equipment | $6,400 | ||||
Taxes due | $6,500 | ||||
Total cash disbursements | $59,822 | $94,045 | $98,522 | ||
Total cash receipts | $63,463 | $73,145 | $85,839 | ||
Total cash disbursements | $59,822 | $94,045 | $98,522 | ||
Net cash flow | $3,641 | ($20,900) | ($12,683) | ||
Add: Beginning cash | $4,500 | $8,141 | ($12,759) | ||
Ending cash | $8,141 | ($12,759) | ($25,442) | ||
Minimum cash | $4,500 | $4,500 | $4,500 | ||
Required total financing(Notes Payable) | $17,259 | $29,942 | |||
Excess cash balance(Marketable Securities) | $3,641 |
Cash budget-Basic Grenoble Enterprises had sales of $50,400 in March and $60,200 in April. Forecast sales...
Cash budget-Basic Grenoble Enterprises had sales of $50,400 in March and $60,200 in April. Forecast sales for May, June, and July are $70,200, $80,100, and $100,400, respectively. The firm has a cash balance of $5,300 on May 1 and wishes to maintain a minimum cash balance of $5,300. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 22% of sales for cash, 61% are collected in the...
Cash budget-Basic Grenoble Enterprises had sales of $49,900 in March and $59,800 in April. Forecast sales for May, June, and July are $69,900, $80,200, and $99,700, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,500. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 18% of sales for cash, 56% are collected in the...
Cash Budget—Basic Grenoble Enterprises had sales of 49,700 in March and $60,200 in April. Forecast sales for May, June, and July are $69,700,$79,600, and $100,500,respectively. The firm has a cash balance of $5,300 on May 1 and wishes to maintain a minimum cash balance of $5,300. Given the following data, prepare and interpret a cash budget for the months of May, June, and July.(1) The firm makes 15% of sales for cash,55% are collected in the next month, and the...
Cash budget-Basic Grenoble Enterprises had sales of $49,600 in March and $60,500 in April. Forecast sales for May, June, and July are $70,300, $80,200, and $99,600, respectively. The firm has a cash balance of $4,600 on May 1 and wishes to maintain a minimum cash balance of $4,600. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 25% of sales for cash, 62% are collected in the...
Grenoble Enterprises had sales of $ 50,100 in March and $ 60,500 in April. Forecast sales for May, June, and July are $ 70,400,$ 79,800, and $99,800 respectively. The firm has a cash balance o f$5,100 on May 1 and wishes to maintain a minimum cash balance of $5,100. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 16 % of sales for cash, 60 % are...
P4-9 (similar to) A Question Help Cash budget-Basic Grenoble Enterprises had sales of $49.700 in March and $60,200 in April. Forecast sales for May, June, and July are $69,700, $79,800, and $99,600, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 17% of sales for...
Cash budgetlong dash—Basic Grenoble Enterprises had sales of $ 50 comma 300$50,300 in March and $ 60 comma 000$60,000 in April. Forecast sales for May, June, and July are $ 69 comma 800$69,800, $ 79 comma 800$79,800, and $ 99 comma 900$99,900, respectively. The firm has a cash balance of $ 4 comma 500$4,500 on May 1 and wishes to maintain a minimum cash balance of $ 4 comma 500$4,500. Given the following data, prepare and interpret a cash budget...
P4-10 Cash bude Cash budget: Basic Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 20% of sales for cash, 60%...
PLEASE HELP I HAVE TO HAVE THIS DONE SOON Cash budget—Basic Grenoble Enterprises had sales of $50,200 in March and $59,800 in April. Forecast sales for May, June, and July are $70,300, $79,900, and $100,500, respectively. The firm has a cash balance of $5,100 on May 1 and wishes to maintain a minimum cash balance of $5,100. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 16%...
please explain to me how to resolve this question homework March April May Sales $ 70,500 50,200 $ 12,550 60,000 $ 15,000 $ Cash sales EA Lag 1 month Lag 2 months EA Other income EA Total cash receipts EA Enter any number in the edit fields and then click Check Answer. Homework: Chapter 4 Homework Save Score: 0.17 of 1 pt 4 of 6 (6 complete) HW Score: 86.21%, 5.17 of 6 pts WP4-10 (similar to) Question Help O...