Problem 4-24 (Algo) Cash budget [LO4-2] Graham Potato Company has projected sales of $13,800 in September,...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648e2628e3c1_5786648e262300c5.jpg)
Transcribed Image Text:
Problem 4-24 (Algo) Cash budget [LO4-2] 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 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. Graham Potato Company Total cash receipts Total cash payments Cash Budget November December Net cash flow $ 0 $ 0 Beginning cash balance Cumulative cash balance $ 0 $ 0 Monthly borrowing (repayment) Ending cash balance $ 0 $ 0 Cumulative loan balance Problem 4-24 (Algo) Cash budget [LO4-2] 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 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. Graham Potato Company Total cash receipts Total cash payments Cash Budget November December Net cash flow $ 0 $ 0 Beginning cash balance Cumulative cash balance $ 0 $ 0 Monthly borrowing (repayment) Ending cash balance $ 0 $ 0 Cumulative loan balance
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
A physical pendulum of mass m = 3 . 3 6 kg is comprised of an odd shape that has a centre - of - mass a distance of d = 0 . 5 5 5 m from the pivot point. The pendulum is displaced from equilibrium to...
-
Journalize the following transactions for Gillaspie Manufacturing. (a) Incurred direct labor costs of $24,000 for 3,000 hours. The standard labor cost was $25,200. (b) Assigned 3,000 direct labor...
-
The familiar phenomenon of a rainbow results from the diffraction of sunlight through raindrops. (a) Does the wavelength of light increase or decrease as we proceed outward from the innermost band of...
-
The equity method is often described as a one-line consolidation. Discuss the similarities of the equity method and consolidated reporting. Discuss how these methods differ in their financial...
-
Phan Mai is a single taxpayer with two dependent children under age 17. Phan estimates her wages for the year will be $36,000 and her itemized deductions will be $11,000. Assuming Phan files as head...
-
Identify the different elements and structure of language. Explain how language develops. Evaluate whether or not language influences how people think. Explain how mental images are involved in the...
-
The Concord Theater, owned by Meg Vargo, will begin operations in March. The Concord will be unique in that it will show only triple features of sequential theme movies. As of March 1, the ledger of...
-
The simplest form of mass matrix is known as a. lumped-mass matrix b. consistent-mass matrix c. global mass matrix
-
Fill in the Blank. When the speed of rotation of a shaft equals one of the natural frequencies of the shaft, it is called ____________ speed.
-
What is the role of transformation matrices in the finite element method?
-
True or False. The element mass matrices are always singular.
-
Fill in the Blank. The moving elements of a reciprocating engine are the crank, the connecting rod, and the ____________.
-
Earnings Per Share (EPS) Answer Key Year 1 EPS $2.00 per share Year 2 EPS $1.09 per share Year 1 reported in Year 2 $1.00 per share Company had 202,000 CS shares O/S at 1/1/Y1. Following is info for...
-
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
-
Many retailers have installed point-of-sale (POS) systems to better manage their inventory and to save time and cut costs associated with ringing up customer sales. How should employees be trained to...
-
Airlines have long used database technology to monitor capacity and maximize revenue by charging different prices to almost every passenger on a given flight. To what extent can other industries...
-
Why not use copies of the sales order as the picking ticket, packing list, and sales invoice?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App