Will Benjamin has been working on Heston Paints' cash budget for the coming year. Based on his

Question:

Will Benjamin has been working on Heston 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 $650,000, and cash disbursements will be $684,000. Heston Paints desires to maintain a $45,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). Accrued interest is paid at the time of repayment.


Required

a. How much will Heston Paints need to borrow from the bank at the beginning of March?

b. Assuming that Heston Paints has $20,000 in excess cash budgeted for April, how much principal will the company plan to repay? How much interest will be repaid in April?

Cash Budget
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment.  Its primary purpose is to provide the...
Line of Credit
A line of credit (LOC) is a preset borrowing limit that can be used at any time. The borrower can take money out as needed until the limit is reached, and as money is repaid, it can be borrowed again in the case of an open line of credit. A LOC is...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Accounting

ISBN: 978-1119343615

3rd edition

Authors: Charles E. Davis, Elizabeth Davis

Question Posted: