Calculate the present value and net present value

Assignment Help Financial Management
Reference no: EM13907549

Use the process and cost information provided below to assess the feasibility of the following pollution prevention projects using (only) the TCA balanced approach and the spreadsheets provided (please see the attached file).

1) Use the provided information to fill in the tables. Calculate the capital costs of each alternative, total operating costs, and incremental cash flow.

2) Calculate the present value (PV) and net present value (NPV) for each alternative.

3) Use the qualitative information provided in the background and quantitative results calculated to answer the following questions:

a. Is either option financially feasible?

b. Which is the more attractive option, and why?

Background Information:

You are the EHS manager at Tightwove Fabrics, Inc, a small, privately owned, textile dye shop providing dyed and finished fabrics to a variety of sportswear and garment companies. Most dyeing equipment is 20-30 years old. Tightwove is located within an urban center and has very little spare floor space for new equipment. The company has been notified that its POTW pretreatment program is going to start regulating the shop's copper with a pretreatment discharge permit. You researched the cost of upgrading your onsite pretreatment system to meet the new standard and determined the NPV is $40,000 for the upgrade. Management doesn't like that number and wants you to research pollution prevention alternatives for meeting the new discharge limit for copper in their industrial pretreatment permit from their POTW.

You have been instructed to look at technologies for reducing or eliminating copper in the wastewater. A review of the processes, material safety data sheets, and dye bath recipes revealed two options:

1. Find a substitute for the copper dyes, or

2. Improve the dye/fabric adhesion efficiency.

You located vendors of chemical dyes and dying technologies and received these two proposals. The company's cost of borrowing capital (i.e. the "discount rate") is 12%.

Option 1: The Blue Sky Dye Proposal

Blue Sky Chemical Company provided you with MSDSs and samples of copper-free dyes, as well as a list of references. The dyes have no copper-based pigments, and use a zircon-based pigment. The literature said the new pigment was extremely lightfast and colorfast. Color swatches included in the sales material compared favorably with the color hues used at Tightwove. A higher operative temperature and the need for a hot rinse would require some modifications to the existing dye jigs. The sales rep said that the toxicity EPA is backlogged, so the evaluation of zircon's potential toxicity will take at least 4 or 5 years. Additional information includes the following:

Purchasing

• Blue Sky chemicals are 10% more expensive.

• Modifications to the heating lines and piping for new hot rinses will cost $33,000.

Environmental Management

• The lack of effluent limits for zircon will decrease the need to install improvements to the waste water pretreatment system and eliminate the annual permitting cost.

• The lack of toxicity information on this product raises concerns about worker acute exposure and chronic health effects.

• Blue Sky has a 5-year lifetime due to potential changes in regulations.

• There will be no change to the safety budget.

Engineering

• Increased temperatures in the tanks and feed lines may fatigue an already well-used system and could precipitate a rupture and spill.

• Annual maintenance costs will rise on the boiler that provides process heat ($3000 in labor time and $5000 in parts.)

• Some facilities using this chemical have found it difficult to maintain product quality.

Manufacturing

• Processing time (production) will decrease 5% due to shorter drying time and will save $6,250.

• The dying process would remain unchanged and not require retraining workers.

• Water use will decrease by 10% annually.

• Natural gas costs would rise by $2500 annually, but electricity should be unchanged.

Option 2: The Speed Jet Proposal

Speed Jet is a manufacturer of ultrasonic assisted dye jigs. The company claims its technology can achieve a 99.5% exhaustion and fixing of dye molecules to fabric, even after rinsing. Typically, exhaustion and adhesion are anywhere from 80-90% in a conventional operation like Tightwove. The Speed Jet operation would require considerable modifications to the process line. The entire process is one long unit, complete with an infrared drying system and a recirculating rinse and filter system. The vendor claims product quality improves because the ultrasonics force the dye into the fibres, resulting in a richer hue. This process was also given a 10-year lifetime. Additional information includes the following:

Purchasing

• The machinery will cost $250,000 and building alterations $85,000.

• Tightwove can continue to use the existing dye and would actually use 30% less.

Environmental Management

• There appears to be no new risk to workers from the self-contained units.

• It will cost $2000 to dispose of the old system.

• There will be no change to the safety budget.

Engineering

• Processing a variety of jobs with this unit may raise scheduling issues and require more careful monitoring of individual runs.

Manufacturing

• Workers are concerned that some will lose their jobs. There is skepticism that this technology can work.

• Maintenance on this system is estimated at $1000/year in labor and $750/year in parts, and may require out -of-shop specialists.

• Production costs would decrease through faster processing (production) time, providing a 7% annual cost savings.

• Water use would decrease by 25% due to a more efficient system.

• Electrical use will rise to $8,000/year.

• Natural gas usage will be reduced by $5000/year.

Hint: There's nothing tricky here. Just watch your whether things are reduced "to" or "by" and double-check your answers after each calculation to make sure they make sense. Watch those signs, and only use formulas with cell identifiers (instead of numbers) to avoid miscopying.

Attachment:- data.xlsx

Reference no: EM13907549

Questions Cloud

Sales representative and sales amount : Write a project in visual basic to design a suitable form to allow the uses to enter name of sales representative and sales amount and then calculate and display commission. Commission is 7% of sales amount if sales amount exceed Ringgits 60000 ot..
Determine the present value : Determine the present value of $5,000 is received in the future at the end of each indicated time. In each of the following situations 5% for 10 years 7% for 7 years 9% for 4 years
Determine the budgeted overhead absorption rate for machine : Determine the budgeted overhead absorption rate for Machine Shop A. Determine the budgeted overhead absorption rate for Machine Shop B.
Make a description on how you would manage change : 1Make a description on how you would manage change using Leavitt's Diamond 2-describe how you would go about performing effective Impact Analysis Brainstorming sessions. What is the purpose of brainstorming with regard to this techniques; what five ..
Calculate the present value and net present value : Use the qualitative information provided in the background and quantitative results calculated to answer the following questions:- Is either option financially feasible and  Which is the more attractive option, and why?
Make the program as efficient as possible : Write a Forms application, using loops, that generates the following diamond pattern when the button is clicked. For your output, use a multi-line textbox with the TextAlign property set to Center. Make the program as efficient as possible! You ca..
How do you react to problems : How do you react to problems? Answer should be in your own words.
What is new price of the bond : A company issues a 10 year bond on par with a coupon rate of 6.5% paid semi annually. The YTM at the beginning of the third year of the bond is 8.4% ( 8 YEARS LEFT TILL MATURITY). What is the new price of the bond?
National center for healthcare leadership : Visit the websites of the following organizations and read about the organizations' missions and visions as well as about their leaders. National Center for Healthcare Leadership American College of Healthcare Executives

Reviews

Write a Review

Financial Management Questions & Answers

  Weighted average cost of capital be before the debt issue

Green Manufacturing, Inc., plans to announce that it will issue $2,000,000 of perpetual bonds and use these funds to repurchase equity. The bonds will have a 6-percent coupon rate. Green manufacturing currently is an all-equity firm. What will Green’..

  Annual cash flows of solar energy system

Tabulate the annual cash flows of a solar energy system that has an initial cost of $7,000 for a 12-year analysis. Also estimate the life cycle savings and the internal rate of return. The following economic parameters apply:

  Company using the free cash flow valuation model

Which of the following is the appropriate way to calculate the price of a share of a given company using the free cash flow valuation model?

  Ruby has purchased a new home that needs repair

Ruby has purchased a new home that needs repair. She has gained approval for a home improvement line-of-credit for $100,000 that she will use to fix up the house over three years. Interest on line-of-credit loans is only incurred on the amount borrow..

  Overview of financial management

Overview of Financial Management

  Real interest rates are generally higher than nominal rate

On average, a coupon bond will increase in value as it approaches maturity. A bond with a coupon rate higher than its yield is worth more than its par value. Real interest rates are generally higher than nominal interest rates.

  Required rate on equity and growth rate

Suppose that today's stock price is $33.9. If the required rate on equity is 19.8% and the growth rate is 3.2%, compute the expected dividend (i.e. compute D1)

  The dividend is expected to grow at constant rate

Boehm Incorporated is expected to pay a $1.50 per share dividend at the end of this year (i.e., D1 = $1.50). The dividend is expected to grow at a constant rate of 6% a year. The required rate of return on the stock, rs, is 15%. What is the value per..

  Agree with ASDs growth projections

ASD Corp. will pay a dividend of $1.15 on each of its common shares next year. The company has stated that it will maintain a constant growth rate of 4.2% per year forever. If you require 8.5% return to invest in ASD stock (and assuming you agree wit..

  Create single graph showing the price of bonds

Consider 3 Treasury bonds which pay semi-annual coupons. Bond A has 5 years remaining to maturity and a coupon rate of 10%. Using Excel, create a single graph showing the price of Bonds A & B for varying YTMs. Let YTM range from 0.5% to 18% per year ..

  What will be his after-tax yield to maturity

An investor purchases a 30-year U.S. government bond for $840. The bonds coupon rate is 10 percent and, it still had twelve years remaining until maturity. If the investor holds the bond until it matures and collects the $1000 par value from the Trea..

  Pledges to increase its dividend

Metroplex Corporation will pay a $3.80 per share dividend next year. The company pledges to increase its dividend by 3.0 percent per year indefinitely. If you require an 11.9 percent return on your investment, you will pay $___________ for the compan..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd