Answer-
ABC COMPANY | |
CASH BUDGET | |
FOR THE MONTH OF AUGUST | |
Particulars | AUGUST |
$ | |
Beginning cash balance (A) | 34000 |
Add- Budgeted cash receipts | |
Collection from clients | 199032 |
Sale of equipment | |
Total cash available for use (B) | 233032 |
Less- Cash Payments | |
Payment for inventory purchases | 26000 |
Operating expenses | 40000 |
Other manufacturing expenses | 61000 |
Bonds retirements | 59000 |
Dividends paid | 24000 |
Total cash payments (C) | 210000 |
Cash surplus/ (Deficit) (D=A+B-C) | 23032 |
Financing:- | |
Add-Borrowings | 0 |
Less-Repayments | 0 |
Budgeted ending cash balance | 23032 |
ABC Company has a cash balance of $34,000 on August 1 and requires a minimum ending...
ABC Company has a cash balance of $37,000 on August 1 and
requires a minimum ending cash balance of $24,160. Cash receipts
from sales budgeted for August are $200,160. Cash disbursements
budgeted for August include inventory purchases, $29,000; other
manufacturing expenses, $55,000; operating expenses, $40,000; bond
retirements, $62,000; and dividend payments, $27,000.
Required:
Prepare a cash budget for ABC Company for August.
August Beginning cash balance Cash Receipts: Total cash available Cash Disbursements: Total cash disbursements Ending cash balance
5) ABC Company pays for raw material purchases as follows: 75% in the month of purchase; 25% in the subsequent month. Budgeted purchases are as follows: June = $56,000; July = $60,000. Budgeted cash payment to be made in the month of July is $ ? ------- 6) ABC Company pays for raw material purchases as follows: 75% in the month of purchase; 25% in the subsequent month. Budgeted purchases are as follows: June = $56,000; July = $60,000. Cash...
Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units; August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $262,500 and accounts payable of $148,500. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $225,000 July $ 135,000 June 240,000 August 120,000 September 150,000 October 180,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...
Karim Corp. requires a minimum $10,000 cash balance. Loans taken
to meet this requirement cost 1% interest per month (paid monthly).
Any excess cash is used to repay loans at month-end. The cash
balance on July 1 is $10,400, and the company has no outstanding
loans. Forecasted cash receipts (other than for loans received) and
forecasted cash payments (other than for loan or interest payments)
follow.
July
August
September
Cash receipts
$
26,000
$
34,000
$
42,000
Cash payments
31,000...
Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. Beginning cash balance on June 1, $94,500. Cash receipts from sales, $415,500. Budgeted cash disbursements for purchases, $270,500. Budgeted cash disbursements for salaries, $95,500. Other budgeted cash expenses, $57,500. Cash repayment of bank loan, $32,500. Budgeted depreciation expense, $34,500.
Purchases and Cash Budgets On July 1, MTC Wholesalers had a cash balance of $175,000 and accounts payable of $99,000. Actual sales for May and June, and budgeted sales for July, August, September, and October are: Month Actual Sales Month Budgeted Sales May $150,000 July $ 90,000 June 160,000 August 80,000 September 100,000 October 120,000 All sales are on credit with 75 percent collected during the month of sale, 20 percent collected during the next month, and 5 percent collected...
Cash Budget The Williams Supply Company sells for $40 one product that it purchases for $25. Budgeted sales in total dollars for next year are $1,400,000. The sales information needed for preparing the July budget follows: Month Sales Revenue May $ 34,000 June 48,000 July 56,000 August 64,000 Account balances at July 1 include these: Cash $ 24,000 Merchandise inventory 17,500 Accounts receivable (sales) 25,760 Accounts payable (purchases) 16,250 The company pays for one-half of its purchases in the month...
1: Prepare a sales budget, including a schedule of expected
cash collections.
2: prepare a merchandise purchase budget, including a schedule
of expected cash disbursements for merchandise, and a selling and
administrative budget.
3: prepare a cash budget.
MOST LIKELY NUMBERS AND ASSUMPTIONS SALES MANAGER PRIVATE INFORMATION October Most likely sales 600,000 910,000 475,000 385,000 PURCHASING MANAGER PRIVATE INFORMATION Most likely cost of merchandise as a % of sales Desired ending inventory as a percentage of next month's cost of...
Please help. All one question. Thanks.
Fortner Manufacturing has a cash balance of $8,000 on August 1 of the current year. The company's controller forecast the following cash receipts and cash disbursements for the upcoming two months of activity: Cash Receipts $47,000 70,000 Cash Payments $60,000 58,000 August September Management desires to maintain a minimum cash balance of $8,000 at all times. If necessary, additional financing can be obtained in $1,000 multiples at a 12% interest rate. All borrowings are...