Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash paymentsexcluding cash payments for loan principal and interest payments) for the first three months of next year.JanuaryFebruaryMarchCashReceipts$ 521,000410,500480,000Cashpayments$ 467,800357,300528,000Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loanfor the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has acash 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 balanceAdd: Cash receiptsTotal cash availableKAYAK COMPANYCash BudgetJanuary$ 30,000FebruaryMarchTotal cash paymentsPreliminary cash balanceLoan activityEnding cash balanceLoan balance - Beginning ofmonthAdditional loan (loan repayment)Loan balance, end of month000Loan balance$ 60,000$0

Key points to note:The company is able to repay its entire loan balance of $60,000 by the end of…

Answered: Kayak Company budgeted the following…

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

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…
Miller Corporation has the following sales budget for the third quarter of 2021: Month Sales July $400,000 August $320,000 September $500,000 Historically, the following trend has been established regarding cash collection of sales: 60 percent of sales are paid in month of sale 35 percent of sales are paid in month following the sale 5 percent of sales are uncollectible and are written off in the month following the sale The expected total cash receipts for the month of September is: A. $300,000. B. $25,000. C. $112,000. D. $412,000.
The Lowville Company has budgeted the following data for November: • Sales of $1,728,300, all in cash. • A cash balance on November 1 of $72,000. • Cash disbursements (other than interest) during November of $1,740,000. • A minimum cash balance of $90,000 at the end of each month. The company has 2% open line of credit for $100,000. All borrowing will take place at the beginning of the month. The November interest will be paid in cash when repayment is made. The excess (deficiency) of cash available over disbursements for November will be: A. $(11,700) B. $ (29,700) C. $60,300 D. $72,000 1. 2. The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is: A. $11,700 B. $18,000 C. $29,700 D. $30,000 The minimum cash balance the Lowville Company should have in order to make both repayment and interest payment in December should be closest to: A. $18,060 B. $29,800 C. $90,600 D. $119,800
Company L charges all operating expenses to credit. They pay 70% of their accounts payable in the month following the expense, and 30% two months following the expense. Expenses (all paid for on credit) for the last three months have been provided below: August: $80,000 September: $120,000 October: $94,000 What is the budgeted cash outflow for October?
Karim Corporation requires a minimum $8,100 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 $8,100 is used to repay loans at month-end. The cash balance on July 1 is $8,500, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. Cash receipts Cash payments Beginning cash balance 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 July August $ 24,100 $ 32,100 28,150 30,100 Total cash payments Preliminary cash balance Loan activity Ending cash balance September $ 40,100 32,100 KARIM CORPORATION Cash Budget $ July Loan balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance…
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?
Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.
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 Cash receipts. $260,000 $280,000 $250,000 Cash disbursements 240,000 320,000 260,000 The expected cash balance at January 1 is $42,000. Brewster wants to maintain a cash balance at the end of each month of at least $40,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 February Beginning cash balance Cash receipts $ Short-term borrowings Cash available Cash disbursements Interest…
Getty Company expects sales for the first three months of next year to be $185,000, $235,000 and $310,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. February March Budgeted cash receipts $ 250,000
None
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…
Markham Company has completed its sales budget for the first quarter of Year 2. Projected credit sales for the first four months of the year are shown below: January February March April $ 20,000 $ 26,000 $ 35,000 $ 38,000 The company's past records show collection of credit sales as follows: 40% in the month of sale and the balance in the following month. The total cash collection from receivables in March is expected to be: Multiple Choice $29,600. $22,100. $31,850. $35,000.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS