from management team, she has the following information. October November December Cash receipts $54,000 $ 56,500 $56,000 54,000 Cash Disbursements 52,000 62,000 Addition Information: 1. Line of credit draw: must be taken out on the first of the month in $1,000 increments 2. Line of credit payment: must be repaid on the last day of the month, in $1,000 increments 3. Credit line balance, eptember 30, $2.000
from management team, she has the following information. October November December Cash receipts $54,000 $ 56,500 $56,000 54,000 Cash Disbursements 52,000 62,000 Addition Information: 1. Line of credit draw: must be taken out on the first of the month in $1,000 increments 2. Line of credit payment: must be repaid on the last day of the month, in $1,000 increments 3. Credit line balance, eptember 30, $2.000
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:Scout is a true accountant: she not only likes knowing where every dollar is going, she
is obsessed about it. So, she is happy to take on the cash for this small company. She
wants to go back through the fourth-quarter plan with a fine-toothed comb before
working on the following calendar year's cash budget. After reviewing many notes
from management team, she has the following information.
October November December
Cash receipts
$54,000 $ 56,500 $56,000
Cash Disbursements
52,000
62,000
54,000
Addition Information:
|1. Line of credit draw: must be taken out on the first of the month in $1,000 increments
2. Line of credit payment: must be repaid on the last day of the month, in $1,000 increments
3. Credit line balance, September 30, $2,000
4. Annual loan interest rate, 5% with monthly interest payments required
5. Minimum monthly cash account balance, $10,000
6. Cash balance, September 30, $10,500
Required
A. Complete the fourth-quarter cash budget for Scout, reporting amounts for each month and
for the quarter overall.
B. Assume company executive prefer not to borrow more than $5,000 from the company's line
of credit at any given time (because debt in any amount makes them nervous). In this fourth
quarter , is this an issue? If so, Identify for which month(s) this is an issue.
C. Assume all of the company's sales are made on account, and 95% of the customers pay their
bill in full (albeit sometimes t3 months later). What tactics could the accounting and finance
department use to improve the company's cash flow?ldentify as many feasible as you can.
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 4 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