Exercise 20-17 (Algo) Preparation of cash budgets (for 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 $527,000 407,500 472,000 $473,800 354,300 532,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.) Beginning cash balance Add: Cash receipts KAYAK COMPANY Cash Budget January February March 40,000 $ 527,000 40,000 407,500 472,000

Exercise 20-17 (Algo) Preparation of cash budgets (for 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 $527,000 407,500 472,000 $473,800 354,300 532,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.) Beginning cash balance Add: Cash receipts KAYAK COMPANY Cash Budget January February March 40,000 $ 527,000 40,000 407,500 472,000

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

None
do not give solution in image
None
Budget in Service Company (Cash Budget) Edge Soccer Program (Edge) began the year with a cash balance of $10,500. The budget forecasts that collections from customers owed to the company will be $11,000 in January and $15,200 in February. The soccer program is also supposed to receive $8,500 in January on a note receivable from a soccer club that owes Edge for training. Edge plans to purchase soccer equipment in January and February with cash. The budgeted amounts of the purchases are $15,600 in January and $14,800 in February. Operating costs for the business is $2900 per month. Edge must maintain a minimum cash balance of $10,000 in their bank account at all times. If the amount in the bank account falls below $10,000, then bank extends credit to Edge immediately in multiples of $1000. Edge pays back any amounts borrowed each quarter in payments of $2000 plus 4% interest. The first payment occurs three (3) months after the bank has extended edge credit. Requirement Prepare a cash…
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of the year (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1) January February March $280,000 $300,000 $270,000 Cash receipts Cash disbursements 260,000 340,000 280,000 The expected cash balance at January 1, is $62,000. Brewster wants to maintain a cash balance at the end of each month of at least $60,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31. Brewster Corporation Cash Budget for the Quarter Ended March 31 January Beginning cash balance Cash receipts Short-term borrowings Cash available Cash disbursements Interest payment Total…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
RequiredPrepare cash budget, for the three month from October to December showing cash balance at the end of December .
Please do not give image format
8-19
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
Cash budget In addition to the information presented in Mini-Exercise 14.4, ABC Company has a cash balance of $25,000 on August 1 and requires a minimum ending cash balance of $20,000. Cash disbursements budgeted for August include inventory purchases, $40,000; other manufacturing expenses, $98,000; operating expenses, $76,200; bond retirements, $50,000; and dividend payments, $15,000.Required:Prepare a cash budget for ABC Company for August.