Question
5

Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cas
Prepare monthly cash budgets for January, February, and March (Negative balances and Loan repayment amounts (if any) should b
0 0
Add a comment Improve this question Transcribed image text
Answer #1
KAYAK COMPANY
Cash Budget
For January, February, and March
January February March
Beginning balance 30000 30000 75726
Cash Receipts 515000 412000 478000
Total cash available 545000 442000 553726
Cash Payments 461800 358800 524000
Interest expenses 600 74 0
(60000*1%) (7400*1%)
Preliminary cash balance 82600 83126 29726
(545000-461800-600)
Additional loan (loan repayment) -52600 -7400 274
Ending cash balance 30000 75726 30000
Loan Balance
Loan Balance - Beginning of the month 60000 7400 0
Additional loan (loan repayment) -52600 -7400 274
Loan Balance - End of month 7400 0 274
Add a comment
Know the answer?
Add Answer to:
5 Kayak Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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. January February March Cash Receipts $524,000 401,500 465,000 Cash payments $465,300 342,800 528,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 $150,000 at...

  • 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. January February March Cash Receipts $516,000 406,000 478,000 Cash payments $461,700 351,700 524,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month end. In return, the bank has agreed that the company can borrow up to $150,000...

  • 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 Cash Receipts $518,000 403,000 464,000 payments $463,700 348,700 524,000 January February March 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 borrow up...

  • 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 $ 524,000 $ 466,400 February 403,500 345,900 March 455,000 522,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...

  • Kayak Co. budgeted the following cash receipts (excluding dash receipts from loans received) and cash payments...

    Kayak Co. budgeted the following cash receipts (excluding dash 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 $525,000 400,eee 45e,eee Cash payments $475,eee 350, eee 525,e00 January February March 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 borrow...

  • 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 Cash Receipts $525,000 400,000 450,000 payments $475,000 350,000 525,000 January February March According to a credit agreement with its bank, Kayak requires a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at...

  • 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. January February March Cash Receipts $521,000 411,500 460,000 Cash payments $463,400 353,900 533,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at...

  • 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. January February March Cash Receipts $524,000 402,500 454,000 Cash payments $466,400 344,900 527,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at...

  • 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. January February March Cash Receipts $522,000 409,500 474,000 Cash payments $ 462,200 349,700 535,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow up to $140,000...

  • 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 $ 526,000 $ 470,600 February 408,000 352,600 March 465,000 532,000 According to a credit agreement with its bank, Kayak requires a minimum cash balance of $30,000 at each month-end. In return, the bank has agreed that the company can borrow up to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT