Question

In: Finance

Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability...

Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending $500,000 on the research of the potential market for the new chemical, Canyon Buff is considering a project that requires an initial investment of $9,000,000 in manufacturing equipment.

 The equipment must be purchased before the chemical production can begin. For tax purposes, the equipment is subject to a 5-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.e., 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.

 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 $6,000,000. In future years accounts receivable are 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 selling, general and administrative expense is estimated to be $6,000,000 per year, but $1 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.

 The annual interest expense tied to the project is $1,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%.

Determine the NPV of the project.

Solutions

Expert Solution

Only relevant costs will be considered in the capital budgeting analysis.

  • $500,000 spent on the research of the potential market for the new chemical, is now a sunk cost and hence irrelevant.  
  • The market research cost of $500,000 to be paid by the end of next year is again a sunk cost and hence irrelevant.  
  • The annual interest expense of $1,000,000 is a financing cost and hence not considered in decision making.
  • Only incremental selling, general and administrative expense = $6,000,000 -1,000,000 = $ 5,000,000 will be considered relevant and hence included in capital budgeting.
  • Marginal tax rate of 30% should be considered

I will show you two snpashots. The first snapsot will have the figures and answers. The second snapshot will be in formula mode so that you know how to create this model at your end.

Snapshot 1

Please see the table below. All financials are in $.

Year, n                     -                         1                     2                      3                       4                      5                     6                     7
Sales     30,000,000    31,800,000     33,708,000      35,730,480     37,874,309 40,146,767 40,949,703
y-o-y growth 6% 6% 6% 6% 6% 2%
COGS     21,600,000    22,896,000     24,269,760      25,725,946     27,269,502 28,905,672 29,483,786
S, G & A expense        5,000,000      5,000,000       5,000,000        5,000,000       5,000,000      5,000,000      5,000,000
Depreciation        1,800,000      1,800,000       1,800,000        1,800,000       1,800,000                    -                      -  
EBIT        1,600,000      2,104,000       2,638,240        3,204,534       3,804,806      6,241,095      6,465,917
Taxes           480,000         631,200          791,472           961,360       1,141,442      1,872,328      1,939,775
Unlevered net income        1,120,000      1,472,800       1,846,768        2,243,174       2,663,365      4,368,766      4,526,142
Working Capital Calculations
Inventory        4,579,200      4,853,952       5,145,189        5,453,900       5,781,134      5,896,757                    -  
Account Receivables        4,770,000      5,056,200       5,359,572        5,681,146       6,022,015      6,142,455                    -  
Account Payables        3,434,400      3,640,464       3,858,892        4,090,425       4,335,851      4,422,568                    -  
NWC level       6,000,000        5,914,800      6,269,688       6,645,869        7,044,621       7,467,299      7,616,645                    -  
Change in NWC       6,000,000            -85,200         354,888          376,181           398,752          422,677         149,346    -7,616,645
CF due to change in NWC      -6,000,000             85,200        -354,888         -376,181          -398,752         -422,677       -149,346      7,616,645
Unlevered Cash flows
Unlevered Net Income        1,120,000      1,472,800       1,846,768        2,243,174       2,663,365      4,368,766      4,526,142
[+] Depreciation        1,800,000      1,800,000       1,800,000        1,800,000       1,800,000                    -                      -  
CF due to change in NWC      -6,000,000             85,200        -354,888         -376,181          -398,752         -422,677       -149,346      7,616,645
CF from capital expenditure      -9,000,000
Free Cash flows -15,000,000        3,005,200      2,917,912       3,270,587        3,644,422       4,040,687      4,219,420 12,142,786
Year 5 terminal value     23,441,225
Discount factor 0.833 0.694 0.579 0.482 0.402 0.335
FCF present value -15,000,000        2,504,333      2,026,328       1,892,701        1,757,534       1,623,862
NPV        4,225,259

Snapshot 2

Related Solutions

Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability...
Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending $500,000 on the research of the potential market for the new chemical, Canyon Buff is considering a project that requires an initial investment of $9,000,000 in manufacturing equipment. • The equipment must be purchased before the chemical production can begin. For tax purposes, the equipment is subject to a 5-year straight-line depreciation schedule, with a projected zero salvage value....
Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability...
Canyon Buff Corp. has developed a new construction chemical that greatly improves the durability and weatherability of cement-based materials. After spending $500,000 on the research of the potential market for the new chemical, Canyon Buff is considering a project that requires an initial investment of $9,000,000 in manufacturing equipment. • The equipment must be purchased before the chemical production can begin. For tax purposes, the equipment is subject to a 5-year straight-line depreciation schedule, with a projected zero salvage value....
A new chemical process has been developed for producing gasoline.  The company claims that this new process...
A new chemical process has been developed for producing gasoline.  The company claims that this new process will increase the octane rating of the gasoline. Sixteen samples of the gasoline produced with the new process are selected at random and their octane reading were: 94, 93, 97, 92, 96, 94, 95, 91, 98, 95, 92, 91, 98, 95, 92, 91, 95, 96, 97, 93. If the mean octane using the existing process is 93, is the company's claim correct (use 1%)...
Assume a brilliant health economist has developed a plan that will greatly improve the efficiency of...
Assume a brilliant health economist has developed a plan that will greatly improve the efficiency of the U.S. health care system. Explain why this, or anything close to it, would be unlikely to be adopted in the United States. (Hint: Think about who would be interested in preserving the status quo and why).
A pharmaceutical company developed a new revolutionary diet pill, “fat buster,” which is believed to greatly...
A pharmaceutical company developed a new revolutionary diet pill, “fat buster,” which is believed to greatly help people with losing weights. They conducted an experimental study to assess its relative effectiveness, comparing it with a currently popular diet pill in the market. A random sample of 28 participants were split into two groups: People in Group A used this company’s “fat buster” and those in Group B used a competing diet pill, “fat killer.” After taking the pills for 6...
1. The Sturgeon Corp. has developed a new line of spinning reel it plans to produce...
1. The Sturgeon Corp. has developed a new line of spinning reel it plans to produce and sell in the United States. The cost of the necessary equipment will be $2.8 million plus $340,000 for installation and delivery. The equipment falls into the MACRS 7-year class. The equipment will be scrapped when the project is finished in 5 years for an estimated $700,000. Sturgeon estimates that sales in the first year of production will be 110,000 units at $30 apiece....
The Asian Carp Corp. (ACC) has developed a new line of spinning reel it plans to...
The Asian Carp Corp. (ACC) has developed a new line of spinning reel it plans to produce and sell in the United States. The cost of the necessary equipment will be $835,000 plus $37,000 for installation and delivery. The equipment falls into the MACRS 5-year class. The equipment will be scrapped in 5 years for an estimated $100,000. ACC estimates that sales in the first year of production will be $750,000, and due to intense marketing and word-of-mouth advertising, they...
The Baily Corporation has developed a specialized software program that improves inventory control capability. The following...
The Baily Corporation has developed a specialized software program that improves inventory control capability. The following table/information provides the necessary data to evaluate: Quarter Forecast (units) Regular Time Overtime Sub-Contract 1 500 400 80 100 2 750 400 80 100 3 900 800 160 100 4 450 400 80 100 Initial Inventory = 200 units Regular Time Cost = $2.50/unit Overtime Cost = $1.00/extra per unit Subcontracting Cost = $4.00/unit Carrying Cost = $.50/unit Back-Order Cost = $.75/unit The company...
Plutarch Corp. has recently developed a new product which is the first of its kind. Plutarch...
Plutarch Corp. has recently developed a new product which is the first of its kind. Plutarch expects this will give it a significant first mover advantage in the market and that is expected to provide growth in earnings per share of 400% within the coming year, and 75% growth in each of the subsequent 3 years. After that time, it is expected competitors will have developed and brought to market similar products with the result that Plutarch would expect earnings...
At the beginning of 2018, Heinz Corp. started construction on a new office building. Construction expenditures...
At the beginning of 2018, Heinz Corp. started construction on a new office building. Construction expenditures during 2018 were as follows: January 1                     $400,000 May 1                          150,000 July 1                         300,000   December 31               100,000    Heinz has the following debts outstanding during 2018; the bonds payable is directly related to the construction projects; none of the others are related to the construction project. Liability Annual Percent Loan Amount Notes Payable 4% $200,000 Bonds Payable 6% $400,000 Mortgage Payable 5% $300,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT