Integrated Case
NEW WORLD CHEMICALS INC.
16-16 FINANCIAL
Assume that you were recently hired as Wilson’s assistant and that your first major task is to help her develop the formal financial forecast. She asks you to begin by answering the following questions.
- a. Assume (1) that NWC was operating at full capacity in 2014 with respect to all assets. (2) that all assets must grow at the same rate as sales. (3) that accounts payable and accrued liabilities also will grow at the same rate as sales, and (4) that the 2014 profit margin and dividend payout will be maintained. Under those conditions, what would the AFN equation predict the company's financial requirements to be for the coming year?
- b. Consultations with several key managers within NWC, including production, inventory, and receivable managers, have yielded some very useful information.
- 1. NWC’s high DSO is largely due to one significant customer who battled through some hardships the past 2 years but who appears to be financially healthy again and is generating strong cash flow. As a result, NWC’s
accounts receivable manager expects the firm to lower receivables enough for a calculated DSO of 34 days without adversely affecting sales. - 2. NWC was operating slightly below capacity; but its forecasted growth will require a new facility, which is expected to increase NWC's net fixed assets to $700 million.
- 3. A relatively new inventory management system (installed last year) has taken some time to catch on and to operate efficiently. NWC's inventory turnover improved slightly last year, but this year NWC expects even more improvement as inventories decrease and inventory turnover is expected to rise to 10 ×.
- 1. NWC’s high DSO is largely due to one significant customer who battled through some hardships the past 2 years but who appears to be financially healthy again and is generating strong cash flow. As a result, NWC’s
Incorporate that information into the 2015 initial forecast results, as these adjustments to the initial forecast represent the final forecast for 2015. (Hint: Total assets do not change from the initial forecast.)
- c. Calculate NWC’s forecasted ratios based on its final forecast and compare them with the company’s 2014 historical ratios, the 2015 initial forecast ratios, and the industry averages. How does NWC compare with the average firm in its industry, and is the company’s financial position expected to improve during the coming year? Explain.
- d. Based on the final forecast, calculate NWC’s
free cash flow for 2015. How does this FCF differ from the POP forecasted by NWC's initial “business as usual” forecast? - e. Initially, some NWL managers questioned whether the new iacility expansion was necessary, especially as it results in increasing net fixed assets from $500 million to $700 million (a 40% increase). However, after extensive discussions about NWC needing to position itself for future growth and being flexible and competitive in today’s marketplace, NWC’s top managers agreed that the expansion was necessary. Among the issues raised by opponents was that NWC’s fixed assets were being operated at only 85% of capacity. Assuming that its fixed assets were operating at only 85% of capacity, by how much could sales have increased, both in dollar terms and in percentage terms, before NWC reached full capacity?
- f. How would changes in the following items affect the AFN: (1) the dividend payout ratio, (2) the profit margin, (3) the capital intensity ratio, and (4) NWC beginning to buy from its suppliers on terms that permit it to pay after 60 days rather than after 30 days? (Consider each item separately and hold all other things constant)
Financial Statements and Other Data on NWC (Millions of Dollars) Table 1C 16.1
A. |
2014 | 2015E |
Cash and equivalents | $ 20 | $ 25 |
Accounts receivable | 240 | 300 |
Inventories | 240 | 300 |
Total current assets | S 500 | $ 625 |
Net fixed assets | 500 | 625 |
Total assets | $1,000 | $1,250 |
Accounts payable and accrued liabilities | $ 100 | $ 125 |
Notes payable | 100 | 190 |
Total current liabilities | $ 200 | $ 315 |
Long-term debt | 100 | 190 |
Common stock | 500 | 500 |
200 | 245 | |
Total liabilities and equity | $1,000 | $1,250 |
B. Income Statements | 2014 | 2015E |
Sales | $2,000.00 | $2,500.00 |
Variable costs | 1,200.00 | 1,500.00 |
Fixed costs | 700.00 | 875.00 |
Earnings before interest and taxes (EBIT) | $ 100.00 | $ 125.00 |
Interest | 16.00 | 16.00 |
Earnings before taxes (EBT) | $ 84.00 | $ 109.00 |
Taxes (40%) | 33.60 | 43.60 |
Net income | $ 50.40 | $ 65.40 |
Dividends (30%) | $ 15.12 | $ 19.62 |
Addition to retained earnings | $ 35.28 | $ 45.78 |
C. Key Ratios | NWC (2014) | NWC (2015E) | Industry | Comment |
Basic earning power | 10.00% | 10.00% | 20.00% | |
Profit margin | 232 | 2.62 | 4.00 | |
7.20 | 8.77 | 15.60 | ||
Days sales outstanding (365 days) | 43.80 days | 43.80 days | 32.00 days | |
Inventory turnover | 8.33× | 8.33× | 11.00× | |
Fixed assets turnover | 4.00 | 4.00 | 5.00 | |
Total assets turnover | 2.00 | 2.00 | 2.50 | |
Total 1iabi1ities/Assets | 30.00% | 40.40% | 36.00% | |
Times interest earned | 6.25 × | 7.81× | 9.40× | |
Current ratio | 2.50 | 1.99 | 3.00 | |
Payout ratio | 30.00% | 30.00% | 30.00% |
Want to see the full answer?
Check out a sample textbook solutionChapter 16 Solutions
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
- Show the solution in good accounting formarrow_forwardChapter 12, Question 1arrow_forwardMANAGEMENT ACCOUNTING Gxsport is a small business manufactures sportswear focusing on tracksuits. Gxsportperform very well in 2021 with yearly sales amounting to RM630,000, equivalent to 12,600pieces sold. For the 1st quarter of 2022, the sales are predicted to increase by 7% ascompared to 2021’s sales due to the raised of awareness for a healthy lifestyle.The price of the tracksuit is RM50 per piece. The labour rate is RM7 per hour and eachpiece of tracksuit requires 0.4 hours to make. Manufacturing overheads are charges atRM1.50 per piece. The inventory is expected to have a balance of 500 pieces of tracksuitsas at 1st January 2022 and increase by 10% as at 31st March 2022.Calculate the production budget (in unit) for the 1st quarter 2022 (1st January to 31st March2022).arrow_forward
- Abeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for 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,000 February 8,000 August 11,000 March 7,200 September 12,800 April 8,800 October 13,600 May 10,000 November 12,000 June 11,200 December 14,000 Ellen 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: Bows are sold at an average price of $150. Abeng has experienced an excellent record in accounts receivable collection…arrow_forwardAbeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for 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,000 February 8,000 August 11,000 March 7,200 September 12,800 April 8,800 October 13,600 May 10,000 November 12,000 June 11,200 December 14,000 Ellen 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: Bows are sold at an average price of $150. Abeng has experienced an excellent record in accounts receivable collection…arrow_forwardAbeng Corp, a rapidly-expanding crossbow distributor, is in the process of formulating plans for 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,000 February 8,000 August 11,000 March 7,200 September 12,800 April 8,800 October 13,600 May 10,000 November 12,000 June 11,200 December 14,000 Ellen 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: Bows are sold at an average price of $150. Abeng has experienced an excellent record in accounts receivable collection…arrow_forward
- ZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000arrow_forwardQuestion 5arrow_forward15. Texas Company has begun selling new chili recipe and they want you to help with next year's budgeted financial statements. Using the worksheet below, complete Texas Company forecast and answer the questions which follow. Assumptions: To begin with, Texas Company is sure sales will grow 40% next year. Assume that is true. Then assume that COGS, Current Assets, and Current Liabilities all vary directly with Sales (that means if sales grow a certain percentage, then the account in question will grow by that same percentage). Assume that fixed expenses will remain unchanged, and that $3,000 worth of new Fixed Assets will be obtained next year. Lastly, the current dividend policy will be continued next year. Texas Company Financial Forecast Estimated This Year for next year $45,000 $5,000 40,000 Sales COGS Gross Profit 3,000 37,000 Fixed Expenses Before-Tax Profit Tax @ 33.3333% Net Profit 12.332 24,668 Dividends $0 Current Assets $30,000 20,000 $50,000 Net Fixed Assets Total Assets…arrow_forward
- Solve all the questionsarrow_forwardThis problem has several components… Last year sales = 500,000 units. The organization is planning a 10 percent increase in sales for the year 2012. The company is a retail organization that sees higher sales due to the holidays in the 4th quarter. 40 percent of the sales occur in the 4th quarter and the remaining units are sold equally over the other three quarters. The beginning inventory for the year amounts to 20,000 units. The estimated sales for the first quarter of 2022 amount to 115,000 units. The company requires an ending inventory of 20 percent of the next quarters' sales. The projected sales price is $50 per unit. Materials: Each unit requires 1 yard of fabric and 1/2 pound of fiberfill stuffing. Fabric can be purchased at $9.00 per yard and fiberfill sells for $4.00 per pound. Desired ending inventories of materials are listed as follows: Qtr1 Qtr2 Qtr3 Qtr4 Fabric/yds 17,000…arrow_forwardBooker Inc. is a distributor of building supplies. Management for the company has developed the following forecasts of net income: Table 8 Forecasted Net Income of Booker Inc. in USD (As of December 31st of each year) Year Forecasted Net Income 2011 $111,432 2012 $131,490 2013 $156,473 2014 $178,379 2015 $199,784 Management expects net income to grow at a rate of 7% per year after 2015 and the company's cost of equity capital is 14%. Management has set a dividend payout ratio equal to 25% of net income and plans to continue this policy. Booker’s common shareholders' equity at January 1, 2011, is $544,902. Using the residual income model, compute the value of equity of Booker as of January 1, 2011. Using the dividend discount model, compute the value of equity of Booker as of January 1, 2011. Compare the results in parts (a) and (b) and discuss possible reasons for any discrepancies.arrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning