# 1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement...

## Question:

1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over this period?

2. Use the spreadsheet below to project Idexo's working capital needs over the next five years. Why is the increase in net working capital negative in 2011? Why does the increase in net working capital decline from 2014 to 2015?

3. Based on the forecasts you have already developed, use the spreadsheet below to project Idexo's free cash flow for 2011 to 2015. Will the firm's free cash flow steadily increase over this period? Why or why not?

4. (Optional) Recall that Idexo plans to maintain only the minimal necessary cash and pay out all excess cash as dividends.
a. Suppose that, at the very end of 2010, Ferris plans to use all excess cash to pay an immediate dividend. How much cash can the firm pay out at this time? Compute a new 2010 balance sheet reflecting this dividend using the spreadsheet below.
b. Forecast the cash available to pay dividends in future years-the firm's free cash flow to equity-by adding any new borrowing and subtracting after-tax interest expenses from free cash flow each year. Will Idexo have sufficient cash to pay dividends in all years? Explain.
c. Using your forecast of the firm's dividends, construct a pro forma balance sheet for Idexo over the next five years.

5. In late 2010, soon after Ferris's return as CEO, the firm receives an unsolicited offer of $210 million for its outstanding equity. If Ferris accepts the offer, the deal would close at the end of 2010. Suppose Ferris believes that Idexo can be sold at the end of 2015 for an enterprise value equal to nine times its final EBITDA. Idexo's unlevered cost of capital is 10% (specifically, 10% is the pre-tax WACC). Based on your forecast of Idexo's free cash flow in 2011 to 2015 in Question 3, and its final enterprise value in 2015, estimate the following: a. Idexo's unlevered value at the end of 2010. b. The present value of Idexo's interest tax shields in 2011 to 2015. (Recall that these tax shields are fixed and so have the same risk level as the debt.) c. Idexo's enterprise value at the end of 2010. (Add the present value of the interest tax shield in 5b to the unlevered value of the firm in 5a.) d. Idexo's equity value today. (Adjust the enterprise value in 5c to reflect the firm's debt and excess cash at the end of 2010.) e. Based on your analysis, should Ferris sell the company now? Idexo Corporation is a privately held designer and manufacturer of licensed college apparel in Ottawa, Ontario. In late 2010, after several years of lacklustre performance by the firm, the firm's owner and founder, Rebecca Ferris, returned from retirement to replace the current CEO, reinvigorate the firm, and plan for its eventual sale or a possible IPO. She has hired you to assist with developing the firm's financial plan for the next five years. In 2010, Idexo had total assets of about$103 million and annual sales of $100 million (see Table 1). The firm was profitable, with expected 2010 earnings of over$9 million, for a net profit margin of 9.1%.5 However, revenue growth has slowed dramatically in recent years, and the firm's net profit margin has actually been declining. Ferris is convinced the firm can do better. After only several weeks at the helm, she has already identified a number of potential improvements to drive the firm's future growth.
TABLE-1: Idexo's 2010 Income Statement and Balance Sheet

Operational Improvements. On the operational side, Ferris is quite optimistic regarding the company's prospects. The market is expected to grow by 6% per year, and Idexo produces a superior product. Idexo's market share has not grown in recent years, because prior management devoted insufficient resources to product development, sales, and marketing. At the same time, Idexo has overspent on administrative costs. Indeed, as shown in Table 1, Idexo's current administrative expenses are $18 million/$100 million = 18% of sales, which exceeds its expenditures on sales and marketing (15% of sales).
Competitors spend less on administrative overhead than on sales and marketing. Ferris plans to cut administrative costs immediately to 15% of sales and redirect resources to new product development, sales, and marketing. By doing so, she believes Idexo can increase its market share from 10% to 14% over the next four years. Using the existing production lines, the increased sales demand can be met in the short run by increasing overtime and running some weekend shifts. The resulting increase in labour costs, however, is likely to lead to a decline in the firm's gross margin to 53%. Table 2 shows sales and operating-cost projections for the next five years based on this plan, including the reallocation of resources from administration to sales and marketing over the five-year period, and an increase in Idexo's average selling price at a 2% inflation rate each year.
TABLE-2: Idexo's Sales and Operating-Cost Projections

Corporation
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may...
Cost Of Capital
Cost of capital refers to the opportunity cost of making a specific investment . Cost of capital (COC) is the rate of return that a firm must earn on its project investments to maintain its market value and attract funds. COC is the required rate of...
Fantastic news! We've located the answer you've been seeking!