Jason Allen has been working on Vaughn Paints' cash budget for
the coming year. Based on his projections for March, the beginning
cash balance will be $45,700; cash collections will be $520,000;
and cash disbursements will be $554,000. Vaughn Paints desires to
maintain a $40,000 minimum cash balance. The company has a 6% open
line of credit with its bank, which provides short-term borrowings
in $500 increments. All borrowings are made at the beginning of the
month, and all repayments are made at the end of the month (in $500
increments). When partial payments are made against the line of
credit, accrued interest applicable to the full amount due through
that date is paid along with the partial principal
repayment.
(a) | How much will Vaughn Paints need to borrow from the bank at the beginning of March? | |||||
|
(b) | Vaughn anticipates having a positive $20,000 net cash flow from April activities. How much of the line of credit from March can be repaid? How much interest will be repaid in April? | ||||||||||
|
Answer a.
Total Cash available = Beginning Cash Balance + Cash
Collection
Total Cash available = $45,700 + $520,000
Total Cash available = $565,700
Excess (deficit) of Cash available over disbursement = Total
Cash available - Cash Disbursements
Excess (deficit) of Cash available over disbursement = $565,700-
$554,000
Excess (deficit) of Cash available over disbursement = $11,700
Minimum Cash Balance = $40,000
Financing required = Minimum Cash Balance - Excess (deficit) of
Cash available over disbursement
Financing required = $40,000- $11,700
Financing required =$28,300
So, Vaughn Paints should borrow $28,300
Answer b.
Annual Interest Rate = 6%
Monthly Interest Rate = 0.5%
Interest due = 0.5% * $28,300 * 2
Interest due = $283
Since principal to be repaid in incremental of $500
Excess cash available :$20,000-$283=$19,717
Principal Repaid = $19,500
Interest to be repaid = $283
Jason Allen has been working on Vaughn Paints' cash budget for the coming year. Based on...
assistance needed aton WINTraveRSION BACK NEXT URCES Exercise 5-26 Will Benjamin has been working on Sunland Paints cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $50, 194; cash collections will be $700,000; and cash disbursements will be 5710,790, Sunland Paints desres to maintain a 550,000 minimum cash balance. The company has a 10% open line of credit with ts bank, which provides short ter borrowings in $500 increments. All borrowings...
The George Company has a policy of maintaining an end-of-month cash balance of at least $34,000. In months where a shortfall is expected, the company can draw in $1,000 increments on a line of credit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000 increments of principal) are assumed to occur at the end...
Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments (excluding loan principal repayments and interest payments) from the cash disbursements budget for the next quarter (April, May, & June). Cash Receipts Cash Payments April $30,024 $27,064 May $32,398 $39,383 June $36,064 $32,772 In addition, Kaiser's beginning cash balance as of April 1 is $15,290. Kaiser, Inc. would like to maintain a minimum $15,000 cash balance at all times. In order to achieve this...
John Wills, Swifty & Hill Fabricators’ budget director, has received budget information from several managers and is preparing the company’s cash budget. January February March Quarter Collections from sales 303,405 550,875 587,100 1,441,380 Payments for direct materials 45,470 67,800 80,180 193,450 Payments for direct labor 125,430 215,830 190,970 532,230 Payments for manufacturing overheads 97,615 100,779 99,909 298,303 Payments for Selling & administrative expenses 58,195 74,300 70,910 203,405 In addition to the information he received from these managers, John knows...
Vaughn Products, a rapidly growing distributor of home gardening equipment, is formulating its plans for the coming year. Carol Jones, the firm's marketing director, has completed the following sales forecast. Month January February March April May June Sales $908,300 $1,005,800 $908,300 $1,153,500 $1,252,100 $1,409,900 Month July August September October November December Sales $1,504,200 $1,504,200 $1,606,500 $1,606,500 $1,504,200 $1,707,200 Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. He has gathered the...
A) Prepare Drew Consulting's cash budget for January AND February B) How much cash will Drew borrow in February if cash receipts from customers that month total $39,000 instead of $49,000 Assume Drew Consulting began January with $15,000 cash. Management forecasts that cash receipts from credit customers will be $48,000 in January and $49,000 in February. Projected cash payments include equipment purchases ($18,000 in January and $41,000 in February) and selling and administrative expenses ($3,000 each month). Drew's bank requires...
The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000. In months where a shortfall is expected, the company can draw In $1,000 Increments on a line of credit it has with a local bank, at an Interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000 Increments of principal) are assumed to occur at the end...
The George Company has a policy of maintaining an end-of-month cash balance of at least $33,000. In months where a shortfall is expected, the company can draw in $1,000 Increments on a line of credit it has with a local bank, at an Interest rate of 12% per annum. All borrowings are assumed for budgeting purposes to occur at the beginning of the month, while all loan repayments (In $1,000 Increments of principal) are assumed to occur at the end...
I am working on this Cash budget but cannot seem to find out where the Beginning cash balance is coming from & the Negative amounts. Please help in Month May June Quarter o $ $ $ April 7,800 62,600 70,400 $ 72,000 $ 89,000 $ 223,600 $ $ 62,625 15,920 $ $ 57,675 20,420 $ $ $ $ $ 7 Beginning Cash balance 8 Add Cash Collections 9 Total Cash Avaliable LO Less Cash Disbursments: 11 Inventory 12 Expenses 13...
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: 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...