Foyert Corporation requires a minimum $7,400 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 $7,400 is used to repay loans at month-end. The cash balance on October 1 is $7,400, and the company has an outstanding loan of $3,400. 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 $ 23,400 26,100 Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for All items excluding interest All items excluding interest. Total cash payments Preliminary cash balance Loan activity Ending cash balance. 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.) November $ 17,400 16,400 Loan balance - Beginning of month December $ 21,400 14,600 FOYERT CORPORATION Cash Budget $ October Loan balance $ 7,400 $ 23,400 30,800 34 4,666 4,700 November 3,400 7,400 $ 17,400 24,800 61 December 61 7,400 21,400 28,800 52 52

Foyert Corporation requires a minimum $7,400 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 $7,400 is used to repay loans at month-end. The cash balance on October 1 is $7,400, and the company has an outstanding loan of $3,400. 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 $ 23,400 26,100 Beginning cash balance Add: Cash receipts Total cash available Add: Cash payments for All items excluding interest All items excluding interest. Total cash payments Preliminary cash balance Loan activity Ending cash balance. 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.) November $ 17,400 16,400 Loan balance - Beginning of month December $ 21,400 14,600 FOYERT CORPORATION Cash Budget $ October Loan balance $ 7,400 $ 23,400 30,800 34 4,666 4,700 November 3,400 7,400 $ 17,400 24,800 61 December 61 7,400 21,400 28,800 52 52

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

Peach Corporation's only cash receipts are those derived from customer sales. Peach makes both cash sales and sales on account. For its credit sales, Peach collects 50% in the month of the sale, 40% in the month following the sale, and 10% in the second month following the sale. Peach is preparing its cash budget for the upcoming year. Sales on account for the month of March are budgeted at $150,000. The budgeted accounts receivable balance on March 1 is $113,000, of which $90,000 represents uncollected sales made in February and $23,000 represents uncollected sales made in January. If Peach's total cash receipts for the month of March are budgeted at $205,000, what are Peach's budgeted cash sales during March? O $17,000 O $35,000 $53,000 $71,000 O None of the above
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 Cash payments $ 519,000 $ 468,000 404,000 452,000 353,000 521,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 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. (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 January February March $ 519,000 409,000 476,000 $ 459,200 349,200 532,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. Beginning cash balance Add: Cash receipts Total cash available Less: Cash payments for Interest on 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…
Sparks Corporation has a cash balance of $24,100 on April 1. The company must maintain a minimum cash balance of $6,500. During April, expected cash receipts are $49,000. Cash disbursements during the month are expected to total $68,500. Ignoring interest payments, during April the company will need to borrow:
Dog
The following information was taken from Bonita Industries's cash budget for the month of July: Beginning cash balance $440000 Cash receipts 404000 Cash disbursements 558000 If the company's policy is to maintain a minimum end of the month cash balance of $430000, the amount the company would have to borrow in July is $286000. $144000. $10000. $26000.
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 Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,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.)
Foyert Corporation requires a minimum $7,000 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 $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
The beginning cash balance is $18,000. Sales are forecasted at $860,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 $475,000. Accounts Receivable from previous accounting periods totaling $11,300 will be collected in the current year. The company is required to make a $14,000 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 $95,000, and the annual interest rate is 8%. Compute the excess of available cash over cash disbursements. Excess of available cash over cash disbursements $
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.
Santos Co. is preparing a cash budget for February. The company has $20,000 cash at the beginning of February and anticipates $75,000 in cash receipts and $100,250 in cash payments during February. What amount, if any, must the company borrow during February to maintain a $5,000 cash balance? The company has no loans outstanding on February 1.