could you show how to do this in excel Solve using Microsoft Excel...
50.1K
Verified Solution
Link Copied!
Question
Finance
could you show how to do this in excel
Solve using Microsoft Excel Upload your excel file in Black Board Econ. Prob. T-Bill Ultra Inc Repo American Foam Market portfolio Very week 0.1 8% -21% 28% 10% -13% Below average 0.2 8 -4 15 -10 1 Average 0.4 8 20 0 7 15 Above average 0.2 8 35 -15 55 19 Strong 0.1 8 50 -20 30 43 1. Calculate the expected return for each of the investment alternatives. 2. Calculate the standard deviation (SD) for each of the investment alternatives. 3. Calculate the coefficient of variation (CV) for each of the investment alternatives. 4. Assume a two-stock portfolio with $50,000 in Ultra Inc Inds. and $50,000 in Repo Men. Calculate portfolio return and portfolio standard deviation. 5. If someone invests 25%, 30%, 30%, and 15% of his/her investment on T-Bill, Ultra Inc, Repo, American Foam respectively, calculate the portfolio return and portfolio standard deviation. 6. If the market risk premium is 7% and beta for Ultra Inc is 1.4, what is the required rate of return? 7. If the beta for Ultra Inc is 1.3 and beta for Repo is .75, and you invest 50% of your total investment in Ultra Inc and rest 50% on Repo, what is the beta of your portfolio? what is the required rate of return on the portfolio
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
