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 ALREADY IN THE CHART 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_2

Step: 3

blur-text-image_3

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

Workbook/Study Guide To Accompany Managerial Accounting

Authors: Ray H Garrison, Eric Noreen, Peter C. Brewer

11th Edition

0072986131, 978-0072986136

More Books

Students also viewed these Accounting questions

Question

2. What are the different types of networks?

Answered: 1 week ago