Prepare and interpret a cash budget for the months

Assignment Help Financial Management

Reference no: EM132019031

Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May, June, and July are $70,100, $79,600, and $99,800, respectively. The firm has a cash balance of $4,500 on May 1 and wishes to maintain a minimum cash balance of $4,500. 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, 62% are collected in the next month, and the remaining 22% are collected in the second month following sale.

2) The firm receives other income of $1,900 per month.

3) The firms actual or expctd purchses, all made for cash, are $50,200, $70,200, and $79,900 for the months of May through July, respectively.

4) Rent is $2,900 per month.

5) Wages and salaries are 9% of the previous months sales.

6) Cash dividends of $3,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 $5,900 is scheduled in July.

9) Taxes of $5,900 are due in June.

PART A: Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar.)

PART B: Complete the second month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar.)

Reference no: EM132019031

Questions Cloud

Analyze the issues of physiological antagonism : Analyze the issues of pharmacological and physiological antagonism. Explain the receptor systems involved and the central nervous system structures effects.

When valuing purchase versus lease : Which one of these can be ignored when valuing a purchase versus a lease?

How should you set the mean to if you want at most : This process follows a normal distribution. What should you set the mean to if you want at most 8% of your cans to contain more than 15 ounces?

Evaluate the risk-benefits of drug use : Elaborate on the receptor agonist-antagonist actions of the drugs and describe the most common side effects seen with these drugs.

Prepare and interpret a cash budget for the months : prepare and interpret a cash budget for the months of May, June and July. Complete the first month of the cash budget for Grenoble Enterprises below.

Determine six-month forward rate be to prevent arbitrage : The annual risk-free rate in the United States is 3 percent, and the annual risk-free rate in South Korea is 6 percent.

Pay the underwriter spread and administrative costs : What are the required proceeds from the sale necessary for the company to pay the underwriter's spread and administrative costs?

What will your cumulative mark to market be if gold prices : Each contract is for 100 ounces. What will your cumulative mark to market be if gold prices are $1,291.85 per ounce at expiration?

What is the after-tax cash flow from leasing relative : The corporate tax rate is 34%. What is the after-tax cash flow from leasing relative to the after-tax cash flow from purchasing in years 6?

User Account

All Pages