Scribd
Upload
268 views3 pages

Managing Tools Activity

Jungaya Industries has prepared a cash budget to forecast cash receipts and payments for October, November, and December based on historical sales data, forecasts, and expected cash inflows and outflows. Cash receipts are expected to be PHP900,000, PHP700,000, and PHP500,000 respectively for the three months. Cash payments are forecasted to be PHP1,030,000, PHP430,000, and PHP535,000 respectively. The cash budget shows a need for financing of PHP130,000 in October but excess cash of PHP270,000 and PHP30,000 in November and

Uploaded by

Cristelyn Tomas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
268 views3 pages

Managing Tools Activity

Jungaya Industries has prepared a cash budget to forecast cash receipts and payments for October, November, and December based on historical sales data, forecasts, and expected cash inflows and outflows. Cash receipts are expected to be PHP900,000, PHP700,000, and PHP500,000 respectively for the three months. Cash payments are forecasted to be PHP1,030,000, PHP430,000, and PHP535,000 respectively. The cash budget shows a need for financing of PHP130,000 in October but excess cash of PHP270,000 and PHP30,000 in November and

Uploaded by

Cristelyn Tomas
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

B.

Bugay Industries, a defense contractor, is developing a cash budget for October, November,
and December. Jungaya’s sales in August and September were PHP100,000 and PHP200,000
respectively. Sales of PHP400,000, PHP300,000, and PHP200,000 have been forecast for
October, November, and December respectively.

Historically, 20% of the firm’s sales have been for cash, 50% have generated accounts receivable
collected after 1 month, and the remaining 30% have generated accounts receivable collected
after 2 months. In December, the firm will receive a PHP30,000 dividend from stock in a
subsidiary.

Required: Prepare the cash receipts section of the cash budget.

Jungaya Industries has gathered the following data needed for the preparation of a cash
disbursements schedule for October, November, and December.

Purchases - The firm’s purchases represent 70% of sales. Of this amount, 10% is paid in cash,
70% is paid in the month immediately following the month of purchase, and the remaining 20%
is paid 2 months following the month of purchase.

Rent Payments - Rent of PHP5,000 will be paid each month

Wages and Salaries - Fixed salary cost for the year is PHP96,000, or PHP8,000 per month. In
addition, wages are estimated as 10% of monthly sales.

Tax Payments - Taxes of PHP25,000 must be paid in December.

Fixed Assets - New machinery costing PHP130,000 will be purchased and paid for in November

Interest Payments - An interest payment of PHP10,000 is due in December.

Generate a cash budget showing the net cash flow, ending cash flow, financing, and excess
cash. At the end of September, Jungaya’s cash balance was PHP50,000,and its notes payable
and marketable securities equaled PHP0. The company wishes to maintain as a reserve for
unexpected needs, a minimum cash balance of PHP25,000.
Problem Solving:
Gerry Jacobs, a financial analyst for Best Valu Supermarkets, has prepared the following sales and cash
disbursement estimates for the period of August through December of the current year.

MONTH SALES CASH DISBURSEMENT

August 400 300


September 500 500
October 500 700
November 600 400
December 700 500
90% of sales are for cash, the remaining 10% are collected one month later. All disbursements are on a cash
basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September
is 25. Prepare a cash budget for the months of October, November, and December, noting any needed
financing or excess cash available.

You might also like