text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...

text 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 $290,000 $310,000 $280,000 Cash disbursements 270,000 350,000 290,000 The expected cash balance at January 1, 2016, is $72,000. Brewster wants to maintain a cash balance at the end of each month of at least $70,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31, 2016. Brewster Corporation Cash Budget for the Quarter Ended March 31, 2016 January February March Beginning cash balance Answer Answer Answer Cash receipts Answer Answer Answer Short-term borrowings Answer Answer Answer Cash available Answer Answer Answer Cash disbursements Answer Answer Answer Interest payment Answer Answer Answer Total cash disbursements Answer Answer Answer Ending cash balance Answer Answer Answer

Expert Solution

ekkarill92 answered 2 years ago

q1 : The cash budget reflects expected cash receipts and cash disbursements from all sources. all...

q1 : The cash budget reflects expected cash receipts and cash disbursements from all sources. all revenues and all expenses for a period. all the items that appear on a budgeted income statement. all the items that appear on a budgeted balance sheet. q2 :A major element in budgetary control is the comparison of actual results with planned objectives. the valuation of inventories. the preparation of long-term plans. approval of the budget by the stockholders. q3 :A static budget should...

E5-14 Prepare a cash budget for two months. Rigley Company expects to have a cash balance...

E5-14 Prepare a cash budget for two months. Rigley Company expects to have a cash balance of $46,000 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collection from customers: January $71,000 and February $146,000. 2. Payments to suppliers: January $40,000, February $75,000. 3. Wages: January $30,000 and February $40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January $21,000 and February $24,000. These costs include...

Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash disbursements...

Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash disbursements (excluding cash disbursements for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash Disbursements January $ 517,000 $ 459,400 February 405,000 347,400 March 455,000 533,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can...

The ABC Company has made the following monthly estimates of cash receipts and cash disbursements when...

The ABC Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. ABC has beginning cash on hand of $25,000 and wants to maintain this minimum cash level throughout the next year. Cash Cash Month Receipts Disbursements January $100,000 $110,000 February $90,000 $110,000 March $95,000 $115,000 April $100,000 $150,000 May $130,000 $180,000 June $160,000 $180,000 July $200,000 $190,000 August $245,000 $180,000 September $245,000 $150,000 October $180,000 $120,000 November...

Alpine Products Company has made the following monthly estimates of cash receipts and cash disbursements when...

Alpine Products Company has made the following monthly estimates of cash receipts and cash disbursements when preparing cash budgets for the next twelve months. Alpine Products has beginning cash on hand of $10,000 and wants to maintain this minimum cash level throughout the next year Cash Cash Month Receipts Disbursements January $100,000 $100,000 February $90,000 $110,000 March $80,000 $110,000 April $100,000 $150,000 May $120,000 $180,000 June $160,000 $180,000 July $200,000 $180,000 August $250,000 $180,000 September $250,000 $150,000 October $200,000 $110,000...

For August 2019, Ravi River Rafting will have cash receipts of RM94,000 and cash disbursements of...

For August 2019, Ravi River Rafting will have cash receipts of RM94,000 and cash disbursements of RM75,000. If its beginning cash is RM2,000 and its desired reserve is RM5,000, will it ending cash be in excess or shortfall, and by how much? Select one: a. Shortfall of RM-11,000 b. Shortfall of RM-6,000 c. Excess of RM8,000 d. Excess of RM6,000 The annual dividend for Sapura Kenchana Corporation was RM2.20 per share and the firm’s required rate of return is 15%....

Kids ’n Caboodle, a children’s clothing store, had the following cash receipts and disbursements for its...

Kids ’n Caboodle, a children’s clothing store, had the following cash receipts and disbursements for its first year of operations: Receipts: Cash sales $155,000 Loan proceeds ___2_1_,_0_0_0_ Total receipts ____1__7__6__,__0__0__0__ Disbursements Merchandise purchases (all sold this year) 84,000 Wages 33,000 Rent and lease payments 22,000 Other operating outlays 7,900 Purchase equipment ___1_0_,_5_0_0_ Total disbursements __1_5_7_,_4_0_0_ Increase in Cash Balance $______1__8__,__6__0__0__ The store has no accounts receivable (it accepts only cash or bank cards for payment). At year-end, an employee had...

The following table consists of cash flow data for a selected ten days. Day Receipts Disbursements...

The following table consists of cash flow data for a selected ten days. Day Receipts Disbursements 1 60 40 2 70 60 3 90 60 4 60 100 5 90 70 6 50 30 7 110 80 8 130 140 9 80 100 10 90 110 A. Calculate the variance of net daily cash flows. B. Assuming a lower limit of $300, a transaction cost of $15, and an annual interest rate of 8 percent, what is the upper limit...

Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December...

Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December 31, 2021, including the following schedules: Sales Budget (ALREADY DONE) & Schedule of Cash Receipts (NEED HELP WITH THIS) Pepsi Company Sales Budget For Year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted Sales in units 4,500 16,500 6,000 3,000 30,000 Selling Price per unit $290 $290.00 $290.00 $290.00 $290 Total budgeted sales $1,305,000 $4,785,000.00 $1,740,000.00 $870,000.00 $8,700,000 Relevant Info Dougs sales forecast...

From the following data, prepare a cash budget for the three months ending 31st December,2019 &nbsp

From the following data, prepare a cash budget for the three months ending 31st December,2019 (1) Months Sales (AED) Materials (AED) Wages (AED) Overheads (AED) September 10000 5000 1000 200 October 20000 4000 1000 200 November 25000 3000 2500 200 December 10000 4200 2000 300 (2) Credit terms are: (a) sales/debtors- 50% sales are on cash basis, 50% of the credit sales are collected next month. (b) Creditors for materials- 1 months for wages- Same months for...

Question