3 Required: Prepare monthly cash budgets for January, February, and March. 4 KAYAK COMPANY 5 6 7 Beginning cash balance 8 9 Total cash available 10 Less: Cash payments for 11 All items excluding interest Interest on loan 12 13 Total cash payments 14 Preliminary cash balance 15 16 Ending cash balance 17 18 Loan balance - Beginning of month Cash Budget January Loan balance February March
3 Required: Prepare monthly cash budgets for January, February, and March. 4 KAYAK COMPANY 5 6 7 Beginning cash balance 8 9 Total cash available 10 Less: Cash payments for 11 All items excluding interest Interest on loan 12 13 Total cash payments 14 Preliminary cash balance 15 16 Ending cash balance 17 18 Loan balance - Beginning of month Cash Budget January Loan balance February March
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:A1
4567
7 Beginning cash balance
3 Required: Prepare monthly cash budgets for January, February, and March.
KAYAK COMPANY
8
00
Jx Accessibility
9 Total cash available
10 Less: Cash payments for
11 All items excluding interest
12
Interest on loan
13 Total cash payments
14 Preliminary cash balance
15
16 Ending cash balance
17
B
18 Loan balance - Beginning of month
19 Additional loan (loan repayment)
20 Loan balance, end of month
21
22
Cash Budget
January
Loan balance
0
C
$0
February
0
$0
D
March
$0
E

Transcribed Image Text:H13
A
5
6 January
7 February
8
March
a
A
33
13
fx
Kayak Company budgeted the following cash receipts (excluding cash receipts from
loans received) and cash payments (excluding cash payments for loan principal and
3 interest payments) for the first three months of next year. (Click on the Graded
Worksheet Tab below.)
В
Minimum cash balance
14 Monthly interest rate
15 January 1 cash balance
C
Cash Receipts Cash payments
$525,000
$475,000
400,000
350,000
450,000
525,000
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 month-end. The
10 interest is computed based on the beginning balance of the loan for the month. Any
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 loan balance of $60,000 at January 1.
$30,000
1%
$30,000
$60,000
D
16 January 1 loan balance.
17
18 Required: Prepare monthly cash budgets for January, February, and March.
19
E
F
G
H
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Recommended textbooks for you


Accounting
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,


Accounting
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