Fundamentals of Corporate Finance with Connect Access Card
11th Edition
ISBN: 9781259418952
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 18, Problem 10QP
Calculating Cash Collections [LO3] The following is the sales budget for Harp, Inc., for the first quarter of 2015:
![Chapter 18, Problem 10QP, Calculating Cash Collections [LO3] The following is the sales budget for Harp, Inc., for the first](http://dev-ingestion-image-output.s3-website-us-east-1.amazonaws.com/9780077861704/Chapter-18/images/61704-18-10qp-question-digital_image_001.png)
Credit sales are collected as follows:
65 percent in the month of the sale
20 percent in the month after the sale
15 percent in the second month after the sale
The accounts receivable balance at the end of the previous quarter was $93,000 ($62,000 of which was uncollected December sales).
a. Compute the sales for November.
b. Compute the sales for December.
c. Compute the cash collections from sales for each month from January through March.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Schedule of Cash Collections on Accounts Receivable and Cash BudgetBennett Inc. found that about 15% of its sales during the month were forcash. Bennett has the following accounts receivable collectionexperience:
Percent collected in the month of sale
Percent collected in the month after the sale
Percent collected in the second month after the sale
25
68
5
Bennett's anticipated sales for the next few months are as follows:
AprilMayJuneJulyAugust
$250,000290,000280,000295,000300,000
(Note: Round all amounts to the nearest dollar.)
Required:1. Calculate credit sales for May, June, July, and August.2. Prepare a schedule of cash receipts for July and August.
1
Schedule of Cash Collections on Accounts Receivable and Cash Budget
Bennett Inc. found that about 30% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience:
Percent paid in the month of sale
25
Percent paid in the month after the sale
68
Percent paid in the second month after the sale
5
Bennett's anticipated sales for the next few months are as follows:
April
$250,000
May
290,000
June
280,000
July
295,000
August
300,000
Required:
1. Calculate credit sales for May.$
Calculate credit sales for June.$
Calculate credit sales for July.$
Calculate credit sales for August.$
Chapter 18 Solutions
Fundamentals of Corporate Finance with Connect Access Card
Ch. 18.1 - What is the difference between net working capital...Ch. 18.1 - Prob. 18.1BCQCh. 18.1 - List five potential sources of cash.Ch. 18.1 - Prob. 18.1DCQCh. 18.2 - Prob. 18.2ACQCh. 18.2 - Prob. 18.2BCQCh. 18.2 - Prob. 18.2CCQCh. 18.3 - What keeps the real world from being an ideal one...Ch. 18.3 - What considerations determine the optimal size of...Ch. 18.3 - Prob. 18.3CCQ
Ch. 18.4 - Prob. 18.4ACQCh. 18.4 - Prob. 18.4BCQCh. 18.5 - Prob. 18.5ACQCh. 18.5 - Describe two types of secured loans.Ch. 18.6 - Prob. 18.6ACQCh. 18.6 - In Table 18.6, what would happen to Fun Toys...Ch. 18 - Prob. 18.1CTFCh. 18 - A firm has an operating cycle of 64 days and a...Ch. 18 - Prob. 18.4CTFCh. 18 - Prob. 18.5CTFCh. 18 - Operating Cycle [LO1] What are some of the...Ch. 18 - Prob. 2CRCTCh. 18 - Prob. 3CRCTCh. 18 - Cost of Current Assets [LO2] Loftis Manufacturing,...Ch. 18 - Operating and Cash Cycles [LO1] Is it possible for...Ch. 18 - Use the following information to answer Questions...Ch. 18 - Use the following information to answer Questions...Ch. 18 - Prob. 8CRCTCh. 18 - Use the following information to answer Questions...Ch. 18 - Use the following information to answer Questions...Ch. 18 - Changes in the Cash Account [LO4] Indicate the...Ch. 18 - Prob. 2QPCh. 18 - Changes in the Operating Cycle [LO1] Indicate the...Ch. 18 - Prob. 4QPCh. 18 - Calculating Cash Collections [LO3] The Morning...Ch. 18 - Prob. 6QPCh. 18 - Prob. 7QPCh. 18 - Calculating Payments [LO3] Sedman, Corp., has...Ch. 18 - Calculating Payments [LO3] The Torrey Pine...Ch. 18 - Calculating Cash Collections [LO3] The following...Ch. 18 - Calculating the Cash Budget [LO3] Here are some...Ch. 18 - Prob. 12QPCh. 18 - Prob. 13QPCh. 18 - Prob. 14QPCh. 18 - Calculating the Cash Budget [LO3] Wildcat, Inc.,...Ch. 18 - Prob. 16QPCh. 18 - Costs of Borrowing [LO3] In exchange for a 400...Ch. 18 - Prob. 18QPCh. 18 - Prob. 1MCh. 18 - Prob. 2MCh. 18 - Prob. 3M
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000arrow_forwardSchedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May.$fill in the blank 5ada08018fd8065_1 Calculate credit sales for June.$fill in the blank 5ada08018fd8065_2 Calculate credit sales for July.$fill in the blank 5ada08018fd8065_3 Calculate credit sales for August.$fill in the blank 5ada08018fd8065_4 2. Prepare a schedule of cash receipts for July and August. Round your answers to the nearest whole dollar, if necessary. If an amount box does not require…arrow_forwardAnswer Fast ASAParrow_forward
- Question6: Company wants to prepare a cash budget for May, June, and July. At the end of every month the cash balance will be Rs. 20,000. Determine whether borrowing will be necessary during the period, and if it is, when and for how much. The following information has been provided: As of April 30, the firm had a balance of Rs. 20,000 in cash. Actual Sales Rs. Forecast Sales Rs. January 50,000 May 70,000 February 50,000 June 80,000 March 60,000 July 100,000 April 60,000 August 100,000 50% of total sales are for cash. The remaining will be collected equally during the following two months. Cost of purchases are 70% of sales, 90% of this cost is paid during the first month after incurrence and the remaining 10% is paid in the following month. Dividend of Rs. 10,000 declared on June will be paid in the month of July. Company plans to sell machinery costing Rs. 10,000 at an expected gain of Rs. 5,000 in June. Purchase plant…arrow_forwardX Your answer is incorrect. On June 30, 2012, a company is preparing the cash budget for the third quarter. The collection pattern for credit sales has been 60% in the month of sale, 30% in the first month after sale, and the rest in the second month after sale. Uncollectible accounts are negligible. There are cash sales each month equal to 25% of total sales. The total sales for the quarter are estimated as follows: July, $30,000; August, $15,000; September, $35,000. Accounts receivable on June 30, 2012 were $10,000. What amount would be the projected cash receipts for September? O $28,500 $30,125 $37,250 $21,375arrow_forwardNeed help with this accounting question please solvearrow_forward
- Calculate estimated cash collections for th month of June?arrow_forwardQ8) Prepare a cash budget for the first quarter for Shamz Logistics Inc., given the following data. Management has projected total and credit sales for the first three months of 2016 in the given table. Based on historical data, 40% of credit sales are collected in the month the sales were made, and 60% are collected the next month. Purchases are estimated to be 50% of the next month’s total sales, but are paid for in the month following the order. (Expenditure for inventory in each month is 50% of that month’s sales.) The beginning and target cash balance is $250,000. Month Year Credit sales December 2015 170,000 January 2016 160,000 February 2016 178,000 march 2016 185,000 Item January February March Wages 25,000 29,000 29,000 Rent 2,700 2,700 2,700 Other 1,000 1,200 1,400 Taxes 15,000 -- -- Dividend -- -- 4,000 Cap. Ex. -- 5,000 --arrow_forwardPlease help me with show all calculation thankuarrow_forward
- Please answer the question What are the estimated cash receipts for March, if 20 percent of sales are cash, 40 percent are credit sales paid in the month after the sale, and 40 percent are credit sales paid 2 months after the sale? Answer it with complete solutions and explanations if needed. Thank youarrow_forwardQUESTION 1 Ginobili has forecast sales to be $120100 in February, $151200 in March, $162700 in April, and $174000 in May. 24% of sales are on made on credit, the rest are for cash. The sales on credit are collected 40% in the month of sale, and 60% the month following. What are the total budgeted cash receipts in April?arrow_forwardes The following is the sales budget for Symon, Incorporated, for the first quarter of 2024: January February March Sales budget $ 165,000 $ 187,000 $ 204,000 Credit sales are collected as follows: 65 percent in the month of the sale. 20 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $84,000 ($62,000 of which was uncollected December sales). a. Calculate the sales for November. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. b. Calculate the sales for December. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. Calculate the cash collections from sales for each month from January through March. Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. a. November sales b. December sales c. January cash collections Next>arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY