Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excludingcash payments for loan principal and interest payments) for the first three months of next year.JanuaryFebruaryMarchCash Receipts Cash payments$ 519,000$ 468,000404,000452,000353,000521,000Kayak requires a minimum cash balance of $40,000 at each month end. Loans taken to meet this requirement charge 1%, interest permonth, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminarycash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balanceof $80,000 at January 1Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) shouldbe indicated with minus sign.) Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excludingcash payments for loan principal and interest payments) for the first three months of next year.JanuaryFebruaryMarchCash Receipts Cash payments$ 519,000$ 468,000404,000452,000353,000521,000Kayak requires a minimum cash balance of $40,000 at each month end. Loans taken to meet this requirement charge 1%, interest permonth, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminarycash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balanceof $80,000 at January 1Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) shouldbe indicated with minus sign.)

Lets understand the basics. Management prepare budget in order to estimate profit from the business…

Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts be indicated with minus sign.) Beginning cash balance Total cash available Total cash payments Preliminary cash balance Ioan activity KAYAK COMPANY Cash Budget $ January 40,000 February March

Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts be indicated with minus sign.) Beginning cash balance Total cash available Total cash payments Preliminary cash balance Ioan activity KAYAK COMPANY Cash Budget $ January 40,000 February March

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

sh On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following infor- mation has been provided by Spicer's management. Month January February March April May Credit Sales Collections in the month of the sale Collections one month after the sale Collections two months after the sale Uncollectible accounts ary. The company's collection activity on credit sales historically has been as follows. $300,000 (actual) 400,000 (actual) 600,000 (estimated) 700,000 (estimated) 800,000 (estimated) 50% 30 15 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March, April, and May.
Schedule of Cash Payments for a Service Company
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 $33,700. The budgeted expenses for the next three months are as follows: Salaries Utilities Other operating expenses Total January February March $77,500 $94,400 $104,500 6,400 7,100 8,400 59,700 $143,600 65,100 $166,600 71,600 $184,500 Other operating expenses include $4,200 of monthly depreciation expense and $1,000 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 65% 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. Enter all amounts as positive numbers. EastGate Physical Therapy…
Please do not give solution in image format thanku
Preparing the financial budget—cash budget Use the original schedule of cash receipts completed in Exercise E22—26, Requirement 1, and the schedule of cash payments completed in Exercise E22-27 to complete a cash budget for Marcel Company for January, February, and March. Additional information: Marcel’s beginning cash balance is $5,000, and Marcel desires to maintain a minimum ending cash balance of $5,000. Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rate on amounts borrowed is 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Note: Exercises E22-26 and E22-27 must be completed before attempting Exercise E22-28.
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,200. The budgeted expenses for the next three months are as follows: Salaries Utilities Other operating expenses Total January February March $58,000 $70,600 $78,100 4,800 5,300 6,300 44,700 48,700 53,600 $107,500 $124,600 $138,000 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. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
Jayden's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mrs. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: November December Actual $ 240,000 January 260,000 February March Forecast Additional Information $ 320,000 April forecast $360,000 360,000 370,000 Of the firm's sales, 60 percent are for cash and the remaining 40 percent are on credit. Of credit sales, 30 percent are paid in the month after sale and 70 percent are paid in the second month after the sale. Materials cost 30 percent of sales and are purchased and received each month in an amount sufficient to cover the following month's expected sales. Materials are paid for in the month after they are received. Labor expense is 40 percent of sales and is paid for in the month of sales. Selling and administrative expense…
H1.
Cash budgetThe following cash budget is for the third quarter of this year. Solve for the missing numbers on the cash budget, assuming that the accountant has requested a minimum cash balance of $7,000 at the start of each month. All borrowings, repayments, and investments are made in even $1,000 amounts. No borrowings or investments exist at the beginning of July. July August September Total Beginning cash balance $7,400 Cash receipts 16,400 20,200 Total cash available $41,000 $77,800 Cash disbursements Payments on account $7,800 $11,400 Wages expense 10,000 12,400 34,600 Overhead costs 8,000 9,200 26,000 Total disbursements $20,600 $32,600 Cash excess (deficiency) Minimum cash balance (7,000) (7,000) Cash available (needed) $(8,800) $(11,600) Financing Borrowings (repayments) $4,000 $(1,000) Acquire (sell) investments - - Receive…
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 $15,000. The budgeted expenses for the next three months are as follows: January February March Salaries $56,900 $ 68,100 $ 72,200 Utilities 2,400 2,600 2,500 Other operating expenses 32,300 41,500 44,700 Total $91,600 $112,200 $119,400 Other operating expenses include $3,000 of monthly depreciation expense and $500 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. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical…
QS 20-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $76,000. b. Cash receipts from sales, $308,000. c. Cash payments for direct materials, $140,000. d. Cash payments for direct labor, $79,000. e. Cash payments for overhead, $37,000. f. Cash payments for sales commissions, $7,000 g. Cash payments for interest, $170 (1% of beginning loan balance of $17,000) h. Cash repayment of loan, $17,000. Prepare a cash budget for March for Gado Company. Total cash available GADO COMPANY Cash Budget March
Please do not give solution in image format thanku