higrowth(1) - Current Financial Information (Enter the most...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Current Financial Information (Enter the most recent information you can find; if possible, use trailing 12-month data) I. Income Statement Current EBIT = $(55.00) Current Interest Expense = $0.51 Current Capital Spending $459.27 Current Depreciation and Amortiza $59.52 Current Revenues = $1,246.30 II. Balance Sheet This period Last period Current Non-cash Working Capital $65.00 $29.00 Book Value of Debt = $198.47 108.165 Book Value of Equity = $1,513.04 1097.267 $792.26 Non-operating Assets $194.48 III. Tax Information NOL carried forward = $1,289.00 Marginal tax rate = 37.50% Adjustments to Current Financial Information Do you have any operating leases? Yes No Are there any other operating expenses to be capitalized? No Discount Rate Inputs Current Beta = 1.37 Current Cost of Borrowing = 5.91% Current Market Value of Debt =  $143.14  Expectations for the future Do you want to enter the growth rate in revenues each year? If no, Compounded Annual Growth Rate in Revenues for next 10 years: 28.54% Do you want me to use current working capital as percent of revenues for the futu No If not, enter non-cash working capital as a percent of revenues in future periods 140.77% How would you like capital expenditures to be estimated? 3 If you would chose 3, enter the sales to capital ratio that you would like maintaine 3.02 Stable Growth Inputs Expected Growth Rate in perpetutity = 3% Speed of convergence Expected Operating Margin = 14.19% 1.5 Expected Debt to Capital(MV) Ratio for the firm = 44.71% Expected Beta =  1.10  Expected Cost of Debt = 7.20% Return on Capital for the firm = 26.39% Per Share Inputs Number of Shares outstanding = 81.644 Current Stock Price =  $119.48  Does your firm have equity options outstanding? Yes If yes, enter the number of options outstanding = 1.53631           and the average exercise price of the options outstanding  251.31           and the average maturity of the options outstanding = 9           and the standard deviation in the firm's stock price = 61% General Information Current long term government bond rate = 3.55% Estimated Market Risk Premium = 4.56% Relative Valuation If you want to do a relative valuation of your firm, enter these inputs: Year on which multiple is to be applied = 10 Value to Sales multiple in that year = 3.796507133 Yes
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Base 1 2 3 4 5 6 7 8 9 10 Terminal Year Revenue Growth Rate 55.00% 45.00% 40.00% 35.00% 30.00% 20.00% 15.00% 12.00% 8.00% 6.00% 3% Revenues $1,246 $1,932 $2,801 $3,921 $5,294 $6,882 $8,259 $9,497 $10,637 $11,488 $12,177 $12,543 Operating Margin -4.18% 3.17% 7.58% 10.22% 11.81% 12.76% 13.34% 13.68% 13.88% 14.01% 14.08% 14.19% EBIT -$52 $61 $212 $401 $625 $878 $1,101 $1,299 $1,477 $1,609 $1,715 $1,780 Taxes
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

higrowth(1) - Current Financial Information (Enter the most...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online