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 getsetgo Your Own Question

getsetgo
getsetgo, MBA
Category: Homework
Satisfied Customers: 3386
Experience:  MBA from IIM Calcutta, Engineer, 8+ years of exp. at executive level
15962517
Type Your Homework Question Here...
getsetgo is online now
A new question is answered every 9 seconds

MGT 325 Module 5 Spreadsheet Exam - this is one long problem

Customer Question

MGT 325 Module 5 Spreadsheet Exam - this is one long problem or case

To do this exam you need to study the cases at the end of Chapter 11. Remember that the cost of debt
when calculated is before tax and has to be converted to an after tax return. The returns on preferred and
common stock are already after tax so are not adjusted which is in Chapter 10.

PROBLEM FOR CHAPTERS TEN AND ELEVEN
Saint Leo Manufacturing is going to introduce a new product line and to accomplish this
it has four projects analyzed in which it wants to invest a total of $100 million. Your job is to
find what it will cost to raise this amount of capital and based on the cost of capital determine which of the
projects should be accepted by the firm to invest in.

PROJECTS
A B C D
INVESTMENT $30,000,000 $20,000,000 $25,000,000 $25,000,000
EXPECTED RETURN 10.00% 14.00% 11.50% 16.00%

The firms capital structure consists of: FMV
CAPITAL PERCENTAGE AMOUNT
DEBT 30% $15,000,000
PREFERRED STOCK 10% $5,000,000
COMMON STOCK 60% $30,000,000
$50,000,000
Other information about the firm:
CORPORATE TAX RATE 30%
DEBT
CURRENT PRICE $1,050.00
ANNUAL INTEREST 6.00% CURRENT INTEREST PAID SEMIANNUALLY
ORIGINAL MATURITY 25 YEARS, BUT NOW 20 YEARS LEFT
MATURITY VALUE $1,000.00
FLOTATION COST INSIGNIFICANT
MARKET YIELD PROJECTED:
UP TO $20 MILLION 9%
ABOVE $20 MILLION 12% 3 % additional premium

PREFERRED
CURRENT PRICE $45.00
LAST DIVIDEND (D0) $3.38 FIXED AT 7.5% OF PAR
FLOTATION COST $1.50
NEXT DIVIDEND (D1) $3.38

COMMON
CURRENT PRICE $35.00
LAST DIVIDEND (D0) $1.00
RETAINED EARNINGS $10,000,000
GROWTH RATE (g) 9%
FLOTATION COST $1.50
NEXT DIVIDEND (D1) $1.090

NOTE - Once retained earnings is maxed out new common stock will need to be issued.
Any preferred stock would be new preferred stock. You may want to review case in chapter 11.

REQUIRED:

In all of the required parts one part builds on the previous part. If you can't do a part use the
set of other numbers to solve the next part.
a. What is the current Kd, Kp and Ke assuming no new debt or stock?
b. Since any new capital investment will require issuing new perferred stock, what would the
the new returns be preferred stock (knp) and the new cost of capital?
c. What amount of increase (marginal cost of capital) in capital structure will the firm run
out of retained earnings and be forced to issue new common stock?
d. If new common stock has to be issued what will the new return required be (Kne) and the
new cost of capital?

Note: All Answers Should Be Taken Out to 2 Decimal Places, Especially the Interest Rate Answers.

Part a
Current price
Maturity value
Interest payment
Payment periods
Yield rate six month rate
Annual yield annual rate
Kd
Kp
Ke
Current Cost of capital

Can't really use the current cost of capital since accepting any new projects will require issuing new
Preferred stock requiring a rate higher than its current 7.5% yield.

Part b
Use your solutions in Part a to do this part, but if you couldn't complete Part a, assume Kd=4%, Kp=8%, and Ke=13%; =
Knp preferred stock
New cost of capital

Part c
If the capital structure increases more than
new common stock will have to be issued to finance new projects since internally generated RE runs out,
and the required return on common stock will increase as demanded by shareholders.

Part d
Kne common stock
If you could not come up with the Kne common stock returns, do the cost of capital assuming Kd=5%, Knp=9%, and Ke=14%=
New cost of capital
Submitted: 2 years ago.
Category: Homework
Expert:  F. Naz replied 2 years ago.
Welcome to JA

By what time do you need the answer thanks.
Customer: replied 2 years ago.
I need the answer today if possible..
Expert:  getsetgo replied 2 years ago.
Hello,
Welcome to Just Answer!

Please download your answer Here

Please note that I will get paid for my work only after you accept the answer. So, kindly ACCEPT the answer by clicking at Green button, so that I get paid for my work.
Customer: replied 2 years ago.

Looks good, but some of it is confusing me..not sure the formulas off to the right are, and some of the questions (i.e yield rate (six months)) are missing from your spreadsheet.

Attachment: 2012-04-06_140807_mgt325_m5_spreadsheet_exam_robinson.xls

I attached the actual worksheet, not sure if that makes a difference.

Expert:  getsetgo replied 2 years ago.
Yes, this excel is very helpful. Will be posting revised answer in half an hour.
Customer: replied 2 years ago.
Thanks so much!!!
Expert:  getsetgo 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.
getsetgo, MBA
Category: Homework
Satisfied Customers: 3386
Experience: MBA from IIM Calcutta, Engineer, 8+ years of exp. at executive level
getsetgo and 9 other Homework Specialists are ready to help you
Customer: replied 2 years ago.
Great! Can you explain formula D54 so I can get a better understanding of this formula please
Expert:  getsetgo replied 2 years ago.
Formula is: WACC = Wd*Kd + Wp*Kp + We*Ke

This formula calculates weighted average cost of capital. A company's capital structure is made up of debt, preferential shares, and common equity. The cost of debt, cost of pref. share and cost od equity are not same. So, to arrive at WACC, we multiply weight of each of the component of capital structure and its cost, then we add all three.
WACC= weight of debt*cost of debt + weight of pref share*cost of pref share + weight of equity*cost of equity

here, one thing should be noted. Cost of debt is after tax cost as debt gives tax shield on interest payment. So, Kd = pretax cost of debt*(1-Tax rate)
In our example, we calculated YTM, which is pretax cost of debt. After tax cost of debt is calculated as YTM*(1-T)
Customer: replied 2 years ago.

Can I ask you a quick question...In Part C on the worksheet the question is..

If the capital structure increases more than new common stock will have to be issuesed to finance new projects since internally generated RE runs out, and the required return on common stock will increase as demanded by shareholders.

Your response in the spreadsheet you sent gave me three things, do I need all three for the answer of this question. Or do I need to input all three in the answer and why?

 

Thank you again for the assistance!!!

Expert:  getsetgo replied 2 years ago.
Sorry for late response. As we are in different time zone, when you posted the query, it was late night here.
common stock is 60% of capital structure. So, new equity has to be issued when capital structure increases more than 60% of the retained earning. Retained earning is 10,000,000. So, new stock has to be issued when capital structure increases more than 10,000,000/60% = $16,666,667.

Answer is $16,666,667

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:

    4520
    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:

    4520
    More than 5000 online tutoring sessions.
  • 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:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • 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:

    2341
    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:

    1975
    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:

    1873
    Bachelors Degree and CPA with Accounting work experience