The companies are as follow: Macy's, Microsoft, Amazon, Facebook and Apple. Make sure all 5 companies have been publicly traded with daily price data available in Yahoo Finance for at least the last 5 years. Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E.

Please provide information on the following (for each company): Company name, Ticker, CEO, Market capitalization, P/E ratio, Dividends, Competitor 1, Competitor 2, Competitor 3, Competitor 4, Revenue (most recent year), Revenue projection (current year), Revenue growth projection, EPS (most recent year), EPS projection (current year), EPS growth projection, Long-term credit rating.