FUND.OF CORP.FIN.(LL)-W/ACCESS >CUSTOM<
11th Edition
ISBN: 9781260100259
Author: Ross
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 18, Problem 15QP
Calculating the Cash Budget [LO3] Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:
![Chapter 18, Problem 15QP, Calculating the Cash Budget [LO3] Wildcat, Inc., has estimated sales (in millions) for the next four , example 1](http://dev-ingestion-image-output.s3-website-us-east-1.amazonaws.com/9780077861704/Chapter-18/images/61704-18-15qp-question-digital_image_001.png)
Sales for the first quarter of the year after this one are projected at $170 million. Accounts receivable at the beginning of the year were $68 million. Wildcat has a 45-day collection period.
Wildcat’s purchases from suppliers in a quarter are equal to 45 percent of the next quarter’s
Wildcat plans a major capital outlay in the second quarter of $75 million. Finally, the company started the year with a $49 million cash balance and wishes to maintain a $30 million minimum balance.
a. Complete a cash budget for Wildcat by filling in the following:
![Chapter 18, Problem 15QP, Calculating the Cash Budget [LO3] Wildcat, Inc., has estimated sales (in millions) for the next four , example 2](http://dev-ingestion-image-output.s3-website-us-east-1.amazonaws.com/9780077861704/Chapter-18/images/61704-18-15qp-question-digital_image_002.png)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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
Capital budgeting
50. An investment of $773,640 is expected to generate cash flows of $200,000 in Year 1, $300,000 in Year 2, and $500,000 in Year 3. What is the internal rate of return?A. less than 8%B. between 8% and 11%C. between 11% and 14%D. greater than 14%
51. You will need $15,000 at the end of each of the next four years. If an interest rate of 8% is appropriate, what is the present value of the series of payments that you are forecasting?A. $44,100.00B. $49,681.50C. $36,230.79D. $45,559.50
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
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
- 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,800arrow_forwardThern 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_forwardCash Budgeting The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent, with the first-quarter sales projection at $165 million. In addition to this basic trend, the seasonal adjustments for the four quarters are, in millions, 0, -$12, –$6, and $18, respectively. Generally, 50 percent of the sales can be collected within the quarter and 45 percent in the following quarter; the rest of the sales are bad debt. The bad debts are written off in the second quarter after the sales are made. The beginning accounts receivable balance is $84 million. Assuming all sales are on credit, compute the cash collections from sales for each quarter. Don't round off until you get to the end.arrow_forward
- AB Company’s budgeted sales and cost of sales for the coming year are P72 million and P45 million respectively. Shortterm interest rates are expected to average 10%. If the company can increase inventory turnover from its current levelof 9 times per year to 12 times per year, its cost savings in the coming year are expected to beA. P125,000 C. P375,000B. P300,000 D. P500,000arrow_forwardThe 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_forward(Capital budgeting) 33. An investment that costs $80,000 will provide a return of $20,000 per year for each of the next five years. Ignoring taxes, what is the net present value of the investment if the required rate of return in 14 percent?A. ($20,000)B. $21,552C. ($11,338)D. $68,662 34. A proposed project will cost $600,000 and will provide returns of $150,000 in Year 1, $300,000 in Year 2, and $500,000 in Year 3. There will not be any cash flows associated with the project after Year 3. If taxes are ignored, and the company’s hurdle rate is 15%, what is the net present value of the project?A. $86,020B. $23,013C. $66,373D. $50,000arrow_forward
- Capital budgeting 18. You will need $15,000 at the end of each of the next four years. If an interest rate of 8% is appropriate, what is the present value of the series of payments that you are forecasting?A. $44,100.00B. $49,681.50C. $36,230.79D. $45,559.50 20. Assume that 15% is an appropriate rate of return. What is the present value of an annuity of $300,000 per year for the next ten years?A. $2,608,000B. $741,600C. $2,281,830D. $1,505,640arrow_forward2. 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_forwardDown Under Company's budgeted sales and budgeted cost of sales for the coming year are P126 million and P72 million, respectively. Short-term interest rates are expected to average 10%. If Down Under can increase inventory turnover from its current level of nine times per year to a level of 12 times per year, its cost saving in the coming year are expected to bearrow_forward
- 2.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_forwardIf 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_forwardKern Company prepared the following tentative budget for next month: Sales ................... R500 000 Selling price ........... R5 per unit Variable expenses ....... R300 000 Fixed expenses .......... R150 000 The sales manager argues that the unit selling price could be increased by 20%, with an expected volume decrease of only 10%. If Kern incorporates these changes in its budget, what should be the budgeted net income? A. R120 000 B. R90 000 C. R66 000 D. R145 000arrow_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
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license