You need the excel spreadsheet provided that has raw data for Raytheon Company and the Standard &…

Posted on | by Stevepiscles

You need the excel spreadsheet provided that has raw data for Raytheon Company and the Standard &….

You need the excel spreadsheet provided that has raw data for Raytheon Company and the Standard & Poors 500 Index.

Suppose you have been hired as a financial consultant to Raytheon Company (RTX), 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.

NOTE: I will post the remaining parts of the question in different questions (4 total). Thanks!

Date RTX S&P
5/1/2016 56.07634 2,096.95
6/1/2016 57.5543 2,098.86
7/1/2016 60.41658 2,173.60
8/1/2016 59.73187 2,170.95
9/1/2016 57.36799 2,168.27
10/1/2016 57.70678 2,126.15
11/1/2016 60.82361 2,198.81
12/1/2016 62.27816 2,238.83
1/1/2017 62.30656 2,278.87
2/1/2017 63.94279 2,363.64
3/1/2017 64.12897 2,362.72
4/1/2017 68.00379 2,384.20
5/1/2017 69.31255 2,411.80
6/1/2017 70.16838 2,423.41
7/1/2017 68.13419 2,470.30
8/1/2017 68.79503 2,471.65
9/1/2017 67.10844 2,519.36
10/1/2017 69.23594 2,575.26
11/1/2017 70.21297 2,647.58
12/1/2017 74.19282 2,673.61
1/1/2018 80.26458 2,823.81
2/1/2018 78.36278 2,713.83
3/1/2018 73.58158 2,640.87
4/1/2018 70.26567 2,648.05
5/1/2018 72.99676 2,705.27
6/1/2018 73.53207 2,718.37
7/1/2018 79.8308 2,816.29
8/1/2018 77.4548 2,901.52
9/1/2018 82.66363 2,913.98

You need the excel spreadsheet provided that has raw data for Raytheon Company and the Standard &…