Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. a. Beginning cash balance on June 1, $95,000. b. Cash receipts from sales, $418,000. c. Budgeted cash payments for purchases, $273,000. d. Budgeted cash payments for salaries, $96,000. e. Other budgeted cash expenses, $58,000. f. Cash repayment of bank loan, $33,000. g. Budgeted depreciation expense, $35,000.

Use the following information to determine the ending cash balance to be reported on the month ended June 30 cash budget. a. Beginning cash balance on June 1, $95,000. b. Cash receipts from sales, $418,000. c. Budgeted cash payments for purchases, $273,000. d. Budgeted cash payments for salaries, $96,000. e. Other budgeted cash expenses, $58,000. f. Cash repayment of bank loan, $33,000. g. Budgeted depreciation expense, $35,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

a. Beginning cash balance on June 1, P85,300. b. Cash receipts from sales, P519,500. Budgeted cash disbursements for purchases, P274,500. C. d. Budgeted cash disbursements for salaries, P96,300. e. Other budgeted cash expenses, P58,300. f. Cash repayment of bank loan, P33,300. g. Budgeted depreciation expense, P35,300. Use the above information to determine the ending cash balance to be reported on the month ended June 30 cash budget.
The following information is available from various budgets for the current period: Amount Budget Cash budget Account Cash Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation - Equipment Schedule of cash receipts from customers Inventory, purchases, and cost of goods sold budget Selling and administrative expense budget Capital expenditures budget OA. $173,000 OB. $164,000 OC. $159,000 O D. $162,000 $28,000 Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense Equipment (expense incurred during the period) Selling and administrative expense budget 2,000 The following balances are available from the balance sheet at the end of the previous year: $5,000 28,000 7,000 What would be the amount of total assets on the budgeted balance sheet? 35,000 41,000 2,000 36,000
not graded... please help Prepare Cash Budget from Budgeted Transactions Prepare a cash budget for the month ended May 31, 2019. Campton Company anticipates a cash balance of $74,000 on May 1, 2019. The following budgeted transactions for May 2019 present data related to anticipated cash receipts and cash disbursements: 1. For May, budgeted cash sales are $50,000 and budgeted credit sales are $490,000. (Credit sales for April were $450,000.) In the month of sale, 40% of credit sales are collected, with the balance collected in the month following sale. 2. Budgeted merchandise purchases for May are $270,000. (Merchandise purchases in April were $240,000.) In the month of purchase, 70% of merchandise purchases are paid for, and the balance is paid for in the following month. 3. Budgeted cash disbursements for salaries and operating expenses for May total $155,000. 4. During May, $25,000 of principal repayment and $4,000 of interest payment are due to the bank. 5. A $20,000 income…
The following information was taken from Bonita Industries's cash budget for the month of July: Beginning cash balance $440000 Cash receipts 404000 Cash disbursements 558000 If the company's policy is to maintain a minimum end of the month cash balance of $430000, the amount the company would have to borrow in July is $286000. $144000. $10000. $26000.
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 310,000 $ 438,038 $365,008 $ 335,000 Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. The company's beginning cash balance for the upcoming fiscal year will be $25,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Beginning cash balance Total cash receipts Total cash available Total cash…
Edelmar Corp. has prepared a preliminary cash budget for the third quarter as shown below: Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments: Purchases of direct materials July $36,000 $56,000 92,000 Operating expenses Capital expenditures Ending cash balance Aug $17,000 $52,000 $69,000 34,000 41,000 0 $17,000 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $54,000 in July, $55,000 in August, and $44,000 in September. Based on the new data, calculate the new projected cash balance at the end of July Sep $21,500 47,800 $69,300 9,000 30,500 8,000 $21,500 10,000 30,800 7,700 $20,800
Kayak Co. 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 Cash Receipts $519,000 407,500 455,000 раynente $461,400 349,900 524,000 January February March According to a credit agreement with the company's bank, Kayak promises to have a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month, The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. ces Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be…
Garden Depot is a retaller that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter $ 280,000 $ 344,888 Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 480,000 $ 314,000 The company's beginning cash balance for the upcoming fiscal year will be $45,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Total financing Ending cash balance Required:…
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $41,000. b. Actual sales for May and June and expected sales for July are as follows: May $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 June July Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected In the second month following sale. The remaining 2% is uncollectible. C. Purchases of inventory will total $376,000 for July. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $174,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $452,000 for July. Of this amount, $63,500 is for depreciation. e. A new web server for the Marketing Department costing $86,500 will be…
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 $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 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.
Tamarisk Garden Center has the following cash budget information available for the month of August: Beginning cash balance Cash receipts from sales and collections on account Collection of note receivable and interest Cash disbursements for operating expenses The company would have to $129,000 eTexthonk and Media 115,000 8,100 If the company has a policy of maintaining an end of the month cash balance of $120,000, determine the amount the company would have to borrow or the amount of excess cash it will have to invest in August. 96,400 SUPPORT
Cash budget. The budgeted beginning cash balance is $20,000, budgeted cash receipts total $100,000 and budgeted cash disbursements total $110,000. The desired ending cash balance is $30,000. How much the company needs to borrow