Expected monthly return, Financial Management

In this exercise you will construct efficient portfolios with 5 risky assets using Excel's non-linear optimization routing "Solver". The questions are designed to be sequential and to lead up to the desired result. It is crucial to notice that you will be using past returns to estimate expected returns and risk. From Sakai download the file  data_question1.xlsx which contains monthly returns for AT&T, Ford, Google, Exxon Mobile, and Gold from 2005-2012. The monthly returns have been adjusted to reflect dividend payments and are provided in decimal form to make the necessary calculations easier.

a)  Using the monthly returns provided what is the expected monthly return for each asset and what is the corresponding standard deviation? In order to calculate the mean use the Excel function "AVERAGE"; in order to calculate the standard deviation use the Excel function "STDEV.S".

b)  We discussed in class that when we are analyzing the returns on a portfolio of assets, the covariance or correlations of each asset with the other ones will be crucial in determining the portfolio risk. Using the given monthly returns tabulate the pairwise covariances for each asset pair and tabulate the correlations for each asset pair. Use the Excel functions "COVARIANCE.S" and "CORREL".

Posted Date: 2/28/2013 5:53:21 AM | Location : United States







Related Discussions:- Expected monthly return, Assignment Help, Ask Question on Expected monthly return, Get Answer, Expert's Help, Expected monthly return Discussions

Write discussion on Expected monthly return
Your posts are moderated
Related Questions
CHROMEX PLC Payback period Payback period must be based on cash flows that is the cash generated from operations and the capital invested by Chromex. Profit is different f

Define the conversion and competitive effects of exchange rate changes on the company's operating cash flow. Answer:  The competitive effect: Exchange rate modifications may in

A Swiss Variable Rate Mortgage (SVRM) is a version of ARM which carries a coupon rate that a bank can change any time giving a notice of three m

The collaterals used in the repo market are high quality securities; but they are also not free from credit risk. In our earlier example, we see the dealer borrow

Q. Features of Capital Budgeting Decisions? Features of Capital Budgeting Decisions:- Moneys are invested in long-term assets. Moneys are invested in present times i

Q. Explain about Cash Flow Statement? Cash Flow Statement: - This is another process of cash management. A cash flow statement is the statement showing inflows as well as outfl

Q. Display the position explicitly Example: I borrow 7800000 HKD at time t = t 0 at an interest rate r t0 . After one year I pay back 7800000(1 + rt o ). At

What is the present value of an annuity that makes a quarterly payment of $37,110 for 11 years, assuming an annual yield to maturity of 5%?

Question 1: (a) Explain fully the following financial accounting techniques: i. Cash accounting ii. Accrual accounting iii. Fund accounting iv. B

What is the Ratio uses To compare results over a period of time To measure performance against other organisations To compare results with a target To compare against