Vaughn, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Vaughn desires tomaintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings andrepayments must be made in even increments of $1,000. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)Beginning cash balanceCollections from salesTotal cash availableLess disbursementsMaterials purchasesDirect laborManufacturingoverheadSelling &administrativeexpensesEquipment purchaseDividendsTotal disbursementsExcess (deficiency) ofcashMinimum cash balanceCash available(needed)Financing:BorrowingsRepaymentsInterestTotal financingEnding cash balanceOctober50,00066,5005,00020,00028,50066,00015.000-14,500$15.500November$15.500 $93,50010.0006,00024,00025,00028.50015.000-150-15,150$13,350 $December120,00014,0008,00022,0005,00015,0009,000$Quarter$16.500234,65036,50019,00015,0005,00015,000-15.000-150-150

The cash budget is referred to as the budget which makes estimates of cash inflows and outflows on a…

Answered: Vaughn, Inc. prepared the following…

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter16: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 16MC: In an attempt to better understand RR’s cash position, Johnson developed a cash budget for the first...

See similar textbooks

Similar questions

Aswer correctly. Options already selected are not all correct. Revise and answer.
are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $26,800. Accounts receivable on April 1 will total $193,200, of which $165,600 will be collected during April and $22,080 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $360,000 $ 275,000 $32,000 $ 38,400 $ 73,000 $0 $ 15,400 Required 1 Required 2 May $ 582,000 $ 227,000 $ 32,000 $ 38,400 $ 73,000 $0 $ 15,400 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise…
Jim Daniels Health Products has eight stores. The firm wants to expand by two more stores and needs a bank loan to do this. Mr. Hewitt, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures: Actual November December $420,000 January 440,000 February March Forecast Additional Information $500,000 April forecast $550,000 540,000 560,000 of the firm's sales, 40 percent are for cash and the remaining 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after the sale. Materials cost 35 percent of sales and are purchased and received each month in an amount sufficient to cover the current month's expected sales. Materials are paid for in the month they are received. Labour expense is 45 percent of sales and is paid in the month of sales. Selling and administrative expense is 4 percent of…
Prime Products hopes to borrow $79,000 on April 1 and repay it plus interest of $1,140 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $16,500. Accounts receivable on April 1 will total $190,400, of which $163,200 will be collected during April and $21,760 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April May $ 312,000 $ 204,000 $ 24,000 $ 24,800 $ 79,200 $ 428,000 $ 162,000 $ 24,000 $ 24,800 $ 79,200 $ 17,200 $ 17,200 c. Merchandise purchases…
Avery Company has prepared the following schedules and additional information: 1(Click the icon to view the cash receipts schedule.) 2(Click the icon to view the cash payments schedule.) 3(Click the icon to view the additional information.) Complete a cash budget for Avery Company for January, February and March. (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar. Enter a cash deficiency with a minus sign or parentheses.) Avery Company Cash Budget January, February, and March January Beginning cash balance $5,500 Cash receipts 10,800 Cash available 16,300 Cash payments: Purchases of direct materials 0 Direct labor 2,900 Manufacturing overhead 3,720 Selling and administrative expenses 5,920 Interest expense 0 Total cash payments 12,540…
The president of the retailer Prime Products has just approached the company's bank with a request for a $91,000, 90-day loan. The purpose of the loan is to assist the company in acquiring Inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $15,800. Accounts receivable on April 1 will total $176,400, of which $151,200 will be collected during April and $20,160 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…
please help me these questions
Please provide complete and correct answer for both requirements and show all work like explanation , computation , formula with steps. Answer in text. Million thanks !
The accountant for Jean's Dress Shop prepared the following cash budget. Jean's desires to maintain a cash cushion of $10,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required a. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Jean's will report on the third quarter pro forma statement of cash flows. c. Determine the amount of net cash flows from financing activities Jean's will report on the third quarter pro forma statement of cash flows. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the cash budget by filling in the missing amounts. (Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) Cash Budget Section 1: Cash receipts Beginning cash balance Add cash receipts Total cash…
The accountant for Baird's Dress Shop prepared the following cash budget. Baird's desires to maintain a cash balance of $24,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 1 percent per month. Required a. Complete the cash budget by filling in the missing amounts. b. Determine the amount of net cash flows from operating activities Baird's will report on the third quarter pro forma statement of cash flows. c. Determine the amount of net cash flows from financing activities Baird's will report on the third quarter pro forma statement of cash flows. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the cash budget by filling in the missing amounts. Note: Any shortages or repayments should be indicated with a minus sign. Round your answers to the nearest whole dollar amount. Cash Budget July August September Section 1: Cash receipts Beginning cash balance…
Prepare a master budget for the three-month period ending June 30 that includes a cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $68,000. (Cash deficiency, repayments and interest should be indicated by a minus sign.)
a .Prepare an estimate of cash position for three months from April to June b. Based on the budget prepared, evaluate the cash position of the comupany, give your comments and provide suitable suggestion to the management on effective cash managenent.

SEE MORE QUESTIONS

Recommended textbooks for you

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

SEE MORE TEXTBOOKS