14. Construct the cash budget for December- March. Anticipated sales in Column 1 and variable cash disbursements in Column 2. Sales December: $5,000 January: 15,000 February: 25,000 March: 40,000 Cash Disbursements 12,000 14,000 31,000 29,000 Thirty percent of the sales are for cash and 70 percent are on credit. Of the credit sales, 90 percent are collected one month after sale and 10 percent as collected two months after the original sale. Cash at the beginning of December $60,100, Other anticipated receipts include a $1,000 tax refund in December. Fixed cash disbursements is $3,000. The firm must retire a $25,000 loan in January. Since the $25,000 loan is retired in January, the desired level of cash will be reduced from $10,000 to $6,000 starting in February. After completing the cash budget, answer the following questions: 1. What are the firm's accounts receivable at the end of March? 2. What is the amount borrowed during February?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

Finance

14. Construct the cash budget for December- March. Anticipated sales in
Column 1 and variable cash disbursements in Column 2.
Sales
December: $5,000
January: 15,000
February: 25,000
March: 40,000
Cash Disbursements
12,000
14,000
31,000
29,000
Thirty percent of the sales are for cash and 70 percent are on credit. Of
the credit sales, 90 percent are collected one month after sale and 10
percent as collected two months after the original sale. Cash at the
beginning of December $60,100, Other anticipated receipts include a
$1,000 tax refund in December. Fixed cash disbursements is $3,000.
The firm must retire a $25,000 loan in January. Since the $25,000 loan is
retired in January, the desired level of cash will be reduced from $10,000 to
$6,000 starting in February.
After completing the cash budget, answer the following questions:
1. What are the firm's accounts receivable at the end of March?
2. What is the amount borrowed during February?
Transcribed Image Text:14. Construct the cash budget for December- March. Anticipated sales in Column 1 and variable cash disbursements in Column 2. Sales December: $5,000 January: 15,000 February: 25,000 March: 40,000 Cash Disbursements 12,000 14,000 31,000 29,000 Thirty percent of the sales are for cash and 70 percent are on credit. Of the credit sales, 90 percent are collected one month after sale and 10 percent as collected two months after the original sale. Cash at the beginning of December $60,100, Other anticipated receipts include a $1,000 tax refund in December. Fixed cash disbursements is $3,000. The firm must retire a $25,000 loan in January. Since the $25,000 loan is retired in January, the desired level of cash will be reduced from $10,000 to $6,000 starting in February. After completing the cash budget, answer the following questions: 1. What are the firm's accounts receivable at the end of March? 2. What is the amount borrowed during February?
Expert Solution
steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
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