Question

Al-Bazar industries are developing a cash budget for April May and June. Al-Bazar's cash receipts in...

Al-Bazar industries are developing a cash budget for April May and June. Al-Bazar's cash receipts in February and March were $20,000 and $90,000 respectively. Total Cash receipts of $210,000, $320,000, and $340,000 have been forecast for April May and June. On the other hand, the total cash disbursements in April, May, and June were $213,000, $418,000 and $305,000. Al-Bazar Industries has a cash balance of $50,000 at the end of March and wishes to maintain, as a reserve for unexpected needs, a minimum cash balance of $30,000. Based on this information prepare a cash budget and determine the required total financing or excess cash balance for April, May, and June.

The Cashflow of April ?, Cash Budget for June? Beginning balance of May? Beginning balance of June? The net Cash flow of May?Cash Budget for April?The net Cash flow of June

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Based on the given data, pls find below steps and workings on monthly budget:

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during...
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016) January February March Cash receipts $300,000 $320,000 $290,000 Cash disbursements 280,000 360,000 300,000 The expected cash balance at January 1, 2016, is $82,000. Brewster wants to maintain a cash balance at the end of each month of at least $80,000. Short-term borrowings at 1%...
Develop a cash budget for the next two months using the information provided below Monthly sales...
Develop a cash budget for the next two months using the information provided below Monthly sales forecast are $210,000 and $30,000 for the next two months The current month's sales were $140,000 80% of sales are collected in the month of sale, with the remainder collected in the following month Cost of goods sold equal 70% of sales The monthly lease payment is $75,000 The cash position at the end of the current month is $70,000 The target cash balance...
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following...
Cash Budget Problem: Mia Company Prepare Cash Budget for April, May, June 2018 Follow the following to prepare the budget: 1.         Real Sales 2018:         January                        - $100,000                                                 February                      - $200,000                                                 March                          - $150,000             Projected for 2018:     April                            - $400,000                                                 May                             - $300,000                                                 June                             - $200,000             Sales Payment History:           10% cash                                                             40% Accts. Rec. – collected n/30 days                                                             50% Accts. Rec. – collected n/60...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for...
Calculating the Cash Budget Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: April May June Credit sales $ 327,000 $ 307,000 $ 367,000 Credit purchases 135,000 158,000 183,000 Cash disbursements Wages, taxes, and expenses 44,700 12,200 63,700 Interest 11,700 11,700 11,700 Equipment purchases 87,000 164,000 0    The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
Mosbey Inc. is working on its cash budget for June. The budgeted beginning cash balance is...
Mosbey Inc. is working on its cash budget for June. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $175,300 and budgeted cash disbursements total $204,000. The desired ending cash balance is $49,000, and the company borrows in increments of $500 only. The amount Mosbey Inc needs to borrow for June will be:
Here are some important figures from the budget of Marston, Inc., for the second quarter of...
Here are some important figures from the budget of Marston, Inc., for the second quarter of 2016:    April May June Credit sales $ 415,000 $ 364,000 $ 452,000 Credit purchases 192,000 180,000 213,000 Cash disbursements Wages, taxes, and expenses 81,000 76,500 105,200 Interest 10,700 10,700 10,700 Equipment purchases 39,500 12,000 160,000    The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the...
Markissons’ Plastics Company has presented you with forecasted cash receipts and expenditure for the period April...
Markissons’ Plastics Company has presented you with forecasted cash receipts and expenditure for the period April to June 2016. They are as follows:      Cash Receipts Expenditure     $    $ March         75,000     April     69,000    73,000     May     77,000    39,000    June              105,000    59,000 Further analysis revealed the following:  Expenditure for the period March to June includes monthly depreciation of $4,000.  Payment for the cash related expenditure would be 25% in the month of purchase, the balance being paid the following month....
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From sales on account† 280,500 112,200 Total cash receipts $412,500 $211,200 *Half of each month’s sales are on account. March sales amounted to $198,000. †60% of credit sales is collected in the month of sale; 40% is collected in the following month.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT