Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

select a keyword that may result from the truncation search phil *

Answered: 1 week ago