Question

Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during...

Prepare Cash Budget For 3 Months
Brewster Corporation expects the following cash receipts and disbursements during the first quarter of 2016 (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1, 2016)

January February March
Cash receipts $300,000 $320,000 $290,000
Cash disbursements 280,000 360,000 300,000

The expected cash balance at January 1, 2016, is $82,000. Brewster wants to maintain a cash balance at the end of each month of at least $80,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31, 2016.

Brewster Corporation
Cash Budget for the Quarter Ended
March 31, 2016
January February March
Beginning cash balance Answer Answer Answer
Cash receipts Answer Answer Answer
Short-term borrowings Answer Answer Answer
Cash available Answer Answer Answer
Cash disbursements Answer Answer Answer
Interest payment Answer Answer Answer
Total cash disbursements Answer Answer Answer
Ending cash balance Answer Answer Answer

PreviousSave AnswersNext

Homework Answers

Answer #1

Answer:

January

February

March

Beginning Cash balance

$82,000

$102,000

$80,810

Cash receipt

300000

320000

290000

Short-term borrowings

0

19000

10000

Total cash available

382000

441000

380810

Cash Disbursements

280000

360000

300000

Interest payment

0

190

290

Total cash Disbursements

$280,000

$360,190

$300,290

Ending Cash balance

$102,000

$80,810

$80,520

Note:

  • Interest for February = (19,000*1%) =190
  • Interest for March= (19,000*1%) + (10,000*1%) = 290
  • Cash to barrowed in multiples of $1,000
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
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash disbursements...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash disbursements (excluding cash disbursements for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash Disbursements   January $ 525,000       $ 475,000           February 400,000       350,000           March 450,000       525,000         According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated...
Cash Budget Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows: Month Sales Revenue Month Sales Revenue January $300,000 March $200,000 February 245,000 April 155,000 All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of...
Please answer all parts of chart Kayak Co. budgeted the following cash receipts (excluding cash receipts...
Please answer all parts of chart Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 521,000 $ 468,900 February 400,500 348,400 March 453,000 533,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $40,000 at each month-end. In return, the bank...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 516,000 $ 461,700 February 404,500 350,200 March 471,000 523,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 517,000 $ 464,900 February 410,000 357,900 March 474,000 526,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can...
Zolezzi Inc. is preparing its cash budget for March. The budgeted beginning cash balance is $28,000....
Zolezzi Inc. is preparing its cash budget for March. The budgeted beginning cash balance is $28,000. Budgeted cash receipts total $105,000 and budgeted cash disbursements total $92,000. The desired ending cash balance is $60,000. The company can borrow up to $60,000 at any time from a local bank, with interest not due until the following month. Required: Prepare the company's cash budget for March in good form. Make sure to indicate what borrowing, if any, would be needed to attain...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant...
Halloween Pty Ltd is preparing a cash budget for the first three months of 2016. Relevant estimates for the budget are as follow: January February March Sales 260,000 300,000 350,000 Materials Purchases 150,000 185,000 220,000 Salaries and Wages 30,000 30,000 35,000 Selling Expenses 14,500 19,000 22,000 Administration Expenses 20,500 24,800 27,600 Additional information: ? All sales are on credit. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20%...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. According to a credit agreement with its bank, Kayak requires a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at a monthly interest rate of 1%, paid on the last day of each...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 518,000 $ 462,600 February 409,500 354,100 March 475,000 529,000 According to a credit agreement with the company’s bank, Kayak promises to have a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 516,000 $ 463,900 February 406,000 353,900 March 454,000 536,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can borrow up to...