Estimate the expected return, Financial Accounting

Assignment Help:

Case study

Josephine

Josephine has just landed her first job out of graduate school.  She is lucky enough to be working for one of the Big Four, earning $50,000 per year.  She expects her salary to increase by 3% each year.  Josephine has a goal of retiring after 30 years and then traveling the world in retirement for 20 years.  Once she retires she will move all of her assets into Treasury Bonds earning 2%.  Josephine would pay for her post retirement lifestyle by drawing $82,000 each year from her 401K.  She will contribute 18% of her salary to the 401K each year.  Her 401K offers her the choice of low-risk bonds yielding 5% a year indefinitely and a stock portfolio that is considerably more risky, but expected to yield 9% per year on average. 

Design a long-term portfolio, with appropriate weighting between bonds and stocks, for Josephine that will achieve her goal of allowing her to draw $82,000 a year from her 401K each year for 20 years beginning 30 years from now.  You should construct a portfolio that would produce an "expected outcome" that gives her just what she needs (i.e., $82,000 a year for 20 years with nothing left at the end) with the minimum degree of risk possible.  For simplicity, assume that whatever portfolio you develop for her would be the same portfolio for the 30 pre-retirement years. 

What is the minimum rate of return that she would require?  You can use a trial-and-error approach or use Excel's Goal-Seek function.  What proportion of her portfolio should be in low-risk bonds and what proportion should be in stocks? 

Jim

Jim is a 59-year old carpenter.  He wants to retire next month on his 60th birthday.  He will receive an annual pension of $35,000 from his former employment.  He also has a tax deferred annuity (401k) currently valued at $250,000.  At the moment, his 401k is invested in just two stocks: He is 25% invested in Microsoft (MSFT), and 75% invested in McDonald's (MCD). 

Jim has calculated the beta of both stocks (relative to the S&P 500), the standard deviation of both stocks, and the covariance of the returns of the two stocks.  He has also checked the risk-free rate and he has estimated the return on the S&P 500.  His estimates are below.

                   Stock         Beta           Standard Deviation

                   MSFT       1.8                      68%                     

                   MCD         1.3                      46%   

Correlation (MSFT, MCD) =   0.0350

Risk-free rate = 1%

Expected return on the S&P 500 = 9%

A. Estimate the expected return on his current portfolio.

Estimate the risk associated with his current portfolio in terms of both the portfolio beta and the portfolio standard deviation.

B. Limited to the two stocks that Jim is already invested, develop a better portfolio for Jim.  That is, change the weighting on Jim's two stocks to try to get a higher expected return or a lower level of risk (as measured by the standard deviation).  You can use a trial-and-error approach or use Excel's Solver function.


Related Discussions:- Estimate the expected return

Significance in working capital cycle, For several firms trade payables - s...

For several firms trade payables - suppliers of goods and services - represent the major component of current liabilities the amounts owed by the company which have to be repaid wi

Cash budget, Beginning balance 24,000 cash Sales 250,000 Gross profit 45% o...

Beginning balance 24,000 cash Sales 250,000 Gross profit 45% of sales Accounts receivable increase by 24,000 Accounts payable increased by 51,000 Inventory increased by 98,000 Sell

Ex interest, what is ex interest accounting,uses,types

what is ex interest accounting,uses,types

Show the basis of weightings, Q. Show the Basis of weightings? (i) Both...

Q. Show the Basis of weightings? (i) Both costs of capital (Ke and Kd) as well as the WACC have been calculated using current   ex-dividend (ex-interest) market values rather t

Use the multi factor productivity ratio, Alyssa's Custom Cakes currently se...

Alyssa's Custom Cakes currently sells 5 birthday, 2 wedding, and 3 specialty cakes each month for $50, $150, and $100 each, respectively.. The cost of labor is $50 per hour includi

What is comparability, What is Comparability This quality would en...

What is Comparability This quality would enable users to identify changes in the business over time (for instance, trend in sales revenue over the past five years). It wou

Effect of winding up order-liquidation of companies, Effect of Winding-up O...

Effect of Winding-up Order The consequences of a winding-up order are: 1) Any disposition of the company's property and any transfer of shares is void, unless the court otherwis

Project Assistance, How do you create an Excel document with several financ...

How do you create an Excel document with several financial statements, all linked together with specific financial data?

Complete the cash flow spreadsheet, This lab assignment will correspond to ...

This lab assignment will correspond to developing a cash flow budget with an operating loan. There is on lab exercise listed below. Additionally, there are two assignment questions

Repayment of principal, a) Your company is planning to take $1,750,000 on a...

a) Your company is planning to take $1,750,000 on a 3-year, 10%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will sho

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd