Prepare and interpret cash budget for the months

Assignment Help Financial Management

Reference no: EM131989720

Cash budget: Basic Grenoble Enterprise has 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% 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,000 per month.

3) The firm actual or expected purchases, all made for cash are $50,000.

4) REnt is $3,000 per month

5) Wages and Salaries are 10% of the previous month's sales.

6) Cash dividends of $3,000 will be paid in June.

7) Payment of principal and interest of $4,000 is due in June.

8) A cash purchase of equipment costing $6,000 is scheduled in July.

9) Taxes of $6,000 are due in June.

Reference no: EM131989720

Questions Cloud

Find the future values of ordinary annuities : Find the future values of the following ordinary annuities:

What is this worth in two years time : Suppose you pay $200 each year for the next 2 years. The interest rate is 5% and you pay the first payment next year. What is this worth in 2 years' time?

Present value for various discounting periods : Find the present value of $400 due in the future under each of these conditions: 15% nominal rate, semiannual compounding, discounted back 6 years.

What is the bond current market price : The coupon interest rate is 8%, and the yield to maturity is 7%. What is the bond's current market price?

Prepare and interpret cash budget for the months : Given the following data, prepare and interpret a cash budget for the months of May, June, and July.

Explain what you learn about discount cash flow : Explain what you learn about Discount cash flow. explain the Important bond features and types of bonds.

Yield curve is horizontal-interest rate remain current level : If the yield curve is horizontal and interest rates remain at their current level, when is the latest that investors might expect the firm to call the bonds?

What is the yield to maturity-expected current yield : what is the expected current yield? What is the yield to maturity?

What rate of return would she have earned for past year : what rate of return would she have earned for the past year?

User Account

All Pages