Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Caught warning in the question code: number_format() expects parameter 1 to be float, string given on line 1945 in file /var/app/current/assessment/macros.php Caught warning in the

image text in transcribed

Caught warning in the question code: number_format() expects parameter 1 to be float, string given on line 1945 in file /var/app/current/assessment/macros.php Caught warning in the question code: number_format() expects parameter 1 to be float, string given on line 1945 in file /var/app/current/assessment/macros.php Kaiser, Inc. has the following budgeted cash collections from the cash receipts budget and cash payments (excluding loan principal repayments and interest payments) from the cash disbursements budget for the next quarter (April, May, & June). Cash Cash Receipts Payments April $33,841 $30,884 May $31,165 $38,225 June $30,279 $26,962 In addition, Kaiser's beginning cash balance as of April 1 is $15,260. Kaiser, Inc. would like to maintain a minimum $15,000 cash balance at all times. In order to achieve this goal Kaiser has negotiated a line of credit with the bank. If the preliminary cash balance falls below $15,000 Kaiser will borrow the necessary funds to keep their balance above the desired amount. If the preliminary cash balance is above the $15,000 minimum balance they will use any excess to pay down any outstanding loan balance at the time. The interest rate on any outstanding line of credit balance is 6% per year. The interest is paid at the end of each month and is computed on the beginning loan balance for the month. They have a zero balance on their line of credit on April 1st. Prepare the cash budget for the quarter. Enter cash disbursements and loan repayments as a negative number. Round all calcul whole dollar. to nearest Kaiser, Inc. Cash Budget For April, May, June April May June Beginning Cash Balance $ $ $ $ Cash collected Cash Disbursements Cash payments (given) Interest on bank loan (6%) $ $ $ Preliminary cash balance $ $ $ Additional loan/ or (repayment) $ $ Ending cash balance $ Line of Credit balance April May June Loan balance at beg. of month $ Additional money borrowed $ principal amount repaid $ Loan balance at end of month $

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

Agile Auditing Fundamentals And Applications

Authors: Raven Catlin, Danny M Goldberg, Ceciliana Watkins

1st Edition

1119693462, 9781119693468

More Books

Students also viewed these Accounting questions