Question: I Show me the solution in excel with show the function Hedi Company operates in Health Care sector and experiences a high growth rate during

I Show me the solution in excel with show the function Hedi

Show me the solution in excel with show the function

Hedi Company operates in Health Care sector and experiences a high growth rate during COVID-19 pandemic outbreak. The financial manager asked you to evaluate the value of the share on December 31, 2020. The free cash flow (FCF) of the firm is $11,750,000. In 31 December 2020, the market value of debt is $5,000,000 and the cash is $1,500,000. The company has 200,000,000 shares outstanding. The Company experiences a high growth rate for the coming first five years of 25% thereafter it the FCF growth will slow to 7.5 % per year and forever. The cost of capital is 8%. The FCFs occur in midyear. 1) What is the share value of equity? 2) What is the value of equity if the cost Jf capital is 3%, 9%, 10%, and 14%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Exercise 3 Hedi Company operates in Health Care sector and experiences a high growth rate during COVID-19 pandemic outbreak. The financial manager asked you to evaluate the value of the share on...

BlackRock Inc (BlackRock) is an investment management firm that offers global investment management, risk management, and advisory services to institutional and retail clients. It manages assets on...

Can someone please help me with this I need it to be very lengthy compile all the following information about Great Plains, build a hypothesis about the current health of the company and suggest...

A Template for Use to Write Your Paper NOTE: This template modifies the standard Marketing Plan to adapt it to a Career Marketing Plan. You will use this for the BODY of your project and following...

The Stunning Rise and Fall of Keya Cosmetics In the 90s, as one of the main means of product promotion, companies used to advertise very attractive adverts on TV and radio. If you list them all, the...

summarize the main idea of each article, discuss issues being highlighted briefly, give opinion pertaining the coverage of each article and provide recommendations for each issue in the article....

The pandemic has caused the massive growth of public debt in many countries. With reference to the latest supply bill based on the research attached below devlop 4 research questions LO INTRODUCTION:...

The pandemic has caused the massive growth of public debt in many countries. With reference to the latest supply bill based on the research attached below devolpe four research questions LO...

Which factor has the largest variation? Is it A, B, or C? Given the following DOE, which factor has the largest affect on variation? A -1 -1 -1 -1 1 1 1 1 B -1 -1 1 1 -1 -1 1 1 -1 1 -1 1 -1 1 -1 1 Y...

You have the following financial market information. You also have 1.13 million Australian dollar (A$) or 3.70 million Thai baht (THB) to make a profit due to covered interest arbitrage (CIA)....

Select three articles from an issue of an arts/events journal and identify the basis of their choice of research topic.

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

You are offered a great job, but you have to relocate to a distant city. Your family agrees that the decision is yours to make, but you know they do not want to move. What do you do?

Your personal relationships: Are you closely connected to your family? Who are your friends?

3. When asked for advice for future entrepreneurs, Vickie Stringer said, Be patient, allow room for growth, build your company on a strong accounting system, and as always, dare to dream. How does...