Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Grenoble Enterprises had sales of $49,700 in March and$59,900 in April. Forecast sales for May, June, and July are $70,500,$80,300,and$100,300,respectively. The firm has a cash

Grenoble Enterprises had sales of $49,700 in March and$59,900 in April. Forecast sales for May, June, and July are $70,500,$80,300,and$100,300,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 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale.(2) The firm receives other income of $2,100 per month.(3) The firm's actual or expected purchases, all made for cash, are $50,100,$70,100,and $80,00 for the months of May through July, respectively.(4) Rent is $3,200 per month.(5) Wages and salaries are11%of the previous month's sales.(6) Cash dividends of$3,200will be paid in June.(7) Payment of principal and interest of$4,400 is due in June.(8) A cash purchase of equipment costin $5,900is scheduled in July.(9) Taxes of $6,100 are due in June.

Complete the first month of the cash budget for Grenoble Enterprises below:

March

April

May

June

July

Sales

Cash sales (30%)

Lag 1 month (65%)

Lag 2 months (5%)

Other income

Total cash receipts

March

April

May

June

July

Disbursements

Purchases

Rent

Wages and salaries

Dividends

Principal and interest

Purchase of new equipment

Total cash disbursements

March April May June July

Net cash flow

Add: Beginning cash

Ending cash

Minimum cash

Required total financing (notes payable)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Mathematics

Authors: Cacildo Marques

1st Edition

8741574710, 979-8741574713

More Books

Students also viewed these Finance questions

Question

Describe SONET. How does it differ from SDH?

Answered: 1 week ago

Question

3. Is it a topic that your audience will find worthwhile?

Answered: 1 week ago

Question

2. Does the topic meet the criteria specified in the assignment?

Answered: 1 week ago