Question

Kenneth Clark has been working on Concord Paints' cash budget for the coming year. Based on...

Kenneth Clark has been working on Concord Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $40,700; cash collections will be $560,000; and cash disbursements will be $594,000. Concord Paints desires to maintain a $41,000 minimum cash balance. The company has a 12% 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 Concord Paints need to borrow from the bank at the beginning of March?
Concord Paints should borrow $enter the amount the company should borrow in dollars
(b) Concord 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?
Principal to be repaid $enter the principal to be repaid in dollars
Interest to be repaid $enter the interest to be repaid in dollars

Homework Answers

Answer #1
a)
Particular Amount ($)
Beginning cash balance 40700
Add : Cash collections 560000
Less : Cash disbursement -594000
Avaliable Cash 6700
Minimum Balance required 41000
Shortfall in Cash 34300
Bank Borrowing To be made 34500
( Borrowed in increments of $500 )
b) Interest for two months on bank borrowing
34500* 12% * 2/12 = $ 690
Excess Cash available =
20000 - 690 = 19310
Principal to be repaid = $ 19000
( Repaid in increments of $500 )
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Paul White has been working on Oriole Paints' cash budget for the coming year. Based on...
Paul White has been working on Oriole Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $42,700; cash collections will be $530,000; and cash disbursements will be $564,000. Oriole Paints desires to maintain a $38,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...
The George Company has a policy of maintaining an end-of-month cash balance of at least $39,000....
The George Company has a policy of maintaining an end-of-month cash balance of at least $39,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...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January...
Maleficent Company Limited is preparing budget based on the information below. 1. Budget sales revenues: January February March $ $ $ Credit sales 550,000 450,000 650,000 Cash sales 65,000 55,000 55,000 Total sales 615,000 505,000 705,000 Past experience indicates that customers usually settle their balances as follows: - 60% of a month's credit sales are collected in the month of sale; and - the remaining 40% of a month's credit sales are collected in the following month. All purchases are...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months...
​(Preparation of a cash budget​) Lewis Printing has projected its sales for the first 8 months of 2016 as​ follows: January ​$120,000 April ​$280,000 July ​$200,000 February   140,000 May   275,000 August   200,000 March   170,000 June   200,000 ​(Click on the icon located on the​ top-right corner of the data table above in order to copy its contents into a spreadsheet.​) PrintDone . Lewis collects 30 percent of its sales in the month of the​ sale, 50 percent in the month following...
You are provided with the following information taken from Metlock, Inc.’s March 31, 2017, balance sheet....
You are provided with the following information taken from Metlock, Inc.’s March 31, 2017, balance sheet. Cash $ 11,630 Accounts receivable 22,600 Inventory 37,120 Property, plant, and equipment, net of depreciation 122,700 Accounts payable 22,540 Common stock 153,700 Retained earnings 12,390 Additional information concerning Metlock, Inc. is as follows. 1. Gross profit is 27% of sales. 2. Actual and budgeted sales data: March (actual) $47,000 April (budgeted) 70,800 3. Sales are both cash and credit. Cash collections expected in April...
You are provided with the following information taken from Metlock, Inc.’s March 31, 2022, balance sheet....
You are provided with the following information taken from Metlock, Inc.’s March 31, 2022, balance sheet. Cash $ 11,630 Accounts receivable 22,600 Inventory 37,120 Property, plant, and equipment, net of depreciation 122,700 Accounts payable 22,540 Common stock 153,700 Retained earnings 12,390 Additional information concerning Metlock, Inc. is as follows. 1. Gross profit is 27% of sales. 2. Actual and budgeted sales data: March (actual) $47,000 April (budgeted) 70,800 3. Sales are both cash and credit. Cash collections expected in April...
Finch Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000...
Finch Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000 $ 112,000 $ 132,000 Cash payments For inventory purchases 93,000 75,000 88,000 For S&A expenses 34,000 35,000 30,000 Finch Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,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...
SweeneySweeney Health Center provides a variety of medical services. The company is preparing its cash budget...
SweeneySweeney Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to​ occur: a. Cash collections from services in​ July, August, and​ September, are projected to be $94,000​, $158,000​, and $127,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $149,000 in​ July, $103,000 in​ August, and $131,000 in September. c. The cash balance as of the first day of the...
Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 110,000...
Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 110,000 $ 116,000 $ 136,000 Cash payments For inventory purchases 95,000 77,000 90,000 For S&A expenses 36,000 37,000 32,000 Newman Medical had a cash balance of $13,000 on January 1. The company desires to maintain a cash cushion of $9,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...
Franklin Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 107,000...
Franklin Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 107,000 $ 113,000 $ 133,000 Cash payments For inventory purchases 93,500 75,500 88,500 For S&A expenses 34,500 35,500 30,500 Franklin Medical had a cash balance of $11,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...