Fundamentals of Corporate Finance
11th Edition
ISBN: 9780077861704
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
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:
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 solutionStudents 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.
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.$
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.$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…
Chapter 18 Solutions
Fundamentals of Corporate Finance
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
- Use the information below to answer question 1 to 22. The financial controller of BOE Ltd. is gathering data to prepare a cash budget for the second quarter of 2018. The following information is available. a) Sales for the first six months of the year are as follows: January February March 23,000 30,000 50,000 57,000 60,000 56,000 April Мay June a) 40% of all sales are cash sales. b) Of credit sales, 50% are collected in the month of sales and the remaining 50% collected the following month. c) The cost of raw materials equals 35% of each month's sales. 50% of raw materials are paid for in the month of purchase. The remaining 50% are paid in the following month. d) Wages total ¢5,500 per month and are paid for in the month incurred. e) Operating expenses per month totalled ¢16,800 of which ¢2,500 is depreciation and ¢300 is expiration of prepaid insurance premium (the annual premium of ¢3,600 paid in Jan 1). f) Dividend of ¢7,000 declared in March 31 will be paid on April 20. g) Old…arrow_forwardQuestion6: 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_forward
- Q8) 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_forwardUranus sells wires and it reports the following information from its sales budget: Expected Sales amount: July RM 97,000 August RM117,000 September RM127,000 Cash sales are normally 30% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in September is: 1.120,000 2.38,100 3.127,000 4.81,900 5.208,900arrow_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_forward
- Question: 1. Based on the following data, how to prepare a cash budget (in proper form with labels) for July and August. Forecast sales May $12,000 cCash sales are 30% of total sales. Credit sales June 15,000 are collected as follows: 60% one month after the July $16,000 sale and 40% 2 months after the sale August $12,000 Accounts payable are paid 100% 2 months after the purchase Expected A/P May $5,000 In addition to purchases, there are utility June $6,000 bills of $1,500 each month July $7,000 August $8,000 Beginning cash for July is $3,800arrow_forwardThe information in the following table is from a company's sales budget Expected sales April May June $ 96,000 116,000 126,000 Cash sales are normally 25% of total sales and all credit sales are expected to be collected in the month following the date of sale. The total amount of cash expected to be received from customers in June OAS118,500 O $31,500 OC$213,000 005126,000 O $87,000arrow_forwardA company has the following budgeted sales in each quarter of the year 2024: Expected Sales Q1 Q2 Q3 Q4 Cash collection information is as follows: $240,000 $280,000 $300,000 $420,000 1. Of all sales, 70% are on credit REMBRA 2. 60% of credit sales are collected in the quarter in which the sale is made; 30% are collected in the following quarter, and 10% are collected in the second quarter after the sale. 3. Accounts Receivable is estimated to be $63,000 on December 31,2023. The company expects to collect all outstanding receivabl in the first quarter of 2024. Q. What is the total cash collection for the second quarter of 2024? Answer. (Click to select) (Click to select) None of the answers are correct $231,000 $168,000 $252,000 $315,000arrow_forward
- 1. Prepare a Cash budget from March to June based on the following information: Cash balance at end of March = Rs. 200000 Sales in January = 1000 units and expected to increase by 1000 units per month in the first 3 months and thereafter by 1500 units per month Selling price = Rs. 100 per units and is fixed after adding 20% to cost Cash sales are 25% of total sales Cash Purchases are 20% of total purchases 2% of Accounts Receivables are bad debt losses, 50% of good accounts receivables are collected in the month following sales and the rest in the next month 50% of credit purchases are paid in one month following purchases and the remaining in the second month No stock remains at end of the month Time lag in payment of wages is one-fourth of a month and that of Administrative expenses is half a month (Rs.) Jan Feb Mar Apr May June Wages 15000 20000 25000 28000 32000 36000 Administrative expenses (excluding depreciation) 18000 22000 26000…arrow_forwardWoxy company is considering its forthcoming projections for cash budget purposes. Woxy's forecasts the following sales figures for the next four months. April $250,000 May $150,000 June $225,000 July $150,000 Cash sales average 10% of total sales and credit sales are collected 50% in the month of sale and 50% in the month following sale. What are the estimated cash collections in May?arrow_forwardClay Co.'s projected sales are as follows: August $400,000 September $450,000 October $550,000 Clay estimates that it will collect 30% in the month of sale, 50% in the month after the sale, and 18% in the second month following the sale. Two percent of all sales are estimated to be bad debts. Instructions: How much are Clay Co.'s budgeted cash receipts for October?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