Case 1- Canyon Buff's Chemical Equipment This case is a simple capital budgeting exercise that should...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case 1- Canyon Buff's Chemical Equipment This case is a simple capital budgeting exercise that should reinforce your understanding of the following topics: • Incremental unlevered net income • Free cash flow • Sensitivity analysis and scenario analysis O Iutial Inu - Introduction Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending S500,000 on the research of the potential market for the new chemical, Canyon Buff is considering a project that requires an initial investment of S9.000,000 in manufacturing equipment. Depreaahor The equipment must be purchased before the chemical production can begin. For tax purposes. the equipment is subject to a S-year straight-line depreciation schedule, with a projected zero salvage value. For simplicity, however, we will continue to assume that the asset can actually be used out into the indefinite future (i.c., the actual useful life is effectively infinite). • Canyon Buff anticipates that the sales will be $30,000,000 in the first year (Year 1). They expect that sales will initially grow at an annual rate of 6% until the end of sixth year, After that, the sales will grow at the estimated 2% annual rate of inflation in perpetuity. wth The cost of goods sold is estimated to be 72% of sales. The accounting department also estimates that at introduction in Year 0, the new product's required initial net working capital will be S6,000,000. In future years accounts receivable E ure expected to be 15% of the next year sales, inventory is expected to be 20% of the next year's cost of goods sold and accounts payable are expected to be 15% of the next year's cost of goods sold. the • The selling, general and administrative expense is estimated to be $6.000,000 per year, but S1 million of this amount is the overhead expense that will be incurred even if the project is not accepted. The market research to support the product was completed last month at a cost of $500,000 to be paid by the end of next year. O Ore The annual interest expense tied to the project is S1,000,000. • Canyon Buff has a cost of capital of 20% and faces a marginal tax rate of 30% and an average tax rate is 20%. unt end Instructions I posted an incomplete Excel template for your analysis. You need to figure out how to construct the pro forma income statements and calculate the incremental unlevered net income. You should include ONLY the factors that will affect vour capital budgeting decision. Revise the template if necessary. Note that your analysis should be set up so the assumptions that impact the cash flow estimates can be easily changed to identify the sensitivity of your calculations to these assumptions. There are three sheets in the template. Use the worksheet "NPV" for questions 1 to 4, and the other two sheets for questions 5 and 6. Submit your Excel spreadsheet through blackboard. Clearly show your work so that I can trace your numbers. Questions 1. Use Excel to construct six-year pro forma income statements and calculate the incremental unlevered net income for the first six years. 2. Calculate six-year projections for free cash flows. Remember to include cash flows from the income statement and depreciation, changes in net working capital, and capital expenditures or dispositions. Hìnt: You need to calculate the level of net working capital (NWC) and change in NWC. Pay attention to the timing of NWC. Canyon Buff expects that free cash flow from Year 6 onwards will increase at a constant rate of 2%/year into the indefinite future. Calculate PV(terminal value that captures the value of future free cash flows in Year 6 and beyond). That is, calculate the terminal value first, then find its value in Year 0 (today). 3. Hint: We went over this in Lecture Note 6, so let me briefly review the key points: a. Assuming the cash flows grow at a constant rate g after Year N+1, then Year N TV - (Year N+1 CF/(r-g) where r is discount rate (from growing perpetuity formula). b, We should discount this Terminal Value back to Year 0. 4. Determine the NPV of the project. Remember to net out any initial cash outflows. Perform a sensitivity analysis by varying the four parameters as follows: Case 1- Canyon Buff's Chemical Equipment This case is a simple capital budgeting exercise that should reinforce your understanding of the following topics: • Incremental unlevered net income • Free cash flow • Sensitivity analysis and scenario analysis O Iutial Inu - Introduction Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending S500,000 on the research of the potential market for the new chemical, Canyon Buff is considering a project that requires an initial investment of S9.000,000 in manufacturing equipment. Depreaahor The equipment must be purchased before the chemical production can begin. For tax purposes. the equipment is subject to a S-year straight-line depreciation schedule, with a projected zero salvage value. For simplicity, however, we will continue to assume that the asset can actually be used out into the indefinite future (i.c., the actual useful life is effectively infinite). • Canyon Buff anticipates that the sales will be $30,000,000 in the first year (Year 1). They expect that sales will initially grow at an annual rate of 6% until the end of sixth year, After that, the sales will grow at the estimated 2% annual rate of inflation in perpetuity. wth The cost of goods sold is estimated to be 72% of sales. The accounting department also estimates that at introduction in Year 0, the new product's required initial net working capital will be S6,000,000. In future years accounts receivable E ure expected to be 15% of the next year sales, inventory is expected to be 20% of the next year's cost of goods sold and accounts payable are expected to be 15% of the next year's cost of goods sold. the • The selling, general and administrative expense is estimated to be $6.000,000 per year, but S1 million of this amount is the overhead expense that will be incurred even if the project is not accepted. The market research to support the product was completed last month at a cost of $500,000 to be paid by the end of next year. O Ore The annual interest expense tied to the project is S1,000,000. • Canyon Buff has a cost of capital of 20% and faces a marginal tax rate of 30% and an average tax rate is 20%. unt end Instructions I posted an incomplete Excel template for your analysis. You need to figure out how to construct the pro forma income statements and calculate the incremental unlevered net income. You should include ONLY the factors that will affect vour capital budgeting decision. Revise the template if necessary. Note that your analysis should be set up so the assumptions that impact the cash flow estimates can be easily changed to identify the sensitivity of your calculations to these assumptions. There are three sheets in the template. Use the worksheet "NPV" for questions 1 to 4, and the other two sheets for questions 5 and 6. Submit your Excel spreadsheet through blackboard. Clearly show your work so that I can trace your numbers. Questions 1. Use Excel to construct six-year pro forma income statements and calculate the incremental unlevered net income for the first six years. 2. Calculate six-year projections for free cash flows. Remember to include cash flows from the income statement and depreciation, changes in net working capital, and capital expenditures or dispositions. Hìnt: You need to calculate the level of net working capital (NWC) and change in NWC. Pay attention to the timing of NWC. Canyon Buff expects that free cash flow from Year 6 onwards will increase at a constant rate of 2%/year into the indefinite future. Calculate PV(terminal value that captures the value of future free cash flows in Year 6 and beyond). That is, calculate the terminal value first, then find its value in Year 0 (today). 3. Hint: We went over this in Lecture Note 6, so let me briefly review the key points: a. Assuming the cash flows grow at a constant rate g after Year N+1, then Year N TV - (Year N+1 CF/(r-g) where r is discount rate (from growing perpetuity formula). b, We should discount this Terminal Value back to Year 0. 4. Determine the NPV of the project. Remember to net out any initial cash outflows. Perform a sensitivity analysis by varying the four parameters as follows:
Expert Answer:
Related Book For
Intermediate Accounting
ISBN: 978-0324300987
10th Edition
Authors: Loren A Nikolai, D. Bazley and Jefferson P. Jones
Posted Date:
Students also viewed these general management questions
-
Sensitivity analysis and scenario analysis are somewhat similar. Describe which is a more realistic method of analyzing the impact of different scenarios on a project.
-
A company is considering a 6-year project that requires an initial outlay of $19,000. The project engineer has estimated that the operating cash flows will be $3,000 in year 1, $6,000 in year 2,...
-
This exercise tests your understanding of the four inventory methods. List the name of the inventory method that best fits the description. Assume that the cost of inventory is rising. 1....
-
Write a program that takes an integer command-line argument n and prints all the positive powers of 2 less than or equal to n. Make sure that your program works properly for all values of n.
-
a. Suppose that 0 < q < p and that n = + O(np). Show that n = + O(nq). b. Make a table listing 1/n, 1/n2, 1/n3, and 1/n4 for n = 5, 10, 100, and 1000, and discuss the varying rates of convergence...
-
Light passes through a 10-m-wide slit and is viewed on a screen 1 m behind the slit. If the width of the slit is narrowed, the band of light on the screen will. A. Become narrower. B. Become wider....
-
Explain what type of stability the aircraft would exhibit if the CG is behind the CL.
-
Trevor Moore opened a law office on January 1, 2015. During the first month of operations, the business completed the following transactions: Jan. 1 Moore contributed $ 59,000 cash to the business,...
-
For shooting practice a person uses a pellet gun and an empty pop can. The pop can rests on a flat surface that has a coefficient of kinetic friction 0.500. The pellet has a mass of 0.120 kg and the...
-
The limit order book for a security is as follows: The specialist receives the following, in order: Market order to sell 300 shares Limit order to buy 100 shares at 25.38 Limit order to buy 500...
-
What are commodities in the context of investments?
-
Nirmo Power and Light has two P1,000 par value bonds outstanding. Bond X matures in five years and Bond Y matures in 15 years. Both bonds pay P80 interest annually and currently sell at their par...
-
Criticism of the World Bank is generally on a diverse range of issues but they generally centre around concern about the approaches adopted by the World Bank in formulating their policies, and the...
-
Feldstein tells DiMaria thatGM forecast operating exposure for all its regions on a monthly basis. Then, the "riskiness" of these exposures is calculated by multiplying the net (regional) exposure by...
-
(d) Suppose that instead of restricting imports or giving explicit advantages to Canadian-made products, the Bank of Canada enters the foreign exchange market and buys up large quantities of foreign...
-
If Bob faces a 20% chance of losing $20 or an 80% chance of losing nothing. What is the expected loss and variance?
-
Q3. The electrical resistance R of a piece of wire of length L and diameter d is given by 4pL R= If p= 44.2102m, L = (527.30.1) cm, and d= (0.6200.010) mm, calculate R to three significant figures...
-
Why is it necessary to study the diffusion of molecules in biological systems?
-
The controller of the Halpern Company prepared the following income statement and balance sheet at the end of the first year of the companys existence: Income Statement Sales revenue ...... $40,000...
-
Indicate how a company computes the amount of interest and income taxes that it paid during the year.
-
The Cobler Company uses a periodic inventory system and presents the following partial list of account balances taken from its December 31, 2007 adjusted trial balance: Operating expenses...
-
In March 2015, a Nielsen global online survey "found that consumers are increasingly willing to pay more for socially responsible products." Over 30,000 people in 60 countries were polled about their...
-
Proportion of US adults who own a cell phone. In a survey of 1006 US adults in 2014, 90% said they had a cell phone. Give the correct notation for the quantity described and give its value.
-
One of the many wonderful things about studying statistics is that graduate programs in statistics often pay their graduate students, which means that many graduate students in statistics are able to...
Study smarter with the SolutionInn App