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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education