Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Objective: Select a publicly - traded Moroccan company and calculate its Weighted Average Cost of Capital ( WACC ) using Excel. This calculation will assume

Objective: Select a publicly-traded Moroccan company and calculate its Weighted Average Cost of Capital (WACC) using Excel. This calculation will assume the company is looking to raise capital for a new project with a specific debt-to-equity ratio.
Company Selection: Choose a Moroccan company listed on the Casablanca Stock Exchange. Download the returns from a period of 4 to 5 years (Monthly returns): (for data, you can use the website www.investing.com)
Gather financial information about the chosen company to calculate the following:
Calculate the Cost of Equity : Use the Capital Asset Pricing Model (CAPM) to calculate the cost of equity. This will require estimating the risk-free rate (e.g., yield on Moroccan government bonds), the market return (MASI index), and the companys beta (volatility of the stock in relation to the MASI index).
Calculate the Cost of Debt (After-Tax): Find the current interest rate the company is paying on its debt (The YTM reported by the company). Adjust this rate to reflect the after-tax cost of debt, considering the corporate tax rate in Morocco.
These information can be found in the company's financial statements, stock market data, and other financial reports (for data, you can use the website investing.com)
Assumptions: If you couldn't find the optimal capital structure of the selected firm, assume the company wants to raise capital with a capital structure of 40% debt and 60% equity.
Compute the WACC
Submission: Submit an Excel file that includes details of yourcalculations,

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Finance Book

Authors: Stuart Warner, Si Hussain

2nd Edition

1292401982, 978-1292401980

More Books

Students also viewed these Finance questions

Question

The FeatureManager is:

Answered: 1 week ago

Question

Explain global human resource management.

Answered: 1 week ago

Question

Describe the grievance procedure in a union environment.

Answered: 1 week ago

Question

Discuss whistleblower protection under OSHA.

Answered: 1 week ago