Graham Potato Company has projected sales of $13,800 in September, $16,500 In October, $23,800 In November,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Graham Potato Company has projected sales of $13,800 in September, $16,500 In October, $23,800 In November, and $19,800 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 $20,000 and $12,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 Answer is complete and correct. Graham Potato Company Cash Receipts Schedule September October November December $ 13,800 $ 16,500 $ 23,800 $ 19,800 10,350 12,375 17,850 14,850 $ 5,950 $ 4,950 4,950 7,140 6,210 7,425 $ 17,110 19,515 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. Answer is complete but not entirely correct. Graham Potato Company Cash Budget November December Total cash receipts Total cash payments $ 17,110 $ 20,000 19,515 12,500 Net cash flow $ 37,110 $ 32,015 Beginning cash balance 5,000 5,000 Cumulative cash balance $ 42,110 $ 37,015 Monthly borrowing (repayment) 2,890 2,890 Ending cash balance $ 45,000 $ 39,905 Cumulative loan balance $ 2,890 $ 0 Graham Potato Company has projected sales of $13,800 in September, $16,500 In October, $23,800 In November, and $19,800 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 $20,000 and $12,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 Answer is complete and correct. Graham Potato Company Cash Receipts Schedule September October November December $ 13,800 $ 16,500 $ 23,800 $ 19,800 10,350 12,375 17,850 14,850 $ 5,950 $ 4,950 4,950 7,140 6,210 7,425 $ 17,110 19,515 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. Answer is complete but not entirely correct. Graham Potato Company Cash Budget November December Total cash receipts Total cash payments $ 17,110 $ 20,000 19,515 12,500 Net cash flow $ 37,110 $ 32,015 Beginning cash balance 5,000 5,000 Cumulative cash balance $ 42,110 $ 37,015 Monthly borrowing (repayment) 2,890 2,890 Ending cash balance $ 45,000 $ 39,905 Cumulative loan balance $ 2,890 $ 0
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Please solve all the letters, and please show all work indetail. If you use excel please show other excel box showing whatyou inputted in the excel boxes.. Thanks!!! 5. Growth opportunities. The firm...
-
Sales budget data for Palermo Company are given in BE20-2. Management desires to have an ending finished goods inventory equal to 20% of the next quarters expected unit sales. Prepare a production...
-
While simple alcohols yield alkenes on reaction with dehydrating acids, diols form carbonyl compounds. Rationalize mechanistically the outcome of the following reaction: HO OH HA
-
Indicate whether each of the following descriptions is more characteristic of a centralized (C) or decentralized (D) company. Description 1. Hires highly motivated employees 2. Prioritizes training...
-
In our example of research on lipstick, where E = $2 and S = $29, what sample size would we require if we desired a 99 percent confidence level? What about if we keep the 95% confidence level, but...
-
Roadrunner Transport (Pty) Ltd has been a medium-sized company in the road transport and freight industry since 2010. Its business premises are in the Alrode industrial area, south of Johannesburg....
-
Write a paper to analysis McDonald?s income statement and balance sheet. In the vertical analysis, you will measure performance against one variable: revenue in the income statement and assets in the...
-
Queueing: Car Wash - utilization We've had a lot of snow in Bloomington and my car got very dirty. I went to the local car wash and discovered a long queue. An analysis of the operation showed that...
-
If a normal population has a mean of ???? and a standard deviation of , then the area to the right of + is less than 0.5. In Exercises 1116, determine whether the statement is true or false. If the...
-
If a normal population has a mean of and a standard deviation of , then the area to the left of is less than 0.5. In Exercises 1116, determine whether the statement is true or false. If the...
-
Related parties are generally cited as indicators of a higher risk of fraud existing for an auditee. The idea is that arms-length transactions in and of themselves exercise control over the propriety...
-
How do exponential smoothing techniques differ from unweighted moving-average techniques?
-
A z-score indicates how many standard deviations a value is above or below the mean. In Exercises 1116, determine whether the statement is true or false. If the statement is false, rewrite it as a...
-
Determine thickness of a flywheel that has diameter of XXcm needed to be added to a machine to reduce it coefficient of fluctuation from 0.22 to 0.20. Average speed of the system is maintained at...
-
Sportique Boutique reported the following financial data for 2012 and 2011. Instructions(a) Calculate the current ratio for Sportique Boutique for 2012 and 2011.(b) Suppose that at the end of 2012,...
-
In Example 7.6 we used the feature map \(\boldsymbol{\phi}(\boldsymbol{x})=\left[x_{1}, x_{2}, x_{1}^{2}+x_{2}^{2} ight]^{\top}\) to classify the points. An easier way is to map the points into...
-
Consider SVM classification as illustrated in Figure 7.7. The goal of this exercise is to classify the training points \(\left\{\left(\boldsymbol{x}_{i}, y_{i} ight) ight\}\) based on the value of...
-
A well-known data set is the MNIST handwritten digit database, containing many thousands of digitalized numbers (from 0 to 9 ), each described by a \(28 \times 28\) matrix of gray scales. A similar...
Study smarter with the SolutionInn App