need saturday 0

– For your week 3 IP you are being given some information and asked to address the following: You have been asked by the director of finance to put together a plan to invest in other companies. Your plan will manage a mutual fund with a $20 million portfolio with a beta of 1.50. Assume that the risk-free rate is 4.50%, and the market risk premium is 5.50%. You expect to receive an additional $5 million, which you plan to invest in a number of stocks. After investing the additional funds, you want the fund’s required return to be 13%. What must the average beta of the new stocks added to the portfolio be to achieve the desired required rate of return? Attach your Excel file showing your calculations. In a Word document, explain the steps you used to arrive at your answers. What does your calculated beta mean to UPC? Should UPC be concerned about the use of betas in making investment decisions? Create your own excel worksheet and calculate the average beta of the new stocks to be added to the portfolio. Copy and paste this into a word document that has a cover sheet, an introduction, the table and in complete format explain the steps to your answer as well as the beta you calculated and its implications on the investments to UPC. Also, in detail answer the question Should UPC be concerned about the use of betas in making investment decisions, why or why not? Don’t forget to add references and citations. Review for spelling, grammar and punctuation before submitting.
 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.