Please help me with the attached question.

Thank you

Part A I have designed three different portfolios (see below). Using these sample portfolios, please complete the following: 1. Calculate the range of expected returns for each portfolio in Excel. 2. For each investment, discuss the risks generally associated with the investment. Be sure to explain how these risks influence the investment's range of returns. Portfolios: Investments Range of returns Portfolio 1 Portfolio 2 Portfolio 3 2% to 3% 33% 10% 10% Fixed income government or low risk (high credit quality) corporate bonds 3% to 6% 33% 40% 20% Publicly traded common shares paying dividends 8% to 15% 34% 50% 40% Private company shares - 0% to 25% no dividends paid in previous years 0% 0% 30% 100% 100% 100% Bank term deposits Total Your response should not exceed one and a half pages, not including Excel. Part B: Consider the information Lisa provided on Modern's expansion into the U.S. and discuss how the company is exposed to fluctuating foreign currency, and the impact on the income statement. To help Lisa understand: Describe the impact Modern would see if the US$ to C$ exchange rate changed from US$1 = C$0.95 to US$1 = C$1.10. Briefly discuss how the company may use the following derivatives to hedge its exposure: forward contracts, future contracts, and options. Conclude on a derivative for Modern to manage its risk, with support. Your response should not exceed two and a half pages for Part B. Investments Bank term deposits Fixed income government or corporate bonds portfolio 1 Range of returns expected returns 2% 0.66% 3% 0.99% 3% 4% 6% 0.99% 1.32% 1.98% Publicly traded common shares paying dividends 8% 9% 10% 11% 12% 15% 2.72% 3.06% 3.40% 3.74% 4.08% 5.10% Private company shares - no dividends paid in previous years 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Portfolio 2 Portfolio 3 expected returns expected returns 0.20% 0.20% 0.30% 0.30% 1.20% 1.60% 2.40% 0.60% 0.80% 1.20% 4.00% 4.50% 5.00% 5.50% 6.00% 7.50% 3.20% 3.60% 4.00% 4.40% 4.80% 6.00% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0.3% 0.6% 0.9% 1.2% 1.5% 1.8% 2.1% 2.4% 2.7% 3.0% 3.3% 3.6% 3.9% 0.4% 4.5% 4.8% 5.1% 5.4% 5.7% 6.0% 6.3% 6.6% 6.9% 7.2% 7.5% Investments Bank term deposits Fixed income government or corporate bonds portfolio 1 Range of returns expected returns 2% 0.66% 3% 0.99% 3% 4% 6% 0.99% 1.32% 1.98% Publicly traded common shares paying dividends 8% 9% 10% 11% 12% 15% 2.72% 3.06% 3.40% 3.74% 4.08% 5.10% Private company shares - no dividends paid in previous years 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Portfolio 2 Portfolio 3 expected returns expected returns 0.20% 0.20% 0.30% 0.30% 1.20% 1.60% 2.40% 0.60% 0.80% 1.20% 4.00% 4.50% 5.00% 5.50% 6.00% 7.50% 3.20% 3.60% 4.00% 4.40% 4.80% 6.00% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0.3% 0.6% 0.9% 1.2% 1.5% 1.8% 2.1% 2.4% 2.7% 3.0% 3.3% 3.6% 3.9% 0.4% 4.5% 4.8% 5.1% 5.4% 5.7% 6.0% 6.3% 6.6% 6.9% 7.2% 7.5%