**Riverbed Inc. Budget Information**Riverbed Inc. provided the following information regarding their projected merchandise purchases and expenses for the months of April, May, and June:| | April | May | June ||---------|----------|---------|--------|| Projected merchandise purchases | $92,500 | $82,000 | $69,000 |**Details:**- **Merchandise Payment Schedule:** - 40% of merchandise purchases are paid in the month of the purchase. - 60% are paid in the following month.- **General Operating Expenses:** - Budgeted to be $34,500 per month. - Depreciation accounts for $3,400 of this amount. - Expenses are paid in the month they are incurred.- **Loan Payments:** - Riverbed makes monthly loan payments of $5,000. - Of this, $550 is for interest and the remainder is for principal.**Task:**Calculate the budgeted cash disbursements for May.**Calculate the total budgeted cash disbursements for May:** Total budgeted cash disbursements: $ [Enter answer]

Depreciation is an non cash expense and not form part ( it is excluded from cost )Only payment which actual outflow end to be considered All non cash expense need to be eliminated Particulars April MayJunePayment for Merchandise Purchased $37,000( $ 92,500 * 40%) $88,300 ($92,500 × 60% + $ 82,000 × 40% ) $76,800 ($82,000 * 60% + $ 69,000 * 40%)General Operating Expenses. note - depreciation expense is excluded as it is non cash expense.$31100$31100$31100Loan Repayment ( Both interest and principal amount is paid in cash)$5000$5000$5000Total cash disbursement $73100$124400$112900Total cash disbursement for may = $124400 Total cash disbursement for April May and June is = $310400 Thanks Hope you understand

Business

Accounting

Riverbed Inc. provided the following information: April May Projected merchandise purchases $92,500 $82,000 Calculate budgeted cash disbursements for May. June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. Total budgeted cash disbursements $ $69,000

Riverbed Inc. provided the following information: April May Projected merchandise purchases $92,500 $82,000 Calculate budgeted cash disbursements for May. June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. Total budgeted cash disbursements $ $69,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Domestic
On October 1 of the current year, Molloy Corporation prepared a cash budget for October, November, and December. All of Molloy's sales are made on account. The following information was used in preparing estimated cash collections: August sales (actual) September sales (actual) October sales (estimated) November sales (estimated) December sales (estimated) $ 40,000 $ 50,000 $ 20,000 $ 70,000 $ 60,000 Approximately 60% of all sales are collected in the month of the sale, 30% is collected in the following month, and 10% is collected in the month thereafter. Budgeted collections from customers in October total:
Sales are budgeted at $360,000 for November, $370,000 for December, and $350,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 60% of sales. • The company desires an ending merchandise inventory equal to 20% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • The November beginning balance in the accounts receivable account is $71,000. • The November beginning balance in the accounts payable account is $258,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total…
Zisk Company purchases direct materials on credit. Budgeted purchases are April, $83,000, May, $113,000; and June, $123,000. Cash payments for purchases are: 70% in the month of purchase and 30% in the first month after purchase. Purchases for March are $73,000. Prepare a schedule of cash payments for direct materials for April, May, and June. ZISK COMPANY Schedule of Cash Payments for Direct Materials April May Materials purchases Cash payments for Total cash payments June
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $82,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January $ Budgeted cost of goods sold Plus: Desired beginning inventory Inventory needed Less: Desired beginning inventory Required purchases (on account) $…
Provide table
Saratoga Company budgeted the following information for 2022 : May June July Budgeted purchases of merchandise $105,500 $110,500 $101,500 Cost of goods sold is 40% of sales. Accounts payable is used only for merchandise inventory acquisitions. Sarasota purchases and pays for merchandise 60% in the month of acquisition and 40% in the following month. Selling and administrative expenses are budgeted at $32,000 for May and are expected to increase 5% per month. These expenses are paid during the month when incurred. In addition, depreciation is budgeted at $10,000 per month. Income taxes are $39,100 for July and are paid in the month incurred. Compute the amount of budgeted cash disbursements for July.
Zisk Company purchases direct materials on credit. Budgeted purchases are April, $89,000; May, $119,000; and June, $129,000. Cash payments for purchases are: 70% in the month of purchase and 30% in the first month after purchase. Purchases for March are $79,000. Prepare a schedule of cash payments for direct materials for April, May, and June.
Purchases of direct material for May were $115,000, while expected purchases for June and July are $121,000 and $136,000, respectively. All purchases are paid 25% in the month of purchase and 75% the following month. Calculate the budgeted payments for the month of June.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 524,000 $ 465,300 February 412,500 353,800 March 475,000 526,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March.
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments excluding cash payments for loan principal and interest payments) for the first three months of next year. January February March Cash Receipts $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available KAYAK COMPANY Cash Budget January $ 30,000…
Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following inventory information is available: Estimated payments in August for purchases in August Estimated purchases for August Estimated cost of goods sold for August Estimated payments in August for purchases in July Estimated payments in August for purchases prior to July Inventories at beginning of August Required: What are the estimated cash disbursements in August? Estimated cash disbursements 70% $ 2,428,000 2,560,000 672,000 160,000 658,000