How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Manal Elkhoshkhany Your Own Question

Manal Elkhoshkhany
Manal Elkhoshkhany, Tutor
Category: Homework
Satisfied Customers: 9512
Experience:  More than 5000 online tutoring sessions.
3708793
Type Your Homework Question Here...
Manal Elkhoshkhany is online now
A new question is answered every 9 seconds

TO BUSINESS TUTOR:QUESTION 1:You work for a major

Customer Question

TO BUSINESS TUTOR: QUESTION 1: You work for a major consultancy firms in corporate finance. Your firm has been approached by one of its major clients to assist them in solving a problem that they have. You have been assigned the task to solve the client’s problem. A shareholder of a firm is wondering what to do in the following situation. The firm is considering an investment that will have one of three EBIT next year: $2,000,000; $3,000,000 or $4,000,000. The issue that the shareholder wants your help with is concerning how to finance the investment. The firm has two possible ways of financing the investment; either by issuing new shares or by a combination of issuing shares and issuing bonds. If fully equity funded the firm will issue 200,000 shares and sell them at $100 a share. If the firm chooses to use debt as part of the financing it will only issue 100,000 shares at $100 and raise $10,000,000 by selling bonds at a yield of 12%. You are asked to do the following by the shareholder using a spreadsheet program: • Analyze the two capital structures for the three different EBIT-scenarios for the shareholder by calculating the EPS for the six possible outcomes. • Use the above to create a graph showing EBIT on the x-axis and EPS on the y-axis for the two capital structure alternatives so the shareholder can see how they relate to each other. • Solve for the break-even EBIT so the shareholder knows above what EBIT leverage is preferable. N.B. Since the client wants to be able to use this spreadsheet in the future for other projects as well you need to use cell references in the formulas.   QUESTION 2: You have also been approached by a friend who is evaluating an investment problem. Knowing that you have studied finance, you are asked to help him answering the below questions. Assume the following expected data on two assets: Return State Probability state Bond Stock Recession 30% 15% -10% Normal 40% 10% 0% Boom 30% 5% 20% The stated probabilities shall be changeable as well as the returns in the different states. Build a spreadsheet model to answer the following question: • What is the expected return of the assets? • What is the risk (variance and volatility) for the assets? • What is the correlation between the two asset’s returns? • Assume a portfolio of the two assets. What is the expected return on this portfolio (the user shall be able to change the percentage weight of the assets in the portfolio)? Use a 50%/50% weights to answer this question. • What is the variance and volatility for this 50%/50%-portfolio? • What is the efficient frontier for the two assets given the information in the table above? (Create a suitable graph depicting this.) • What is the minimum variance portfolio and what is the return of this portfolio, i.e. what fraction of the stock and the bond is it made up of? Use the information in the table above for this question. Hint: Use the solver in excel (include solver results) if you cannot solve this algebraically. N.B. Since the client wants to be able to use this spreadsheet in the future for other projects as well you need to use cell references in the formulas
Submitted: 2 years ago.
Category: Homework
Expert:  Manal Elkhoshkhany replied 2 years ago.

Hello

 

Please advise your deadline

 

Thank you

Customer: replied 2 years ago.

Hello,

 

The deadline is feb. 14th 2012,

 

This is the table for question 2

 

 

 

Return

State

Probability state

Bond

Stock

Recession

30%

15%

-10%

Normal

40%

10%

0%

Boom

30%

5%

20%

 

 

It did not show properly in the questions I sent.

Customer: replied 2 years ago.
Please let me know if you need more information.
Expert:  Manal Elkhoshkhany replied 2 years ago.

Nope :)

 

But I am helping someone with a timed assignment now, so please check tomorrow, if I need anything, I will tell you

 

Thanks a million

Customer: replied 2 years ago.
sounds great. Thanks
Expert:  Manal Elkhoshkhany replied 2 years ago.

You are welcome :)

 

 

Please do not respond to this message as this would lock me out of replying
to other posts .

 

Thank you for understanding :)

Expert:  Manal Elkhoshkhany replied 2 years ago.

Hello again

 

Sorry I did not get back to you earlier, but Please double check Case 1, the tax rate is not provided and that is a very important factor in the analysis. Please check with the instructor and advise me of his response

 

Thank you

Customer: replied 2 years ago.

ok, I will check and get back to you.

Expert:  Manal Elkhoshkhany replied 2 years ago.

Thank you :)

 

 

Customer: replied 2 years ago.
It is weekend so if I dont get the teacher online, It have to be on Monday. However am trying to see if I can get him . I hope that is fine.
Expert:  Manal Elkhoshkhany replied 2 years ago.

Sure. It is not due until the 14th and I have the excel sheet all filled out waiting for the tax rate only and it will be ready, so no problem :)

 

Customer: replied 2 years ago.
That sounds good. I did check last week and I was told that we can submit it on th 15th so that is fine.
Expert:  Manal Elkhoshkhany replied 2 years ago.

Great :) I will wait for your reply then :)

 

 

Customer: replied 2 years ago.

Hi,

 

Am wondering if you could let me know about the formula where the tax rate is required. I may then be able to compare it with the textbook's method and explain this to the instructor as well :).

Expert:  Manal Elkhoshkhany replied 2 years ago.

hello

 

You do not need the formulaCustomer and the instructor does not need you to explain why do you need the tax rate, but in any case, in case 1 you need to calculate the EBIT indifference level, here is the formula:

 

graphic

 

Customer: replied 2 years ago.

 

Thanks for your prompt response. I looked in my textbook and it states that EPS( Earning Per Share) is calculated as follows:

 

EPS = NET INCOME / SHARES OUTSTANDING

 

Can you look at this formula and see if it corresponds to the one you stated?

Expert:  Manal Elkhoshkhany replied 2 years ago.

I told you we need to calculate the EBIT indifference level not the EPS.

 

Customer: replied 2 years ago.
Ok, I'll consult the instructor and ask for the tax rate. I hope I can get him tomorrow and then I'll get back to you.
Expert:  Manal Elkhoshkhany replied 2 years ago.
Have you checked the formula I sent you? :) we need to calculate the EPS for the "All Equity" plan, and the EPS for "the Bond Plan" :)
Customer: replied 2 years ago.

Hi Sure,

 

I did check it. You are right. I will try and get the tax rate from the instructor tomorrow. I think they might have forgotten to include it in the question.

Expert:  Manal Elkhoshkhany replied 2 years ago.
Cool
Customer: replied 2 years ago.

Hi,

 

It wasn't me alone that was wondering about the tax rate issue. Other students had the same issue.

 

Well, the instructor responded that he deliberately left out the tax rate to simplify the analysis. That is to say, 'we should imagine a world without taxes.' This means that we should not take the tax rate in consideration when doing the analysis.

Expert:  Manal Elkhoshkhany replied 2 years ago.
Very strange !! Ok :)
Customer: replied 2 years ago.

I agree it sounds weird. What we can do is use the formula you wrote and then in place of 'tax rate' we put zero. so the (1-tax rate) in the formula will replaced by ( 1-0) and

then continue from there. This will make him realize that we used zero tax rate as he suggested.

Expert:  Manal Elkhoshkhany replied 2 years ago.

Yes :) That is correct :)

 

 

Expert:  Manal Elkhoshkhany replied 2 years ago.

I am done :)

 

Please click on the following link for the solutions:

 

http://www.box.com/s/phislzy49kf4byjejpvs

 

 

P.S. If you like my services, please feel free to direct your future posts to me specifically by typing "For BusinessTutor" at the beginning of your post. Should you choose to do this, please try to allow me 48 hours before the deadline. If you need to meet me online for a timed assignment, please advise me of the date and time (EST) you want me to meet you here and I will. Please make sure you take the length (and number) of the questions into consideration when making your offer to avoid delays in providing solutions.

 

Thank you




Expert:  Manal Elkhoshkhany replied 2 years ago.
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
If you've already paid for this answer, simply Login.
Manal Elkhoshkhany, Tutor
Category: Homework
Satisfied Customers: 9512
Experience: More than 5000 online tutoring sessions.
Manal Elkhoshkhany and 3 other Homework Specialists are ready to help you
Customer: replied 2 years ago.

Hi,

I just got it. Would you mind for me to look at it for before I click accept?

They look great with nice graph as well.

I hope all goes well this time :)

 

Thanks a lot

Expert:  Manal Elkhoshkhany replied 2 years ago.

Of course not :)

 

Please go ahead, do not click accept unless you are 100% convinced :)

Customer: replied 2 years ago.
Great. I will definitely click on accept today :)
Expert:  Manal Elkhoshkhany replied 2 years ago.
Ok :)
Customer: replied 2 years ago.

Hi,

 

I am accepting the answer in few minutes time. I hope I'll be able to get back to you if there is something that I need a further explanation on the answers.

Is that ok?

Expert:  Manal Elkhoshkhany replied 2 years ago.
sure :)
Customer: replied 2 years ago.

Hi,

 

I noticed a slight error in the graph of case one. I see that in calculating the EPS for plan 2, you found the EPS for when EBIT is $4000 000 to be 28 and also EPS to be 28 fro EBIT 5000 000) . When I worked it out the EPS should be 38 when EBIT is 5000 000) could you please confirm this urgently? I chaged it in the graph and I had a straight line graph. Please confirm.

 

Regards

Customer: replied 2 years ago.

 

Hi, Please check this chat you sent, I think there is either a slight error or a typing error.

 

 

EBITEPS Under Plan 1EPS Under Plan 2
$1 000 000 $5 ($2)
$2 000 000 $10 $8
$3 000 000 $15 $18
$4 000 000 $20 $28
$5 000 000 $25 $28 not 38 instead?
$6 000 000 $30 $48

 

the EPS should be 38, when EBIT is $5 000 000

 

EPS = (5000000- 1 200 000) / 100 000 = 38 and not 28 as written.

Am I correct?

I will appreciate it if you could confirm this right now.

Expert:  Manal Elkhoshkhany replied 2 years ago.
will check and get back to you :)

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4522
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3458
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3124
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2385
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1988
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1876
    Bachelors Degree and CPA with Accounting work experience
  • http://ww2.justanswer.com/uploads/avremote/photoa.jpg Seanna's Avatar

    Seanna

    Tutor

    Satisfied Customers:

    1781
    3,000+ satisfied customers, all topics, A+ work
 
 
 
Chat Now With A Tutor
Manal Elkhoshkhany
Manal Elkhoshkhany
4524 Satisfied Customers
More than 5000 online tutoring sessions.