Make return correlation matrix for non-cash assets classes

Assignment Help Finance Basics
Reference no: EM131932901

Question: Alfred has carved out a long and successful career as a human factors engineer with an integrated oil and gas company, Shale plc. The company has been under duress since WTI oil prices plunged from a peak of $107.45 per barrel in June 2014 to a low of $29.01 per barrel in January 2016. Although prices have recovered modestly, the general industry consensus is that prices will be "lower for longer" and Shale plc has been looking to trim excess fat in its operations.

In the past, Alfred was extremely conservative in his outlook and consciously plans for the future but, after his wife died three years ago due to a tragic car accident, he has been living life in the fast lane and firmly believes YOLO. He recently celebrated his 55th birthday with his only child, Isabelle, who is starting a four-year university program, with tuition and associated expenses estimated to be $40,000 a year. During her time at the university, she plans to run an artisanal cafe´ that requires an annual operating lease of $180,000 and other yearly operating costs of $70,000, but is expected to generate revenues of $330,000 per year. These annual cash flows are subject to income taxes and begin in a year but fitting-out costs for the cafe´ of $120,000 will be incurred immediately. Isabelle is asking for Alfred's support for half of the operating lease expenses and will proceed to run the cafe´ if her return on investment is at least 10% per year.

As Alfred was mildly inebriated during his birthday celebration, he promised his daughter not only to fund her university-related expenses but also to financially support her cafe´ venture as requested. He does not expect any return on these investments. The good news is that Alfred's annual income is $500,000 and is expected to increase by 5% per year. His annual living expenses is $100,000, expected to increase at the inflation rate of 3% per year. Alfred also makes annual payments of $200,000 towards an outstanding mortgage loan that will be fully paid off just when he turns 65, which is also when he will retire.

To date, Alfred has accumulated an investable wealth of $1,000,000 and would like his portfolio (excluding the value of his home) to grow to $3,000,000 by the time he retires. He insists that cash flow requirements not be funded by selling securities. You gather and present pertinent information about select asset classes and possible portfolios in Exhibits 1 and 2, respectively. Income and capital gains are taxed at 25% and 15%, respectively.

Exhibit 1. Capital Market expectations for select asset classes

no 1 asset class income yield capital gains covariance
1 2 3 4
1 cash 0.00% 0.00% - - - -
2 public equity 2.50% 9.80% - 0.0237 0.0026 0.0075
3 fixed income 5.00% 5.10% - 0.0026 0.0045 0.0011
4 hedge funds 0.00% 17.40% - 0.0075 0.0011 0.0052

Exhibit 2 prospective portfolios

no asset class portfolio weights
A B C
1 cash 10% 20% 40%
2 public equity 20% 20% 20%
3 fixed income 30% 60% 30%
4 hedge funds 40% 0% 10%





standard deviation 6.29% 5.64% 4.56%

(a) Compute the expected returns for each of the three (3) possible portfolios. State assumptions made, if any.

(b) Construct a return correlation matrix for the non-cash asset classes.

(c) Develop a portfolio for Alfred and justify your recommendation.

Reference no: EM131932901

Questions Cloud

What trading strategy will you recommend based your analysis : Estimate CAPM for each portfolio, and determine whether or not, you find any non-zero alpha that is significantly different from zero.
Wendy sold a commercial building to ann educated person : Wendy sold a commercial building to Ann an educated person, Ann merely half read the contract that she signed.
Most likely to result in positive cash flow to creditors : Which of the following is the most likely to result in a positive cash flow to creditors?
Proportion of customers that leave with a purchase : Construct a 90% confidence interval for the proportion of customers that leave with a purchase.
Make return correlation matrix for non-cash assets classes : Compute the expected returns for each of the three (3) possible portfolios. State assumptions made, if any. Construct a return correlation matrix.
Identify entities and attributes for your conceptual model : Identify the entities and attributes for your conceptual model. Identify the relationships between the entities. Define the entities and attributes.
Calculate the npv in mexican pesos : An American firm is evaluating an investment in Mexico. Calculate the NPV in U.S. dollars. Calculate the NPV in Mexican pesos.
Calculate a 95 confidence interval for µ : A random sample of 150 measurements was selected from a population with unknown mean µ and a standard deviation of 20. Calculate a 95% confidence interval for µ
Prepare a cost of production report : Prepare a cost of production report showing the number of equivalent units of production and The product cost per equivalent unit

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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