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 $528,000 January February March payments $470,400 351,400 534,000 409,000 452,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 a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $40,000 on the last day of each month. The company has a cash balance of S40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)

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 $528,000 January February March payments $470,400 351,400 534,000 409,000 452,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 a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $40,000 on the last day of each month. The company has a cash balance of S40,000 and a loan balance of $80,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter17: The Management Of Cash And Marketable Securities

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

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. CashReceipts Cashpayments January $ 516,000 $ 461,700 February 403,000 348,700 March 451,000 530,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 a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $40,000 on the last day of each month. 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. (Negative balances and Loan repayment amounts…
Kayok Co budgeted the following cash receipts (excluding cash receipts from loans received) oand 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 409, 500 481,000 Cash paynents $457, 300 350, 800 S28,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 hes agreed that the company can borrow up to $150,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan faor the month. The company repays loan principal with any cash in excess of $30,000 on the lest day of each month. The company has a cash bolance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus…
Kayak Co. budgeted the following cash recelpts (excluding cash recelpts from loans recelved) and cash payments (excluding cash payments for loan principal and Interest payments) for the first three months of next year. Cash Cash Receipts $519,eee payments $464,7ee 358, 208 524, еее January February 412,5ee March 464,eee According to a credlt 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 $140,000 at a monthly Interest rate of 1% , pald on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash In excess of $40,000 on the last day of each month. 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. (Negative balances and Loan repayment amounts (If any) should be indicated wlth minus…
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 $519,000 412,000 460,000 Cash payments $466,900 359,900 532,000 According to a credit agreement with the company's bank, Kayak promises to have 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 a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be…
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 $519,000 407,500 455,000 раynente $461,400 349,900 524,000 January February March According to a credit agreement with the company's bank, Kayak promises to have a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $160,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month, The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. ces Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be…
Dear Bartleby, I need assistance calculating interest for part b. b. Assume that management of SeaTech Inc. desires to maintain a minimum cash balance of $10,000 at the beginning of each month and has arranged a $50,000 line of credit with a local bank at an interest rate of 10% to ensure the availability of funds. Borrowing transactions are to occur only at the end of months in which the budgeted cash balance would otherwise fall short of the $10,000 minimum balance. Repayments of principal and interest are to occur at the end of the earliest month in which sufficient funds are expected to be available for repayment. (Use 360 days year for calculations.) Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600…
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. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,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.
Kayak Co. budgeted the following cash recelpts (excluding cash receipts from loans recelved) and cash payments (excluding cash payments for loan principal and Interest payments) for the first three months of next year. cash Cash Receipts $523,000 405,500 453,000 раyments $465,400 347,900 535,000 January February March 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 $140,000 at a monthly Interest rate of 1%, pald on the last day of each month. The Interest Is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negatlve balances and Loan repayment amounts (If any) should be Indicated with minus…
Q1. Below are the budgeted revenue and expenses for a restaurant for the year 2022. RM (*000) 71,250 Revenue Sales RM ('000) 28,500 4,200 17,100 Expenses Cost of supplies Salaries Wages Depreciation Repair and Maintenance Advertisement Laundry Interest on Loan Miscellaneous expenses Utilities 900 3,000 1,500 200 2,200 2,300 650 Below are the additional information given to you for further analysis: The expected pattern of sales for the year 2022 are as follows and it is the company policy to analyse based on quarters. Percentage of sales 24 Quarter 1 2 20 3 24 4 32 75% of the sales are on a cash basis and the balance will be received in the next quarter. The costs of supplies vary directly with sales and a constant stock value of supplies are kept. 20% of purchases of the food and drinks are for cash and the balance are paid during next quarter. 80% of the repairs and maintenance item is for a major redecoration to be paid in the third quarter. Wages, which are variable with sales, are…
Please answer with excel forumlas and step by step explanations. 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. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
NanaKay Company must maintain a minimum cash balance of GH¢25,000. At the beginning of June, the company’s cash balance was GH¢17,000. Budgeted cash receipts for June are GH¢150,000, and budgeted cash disbursements are GH¢201,000. Budgeted net income for July totals GH¢11,000. How much will NanaKay Company need to borrow by the end of June?
Ramon Manufacturing has a cash balance of P8,000 on August 1 of the current year.The company’s controller forecast the following cash receipts and cash disbursementsfor the upcoming two months of activity.Receipts PaymentsAugust P 45,000 P 57,000September 66,000 56,000Management desires to maintain a minimum cash balance of P8,000 at all times. If necessary, additional financing can be obtained in P1,000 multiples at a 12% interest rate. All borrowings are made at the beginning of the month; debt retirement, on the otherhand, occurs at the end of the month. Interest is paid at the time of repaying loan principal and is computed on the portion of debt repaid. 1. Determine the ending cash balance in August both before and after anynecessary financing or debt retirement.