Question

Calculating the sustainable growth rate Excel Sign In FILE FORMULAS REVIEW НOME INSERT PAGE LAYOUT DATA VIEW Itt Calibri A A

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Return on equity = (PM)(TAT)(EM)

Return on equity = (.052)(3.40)(1.30)

Return on equity = 0.2298 or 22.98%

Plowback ratio = 1 - Dividend payout ratio

Plowback ratio = 1 - 0.35

Plowback ratio = 0.65

Sustainable growth rate = (ROE × b) / [1 – (ROE × b)]

Sustainable growth rate = [.2298(.65)] / [1 – .2298(.65)]

Sustainable growth rate = 0.1756, or 17.56%

Add a comment
Know the answer?
Add Answer to:
Calculating the sustainable growth rate Excel Sign In FILE FORMULAS REVIEW НOME INSERT PAGE LAYOUT DATA...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Using the DuPont identity- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In...

    Using the DuPont identity- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12A A Paste - A Alignment Number Conditional Format as Cell Cells Formatting TableStyles- Clipboard Font Styles D13 Zombie Corp. has a profit margin of 5.1 percent, total asset turnover of 1.95, and ROE of 16.15 percent. What is this firm's debt-equity ratio? Profit margin Total asset turnover Return on equity 5.10% 1.95 16.15% 10 Complete the following analysis. Do not hard code...

  • ? Dividend per Share - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Paste - A Cells Editing B...

    ? Dividend per Share - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Paste - A Cells Editing B IU- Font Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Clipboard G A1 A B Suppose a firm has a retention ratio of 60 percent, net income of $36.5 million, and 215 million shares outstanding. What would be the dividend per share paid out on the firm's stock? (Round your answer to 2 decimal...

  • ? X Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT...

    ? X Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Arial -12 A À Paste B IU B A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Editing Clipboard Font D16 д в E F G H K Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years because the firm needs to plow back its...

  • ? X Calculating NPV and IRR - Excel FORMULAS DATA REVIEW - Sign In FILE HOME...

    ? X Calculating NPV and IRR - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Calibri Paste B IU A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font A1 д в E F G H I A project that provides annual cash flows of $15,400 for nine years costs $67,000 today. What is the NPV if the required return is 8 percent? What if it's 20 percent? At...

  • ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE...

    ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE HOME INSERT PAGE LAYOUT VIEW 86 Calibri - 11 LE Paste B I U - AA AAlignment Number Conditional Format as Cell Formatting" Table Styles Styles Cells - Editing Clipboard Font > 41 $ 1.95 Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend...

  • ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE...

    ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE HOME INSERT PAGE LAYOUT VIEW 86 Calibri - 11 LE Paste B I U - AA AAlignment Number Conditional Format as Cell Formatting" Table Styles Styles Cells - Editing Clipboard Font > 41 $ 1.95 Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend...

  • Must be answered using formulas. ? 7 X - Sign In FILE Calculating liquidity ratios -...

    Must be answered using formulas. ? 7 X - Sign In FILE Calculating liquidity ratios - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -11 - Á A = % E D i B IU- A Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles Paste Cells Editing Clipboard A1 Α E F SDJ, Inc., has net working capital of $2,710, current liabilities of $3,950, and inventory of $3,420. What is the current ratio? What is...

  • XES FILE HOME Calculating dividend yield and capital gains yield - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT S...

    XES FILE HOME Calculating dividend yield and capital gains yield - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In % Arial - - 12 - A A Paste B IU B A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font D15 AB DE F G H The next dividend payment by Halestorm, Inc., will be $2.04 per share. The dividends are anticipated to maintain a growth rate of 4.5 percent forever....

  • Using the DuPont identity - Excel REVIEW VIEW Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA...

    Using the DuPont identity - Excel REVIEW VIEW Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA Calibri 11 A A -A Alignment Number Conditional Format as Cell Paste < Clipboardr A1 FormattingTable Styles- Font Styles Y3K, Inc., has sales of $5,783, total assets of $2,604, and a debt-equity ratio of .75. If its return on equity is 11 percent, what is its net income? 4 Total assets Sales Debt-equity ratio Return on equity 2,604 5,783 0.75 11% 10 Complete the...

  • Bond Pricing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS Sign In DATA REVIEW MEW Calibri 11...

    Bond Pricing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS Sign In DATA REVIEW MEW Calibri 11 A A Paste Conditional Format as Formatting Table Styles Styles Alignment Number Cell I U Cells Editing Clipboard Font H11 H E G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 interest payments per year 6 (Note: the bonds pay interest semi-annually.) 500,000 30 7 % 2 8 Required: 9...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT