Assignment help for M. Sc. Finance

CFA Research Report Rubric

Business Description:  Max points 5

Did team address the major components of the company’s business strategy?  Was each operating segment covered? What does the business do? What is the growth of the business? Who their customers (end users) and what is their condition? Make sure you cover each business unit.  Make sure you cover each region of business. Maybe: the major shareholders here.

This section of the report sets the baseline for the rest of the report. Make sure we study each business section and each geographical market in detail. Try to determine where and (if) growth is coming from.

We will use a levered beta for each business segment and ERP for each business region. We will determine weights. 

Industry Overview and Competitive Positioning:  Max points 15

What are the macro trends impacting the business? Discuss how the company is positioned globally and discuss the global environment for growth? What are the factors affecting the industry and how do they impact the target company? What is the overall market growth rate? Who are the company’s main competitors? How is this company different than their competitors? What is the power of suppliers? What is the power of the end-users? Does the company have any competitive advantage? Must show peer analysis. What are the industry drivers and industry structure? A very detailed discussion of the companies competitive positioning should be placed here (not in the investment summary). A strong discussion of industry factors and trends is needed here. Where does company fit? How fragmented is the industry? Locate both public and private competitors.  What is the source of the company’s or industry’s value?  What factors drive the industry? Really, understand how the business runs.

How does this company differential itself?  How does that add value? Talk about the company’s peers. Where does company fit?  Porter 5 forces and SWOT.

Investment Summary: Max points 20

This section must tie in to all others and must really support the buy or sell opinion.  Why did we use what we used?  Why does company trade at a discount or premium to the market multiples?  It the market wrong.  Will their historical multiple change? Why? We really need to have a “why” for each item.  Never use a DCF and market multiple exit together.  One or the other.  This section, and the next two, has the highest maximum points on the rubric. Great detail is needed on these three sections. The team must address and justify its buy (outperform or overweight), hold (neutral), or sell (underperform or underweight). Somewhere in this paper I would like to define our view of what a buy, sell, or hold means. Detail! Did we address and forecast changes in gross profit margin, operating profit margin, interest expense, tax rate, dividend policy, share buyback policy, capital expenditures, research and development spending, management changes, and mergers and acquisition possibilities? Is this a good company? Is this a good stock? Differentiate between these two positions. This could be a good spot to mention risks. Don’t just list the risks; try to quantify the probability and the impact of occurrence. Use and incorporate managements language from their earnings calls. What is management’s guidance for revenue and EPS; does our estimate deviate from management? Why?  Fewer inputs are better, no black box.  What are the key drivers?

Valuation: Max points 20

According to Aswath Damodaran the big three in valuation is 1) capacity to generate cash flows 2) expected growth rate of these cash flows and 3) uncertainty of these cash flows. Must model long-term organic growth given recent business trends. What are the weights of each valuation method; how did the team determine the weights. Must have a relative value valuation, a discounted cash flow valuation, and a PE multiple valuations. If applicable, team could use a sum of the parts valuation or an under value asset valuation. Must have multiple pricing models to improve the target price and valuation. Must show intrinsic value in our one-year price target to justify our buy, sell, hold. Show multiple methodologies! Discuss WACC. What is the consensus estimates? How does our estimate relate?  Do we value company with a higher P/E multiply than the street? Why? When using a DCF model do not have a terminal growth rate greater than the risk free rate. Some companies may grow at a faster rate long run than the risk-free rate but it is infrequent. Lower the risk rate during the terminal growth period.  Betas tend to run towards 1 in the long run. Also think about changing the debt weightings during the terminal period to a more traditional waiting. When working with beta we can use historical information, but it might be better to use some other forward-looking beta estimate. We could use a sector average or we could look at each business segment and assign a beta to each segment and use a weighted average. What are the company’s historical PE multiples. Compare the historical PEs to the S&P and to the sector. Doesn’t typically price at a PE multiple premium or discount? Where does it stand now? Describe how you determine the weights when using several valuation methods. For relative valuation I would like to see current PE, forward PE, price-to-book, enterprise value to EBITDA, and enterprise value to sales compared to the target companies competitors and peers. We should consider using the median value instead of the average or show both. We should consider throwing out outliers, but discussing our rationale. Intuitively, firms with higher growth rates, less risk, and greater cash flow potential should trade at higher multiples. Does our company justify a higher or lower multiple than the averages? In the simplest discounted cash flow model for equity which is stable growth dividend discount model, the value of equity is: Po = D1/k – g . Dividing both sides by net income (E) we obtain the discounted cash flow equation specifying the PE ratio for the stable growth firm. The key determinants of the P/E ratio are the expected growth rate in earnings per share, the cost of equity, and the payout ratio. All things remaining equal, we would expect higher growth, lower risk, and higher payout ratio firms to trade at higher multiples of earnings and firms without these characteristics. 

For relative valuation can we look at the companies PEG ratio versus its peers or sector? The key to relative valuation is finding comparable firms and adjusting for differences between the firms on growth, risk, and cash flows.

I would love to come up with a regression analysis with a macro-variable.  Multivariate regression model (etc. P/E should be x based on ROE, P/B,) for relative valuation. 

Smoothed or normalized earnings to account for cyclicality.

Are there unutilized or underutilized assets?  Add values because they do not show up in DCF.  Underfunded pension liability? Option values? If our intrinsic valuation is significantly off the market price, we really need to have a justification.  Monty-Carlo simulation on macro factors.  Always site references.  Dividends, share repurchase, acquisitions, cap-ex, R&D, debt pay down, what are they doing with cash? How does that effect price and value?  Is this good or bad?

Calculate ROC EBIT (1-t)/ BV of debt + BV of equity – cash.  What is ROC – WACC?  Is it positive?  That is the company’s competitive advantage.  Where do these excess returns come from?  Adjust ROC and BV for research and development costs; capitalize R&D.  Did the company have write-offs?  Write-offs will improve ROC; it will be overstated.  Take write-offs out. Goodwill may understate ROC; try to adjust.  Make sure leases are in book value of debt.

Was the last year’s EBIT a one-time event? Can we normalize EBIT?

Does the company take on good projects? This is the key to success with their future reinvestments. In 1/3 of all companies, ROC is less than WACC.  1/3 ROC = WACC and 1/3 ROC > WACC.  Do not be overwhelmed if ROC = < WACC. Remember, ROC is an accounting number. Is the accounting is misleading?

DCF.  Capital expenditures, acquisitions adjusted research and development and changes in working capital are cash outflows. Depreciation and amortization are cash inflows.

Capex depreciation analogy, calories consumed vs. calories burned off.

Cost of debt.  Try to create a synthetic rating using interest coverage ratio and NYU page.  Then apply appropriate spread.  Always use market values for equity and debt.

Financial Analysis: Max points 20

Be consistent. What do financial ratios mean for the business? How do they compare to the competitors? (Without comparing to competitors ratios are meaningless) Compare ratios to companies past; is there a trend? Looking for what the future holds. Ratio analysis must be compared to peers and the company’s trend. What is the financial model and scenario analysis? Monte Carlo simulation? Make sure to model of future financing needs.  Really, need to put it all together here. Peers? Did were spend enough time segments?

Investment Risks: Max points 15

The team should highlight all risks including risks other than economic, such as political, operational, and execution. Interest rate risk, leverage risk, integration risk, and risk of management change are crucial to this section. Also, cover inflation risk such as the company’s input costs and if the company would be able to cover this cost by raising prices.  Explain each risk the industry faces and how it effects company.  How serious is this risk (high, med, low).  Try to get something in each section of the rubric that is not in the standard 10-k filing.

Credit, liquidity, strategic, operational risks.

A failure to integrate acquisitions successfully. Pricing pressure from large customers. Rising interest rates. Macro – headwinds. Unfavorable regulatory policies. Unfunded pension liabilities – pension fund spending.

Corporate Governance: Max points 5

Describe and highlight the board structure in executive compensation. Try to do an analysis on how “good” the company’s corporate governance actually is. Discuss structure, independence and compensation of the board. Try to include an external metric on risk.  Are they better or worse than peers are?  Does this help or hurt valuation? ESG.  Any major changes here? How does change impact valuation?

Oral presentation

Try to have all members provide some answers. Be very prepared to talk about the company’s competitors. Stay on time!  Example: we mentioned that MTB had a good corporate governance policy.  They asked, “Is it better than their peer group?” They then asked, “How does that add valve to stock?”

Questions

What company acquisitions were good and bad? Were they accretive or dilutive? Were estimated synergies accomplished?

What is the company’s dividend policy? Do you see this changing going forward?  How about buy backs?

What are the company’s competitors how is their performance?

How does the currency exchange rate impact the company? How would a change in the exchange rate impact the company? Is currency exchange listed in the risk section?

Is management confident?

Does the company allocate capital correctly?

What is the company’s competitive advantage?

How much money does the company have in other countries?

Corporate Finance tips

For CAPM Beta
Taken individual beta for each stock and multiplied it with the weight of each stock in the portfolio. Sum up the product of each stock beta and its weight to get CAPM BETA

Total risk
Calculate the variance and covariance matrix using covariance in the data analytics option. Perform Mmult function for the transpose of the weight matrix, covariance matrix and then gain with weight matrix without transpose. You will get the total risk of the portfolio.


Systematic risk
Calculate the portfolio expected return then divide it by market return

Idiosyncratic risk
Sum of the variance of all the stocks divided by the number of stock

R-square
Calculate the correlation of each stock with the market and multiply it with the weight. Do summation of the square of the product.

Corporate Finance Tips

Average historical return is the average monthly return of the portfolio. The expected return of a portfolio can be calculated by multiplying the monthly return of each stock with its respective weight in the portfolio. Summing the above product, that was calculated for each stock return and its weight.


Sharpe ratio is the excess return we are getting on the financial product for every unit of the risk we are taking. TO calculate the Sharpe ratio we need to calculate excess return (portfolio return – risk-free return) and divide it with the standard deviation of the portfolio return.

Relative Sharpe ratio is portfolio Sharpe ratio dived by market Sharpe ratio. One we will calculate the portfolio Sharpe ratio, we will calculate the market Sharpe ratio ((market return – risk-free return)/standard deviation of the market return) and then get the value of relative Sharpe ratio by portfolio Sharpe ratio/market Sharpe ratio.


Jensen’ alpha = (return of portfolio-risk free return)/ (beta of portfolio multiplied to market return – risk
free return).

Corporate Finance Assignment

Instructions:

1. Download BOTH the Assignment Question file and Data file to complete your assignment.

2. Use Microsoft Word for the main assignment

3. Use Microsoft Excel wherever possible for numerical calculations and graphs/plots.

4. Copy and paste Excel outputs (e.g. plots, tables) into your Microsoft Word document (to protect the formatting of Excel output, use the “paste as picture” option in Word.

5. Submit the completed assignment (as a Word document) electronically via “Written Assignment Submission Point: Word Document ONLY” in the Assessment Task 2 folder.

6. Submit the Excel file used for calculations/estimations electronically via “Excel Workbook Submission Point” under Assessment Task 2 folder.

7. Keep a hard copy of the submitted assignment, in case there are problems with the electronic submission.

Important Notice:

  1. Any answer in the Excel document, but not in the main Word document will NOT be marked.
  • As this is an individual assessment, students should submit their own assignment. All assignments submitted will go through a matching process. If found to have cheated/plagiarised, all submissions will receive a mark of zero for this assessment item. It is up to you to keep your assessment confidential.

This Assignment consists of 4 parts. Attempt all parts.

Consider the following scenario:

You will be asked a series of questions to guide your analysis. You will need to manipulate the data to answer the questions below. Some Excel formulas are provided in the worksheet.

Part 1: Average returns [5 marks = 3 + 2 marks]

Compute the monthly return on the shares of each company and the ASX200 index by using the following formula:

where  is the share price (or the value of ASX200 index) in time period . (Please note that you lose the first observation when calculating returns.)

(a) Using the monthly returns, calculate the average return on shares of each company from February 2015 – December 2017. Compare them with the average return on the ASX200 index.

(b) Suppose an investor created an equally weighted portfolio of these five companies (i.e. invested 20% of funds in each company). What would be the average return on the portfolio? Explain how you derived your answer.

Part 2: Volatility [9 Marks = 2 + 2 + 5 marks]

(a) Calculate the standard deviation of returns for the five companies. What does the standard deviation tell us about the overall risk of these companies?

(b) Compute the standard deviation of the equally weighted portfolio of these five shares. How does it compare to the standard deviation of the individual companies?

(c) How does the standard deviation of returns of the ASX200 index compare with that of individual shares and the equally weighted portfolio? Provide a brief explanation.

Part 3: Beta’s [6 Marks = 3 + 3 marks]

(a) Based on the data provided find an estimate of beta for each company.

For this you will have to first calculate the covariance of a company’s returns with the ASX200 index. Use the following formula in excel:

Beta’s can then be calculated by

(b) Briefly explain why each company has high/low values of beta.

Part 4 Forecast & Investment strategy [10 Marks = 7 + 3 marks]

The research department of Tri-Star Management has come up with the following forecast of the share prices and the ASX200 index for the month of June 2018:

They have also concluded that in 2018, the annual risk free rate is going to be steady at 1.5%.  

(a) Based on the forecasts given above, write a short report for the clients of Tri-Star Management. Your report should be approximately 500 words long and contain: (i) an assessment of risk of each company, (ii) an evaluation whether a share is overpriced, underpriced or correctly priced and (iii) your recommendation regarding investment in these companies.

(b) Would you recommend the clients of Tri-Star Management to invest in an equally weighted portfolio of these five companies? Provide a brief explanation.