Graham Potato Company has projected sales of $12,600 in September, $15,500 in October, $22,600 in November, and $18,600 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $19,000 and $11,500, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule September October November December
Graham Potato Company has projected sales of $12,600 in September, $15,500 in October, $22,600 in November, and $18,600 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $19,000 and $11,500, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule September October November December
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Problem 4-24 (Algo) Cash budget [LO4-2]
Graham Potato Company has projected sales of $12,600 in September, $15,500 in October, $22,600 in November, and
$18,600 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience
shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two
months after. Determine collections for November and December.
Also assume Graham's cash payments for November and December are $19,000 and $11,500, respectively. The beginning
cash balance in November is $5,000, which is the desired minimum balance.
a. Prepare a cash receipts schedule for November and December.
Sales
Credit sales
Cash sales
One month after sale
Two months after sale
Total cash receipts
Graham Potato Company
Cash Receipts Schedule
September October
November
$
December
0 $
0
b. Prepare a cash budget with borrowing needed or repayments for November and December.
Note: Negative amounts should be indicated by a minus sign. Assume the November beginning loan balance is $0.
Leave no cells blank be certain to enter O wherever required.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff9c505ad-1b4a-451b-8bf4-7461d56d6e35%2F7e133cf0-2351-4081-bd2f-2aaf655ccd1d%2Fu8ezr0k_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Problem 4-24 (Algo) Cash budget [LO4-2]
Graham Potato Company has projected sales of $12,600 in September, $15,500 in October, $22,600 in November, and
$18,600 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience
shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two
months after. Determine collections for November and December.
Also assume Graham's cash payments for November and December are $19,000 and $11,500, respectively. The beginning
cash balance in November is $5,000, which is the desired minimum balance.
a. Prepare a cash receipts schedule for November and December.
Sales
Credit sales
Cash sales
One month after sale
Two months after sale
Total cash receipts
Graham Potato Company
Cash Receipts Schedule
September October
November
$
December
0 $
0
b. Prepare a cash budget with borrowing needed or repayments for November and December.
Note: Negative amounts should be indicated by a minus sign. Assume the November beginning loan balance is $0.
Leave no cells blank be certain to enter O wherever required.
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 4 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


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