Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part B: Internal and sustainable growth rates - Tabs IGR, SGR and write-up B Use the write-up tab to answer the different questions included below
Part B: Internal and sustainable growth rates - Tabs IGR, SGR" and "write-up B" Use the write-up tab to answer the different questions included below (make sure you indicate for each answer the relevant question number - example: 2.2). 1/ At December 31, 2018, Tiamy Inc. had $1,000 invested capital, no debt, and no cash. Its capital efficiency (defined as Sales in year(n)/Invested Capital year end(n)) is 2.0x. Its operating margin is 15%. Its pay-out ratio is 25%. Assume tax rate is zero. Question: What is Tiamy's Internal Growth Rate? To find the company's internal growth rate, start from its 12/31/2018 B/S below and build its (obviously very) simplified I/S for 2018 as well as its 1/S and B/S for 2019 (in this order) using the format below: Tiamy Inc. - Internal Growth Rate IS 2018 Assumptions: Invested Capital at 12/31/18 Debt at 12/31/18 Balance sheet 2018 (12/31) Debt 1,000.0 Equity 1,000.0 Total Sales Expenses Profit 1,000.0 0.0 Invested Capital Total 0.0 1,000.0 1,000.0 Capital efficiency* Operating margin Payout ratio 2.0 15.0% 25.0% IS 2019 Sales Expenses Profit Balance sheet 2019 (12/31) Debt Equity Total *Sales year(n)/ IC at year end(n) Invested Capital Total Solve for: Sales growth Note: the B/S at 12/31/2018 shown above already takes into account 2018 retained earnings. Tips When building 2019 I/S, start by defining 2019 Sales as 2018 Sales x growth rate in sales (note: the growth rates in sales and profits are the same since margins are constant). Sales growth is the variable you will be solving for. Have the level of debt at the end of 2019 be the plug", i.e. the number that is required to make the B/S balance. Wonder what drives the left side of the B/S and the right side of the B/S. Solve for sales growth using Excel's Goal Seek function by setting debt to 0 (by setting debt to zero, you obtain the Internal Growth Rate, by definition)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started