Trusted by Students Everywhere
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

Finance Dec 19, 2020

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


March

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
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment