Prince Mohammad Bin Fahd University

Spring 2020-21

Case Study/Project

Managerial Finance (MBA 5103)

Today: April 08, 2021

Submission deadline: April 18, 2021, 11.59 pm

Points: 25 (15+10) percent of the final grade

No Plagiarism

 

Instructions

 

According to the syllabus of the course, this is a group project. You already mentioned about your group. Have the same group for this case study. However, one group cannot consult with another group. You will submit by email attachment. It must be typed. You must show your work completely. Finally, make everything clear in your answer and do not assume that I will be able to read your mind. I will grade what I will see. Deadline will be not extended. Submission after the deadline will be subject to high  penalty.

 

I have chosen a particular company for each group. The list is given below. You will use the data of that company for this case analysis. You will use the latest data.

Part I

  1. For the first part, you need to find the weighted average cost of capital (WACC) of your company.
  2. You have already found the beta of your company (available also in finance.yahoo.com). Find the average risk-free rate and market return for the same period. For the risk-free rate use the treasury bond or bill rate. For the market, use S&P 500 return. Convert monthly return into annual return. From all the information above, find the expected return of your stock. You can also call it cost of capital for equity. (hint: you can use CAPM).
  3. Now, you need to find cost of debt of your company. Do some research to find the YTM of your company. It should be available in the internet.
  4. Next you need to know the weight of debt and equity in the capital structure. Go to finance and open the annual balance sheet of your company. It will give you information regarding the value of debt (use only long-term liability for simplicity) of your company. Total value of equity of your firm is the market capitalization (no. of shares outstanding times stock price). Total value of your firm is the summation of the value of equity and the value of debt.
  5. Assume average tax rate in the U.S. is about 25%.
  6. Once you have all the information, use the formula for WACC to find the cost of capital of your firm. This is the minimum rate of return your firm must make if any new project is accepted.
  7. What could happen to WACC if interest rates go up in the U.S.?
  8. President Biden is now considering imposing higher corporate taxes. If it really happens, then what will be the impact on the overall stock market and your company’s stock prices?

 

Part II

  1. It is a capital budgeting problem. Assume that XYZ company wants to invest in a new project that needs $2.65 billion (time 0). It is expected that it will give cash flows as given below.

 

Year 0

Initial Investment

Year 1Year 2Year 3Year 4Year 5-10Year 11Year 12-14Year 15
2,650 million-50 million0 million100 million200 million550 million400 million200 million-100 million

 

Find the NPV and IRR (or MIRR) of the project. Should you accept the project? Discuss in details why you accept or reject the project. Assume WACC is 10%.

  1. If the firm wants to reduce its WACC (from 10% to 8%), how should the company do it? (think about it, I am not helping in this question).

 

Group List (any group missing? – let me know quickly)

Student Name or IDCompany name
Ms. Fajer, Maram, Taja and Raghad

 

Pfizer
Mr. Moath, Majed, Mohammad AlKereshBritish Petroleum
Mr. Abdullah Alhamdan, Mohammad Al Subaie, Fahad

 

Wal-Mart
Mr. Ibrahim, Hamad, Osama, Loai

 

Bank of America
Ms. Abrar, Sara Al Benayyan, Mr. Ahmed Al Obaidullah, Hussain Al Sheikh

 

Royal Caribbean Cruise Line (RCL)
Mr. Abdullah Al Rashed, Mahdi, Bader, Hatem

 

United Airlines
Mr. Waleed, Abdullah Al Babtain, Ms. Sara (171), Rahaf

 

Intel
Mr. Yazeed Al Osaimi, Mohammad Al Subaie, Omar Al Qahtani, Mohammad Al HajriCoca Cola
  
  
  

 

Leave a Reply