Week02Assignment-Part2-Question4.xlsx

Sheet1

Question 4.
Week 02
World Equities:
S&P 500 (level) 2,472
NASDAQ Composite (level) 6,429
FTSE 100 (level) 7,431
Shanghai Composite (level) 3,361
Exchange Rates:
Euro/U.S. Dollar exchange rate ($ per Euro) 1.19
U.S. Interest Rates:
U.S. 3-month T-bill yield (%) 1.01%
U.S. 10-year T-note yield (%) 2.12%
Commodities:
London p.m. fixing price of gold ($) $1,312
Crude oil ($) $47
U.S. Economic Indicators:
Latest inflation rate (U.S. CPI) 1.70%
Latest unemployment rate (U.S.) 4.30%
Your Financial Market Data:
stock from Assignment table (AMAT) $45.12
financial/market variable #1 market direction
financial/market variable #2 quality of earnings