Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 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. KAYAK COMPANY Cash Budget Beginning cash balance Add: Cash receipts Total cash available Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month January $ 30,000 February March 0 0 0 Loan balance $ 60,000 $ 0 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 $ 521,000 410,500 480,000 Cash payments $ 467,800 357,300 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. KAYAK COMPANY Cash Budget Beginning cash balance Add: Cash receipts Total cash available Total cash payments Preliminary cash balance Loan activity Ending cash balance Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month January $ 30,000 February March 0 0 0 Loan balance $ 60,000 $ 0
Expert Answer:
Answer rating: 100% (QA)
To prepare the monthly cash budgets for January February and March for Kayak Company we will calculate the ending cash balance for each month based on ... View the full answer
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
3.6 COMPLETE the table below by LISTING two (2) of your company product's or service's features, advantages and benefits, and link these to typical client needs. Product or Service Student Joan...
-
A prospective renter Is NOT protected by fair housing legislation if he or she _ _ _ A . has a history of serious mental illness B . is unable to live alone without assistance C . has ever been...
-
(2) Should patients who later develop medical problems have to prove negligence by the pharmaceutical company or should it be a matter of strict liability?
-
What is the first question to ask when redefining quality goals? What is the purpose of what I am trying to accomplish? What is the right purpose for me to be working on? What quality goals should I...
-
U.S. consumers spent slightly more last month but earned less for the first time in nearly two years. The new data on spending and incomes suggest Americans tapped their savings to cope with steep...
-
A hospital emergency room is open 24 hours a day. Nurses report for duty at 1 A.M., 5 A.M., 9 A.M., 1 P.M., 5 P.M., or 9 P.M., and each works an 8-hour shift. Nurses are paid the same, regardless of...
-
Covered Interest Arbitrage. The South African rand has a 1-year forward premium of 2 percent. Oneyear interest rates in the United States are 3 percentage points higher than in South Africa. Based on...
-
Maria Bell and J. R. Green are forming a partnership to which Bell will devote one- third time and Green will devote full time. They have discussed the following alternative plans for sharing income...
-
Evaluate the following definite integral using a geometric formula. You must show all work including the geometry area formula. 1 1-x2 dx A. T B. /2 C. /3 D. /4
-
Question 3 [15] In 16 test runs, the fuel consumption of an experimental engine had a sample mean of 20 litres and a sample standard deviation of 2.2 litres. Required: a) Construct and interpret a...
-
It is impossible to motivate, only to demotivate. Discuss.
-
Which of the following is likely to be the most effective audit procedure for verifying dividends earned on investments in publicly traded equity securities? a. Trace deposits of dividend checks to...
-
Indicate whether each account listed below is a(n) asset (A), liability (L), owner's equity (OE), revenue ( \(R\) ), or expense ( \(\mathbf{\text { e }}\) ) account. Salaries Payable Land L. Graham,...
-
List five ways you can customize a QuickBooks Accountant report.
-
The audit firm's valuation specialist would likely be brought in to assist in the audit of fair value measurements at an entity when the following is present: a. The entity is a new audit client. b....
-
8) Shiffon Electronics manufactures music player. Its costing system uses two cost categories, direct materials and conversion costs. Each product must pass through the Assembly Department, the...
-
Define cultural intelligence. Cite the books or journal articles you found in Capella's library. Explain why cultural intelligence is important for HR practitioners and other organizational managers.
-
Alpha AG is wholly owned by Mr Alpha and Beta AG is wholly owned by Mr Beta. The key figures for the two companies are as follows: Alpha acquires Beta. Calculate the shareholdings (as a percentage)...
-
Can the success of a merger be judged by looking at the change in share price of the companies when the merger is announced?
-
What is the difference between the relative value ratio and the exchange ratio?
Study smarter with the SolutionInn App