Question

In: Finance

Target ROE problem You are given the following information regarding KTC for 2019: RETURN ON ASSETS...

Target ROE problem

You are given the following information regarding KTC for 2019:

RETURN ON ASSETS = 7.5% NET PROFIT MARGIN = 6.0% DEBT EQUITY RATIO = 1.5x SALES = $550,000.00 GROSS PROFIT RATE = 50.0% TAX RATE = 34.0%

1) What must KTC project as its 2020's sales in order to generate an additional 5% Return on Equity above last year’s levels (2019’s ROE + 5%, not 2019’s ROE x 105%)

2) Prepare a projected 2020 Profit and Loss Statement and Balance Sheet (general categories are fine).

3) Calculate: 2020’s

projected RETURN ON EQUITY (use the DuPont model)

2020’s projected RETURN ON ASSETS

2020’s projected NET PROFIT MARGIN

2020’s projected EQUITY MULTIPLIER

2020’s projected TOTAL ASSET TURNOVER

4) In addition to the above, determine the increase in sales necessary to also provide for dividends to be paid at the rate of 30% of 2020’s after-tax profits.

Solutions

Expert Solution

KTC
Particulars Amt $/ %
Details of 2019
Sales $             550,000
Net Profit Margin % 6%
Net Profit Margin $ Amount $               33,000
Return on Asset 7.5%
So , Net income/Asset =7.5%
Asset =Net income /7.5%= $             440,000
Debt/Equity =                       1.50
Asset =Debt+Equity
Assune Debt =1.5x , so Equity =1x
So 2.5x=440000
x= $             176,000
Equity = $             176,000
Debt = $             264,000
Return on Equity =Net Margin*Revenue/Total Asset*Total Asset /Equity
ROE =6%*550000/440000*440000/176000= 18.75%
So 2019 ROE =18.75%
2020 ROE =18.75%+5%= 23.75%
2020 ROE =23.75%
so Net Income /Equity=23.75%
Net Income =176000*23.75%= $         41,800.00
Assuming net Margin unchanged =6%
So Sales =41800/6%= $       696,666.67
Ans 1 So projected sales for 2020 would be $696,666.67
Ans 2
KTC
Projected Profit and Loss Statement for the year 2020
Particulars Amt $
Sales revenue $       696,666.67
Less Cost of Goods Sold (@50%) $       348,333.33
Gross Profit $       348,333.33
Operating Expense $       285,000.00
EBT $         63,333.33
Tax @34% $         21,533.33
Net Income $         41,800.00
Ans 2 ( Assuming Assets /Liabilities at 2019 level, additional profit paid as dividend)
KTC
Projected Balance Sheet as on Dec 31 2020
Assets Amt $ Liabilities
Total Asset $           440,000 Debt $ 264,000
Equity $ 176,000
Total $           440,000 Total $ 440,000
Ans 3
In the absence of detailed information.assuming that
the asset and Liabilities are not changing in 2020 and
additional profit paid out as dividend.
ROE in 2020 =Net Margin*Revenue/Total Asset*Total Asset /Equity
ROE=41800/696666.67*696666.67/440000*440000/176000
ROE =23.75%
Return on Asset =41800/440000= 9.50%
2020 Net Margin 6%
2020 Projected Equity Multiplier=Total Asset/Equity= 2.50
2020 total Asset Turnover =Revenue/Total Asset=                       1.58

Related Solutions

Target ROE problem You are given the following information regarding KTC for 2019: RETURN ON ASSETS...
Target ROE problem You are given the following information regarding KTC for 2019: RETURN ON ASSETS = 7.5% NET PROFIT MARGIN = 6.0% DEBT EQUITY RATIO = 1.5x SALES = $550,000.00 GROSS PROFIT RATE = 50.0% TAX RATE = 34.0% 1) What must KTC project as its 2020's sales in order to generate an additional 5% Return on Equity above last year’s levels (2019’s ROE + 5%, not 2019’s ROE x 105%) 2) Prepare a projected 2020 Profit and Loss...
You have been given the following information regarding a potential merger and acquisition. Bidder Target #...
You have been given the following information regarding a potential merger and acquisition. Bidder Target # of shares outstanding 200,000 40,000 Price per share $50 $125 Net Income 200,000 200,000 If the bidder pays $150 per share for each share of the target the new stock price would be $54 per share. A) What is the NPV to the bidder, ? B) what was the premium paid to the target? C) what were the synergies from the merger.? Instead of...
Problem 3.Refer to the following information on the return distribution for two assets in which you...
Problem 3.Refer to the following information on the return distribution for two assets in which you are contemplating to invest in; State of Economy Probability that the state of economy occurs Return if the state occurs              Asset AA Return if the state occurs              Asset BB BOOM 10% 40% 60% AVERAGE 40% 20% 30% BELOW AVERAGE 20% 20% 10% POOR 30% -20% -30% In addition to the above return distribution the two assets (AA& BB) operate in different industries...
Given the following information, calculate the ROE. Sales = $350,000; Net Income = $50,000; Total assets...
Given the following information, calculate the ROE. Sales = $350,000; Net Income = $50,000; Total assets = $500,000; D/E = 1.5. a. 30% b. 20% c. 15% d. 25% e. 10%
Given the information below for a bank, what is the Return on Equity? (ROE). Original Interest...
Given the information below for a bank, what is the Return on Equity? (ROE). Original Interest income 2,250 Interest Expense 1,500 Total assets 45,000 Security losses or gains 21 Earnings assets 40,000 Total liabilities 38,000 Taxes paid 16 Common shares outstanding 5,000 Noninterest income 800 Noninterest expense 900 Provisions for loan losses 250 A. 8.06% B. 9.59% C. 5.79% D. 6.5% E. 4.9%
eBook Problem 4-02 You are given the following information regarding prices for a sample of stocks....
eBook Problem 4-02 You are given the following information regarding prices for a sample of stocks. PRICE Stock Number of Shares T T + 1 A   3,600,000 $60 $80 B 13,000,000   30   45 C 28,000,000   19   34 Construct an equal-weighted index by assuming $1,000 is invested in each stock. What is the percentage change in wealth for this portfolio? Do not round intermediate calculations. Round your answer to two decimal places.   % Compute the percentage of price change for each...
Sales/Total assets = 4.5× Return on assets (ROA) = 10.0% Return on equity (ROE) = 50.0%...
Sales/Total assets = 4.5× Return on assets (ROA) = 10.0% Return on equity (ROE) = 50.0% Book Value of Stockholders’ equity = $30 Price/Earnings ratio = 6.0x Common shares outstanding = 50 Market/Book ratio = 3.0x A. Calculate the price of a share of the company’s common stock. B. Calculate debt-to-assets ratio assuming the firm uses only debt and common equity. C. What were sales last year? D. What is the company’s market value?
Hanan corporation has the following relationships: Return on assets (ROA) 4%, Return on equity (ROE) 8%....
Hanan corporation has the following relationships: Return on assets (ROA) 4%, Return on equity (ROE) 8%. What is the equity ratio? Select one: a. 25% b. 40% c. 50% d. 60% IF CDD has sales revenues of $300,000 and inventory turnover 5x. Find the company ending inventories? Select one: a. $300,000 b. $50,000 c. $240,000 d. $60,000 Find the price of a corporate bond which has a par value of $1000 and coupon payment is 5% and yield is 8%....
You are given the following information:      State of Economy Return on Stock A Return on...
You are given the following information:      State of Economy Return on Stock A Return on Stock B   Bear .119 −.062                Normal .098 .165                Bull .090 .250                 Assume each state of the economy is equally likely to happen.    Calculate the expected return of each of the following stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)    Expected return   Stock A %   Stock B...
You are given the following information:      State of Economy Return on Stock A Return on...
You are given the following information:      State of Economy Return on Stock A Return on Stock B   Bear .119 −.062                Normal .098 .165                Bull .090 .250                 Assume each state of the economy is equally likely to happen.    Calculate the expected return of each of the following stocks. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)    Expected return   Stock A %   Stock B...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT