Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance-Beginning of month Additional loan (loan repayment) Loan balance - End of month Cash Budget October November December $ 6,300 0 0 0 Loan balance $ 2,300

Foyert Corporation requires a minimum $6,300 cash balance. Loans taken to meet this requirement cost 2% interest per month (paid at the end of each month). Any preliminary cash balance above $6,300 is used to repay loans at month-end. The cash balance on October 1 is $6,300, and the company has an outstanding loan of $2,300. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments October $ 22,300 24,450 November $ 16,300 15,300 December $ 20,300 15,700 Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) FOYERT CORPORATION Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for Interest on loan Total cash payments Preliminary cash balance Loan activity Additional loan (loan repayment) Ending cash balance Loan balance-Beginning of month Additional loan (loan repayment) Loan balance - End of month Cash Budget October November December $ 6,300 0 0 0 Loan balance $ 2,300

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

The George Company has a policy of maintaining an end-of-month cash balance of at least $30,000.In months where a shortfall is expected, the company can draw in $1,000 increments on a line ofcredit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed forbudgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000increments of principal) are assumed to occur at the end of the month. Interest is paid at the end ofeach month. For April, an end-of-month cash balance (prior to any financing and interest expense)of $18,000 is budgeted; for May, an excess of cash collected over cash payments (prior to any interest payments and loan repayments) of $22,000 is anticipated. What is the interest payment estimatedfor April (there is no bank loan outstanding at the end of March)? What is the total financing effect(cash interest plus loan transaction) for May?
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 2% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $30,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments Beginning cash balance July August $ 81,000 $ 107,000 109,000 95,900 Prepare a cash budget for July, August, and September. (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 available MOTORS CORPORATION Cash Budget Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan activity Loan…
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 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. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…
Motors Corporation manufactures motors for dirt bikes. The company reguires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $39,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments July S 9e, eee 118, e00 August $ 116,000 104, 900 September $ 155,000 132,400 Prepare a cash budget for July, August, and September (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) MOTORS CORPORATION Cash Budget July August September Total cash available Less: Cash payments for
Kamal Co. has an average collection period (ACP) of 30 days and an operating cycle of 170 days. It has a policy of keeping at least RO 15,000 on hand as a minimum cash balance, and has a beginning cash balance for the first quarter of RO 20,000. Beginning receivables for the first quarter amount to RO 30,000 Sales for the first second and the third quarters are expected respectively to be RO 100,000; RO120,000; and RO 150,000. The purchases amount represents 50% of the next quarter's forecasted sales. The quarterly wages and other expenses is RO 7,000. The capital spending occurs in the second quarter and equals to RO 15,000. The accounts payable period is 45 days. The beginning accounts payable is RO 10,000. A. What are cash collections in the first and second quarters? B. What are cash disbursements for the first and second quarters ? C. What is the cumulative surplus (deficit) at the end of the first and second quarters ?
crane company management wants to maintain a minimum monthly cash balance of $26,500. At the begining of April, the cash balance is $26,500, expected cash receipts for April are $259,700, and cash disbursements are expected to be $270,300. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance ?
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…
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…
A firm collects 25% of its credit sale in the month of sale and the remainder in the following month. The credit sale for the month of June is GHC 150,000. It expert to pay bills of GHC 22,000 in July. The depreciation for the month is GHC 1000. If the company maintains an end month cash balance of GHC 100,000, what is the external finance required?
The beginning cash balance is $16,500. Sales are forecasted at $820,000 of which 80% will be on account. Seventy percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $472,000. Accounts Receivable from previous accounting periods totaling $11,800 will be collected in the current year. The company is required to make a $16,500 loan payment and an annual interest payment on the last day of every year. The loan balance as of the beginning of the year is $90,000, and the annual interest rate is 9%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $
Holiday Tree Farm has a cash balance of $34 and a short-term loan balance of $180 at the beginning of Qt. The net cash inflow for the first quarter is $36 and for the second quarter there is a net cash outflow of $48. All cash shortfalls are funded with short-term debt. The firm pays 2 percent of its prior quarter's ending loan balance as interest each quarter. The minimum cash balance is $20. What is the short-term loan balance at the end of Q2? Multiple Choice $184.3 $179.2 $138.6 $128.4 $1931
Crane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $11 Crane Company management wants to maintain a minimum monthly cash balance of $20,000. At the beginning of April, the cash balance is $20,000, expected cash receipts for April are $196,000, and cash disbursements are expected to be $204,000 How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance $ I I