XYZ has forecast its sales revenues and purchases for the last 5 months of 2015 to be as follows: Sales Purchase August 22,000 and 17,000 September 15,000 and 19,500 October 25,000 and 29,000 November 30,000 and 20,000 December 26,000 and 24,000 60% of sales are on credit. On the basis of past experience, 50% of the accounts receivable is collected the month after the sale and the remainder are collected 2 months after the sale. Purchases are paid 30 days after they are incurred. The firm has a cash balance of $5,000 on hand as of October 31, but its minimum required cash balance is $4,000 A. Prepare a schedule of cash receipts for October, November, and December. B. Prepare a cash budget for the same period.
XYZ has forecast its sales revenues and purchases for the last 5 months of 2015 to be as follows: Sales Purchase August 22,000 and 17,000 September 15,000 and 19,500 October 25,000 and 29,000 November 30,000 and 20,000 December 26,000 and 24,000 60% of sales are on credit. On the basis of past experience, 50% of the accounts receivable is collected the month after the sale and the remainder are collected 2 months after the sale. Purchases are paid 30 days after they are incurred. The firm has a cash balance of $5,000 on hand as of October 31, but its minimum required cash balance is $4,000 A. Prepare a schedule of cash receipts for October, November, and December. B. Prepare a cash budget for the same period.
Chapter3: Evaluation Of Financial Performance
Section: Chapter Questions
Problem 3P
Related questions
Question
XYZ has
Sales Purchase
August 22,000 and 17,000
September 15,000 and 19,500
October 25,000 and 29,000
November 30,000 and 20,000
December 26,000 and 24,000
60% of sales are on credit. On the basis of past experience, 50% of the
A. Prepare a schedule of cash receipts for October, November, and December.
B. Prepare a
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College