Preparation of cash budget

Assignment Help Financial Accounting

Reference no: EM1312969

Preparation of Cash Budget and interpreting the cash position of the company.

Grenoble Enterprises had sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,00, 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 date, 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's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively.
(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 principle 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: EM1312969

Questions Cloud

Describe capital budgeting decision based on present value : Describe Capital budgeting decision based on net present value of XYZ Company is considering replacing a printing machine

To forecast additional funds needed using afn equation : To forecast Additional funds needed using AFN equation - Use the AFN equation to forecast Carter's additional funds needed for the coming year.

Alga has invaded waters of california : The U.S government has placed this strain of C.taxifolia on noxious weed list, which means that any possible source of the contamination of the weed will be highly restricted. Shipments that contain any kind of C.taxifolia and pass through an area wh..

Ungrouped frequency distribution : A survey taken in a restaurant shows the following number of cups of coffee consumed with each meal. Construct an ungrouped frequency distribution.

Preparation of cash budget : Preparation of Cash Budget and interpreting the cash position of the company

Explain capital budgeting involves calculation value : Explain Capital budgeting involves calculation of net present value of Mills Mining is considering an expansion project

Prepare a pro forma balance sheet : Prepare a pro forma balance sheet dated December 31, 2008 and show the financing changes suggested by the statement prepared in part A

Questions on present value and interest rate : What is the present value of $300 to be paid in two years if the interest rate is 12%? What happens to reserves at Third National Bank if one person withdraws $2,000 of cash and another person deposits $750 of cash?

Prepare a pro forma balance sheet : Prepare a pro forma balance sheet dated December 31, 2008 and show the financing changes suggested by the statement prepared in part A

User Account

All Pages