Question

Below are the forecasted cash receipts and cash payments for Kaden Company for the first four...

Below are the forecasted cash receipts and cash payments for Kaden Company for the first four months of the year.

  

                                                            January         February          March             April

Budgeted cash collections               100,000            80,000          75,000       146,000

                                                                                                                            

Budgeted cash payments:                                                                                     

Operating expenses                       127,000           105,000          92,000      120,000

Dividends                                                    0             20,000                   0                 0

Equipment purchase                                 0             40,000                   0                 0

Total budgeted cash payments       127,000           165,000         92,000      120,000

  

On January 1, Kaden Company had a cash balance of $50,000. Kaden has a policy of maintaining a cash balance of at least $10,000 at the end of each month.

  

Assume that Kaden Company had no outstanding loans on January 1. Also assume that there is no interest cost for its loans. What it the balance in Kaden Company’s loans as of the end of April?

  • $17,000

  • $26,000

  • $63,000

  • $9,000

  • $0

Homework Answers

Answer #1

OPTION C---$63000

Particulars Jan Feb March April
Beginning cash balance 50000 23000 10000 10000
Budgeted cash collection 100000 80000 75000 146000
Cash available 150000 103000 85000 156000
Budgeted cash payments
Operating expenses 127000 105000 92000 120000
Dividend 0 20000 0 0
Equipment purchases 0 40000 0 0
Total budgeted cash payments 127000 165000 92000 120000
Preliminary budgeted cash balance 23000 (62000) (7000) 36000
Borrowing - 72000 17000
Loan repayment - 26000
Ending cash balance 23000 10000 10000 10000

Loan Balance at april end =72000+17000-26000=$63000

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 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. 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...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
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...
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 $ 521,000 $ 468,900 February 405,500 353,400 March 478,000 523,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...
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 $ 461,600 February 405,500 350,100 March 476,000 532,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...
Canoe Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Canoe 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 $ 468,400 February 408,500 350,900 March 459,000 534,000 According to a credit agreement with the company’s bank, Canoe promises to have a minimum cash balance of $40,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 $ 521,000 $ 464,500 February 405,000 348,500 March 456,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 has agreed that the company can...