Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Show Work: The Graham Potato Company has projected sales of $ 6 , 0 0 0 in September, $ 1 0 , 0 0 0
Show Work: The Graham Potato Company has projected sales of $ in September, $ in October, $ in November, and $ in December. Of the companys sales, percent are paid for by cash and percent are sold on credit. Experience shows that percent of accounts receivable are paid in the month after the sale, while the remaining percent are paid two months after. Determine collections for November and December. Also assume Grahams cash payments for November and December are $ and $ respectively. The beginning cash balance in November is $ which is the desired minimum balance. Prepare a Cash Budget with borrowing needed or repayments for November and December. You will need to prepare the Cash Receipts Schedule first. Graham Potato Company Cash Receipts Schedule September October November December Sales $ $ $ $ Credit sales Cash sales Collections in month after sales Collections two months after sales Total cash receipts Graham Potato Company Cash Budget November December Cash Receipts Cash Payment Net Cash Flow Beginning Cash Balance Cumulative Cash Balance Monthly Loan or Repayment Cumulative Loan Balance Ending Cash Balance
Show Work: The Graham Potato Company has projected sales of $ in September, $ in October,
$ in November, and $ in December. Of the companys sales, percent are paid for by cash and percent are sold on credit. Experience shows that percent of accounts
receivable are paid in the month after the sale, while the remaining percent are paid two
months after. Determine collections for November and December.
Also assume Grahams cash payments for November and December are $ and $
respectively. The beginning cash balance in November is $ which is the desired minimum
balance. Prepare a Cash Budget with borrowing needed or repayments for November and
December. You will need to prepare the Cash Receipts Schedule first.
Graham Potato Company
Cash Receipts Schedule
September
October
November
December
Sales
$
$
$
$
Credit sales
Cash sales
Collections
in month
after sales
Collections
two months
after sales
Total cash
receipts
Graham Potato Company
Cash Budget
November
December
Cash Receipts
Cash Payment
Net Cash Flow
Beginning Cash Balance
Cumulative Cash Balance
Monthly Loan or Repayment
Cumulative Loan Balance
Ending Cash Balance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started