Please solve this problem (step by step)
On July 28, 2023, Jerome Powell, the chairman of US Federal Reserve Bank (FED), hinted that the series of interest rate hikes could possibly continue to subdue inflation in the country. In July, the inflation rate reached 3.2% in the US, and the FED is determined to bring it down to the 2% target. This is a worrying sign for fund managers investing in fixed income securities. Suppose that a fund manager, who works for a reputable mutual fund in New York, is currently managing government and corporate bonds investments in his portfolio. The details of his investments as of August 2023 are in the table below: The current capital loss of the portfolio since inception is almost $13 million. The fund manager anticipates that the first hike in interest rate is expected to be between 25 to 75 basis points, which is likely to be announced in December 2023. The fund manager needs to anticipate the best- and worstcase scenarios and estimate the market value of each investment and the overall portfolio when the interest rate hike hits the market in December. The best scenario is when the interest rate increases by 25 basis points, and the worst scenario is when the interest rate increases by 75 basis points. Answer the following questions: 1.Explain why the fund manager is worried about the upcoming interest rate hikes. Elaborate on theoretical concept to the financial problem that the fund manager is currently facing. 2.Assuming the fund manager anticipates that the FED is going to increase the level of interest rates by 25 to 75 basis points every 6 months over the next two years, how could the fund manager benefit from such information to restructure the portfolio? Explain how the concept of duration could help the fund manager to manage his portfolio exposure to interest rate risk. 3.Use the table to calculate the bond duration of each investment, portfolio duration, and the expected percentage change in the market value of the overall portfolio for the best- and worst- case scenarios using technology tools such as Excel (Excel sheet is provided on BB), online financial websites such as www.exploringfinance.com, www.mymathtables.com, (select Macaulay duration) or any financial calculator application on mobile app stores. Use a snapshot of the results to provide evidence of your use of the technology tool. You must calculate the portfolio duration and the percentage change in the market value of the overall portfolio using the formulas below in Excel (you need to code them yourself). In calculating the change in the MV of the portfolio, assume the current level of market interest rate is 3%. DURporffolio=j=1n(wjDURj)%PDUR1+i1i2i1 4.Elaborate on the solution process and how you can advise the fund manager to act if the mutual fund has a policy that allows its fund managers to tolerate losses up to $4 million to each interest rate hike. Will you advise him to keep his portfolio as it is based on the expected worst-case scenario? Explain
