JanuaryFebruaryMarchCashReceipts$525,000400,000450,000CashPayments$475,000350,000525,000Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet thisrequirement charge 1% interest per month, paid at each month-end. The interest is computed basedon the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 isused to repay loans at month-end. The company has a cash balance of $30,000 and a loan balanceof $60,000 at January 1.Kayak CompanyCash BudgetFor January, February, and MarchJanuary FebruaryMarchBeginning cash balance$30,000$30,000$69,294Cash receipts525,000400,000450,000Total cash available555,000430,000519,294Cash payments(475,000)(350,000)(525,000)Interest expense (1% per month)(600)(106)0Preliminary cash balance79,40079,894(5,706)Additional loan (loan repayment)(49.400)(10,600)35,706Ending cash balance$30,000$69,294$30,000Loan balanceLoan balance beginning of month$60,000$10,600$0Additional loan (loan repayment)Loan balance - End of month(49,400)(10,600)35,706$10,600$0$35,706

Kayak Company's cashbudget for January to March ensures a minimum cash balance of $30,000monthly by…

Answered: January February March Cash Receipts…

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

The finance department of your company needs to separate the interest and principal of the final payment of a loan. The company borrowed 20,000 at 8% compounded quarterly with month end payments for two years. 1. What are the correct portions assigned to principal interest of the final payment?
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $800,000 at any time over the course of the calendar year. The Unit 10 Template shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the year. Colson agreed to pay interest at an annual rate equal to 2 percent above the bank's prime rate. Please note that the interest rate for each month must be converted into a monthly rate by dividing by 12. Funds are borrowed or repaid on the first day of the month. Interest is payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. For example, Colson pays ((4 percent + 2 percent)/12) monthly interest on $80,000 for the month of January
Prime Products hopes to borrow $73,000 on April 1 and repay it plus interest of $1,080 on June 30. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $41,800. Accounts receivable on April 1 will total $182,000, of which $156,000 will be collected during April and $20,800 will be collected during May. The remainder will be uncollectible. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three-month period follow: April May June Sales (all on account) $316,000 $575,000 $264,000 Merchandise purchases $214,000 $193,000 $ 151,500 Payroll $ 34,200 $ 34,200 $27,300 Lease payments $31,600 $31,600 $ 31,600 Advertising $ 74,000 $ 74,000 $ 43,000 Equipment purchases $70,500 Depreciation…
Help me please
If Dominion Bank also pays 3.25% annual interest, compounded daily. If you had the following deposits and withdrawals, calculate the amount of interest you would have earned at Dominion bank during the month of March. (March has 31 days) DATE ACTIVITY BALANCE March 1 beginning balance $5,500 March 10 $500 March 28 deposit $700 O $14.47 O $14.07 O $16.08 O $17.69 ???? ACCOUNT withdraw ????
A total of $66,000 is borrowed and repaid with 48 monthly payments, with the first payment occurring one month after receipt of the $66.000. The stated interest rate is 5.00% compounded quarterly. Part a What is the intereste rate per cash flow period (month)? Round entry to six decimal places. Tolerance is +0.0005. B.) What monthly payment is required?
Mel's Photography borrowed $15 OOO on March 10 on a demand note. The loan was repaid by payments of $4000 on June 20, $3000 on September 1, and the balance on November 15. Interest, calculated on the daily balance and charged to Mel's Photography current account on the last day of each month, was at 5.5% on March 10 but was changed to 6.25% effective June 1 and to 6% effective October 1. How much did the loan cost?
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
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 Cash payments $ 517,000 409,500 480,000 $ 459,400 351,900 524,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.) Answer is complete but not entirely correct. KAYAK COMPANY Beginning cash balance Add: Cash receipts Cash Budget January February March SA 40,000 $ 40,000 $ 74,168 517,000 409,500 480,000 557,000 449,500…
Given below is the principal owed on a student loan last month, the annual interest rate, and the way the minimum monthly payment is computed. Find this month's minimum payment due. Principal Annual Rate Method for Calculating Minimum Monthly Payment $23,800 3% finance charge+$20+1.5% of principal
Karim Corp. requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 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.) KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $9,400 Total cash available Preliminary cash balance Ending cash…
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…

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