Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
Cash budget-Basic Grenoble Enterprises had sales of $50,300 in March and $60,400 in April
Cash budget-Basic Grenoble Enterprises had sales of $50,300 in March and $60,400 in April. Forecast sales for May, June, and July are $69,800, $79,600, and $100,400, respectively. The firm has a cash balance of $4,900 on May 1 and wishes to maintain a minimum cash balance of $4,900. 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, 58% are collected in the next month, and the remaining 24% are collected in the second month following sale. (2) The firm receives other income of $1,800 per month. (3) The firm's actual or expected purchases, all made for cash, are $50,500, $70,500, and $79,700 for the months of May through July, respectively. (4) Rent is $3,200 per month. (5) Wages and salaries are 9% of the previous month's sales. (6) Cash dividends of $2,500 will be paid in June. (7) Payment of principal and interest of $4,200 is due in June. (8) A cash purchase of equipment costing $6,300 is scheduled in July. (9) Taxes of $5,900 are due in June. Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar. Please input all the values in the table before checking your answers.) March April May 69,800 Sales $ 50,300 $ 60,400 $ 10,872 $ Cash sales 9,054 Lag 1 month Lag 2 months Other income Total cash receipts
Expert Solution
|
|
April |
May |
June |
July |
|
|
Sales |
$50,300 |
$60,400 |
$69,800 |
$79,600 |
$100,400 |
|
Cash sales (0.18) |
$9,054 |
$10,872 |
$12,564 |
$14,328 |
$18,072 |
|
Lag 1 month (0.58) |
$35,032 |
$40,484 |
$46,168 |
||
|
Lag 2 months (0.24) |
$12,072 |
$14,496 |
$16,752 |
||
|
Other income |
$1,800 |
$1,800 |
$1,800 |
||
|
Total cash receipts |
$61,468 |
$71,108 |
$82,792 |
||
|
Disbursements |
|||||
|
Purchases |
$50,500 |
$70,500 |
$79,700 |
||
|
Rent |
$3,200 |
$3,200 |
$3,200 |
||
|
Wages & salaries |
$5,436 |
$6,282 |
$7,164 |
||
|
Dividends |
$2,500 |
||||
|
Principal & interest |
$4,200 |
||||
|
Purchase of new equipment |
$6,300 |
||||
|
Taxes due |
$5,900 |
||||
|
Total cash disbursements |
$59,136 |
$92,582 |
$96,364 |
||
|
Total cash receipts |
$61,468 |
$71,108 |
$82,792 |
||
|
Total cash disbursements |
$59,136 |
$92,582 |
$93,364 |
||
|
Net cash flow |
$2,332 |
($21,474) |
($10,572) |
||
|
Add: Beginning cash |
$4,900 |
$7,232 |
($14,242) |
||
|
Ending cash |
$7,232 |
($14,242) |
($24,814) |
||
|
Minimum cash |
$4,900 |
$4,900 |
$4,900 |
||
|
Required total financing (Notes Payable) |
$19,142 |
$29,714 |
|||
|
Excess cash balance (Marketable Securities) |
$2,332 |
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





