Answered step by step
Verified Expert Solution
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 publiclytraded 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 debttoequity ratio.
Company Selection: Choose a Moroccan company listed on the Casablanca Stock Exchange. Download the returns from a period of to years Monthly returns: for data, you can use the website wwwinvesting.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 riskfree rate eg 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 AfterTax: Find the current interest rate the company is paying on its debt The YTM reported by the company Adjust this rate to reflect the aftertax 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 debt and 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started