Calculate R&E's sustainable growth rate in each year from 2015 through 2018. Assume the dividend payout ratio
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate R&E's sustainable growth rate in each year from 2015 through 2018. Assume the dividend payout ratio was the same in 2015-17 as forecasted in 2018
Transcribed Image Text:
2018 ($ thousands) A B D Year 2017 Actual 2018 2019 3 Net nales $20,613 4 Growth rate in net salcs 25.0% 5 Cost of gooda sold/net salcs 6 Gen., acll., and admin. expensea/net sales 7 Long-term debt 8 Current portion long-term debt 86.0% 12.0% $ 760 $660 $ 100 $100 9 Interest rate 10.0% 10 | Tax rate 45.0% 11 Dividend/carninga after tax 50.0% 12 Current asacta/net salca 29.0% 13 Net fixed assets $280 14 Current liabilitica/net salca 14.5% 15 Owners' equity $ 1,730 16 INCOME STATEMENT 17 Equations Forecast Forecast 18 Year 2018 2018 2019 19 Net salcs = B3 + B3 * C4 $25,766 Cost of goods sold Gross profit Gen., aell., and admin. exp. 20 =C5 * C19 22,159 21 = C19 -C20 3,607 = C6 * C19 = C9 * (C7 + C8 + C40) 22 3,092 23 Interest expense 231 24 Earninga before tax = C21 - C22 - C23 285 25 Тах = C10 * C24 128 26 Barninga after tax 27 Dividenda paid 28 Additiona to retained carninga = C24 - C25 156 = C11 * C26 78 = C26 - C27 78 29 30 BALANCE SHEET = C12 * C19 = C13 = C31 + C32 31 Current asacta 7,472 32 Net fixed assets 280 33 Total anscta 7,752 34 35 Current liabilitica = C14 * C19 3,736 36 Long-term debt Owners' equity = C7 660 = B15 + C28 1,808 6,204 37 38 Total liabilitics and owners" = C35 + C36 + C37 39 oquity 40 EXTERNAL FUNDING REQUIRED = C33 - C38 $1,548 2018 ($ thousands) A B D Year 2017 Actual 2018 2019 3 Net nales $20,613 4 Growth rate in net salcs 25.0% 5 Cost of gooda sold/net salcs 6 Gen., acll., and admin. expensea/net sales 7 Long-term debt 8 Current portion long-term debt 86.0% 12.0% $ 760 $660 $ 100 $100 9 Interest rate 10.0% 10 | Tax rate 45.0% 11 Dividend/carninga after tax 50.0% 12 Current asacta/net salca 29.0% 13 Net fixed assets $280 14 Current liabilitica/net salca 14.5% 15 Owners' equity $ 1,730 16 INCOME STATEMENT 17 Equations Forecast Forecast 18 Year 2018 2018 2019 19 Net salcs = B3 + B3 * C4 $25,766 Cost of goods sold Gross profit Gen., aell., and admin. exp. 20 =C5 * C19 22,159 21 = C19 -C20 3,607 = C6 * C19 = C9 * (C7 + C8 + C40) 22 3,092 23 Interest expense 231 24 Earninga before tax = C21 - C22 - C23 285 25 Тах = C10 * C24 128 26 Barninga after tax 27 Dividenda paid 28 Additiona to retained carninga = C24 - C25 156 = C11 * C26 78 = C26 - C27 78 29 30 BALANCE SHEET = C12 * C19 = C13 = C31 + C32 31 Current asacta 7,472 32 Net fixed assets 280 33 Total anscta 7,752 34 35 Current liabilitica = C14 * C19 3,736 36 Long-term debt Owners' equity = C7 660 = B15 + C28 1,808 6,204 37 38 Total liabilitics and owners" = C35 + C36 + C37 39 oquity 40 EXTERNAL FUNDING REQUIRED = C33 - C38 $1,548
Expert Answer:
Answer rating: 100% (QA)
Sustainable growth rate Return on Equity 1Dividend payout 1Di... View the full answer
Related Book For
Principles Of Managerial Finance
ISBN: 978-0136119463
13th Edition
Authors: Lawrence J. Gitman, Chad J. Zutter
Posted Date:
Students also viewed these accounting questions
-
Assume that the dividend payout ratio will be 75 percent when the rate on long-term government bonds falls to 8 percent. Since investors are becoming more risk averse, the equity risk premium will...
-
If the dividend payout ratio in problem 9 is fixed at 50%, calculate the required total external financing for growth rates in 2016 of 15%, 20%, and 25%. Income Statement, 2015...
-
Sustainable Growth Rate In the chapter, we discussed the two versions of the sustainable growth rate formula. Derive the formula ROE X b from the formula given in the chapter, where ROE is based on...
-
Suppose that we are at time 0 and the interest rate is 10% (d) What is the PV of an asset that pays 20 installments of $5 a year starting today?
-
If the order of objects is not of importance, how many ways can I select nine objects two at a time? Why is this result different from Problem 4.32?
-
Suppose that the spread between the yield on a three-year riskless zero-coupon bond and a three-year zero-coupon bond issued by a bank is 210 basis points. The Black-ScholesMerton price of an option...
-
What is the difference between the $t$ distribution and the normal distribution?
-
Organizing and maintaining a database are more complicated than organizing and maintaining independent files because a database provides more data retrieval functions and performs more operations. A...
-
Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (8,000 units) Variable expenses Contribution margin Fixed expenses Total Per Unit $ 272,000 $...
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
Suppose you are the production manager of ASHMITA Ltd. and you are producing a standard mix of 35,000 units. Details is as follows: A 15,000 44 62.5 Unit Produced Variable Cost (Rs) Selling Price...
-
List the requirements set forth in Goal Setting Theory.
-
Explain the position of Contingency Theory.
-
Explain the difference in status between a superior and a subordinate.
-
How can smoking exert a positive externality on others?
-
Identify the four steps of the KEYS process.
-
Create a Java Program that takes a month number as an input and outputs the proper month name.Your program should have two classes. The first class, month,should include the method Month input, which...
-
What are some of the features of the Unified Process (UP)?
-
Growth rates You are given the series of cash flows shown in the following table. a. Calculate the compound annual growth rate between the first and last payment in each stream. b. If year-1 values...
-
What is the difference between cross-sectional and time-series ratio analysis? What is benchmarking?
-
How does asymmetric information affect the firms capital structure decisions? How do the firms financing actions give investors signals that reflect managements view of stock value?
-
Black vultures excel at gliding flight; they can move long distances through the air without flapping their wings while undergoing only a modest drop in height. A vulture in a typical glide in still...
-
A hiker walks 25 north of east for 200 m. How far north and how far east is he from his starting position?
-
A squirrel completing a short glide travels in a straight line tipped 40 below the horizontal. The squirrel starts 9.0 m above the ground on one tree and glides to a second tree that is a horizontal...
Study smarter with the SolutionInn App