Cash Receipts Cash payments January February March $520,000 408,000 459,000 $ 469,000 357,000 532,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. Beginning cash balance Add: Cash receipts KAYAK COMPANY Cash Budget January February March $ 30,000 $ 30,000 520,000 408,000 459,000 550,000 438,000 Total cash available Less: Cash payments for Interest on loan 600 All items excluding interest 469,000 357,000 532,000 Total cash payments 469,600 357,000 532,000 Preliminary cash balance 80,400 Loan activity Additional loan (loan repayment) Ending cash balance 30,000 Loan balance $ 60,000 0 Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month

Cash Receipts Cash payments January February March $520,000 408,000 459,000 $ 469,000 357,000 532,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. Beginning cash balance Add: Cash receipts KAYAK COMPANY Cash Budget January February March $ 30,000 $ 30,000 520,000 408,000 459,000 550,000 438,000 Total cash available Less: Cash payments for Interest on loan 600 All items excluding interest 469,000 357,000 532,000 Total cash payments 469,600 357,000 532,000 Preliminary cash balance 80,400 Loan activity Additional loan (loan repayment) Ending cash balance 30,000 Loan balance $ 60,000 0 Loan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter9: Accounting For Receivables

Section: Chapter Questions

Problem 21MC: A customer takes out a loan of $130,000 on January 1, with a maturity date of 36 months, and an...

See similar textbooks

Similar questions

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
Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days for a payment to be received and recorded, and that the month is 30 days long. $400 balance, 14%, $100 payment, previous balance method
A $5000 short-term loan was received on December 3 rd 2018. This loan is scheduled to be repaid as nine uniform weekly payments. A grace period is granted for 5 weeks during which no repayments are required. The first repayment took place on January 7th and should go on for 8 more weekly payments. a] Create a cash flow diagram of the loan showing both the money received as loan and, in symbols, money paid back to the lender (R/week). b] What is the weekly payment if the contract says that the nominal interest rate on this loan is 30% compounded daily? In this part, please make the assumption that the 5 week grace period is interest-free. That is, the value of time during the grace period is zero. Starting from January 7th time value of money follows the contract. c] How much would the weekly payment be had the grace period not been interest free? That is, imagine now that time value of money follows the contract from December 3
Compute the size of the final payment for the following loan. Principal $ Periodic Payment $ Payment Period Payment Made at: Interest Rate % Compounding Period 8100 520 3 months beginning 8 quarterly The size of the final payment is $_ .?
An automobile loan of $15,000 at 12% APR compounded monthly for 36 months requires equal monthly payments of $498.21. (a) Complete the following table for the first two payment periods as you would expect the bank to calculate the values (show all calculations made below the table): End of Month(n) Interest Payment Repayment of Principal Remaining Loan Balance 0 N/A N/A $15,000 1 $348.21 2 $146.52 b) What is the portion of the prinicple payment to be made in the 23rd month?
Compute the size of the final payment for the following loan. Periodic Payment Interval Payment Made At: end Conversion Principal $18,000 Payment $1,816 Interest Rate Period 3 months 5% quarterly
Given the annual interest rate and a line of an amortization schedule for that loan, complete the next line of the schedule. Assume that payments are made monthly. Annual Interest Paid on Interest Rate Payment Paid Principal Balance 11.6% $425.57 $64.23 $361.34 $6,280.78 Fill out the amortization schedule below. Annual Interest Paid on Payment Balance Interest Rate Paid Principal 11.6% $425.57 $64.23 $361.34 $6,280.78 (Round to the nearest cent as needed.)
An automobile loan of S26,000 at a nominal rate of 12% compounded monthly for 48 months requires equal end-of-month payments of $684.68. Complete the table below, as you would expect a bank to calculate the values. (Round to the nearest cent.) Repayment of Remaining Loan Principal $ 424.68 End of Month Interest Payment (n) Balance 1. $ 260 $25,575.32 2 S 255.75 $428.93 $25,146 39 13 $206.14
Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days for a payment to be received and recorded, and that the month is 30 days long. (Round your answer to the nearest cent.) $475 balance, 16%, $425 payment; average daily balance method
Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days for a payment to be received and recorded, and that the month is 30 days long. (Round your answers to the nearest cent.) $400 balance, 15%, $50 payment (a) previous balance method $ 5 (b) adjusted balance method $ 4.5623 (c) average daily balance method $ 52.19173973X
For a three-month loan of $5,000 with an interest rate of 10 percent, determine usable funds, the AFC and APY for each of the following four loans (assume a normal deposit balance of $0): a. Regular interest loan (interest paid at maturity) b. Discounted interest loan c. Regular interest loan with a 10% compensating balance requirement d. Discounted interest with a 10% compensating balance requirement
Calculate the monthly finance charge for the credit card transaction. Assume that it takes 10 days for a payment to be received and recorded, and that the month is 30 days long. (Round your answers to the nearest cent.) $200 balance, 15%, $50 payment () previous balance method $2.77 x (b) adjusted balance method $2.09 x Þ (c) average daily balance method $233 x