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 $ 528,000 $469,300 January February March 410,000 453,000 351,300 533,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, 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 $40,000 is used to repay loans al 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. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)

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 $ 528,000 $469,300 January February March 410,000 453,000 351,300 533,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, 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 $40,000 is used to repay loans al 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. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

i do not understand why the loan payment amount is wrong
Group of answer choices $3,729,968 $3,781,600 $4,025,200 $4,408,000
Shalom Company wants to maintain a minimum monthly cash balance of P20,000. The budget for the first quarter showed an ending cash balance of P21,000. In April, expected cash receipts are P321,000, and budgeted expenses, including depreciation of P30,000, are expected to be P288,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) Should Shalom Company enter into a financing agreement? Yes or No? Use the underlined words in capital letters as your choice.
Karim Corporation requires a minimum $8,800 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $8,800 is used to repay loans at month-end. The cash balance on July 1 is $9,200, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on loan Interest revenue Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (If any) should be Indicated with minus sign. Round your final answers to the nearest whole dollar. Total cash payments Preliminary cash balance Loan activity July $ 24,800 29,208 Ending cash balance August $ 32,800 30,800 Loan balance Beginning of month Additional loan (loan repayment) Loan…
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 $ 520,000 $ 463,500 February 401,500 345,000 March 465,000 527,000 Kayak requires a minimum cash balance of $50,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 $50,000 is used to repay loans at month-end. 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 indicated with minus sign.)
cash balance of $10,000 will be maintained throughout the cash budget period. Prepare a monthly cash budget for January and February and answer the following: How much surplus (or loan) is expected at the end of February? A $1,900 B. $200 C. $1,400 D. $3,100 E. none of the other choices is correct
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 523,000 $ Beginning cash balance Total cash available Kayak requires a minimum cash balance of $40,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 $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. 408,500 476,000 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Total cash payments Preliminary cash balance Loan activity Ending cash balance Cash payments $ 469,800…
Garden Depot is a retailer that provided the following budgeted cash flows for next year: 3rd Quarter $ 220,000 $ 227,000 Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 190,000 $ 340,000 $ 267,000 $ 237,000 The company's beginning cash balance for next year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash…
An entity is budgeting its cash payments for the last quarter of 2020. All purchases are made on account with 2% discount for early payments. The October purchases is set at P150,000, and purchases increase by 20% based on the previous month. 50% of purchases are paid on the month of purchase, availing of the purchase discount; 45% are paid the next month; and 5% are paid after 2 months from date of purchase. How much is the total cash payment to be made in December 2020?
Dineshbhai
Vargas Company is preparing a cash budget for April. The company has $27,000 cash at the beginning of April and anticipates $60,000 in cash receipts and $64,500 in cash disbursements during April. Vargas Company has an agreement with its bank to maintain a cash balance of at least $25,000. To maintain the $25,000 required balance, during April the company must: Borrow $2,500 from the owner. Borrow $5,000 from the owner. Borrow $7,500 from the owner. Borrow $4,500 from anyone other than the bank or the owner.
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?