Kayak Company 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 402,000 465,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, Interest per month, pald at each month-end. The Interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add: Cash receipts Total cash available Total cash payments Preliminary cash balance Loan activity Interest on loan Ending cash balance Cash payments $ 471,000 351,000 525,000 Loan balance- Beginning of month Additional loan (loan repayment) Loan balance, end of month KAYAK COMPANY Cash Budget $ January 40,000 $ 522,000 562,000 Loan balance $ 0 80,000 February 40,000 $ 402,000 442,000 0 $ March 40,000 465,000 505,000 0

Vinubhai

Fact Pattern: The Raymar Company is preparing its cash budget for the months of April and May. The firm has established a $200,000 line of credit with its bank at a 12% annual rate of interest on which borrowings for cash deficits must be made in $10,000 increments. There is no outstanding balance on the line of credit loan on April 1. Principal repayments are to be made in any month in which there is a surplus of cash. Interest is to be paid monthly. If there are no outstanding balances on the loans, Raymar will invest any cash in excess of its desired end-of-month cash balance in U.S. Treasury bills. Raymar intends to maintain a minimum balance of $100,000 at the end of each month by either borrowing for deficits below the minimum balance or investing any excess cash. Expected monthly collection and disbursement patterns are shown below. . . . Collections: 50% of the current month's sales budget and 50% of the previous month's sales budget Accounts Payable Disbursements: 75% of the…

The following is the sales budget for Lemonis, Incorporated, for the first quarter of 2021: January February March Sales budget $198,000 $218,000 $241,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $82,000 ($52,000 of which was uncollected December sales). a. Calculate the sales for November. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the sales for December. (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. Calculate the cash collections from sales for each month from January through March. (Do not round Intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. November sales b. December sales c. January cash collections c. February cash collections c.…