FUND.OF CORP.FIN.(LL)-W/ACCESS >CUSTOM<
11th Edition
ISBN: 9781260100259
Author: Ross
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 18, Problem 11QP
Calculating the Cash Budget [LO3] Here are some important figures from the budget of Nashville Nougats, Inc., for the second quarter of 2015:
The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase.
In March 2015, credit sales were $235,000 and credit purchases were $161,300. Using this information, complete the following cash budget:
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Q7
The budgeted sales for the next four quarters are R192 000, R288 000, R288 000 and R336 000 respectively. It is estimated that sales will be paid for as follows:-75% of the total will be paid in the quarter that the sales were made. Of the balance 50% will be paid in the quarter after the sale was made. The remaining 50% will be paid in the quarter after this. The amount of cash received in the third quarter will be:
Select one:
a. R144 000
b. R240 000
c. R324 000
d. R276 000
Capital Budgeting
1. Knight Company has found that 30% of its sales are collected in the month of the sale and the remainder of the sales are collected in the next month. If sales are expected to be $100,000 in April, $120,000 in May, and $80,000 in June, what is the estimated amount of cash receipts for May?A. $114,000B. $106,000C. $92,000D. $108,000
2. In recent years, Princess Company has collected 20% of its sales in the month of the sale and the other 80% in the following month. During the first three months of 2002, Princess is anticipating sales of $350,000; $403,000; and $389,000, respectively. What is the amount of cash receipts budgeted for March?A. $301,200B. $360,600C. $400,200D. $391,800
Pine Co. budgeted credit sales for the coming year is P900,000. A proposed relaxation of credit standards increase the Accounts receivable balance by P25,000. The average collection period is expected to increase from 20 to 25 days. How much is the budgeted credit sales of Pine Co. if the increase in average collection period to 25 days push through? (360 day year)a. 1,080,000b. 2,520,000c. 620,000d. 1,660,000
Chapter 18 Solutions
FUND.OF CORP.FIN.(LL)-W/ACCESS >CUSTOM<
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
- If most companies find their forecasts are inaccurate, why should managers engage in budgeting at all? [8 marks]2. Abeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for 2021. James Chambers, director of marketing, has completed his 2021 forecast and is confident that sales estimates will be met or exceeded. The following forecasted sales figures show the growth expected and will provide the planning basis for other corporate departments:Month Sales (units) Month Sales (units)January 7,200 July 12,000February 8,000 August 11,000March 7,200 September 12,800April 8,800 October 13,600May 10,000 November 12,000June 11,200 December 14,000Ellen Eglin, assistant controller, has been given responsibility for formulating the cash flow projections, a critical element during a period of rapid expansion. The following information will be used in preparing the cash analysis:i. Bows are sold at an average price of $150.ii. Abeng has experienced an excellent…arrow_forwardI'm working on a Cash Budget "Helen bowers" and get stuck on the question: 4) Assume that receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows are paid on the 5th of the month. Will this have an effect on the cash budget – in other words, would the cash budget you have prepared be valid under these assumptions? If not, what can be done to make a valid estimate of the peak financing requirements? No calculations or spreadsheet work is required, though calculations could be used to illustrate the effectsarrow_forwardUse the information provided below to prepare the Cash Budget for January and February 2023:INFORMATIONThe following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 - R576 000 January 2023 - R540 000 February 2023 - R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 - R1 000 000 January 2023 - R800 000 February 2023 - R920 0006. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150 000.…arrow_forward
- Thern Company's budgeted sales for the coming year are $40,500,000 of which 80% are expected to be credit sales at terms of n/30. Thern estimates that a proposes relaxation of credit standards would increase credit sales by 20% and increase the average collection period form 30 days to 40 days. Based on a 360-day year, the proposed relaxation of credit standards would result in an expected increase in the average accounts receivable balance of how much?arrow_forward26. Butterfly Limited has finalised its budget for 20X8 and sales are anticipated to be £243,600 in January, £1,393,200 in February, £516,000 in March and £769,200 in April. Butterfly is budgeting that 50% of sales will be cash and the other 50% will be on credit when 80% of receivables are expected to pay in the month after sale, 15% in the second month after sale, while the remaining 5% are expected to be bad debts. Credit customers who pay in the month of sale can claim a 5% cash settlement discount. Page 10 of 14[2044]What level of sales receipts should be shown in the cash budget for March 20X8?a) £820,650b) £833,550c) £1,425,432d) £1,438,332arrow_forward26. Butterfly Limited has finalised its budget for 20X8 and sales are anticipated to be £243,600 in January, £1,393,200 in February, £516,000 in March and £769,200 in April. Butterfly is budgeting that 50% of sales will be cash and the other 50% will be on credit when 80% of receivables are expected to pay in the month after sale, 15% in the second month after sale, while the remaining 5% are expected to be bad debts. Credit customers who pay in the month of sale can claim a 5% cash settlement discount. What level of sales receipts should be shown in the cash budget for March 20X8? a) £820,650 b) £833,550 c) £1,425,432 d) £1,438,332arrow_forward
- 2. Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,080,000 and for the fourth quarter of the current year are $7,220,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank b0590a054f99004_1 $fill in the blank b0590a054f99004_2 4, current year fill in the blank…arrow_forwardA companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000arrow_forward2.2 Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,690,000 Quarter 3 630,000 Quarter 4 8,200,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,080,000 and for the fourth quarter of the current year are $7,220,000.arrow_forward
- The company’s budgeted sales for the coming year are P30,000,000 of which 70% are expected to be credit sales at terms of n/30. It estimates that a proposed relaxation of credit standards will increase credit sales by 30% and increase the average collection period from 20 days to 30 days. Based on a 360-day year, the proposed relaxation of credit to standards will result in an expected increase in the average accounts receivable balance of?arrow_forwardGolden Corporation is preparing its cash budget for the next year. Sales are expected to be at P100,000 for January; P200,000 for February; P300,000 for March; and P100,000 for April. Approximately half of the sales are cash basis and the other half are on account or on credit. Of the credit sales, 70% is collected on the following month; 20% on the second month, and 10% on the third month. What is the budgeted collection for April? 1. P 130,000 2. P 180,000 3. P 260,000 4. P 360,000 Group of answer choices 1 2 3 4arrow_forwardUse the information provided below to prepare the following for January and February 2023: 4.2)Cash Budget INFORMATION The following information was provided by Intel Enterprises:1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable).2. Credit sales are expected to be as follows:December 2022 January 2023 February 2023R576 000 R540 000 R648 0003. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customersreceive a 10% discount.4. Credit sales are normally collected as follows:* 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount.* 65% in the following monthThe rest is usually written off as bad debts.5. Budgeted purchases of inventory are as follows:December 2022 January 2023 February 2023R1 000 000 R800 000 R920 000 6. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the purchase.7. The monthly salaries amount to R150…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