Construct a portfolio with an expected return consistent with the equity market using iBoxx High Yield ETF (HYG) and US Treasury 10-year bond. Assume you can invest and borrow at the risk-free rate.

Answer all section of question 1&2 using the attached excel spreadsheet. Show all answers on this sheet and your work on paper or on excel file uploaded to Canvas. Calculate the following (600 pts): Beta Expected Return =R QQQ 1.08 ?? SPY 1.01 ?? HYG 0.34 ?? XBT 0.0 ?? US-Treasury 0.0 0.8% Equity Risk Premium 1.0 5.2% Expected Market Return 1.0 6.0% Answer all section of question 1&2 using the attached excel spreadsheet. Show all answers on this sheet and your work on paper or on excel file uploaded to Canvas. Calculate the following (600 pts): Beta Expected Return =R QQQ 1.08 ?? SPY 1.01 ?? HYG 0.34 ?? XBT 0.0 ?? US-Treasury 0.0 0.8% Equity Risk Premium 1.0 5.2% Expected Market Return 1.0 6.0%