Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Kayak requires a minimum cash balance of $ 4 0 , 0 0 0 at each month - end. Loans taken to meet this requirement

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.)
\table[[KAYAK COMPANY],[Cash Budget],[,January,February,March],[Beginning cash balance,$,40,000,$,40,000,$,74,168],[Add: Cash receipts,,522,000,,400,500,,467,000],[Total cash available,,562,000,,440,500,,541,168],[Less: Cash payments for],[Interest on loan,,(800),,(232),,0],[All items excluding interest,,464,400,,342,900,,526,000],[Total cash payments,,463,600,,342,668,,526,000],[Preliminary cash balance,,96,800,,97,368,,],[Loan activity],[Additional loan (loan repayment),,(56,800),,(23,200),,],[Ending cash balance,$,40,000,$,74,168,$,40,000],[Loan balance],[Loan balance - Beginning of month,$,80,000,$,23,200,$,0],[Additional loan (loan repayment),,(56,800),,(23,200),,],[Loan balance, end of month,$,23200,$,0,,]] ALL INFO INSERTED IS CORRECT; JUST NEED THE MARCH PRELIMINARY CASH BALANCE, ADDITIONAL LOAN (LOAN REPAYMENT), AND LOAN BALANCE END OF MONTH FOR MARCH
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen Braun, Wendy Tietz, Louis Beaubien

4th Canadian Edition

013544344X, 9780135443446

More Books

Students also viewed these Accounting questions

Question

6 How can an organisation increase its flexibility?

Answered: 1 week ago

Question

1.6 Identify ways that country culture influences global business.

Answered: 1 week ago