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

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

Rivers Company purchases merchandise on account. In general, Rivers pays 50% in the month of purchase and 50% in the following month. All payments in the month of purchase qualify for a 2% cash discount. First quarter budgeted purchases are: January $90,000 February $80,000 March $96,000 A. What are the total cash disbursements expected in February? B. What are the total cash disbursements expected in March? C. Now suppose that there is no cash discount for purchases made in the month of purchase. Now what are the total cash disbursements expected in February? In March?
Boris detergents expects to have a cash balance of P46,000 on January 1, 2020. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January P71,000, February P146,000. 2. Payments to suppliers: January P40,000, February P75,000. 3. Wages: January P30,000, February P40,000. Wages are paid in the month they are incurred. 4. Administrative expenses: January P21,000, February P24,000. These costs include depreciation of P1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January P15,000, February P20,000. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize P12,000 in cash. The Company has a line of credit at a local bank that enables it to borrow up to P25,000. The company wants to maintain a minimum monthly cash balance of P20,000. Prepare a cash budget for January and February.
Spartan Industries has budgeted the following information for January Cash Receipts $ 43,400 Beginning Cash Balance $ 16,400 Cash Payments $ 61,400 Desired Ending Cash Balance $ 11,400 If there is not enough cash on hand to meet the desired ending balance, the company borrows money from the bank. All cash is borrowed at the beginning of the month in $1,700 increments. Interest is paid monthly on the first day of the following month. The interest rate is 1 percent per month. The company had no debt before January 1 The shortage or surplus of cash before considering cash borrowed or interest payments in January would be a: Multiple Choice $1,600 shortage $9,800 shortage.
Question 3. Please fill in the blanks the same way as the question
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…
Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $100,000 September 185,000 October 225,000 The company expects to sell 40% of its merchandise for cash. Of the sales on account, one third are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections of accounts receivable for August, September, and October. For each month's sales on account, enter the collection months in chronological order. Trapp Co. Schedule of Collections of Accounts Receivable For Three Months Ending October 31, 20xX August September October August sales on account: Collected in August Collected in September September sales on account: Collected in September Collected in October October sales on account: Collected in October Totals
The president of the retailer Prime Products has just approached the company's bank with a request for a $57,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $30,800. Accounts receivable on April 1 will total $159,600, of which $136,800 will be collected during April and $18,240 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…
The beginning cash balance is $20,600. Sales are forecasted at $715,000 of which 70% will be on account. The remainder are cash sales. Sixty percent of credit sales are expected to be collected in the year of sale. Cash expenditures for the year are forecasted at $465,000. Accounts receivable from previous accounting periods totaling $11,000 will be collected in the current year. The company is required to make a $21,500 loan payment and an annual interest payment on the last day of the year. The loan balance as of the beginning of the year is $145,000, and the annual interest rate is 10%. What will be reported as 'cash' on the budgeted balance sheet?
None
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…
Sparks Corporation has a cash balance of $17,700 on April 1. The company must maintain a minimum cash balance of $14,500. During April, expected cash receipts are $65,000. Cash disbursements during the month are expected to total $77,500. Ignoring interest payments, during April the company will need to borrow: Multiple Cholce $9.300 $5,200 $14,500 $12,500