Can you show me using excel calculations please? What is the price per share based on the equity free cash flow model?Year 1:Revenue: 630Fixed costs: 120Variable costs: 200Additional investments in NWC: 10Additional investments in operating long-term assets: 70Depreciation: 60Interest expenses: 35Newly issued debt: 25Principal repayment: 15Cost of equity, Rs: 0.14Corporate tax rate: 0.40Growth rate per year:From year 1 through year 5: 0.12After year 5: 0.05Market value:Short-term debt: 100Long-term debt: 600Common Stock:Market price per share: 18Number of shares: 100Select one:a. $16.39O b. $14.21O c.$13.09O d. $15.33Time left 0:04:22

Name: Can you show me using excel calculations please? What is the price per
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: Can you show me using excel calculations please? What is the price per share based on the equity free cash flow model?Year 1:Revenue: 630Fixed costs: 120Variable costs: 200Additional investments in NWC: 10Additional investments in operating long-term

The stock price per share is the amount of money that you would have to pay to buy one share of a…

Answered: Can you show me using excel…

Business

Finance

Can you show me using excel calculations please?

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter21: Dynamic Capital Structures And Corporate Valuation

Section: Chapter Questions

Problem 9P

See similar textbooks

Similar questions

Weighted Average Cost of Capital (WACC) using Table (Problem 11 in text) Financing Source Dollar Amount % Weight Interest Cost of Rate Capital After Tax Cost (D X (1-tax rate) Component to Sum (FXC) Short Term Note $ 200,000.00 15% Long Term Note $ 300,000.00 18% Equity Capital $ 500,000.00 25% Assumes 30% Tax Rate SOLVE FOR YELLOW HIGHLIGHTED BLOCKS WACC
What is the price per share based on the equity free cash flow model? Year 1: Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments in NWC: 10 Additional investments in operating long-term assets: 70 Depreciation: 60 Interest expenses: 35 Newly issued debt: 25 Principal repayment: 15 Cost of equity, Rs: 0.14 Corporate tax rate: 0.40 Growth rate per year: From year 1 through year 5: 0.12 After year 5: 0.05 Market value: Short-term debt: 100 Long-term debt: 600 Common Stock: Market price per share: 18 Number of shares: 100 Select one: a. $16.39 O b. $14.21 O c. $13.09 O d. $15.33 Time left 0:04:22
3. Compute for the following: Required: Payback period, payback reciprocal, accounting rate of return, Net present value and profitability index Total investment. P 200,000 Cost of capital 10% Net income P 15,000 for 8 years P 80,000 Cash inflow
Use the following information about Red Rocks Inc. to answer the following question: Assume the following: Pays no taxes Return on net operating assets (RNOA) = 18% %3D Has $2,000 in net operating assets financed by equity At the beg. of the year borrows $1000 at 8%. Uses debt to buy additional operating assets. What is the return on equity (ROE) for Red Rocks? Edit View Insert Format Tools Table 12pt v Paragraph v B IU A e T?v I.
) Assuming a 9% cost of capital, find the modified internal rate of return for the following cash flows: a. 19.78% b. 6.95% c. 13.64% d. 7.86% Year Cash Flow 0 1 2 3 -$175 $167 $240 -$120
Determining PB Ratio for Companies with Different Returns and Growth Assume that the present value of expected ROPI follows a perpetuity with growth g (Value = Amount/ [r - g]). Determine the theoretically correct PB ratio for each of the following companies A and B. Note: NOPAT = NOA » RNOA. Company Net Operating Assets Equity RNOA ROE Weighted Avg. Cost of Capital Growth Rate in ROPI $100 $100 19% 19% 10% 2% $100 $100 12% 12% 10% 4% A B Round answers to two decimal places. PB Ratio Company A Company B
Data Given: Debt/Equity of project= 40% 28% 15% 10.00 m 10% $3.20m Tax Rate = Levered equity Debt Issue 24 retiring at the end of year 3. IR= repayment of principal= Find NPV (debt flnancing)
Return on Capital Employed (ROCE) = For Riccarton PLC: ROCE = 50000/380000 X 100 = 13.2% For Edinburgh PLC: ROCE = 45000/230000 X 100 = 19.6% Current Ratio = Current assets/current liabilities For Riccarton PLC: Current ratio = 150/120 = 1.25 For Edinburgh PLC: Current ratio = 80/70 = 1.14 Gearing Ratio = (long term borrowing + short term borrowings) / equity For Riccarton PLC: Gearing ratio = (180 + 100)/200 = 1.4 For Edinburgh PLC: Gearing ratio = (100 + 50)/130 = 1.15 Price/Earnings (P/E) Ratio = Share price / earnings per share For Riccarton PLC: P/E Ratio = 195/35 =5.57 For Edinburgh PLC: P/E Ratio = 451/28 = 16.107 Based on the above ratios explain, which company George H. and James W. should invest in. You should also briefly discuss the limitations of your analysis.
i) PAT - 4000 Cr ii) Tangible Fixed Assets -3300 Cr iii) Depreciation 8.5 % iv) Identifiable Intangible other than brand -1200 Cr v) Risk Premium – 5 % vi) Return from Market is 10 % vii) Beta of the company –Double the market viii) Tax rate – 20 % ix) Debenture Interest Rate is 9 % ) Debt : Equity is in the ratio of 3:2 xi) Expected normal return on Tangible Assets ( Weighted Average Cost of capital + 25 % of the Cost of Debt Post Tax xii ) Appropriate Capitalization rates for Intangibles – 22 % Determine the possible value of Brand as per Potential Earnings Model
If the state tax rate is 20% and the federal tax rate is 30%, what is the total effective tax rate? a. 34% b. 50% c. 44% d. 37% 2. Holding all other variables constant, which of the following would increase return on equity? An increase in _____________. a. the tax rate b. the equity ratio (equity/total assets) c. total assets d. total asset turnover
Problem 1 Assume that ABC Corporation earns a net income of 10 million for the current period. The corporation also needs Br 8 million for new investments for the next period. Suppose the target capital structure of debt to equity ratio is one to three ratios. Based on this, determine the amount of dividend to be paid based on the residual dividend policy? Beob om
Make the following Assumptions: Tangible Asset Value = 16,200,000 Required Return on Tangible Assets = 16% Required Return on Equity = 24% %3D • Forecast Net Income for next period (year) = 4,800,000 Capitalization Rate for Excess earnings to compute Intangible Asset Value = 30% • Current Market Value of Interest Bearing Liabilities = 13,000,000 Compute the Market Value of Equity using the Excess Earnings Approach