Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need assistance with completing the table. the answers already provided are correct Kayak Company budgeted the following cash receipts (excluding cash receipts from loans

I need assistance with completing the table. the answers already provided are correct

image text in transcribed
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loon principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 523, 030 February 408, 530 348, 760 March 535, 080 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 mouth-end. The interest is computed based on the beginning balance of the loan for the month. Ary 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 loen balance of $60,000 at January 1. Prepare monthly cash budgets forJanuary, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) KAYAK COMPANY Cash Budget January February March Beginning cash balance 30.000 -30 000 And: Cash receipts 578,000 108 500 480 040 Total cash available 563,ODU 438.500 Less: Caan payments fur Incetest on than Total cash payments 500 Preliminary cash palance 19 200 19 792 Loan activity Add tiona loan {loan repayment) (54 200) 19 784 Ending cash balance 80 0DO Loan balance Loan balance - Beginning of mouth S 60,000 6 Additional Joan (loan repayment) (60,250) Loan palance, end of month 800

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

Intermediate Accounting Volume 1

Authors: Thomas H. Beechy, Joan E. Conrod, Elizabeth Farrell, Ingrid McLeod Dick

7th Edition

1260306747, 978-1260306743

More Books

Students also viewed these Accounting questions

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago