January February March Cash Receipts $ 524,000 401,000 466,000 Cash payments $ 470,800 347,800 523,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.)

January February March Cash Receipts $ 524,000 401,000 466,000 Cash payments $ 470,800 347,800 523,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.)

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Accounts Receivable Balance XYZ Corp sells widgets to consumers for $20 each. Its beginning accounts receivable balance was $24,975, and it sold 12,376 widgets throughout the year. The total cash collections for the year amounted to $217,750. Required: Calculate the ending accounts receivable balance.
Campus Flights takes out a bank loan in the amount of $200,500 on March 1. The terms of the loan include a repayment of principal in ten equal installments, paid annually from March 1. The annual interest rate on the loan is 8%, recognized on December 31. (Round answers to the nearest whole dollar if needed.) A. Compute the interest recognized as of December 31 in year 1 rounded to the whole dollar. B. Compute the principal due in year 1.
Calculating the net costs of checking accounts. Determine the annual net cost of these checking accounts: a. Monthly fee 4, check-processing fee of 20 cents, average of 23 checks written per month b. Annual interest of 1.5 percent paid if balance exceeds 750, 8 monthly fee if account falls below minimum balance, average monthly balance 815, account falls below 750 during four months
Cash Flow Amounts R. Lee Rouse borrows 10,000 that is to be repaid in 24 equal monthly installments payable at the end of each subsequent month with interest at the rate of 1% per month. Required: Using the appropriate table, calculate the equal installments.
Ancient Grains Unlimited has an accounts receivable turnover ratio of 3.34 times. The net credit sales for the year are $567,920. What is the days sales in receivables ratio for 2018 (rounded to the nearest whole number)? A. 190 days B. 109 days C. 110 days D. 101 days
JOURNAL ENTRIES (NOTE ISSUED FOR BANK LOAN) Prepare general journal entries for the following transactions: Sept. 15 Borrowed 7,000 cash from the bank, giving a 60-day non- interest- bearing note. The note is discounted 8 % by the bank. Nov. 14 Paid the 7,000 note, recognizing the discount as interest expense.
JOURNAL ENTRIES (NOTE ISSUED FOR BANK LOAN) Prepare general journal entries for the following transactions: July15 Borrowed 5,000 cash from the bank, giving a 60-day non- interest-bearing note. The note is discounted 8% by the bank. Sept.13 Paid the 5,000 note, recognizing the discount as interest expense.
Sub-Cinema Inc. borrowed $10,000 on Jan. 1 and will repay the loan with 12 equal payments made at the end of the month for 12 months. The interest rate is 12% annually. If the monthly payments are $888.49, what is the journal entry to record the cash received on Jan. 1 and the first payment made on Jan. 31?
LO3 In the cash receipts journal, each amount in the General Credit column is posted (a) daily. (b) weekly. (c) at the end of the month. (d) at the end of the year.
A customer takes out a loan of $130,000 on January 1, with a maturity date of 36 months, and an annual interest rate of 11%. If 6 months have passed since note establishment, what would be the recorded interest figure at that time? A. $7,150 B. $65,000 C. $14,300 D. $2,383