aborosa, Inc., a merchandising company, has provided the following budgeted amounts for the next budget period. Beginning cash balance Cash collections Payments for: Purchases of merchandise inventory Selling and administrative expenses Capital expenditures $30,700 680,000 OA. $(17,700) OB. $710,700 OC. $290,900 OD. $32,300 349,300 70,500 308,600 A minimum cash balance of $30,000 is required to be maintained. The company can borrow in increments of $10,000 as and when required. Assume the company can borrow the needed funds at the end of the period. Calculate the ending cash balance for the budget period.

aborosa, Inc., a merchandising company, has provided the following budgeted amounts for the next budget period. Beginning cash balance Cash collections Payments for: Purchases of merchandise inventory Selling and administrative expenses Capital expenditures $30,700 680,000 OA. $(17,700) OB. $710,700 OC. $290,900 OD. $32,300 349,300 70,500 308,600 A minimum cash balance of $30,000 is required to be maintained. The company can borrow in increments of $10,000 as and when required. Assume the company can borrow the needed funds at the end of the period. Calculate the ending cash balance for the budget period.

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

Stuart Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 115,000 $ 121,000 $ 141,000 Cash payments For inventory purchases 97,500 79,500 92,500 For S&A expenses 38,500 39,500 34,500 Stuart Medical had a cash balance of $15,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Stuart pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year’s quarterly results. Required Prepare a cash budget.
Weat
Newman Medical Clinic has budgeted the following cash flows. January February March $11,000 $117,000 $137,000 Cash receipts Cash payments For inventory purchases For S&A expenses 36,500 95,500 77,500 90,500 37,500 32,500 Newman Medical had a cash balance of $13,500 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.)
Fanning Medical Clinic has budgeted the following cash flows. January $105,000 February $111,000 March Cash receipts Cash payments For inventory purchases For S&A expenses $131,000 92,500 33,500 74,500 34,500 87,500 29,500 Fanning Medical had a cash balance of $10,500 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Fanning pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage
Valley Trails is preparing the Cash Budget for the upcoming period, and is concerned about their ability to meet their financial obligations in the short term. Following is information relating to Valley's financial performance: Beginning-of-period balances: Accounts Receivable: $108,000 Accounts Payable: $54,000 Accumulated Factory Depreciation: $576,000 Cash: $27,000 Estimates for end-of-period balances: Accounts Receivable: $135,000 Accounts Payable: $36,000 Accumulated Factory Depreciation: $592,000 Budgeted activity levels for the period: Sales: $500,000 Purchases of Direct Materials: $89,600 Direct Labor Wages: $150,000 Manufacturing Overhead: $50,000 Selling and Administrative Expenses: $84,000 Except for purchases of direct materials, all expenses are paid as incurred. What is the budgeted ending cash balance for the period? Select one: O O O a. $178,400 b. $140,400 $152 400
I ne Tollowing information is available from various budgets for the current period: Account Cash Accounts Receivable Merchandise Inventory Insurance Expense (expense incurred during the period) Equipment Depreciation Expense - Equipment (expense incurred during the period) Budget Cash budget Amount $20,000 Schedule of cash receipts from customers 38,000 Inventory, purchases, and cost of goods sold budget 47,000 Selling and administrative expense budget 2,000 Capital expenditures budget 31,000 Selling and administrative expense budget 1,000 The following balances are available from the balance sheet at the end of the previous year: Prepaid Insurance Equipment Accumulated Depreciation Equipment $6,000 22,000 1,000 What would be the amount of total assets on the budgeted balance sheet?
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 $ 350,000 $ 393,000 3rd Quarter $ 400,000 $ 353,000 4th Quarter $ 420,000 $ 373,000 $ 470,000 $ 363,000 The company's beginning cash balance for the upcoming fiscal year will be $20,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. Required: Prepare the company's cash budget for the upcoming fiscal year. (Repayments, interest, and cash deficiencies should be indicated by a minus sign.) 2nd Quarter…
The following budget information is available for the Arch Company for January Year 2: Sales Cost of goods sold Utilities expense Administrative salaries Sales commissions Advertising Depreciation on store equipment Rent on administration building Miscellaneous administrative expenses Multiple Choice O $321,000 All operating expenses are paid in cash in the month incurred. Compute the total budgeted selling and administrative expenses (excluding Interest) amount for January Year 2. $296,500 $272,000 $ 880,000 560,000 3,200 120,000 $323,200 5% of sales 24,000 54,000 64,000 14,000
Fedor, Inc. has prepared the following direct materials purchases budget: Budgeted DM Purchases $69.000 77,000 78,700 77,800 76,200 All purchases are paid for as follows: 40% in the month of purchase, 50% in the following month, and 10% two months after purchase. Calculate total budgeted cash payments made in October for purchases. Month June July August September October OA. $77,250 OB. $46,770 OC. $38,350 O D. $69,380
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…
Flint, Inc. provided the following information: Projected merchandise purchases . March April $67,000 $75,000 Budgeted cash disbursements $ Flint 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 $25,000 per month of which depreciation is $2,000 of this amount. Flint pays operating expenses in the month incurred. Calculate Flint's budgeted cash disbursements for May. May $81,000