Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use Excel and show all formulas. Suppose you have been hired as a financial consultant to Raytheon Company (RTN), a large, publicly traded firm

Please use Excel and show all formulas. Suppose you have been hired as a financial consultant to Raytheon Company (RTN), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. You need to advise them whether to take the project or not. Calculate the Payback Period, NPV, and IRR for the project and determine whether they should take the project or not.

1. The company bought some land three years ago for $3.7 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. The land was appraised last week for $4.5 million.

2. In five years, the after tax value of the land will be $4.9 million.

3. The plant and equipment will cost $21 million to build.

4. The manufacturing plant has an eight-year tax life, and RTN uses straight-line depreciation. At the end of the project, the plant and equipment can be scrapped for $3.7 million.

5. The project requires $1,100,000 in initial net working capital investment to get operational.

6. The plan is to manufacture 13,000 RDSs in the first year and sell them at $10,400 per machine. The following 4 years, the number to be produced grows by 15%, 20%, 25%, and 25% annually, i.e. year over year. We will continue to sell them at $10,400 each year.

7. The company will incur $6,000,000 in annual fixed costs, and the variable production costs are $9,000 per RDS in the first year. The following 4 years, variable production costs will grow at a rate of 5%, 3%, 2%, and 2% annually, i.e. year over year.

8. RTNs tax rate is 35 percent.

9. RTN's WACC is 9.52 percent

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers Merging The Heart With The Dollar Merging The Heart With The Dollar

Authors: J. Michael Leger, Janne Dunham-Taylor

4th Edition

1284127257, 978-1284127256

More Books

Students also viewed these Finance questions