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.
-
The following graphical display is meant to be a comparative bar graph ( USA Today, August 3, 2009). Do you think it is an effective summary of the data? If so, explain why. If not, explain why not...
-
The inner sphere has a net charge of 6 C and the shell has a net charge of +2 C. A conducting sphere (radius a) is placed at the center of a conducting spherical shell (inner radius b and outer...
-
The following information has been extracted from the books of account of Billinge plc as at 30 June 2006: Additional information: 1. The company was incorporated in 2000. 2. The stock at 30 June...
-
Relative Sales Value Method Larsen Realty Corporation purchased a tract of unimproved land for $55,000. This land was improved and subdivided into building lots at an additional cost of $30,000....
-
thanku Shadee Corporation expects to sell 630 sun shades in May and 420 in June. Each shade sells for \( \$ 152 \). Shadee's beginning and ending finished goods inventories for May are 85 and 55...
-
Using the alternative-parameter method, determine the parameters of the following distributions based on the given assessments. Refer to Step 5.5 if necessary. a. Find the parameter value for the...
-
What are internal and external locus of control. Give examples of both.
-
Find the equation of line passing through (-2, 1) and having slope 3.
-
To better understand the effects of debt, which are related to the existence of tax deductibility, it is useful to first consider a world with a zero marginal tax rate. The usual formulas still...
-
Find d.x , if y+x+x* = a.
-
1/6 Opening balance: 400 units on hand @ $25.00 per unit. 6/6 Purchase on credit of 200 units @ $26.00 per unit; total cost $5,200. 7/6 Sale of 170 units. 9/6 Returned to the supplier for credit 20...
-
In the RCP case study, the RCP firm hopes to earn rights to cash flow disproportionate to their capital investment and in addition to reasonable fees they may obtain in their management role. Even...
-
please help Selected year-end account balances from the adjusted trial balance as of December 31, 2025 , for Flounder Corporation is provided below.Prepare closing entries. (List all debit entries...
-
How is use of the word consistent helpful in fraud reports?
-
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...
-
Your European subsidiary has cash and accounts receivable of 100 and 300 euros respectively, and accounts payable and short-term debt of 100 and 200 euros respectively. US headquarters re-measures...
-
In 2006, five retired software developers opened an auto dealership in Redmond, Washington, which they named WinTechMotors. The company specializes in "high-end" sports and luxury autos, and has one...
-
The time value of money Consider the following cash flows from today (year zero) to year 3 in pounds sterling: Your interest rate (or discount rate) in pounds is 10 percent. a Compute the net present...
Study smarter with the SolutionInn App