Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. could you show how to do this in excel solve usi

could you show how to do this in excel Solve using Microsoft Excel...

50.1K

Verified Solution

Question

Finance

could you show how to do this in excel

image

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!
Become a Member

Other questions asked by students