22. Hot Mama's has prepared its fourth quarter budget and provided the following data:Nov$48,500DecOct$52,000$51,200Cash collectionsCash payments:Purchases of direct materialsOperating expensesCapital expenditures35,00013,25015,65022,4509,65023,90016,25012,500The cash balance on September 30 is projected to be $5000. The company has to maintain aminimum cash balance of $6,500 and is authorized to borrow at the end of each month to make upshortfalls. Itmayborrow in inerements of $6,000 and has to pay interest every month at ananyannual rate of 5%. All financing transactions are assumed to take place at the end of the month.The loan balance should be repaid in increments of $6,000 whenever there is surplus cash.Calculate the ending projected cash balance before financing for November.A) S(2,900)B) $3,100C) $6.500D) S53.600

Cash collections for October: $52,000 Purchases of direct materials: $35,000 Operating expenses:…

22. Hot Mama's has prepared its fourth quarter budget and provided the following data: Oct Nov Dec $52,000 $48,500 $51,200 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 35,000 13,250 15,650 22,450 9,650 23,900 16,250 12,500

22. Hot Mama's has prepared its fourth quarter budget and provided the following data: Oct Nov Dec $52,000 $48,500 $51,200 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 35,000 13,250 15,650 22,450 9,650 23,900 16,250 12,500

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

Please explain it properly
Newman Medical Clinic has budgeted the following cash flows. January February March $101,000 $107,000 $127,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,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 2 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. Cash Budget Beginning cash balance Add: Cash receipt Cash available Less: Cash payments 90,500 31,500 Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) For inventory purchases For S&A expenses Interest expense per month…
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
Corp. Is working on its cash budget for March. The budgeted beginning cash balance is $26,000. budgeted cash receipts total $198,000 and budgeted cash disbursements total $197,000. The desired ending cash balance is $45,000. Q) The excess (deficiency) of cash available over disbursements for March will be: Multiple Cholce $25,000 $1,000 $27,000 $224,000
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
Fayette Medical Clinic has budgeted the following cash flows. February $232,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $240,000 $272,000 220,000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,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. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,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 intermediate and final answers to the nearest whole dollar amounts.) X Answer is not complete. Cash Budget January February March Section 1: Cash receipts Beginning cash…
Bustillo Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $36,000. Budgeted cash receipts total $117,000 and budgeted cash disbursements total $111,000. The desired ending cash balance is $53,500. To attain its desired ending cash balance for March, the company needs to borrow: Multiple Choice $95,500 $11,500 $0 $53,500
Galina, Inc. has prepared the following direct materials purchases budget. Budgeted DM Purchases Month June July August $68,000 74,500 76,600 September October 79,600 70,600 All purchases are paid for as follows: 10% in the month of purchase, 40% in the following month, and 50% two months after purchase. Calculate the budgeted balance of accounts payable at the end of October. A. $63,540 B. $75,100 OC. $39,800 D. $103,340
Question 6. Please fill in the blanks in the same format as the question
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,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. 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.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…
please help with this budgeted income statement