|
|
The following document: Discounted Cash Flow DCF Valuation Model Template, is no longer available on docstoc. It has either been removed by the original owner of the document or by the docstoc staff due to copyrighted or inappropriate content. If this was your document and you have questions why it was removed, please contact us at support@docstoc.com
Rabia06 3/26/2008 | 0 (0) | 369 | 29 | 0 | English
Discounted Dividend Valuation ModelThe present value of stock can also be found using the Discounted Dividend Model. The Dividend Discount Model uses the present value of the stock, the expected ... more>>
cshieyiez 1/21/2008 | 1 (1) | 735 | 170 | 0 | English
Forecasting Variables: 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 Revenue growth factor 20% 30% 40% 50% 60% 50% 40% 30% 20% 10% Expected gross profit margin 50% 51% 52% 53% ... ... more>>
Rabia06 3/26/2008 | 0 (0) | 163 | 14 | 0 | English
Analysts who follow Green Mountain Coffee (GMCR) expect a future sales growth in the low 20s with an operating margin between 8% - 8.2%. We will assume a future sales growth of 21%... ... more>>
Valuation
mbilinsky 6/27/2008 | 0 (0) | 160 | 8 | 0 | English
This document will help you with financial evaluation for a Financial Ratio list. ... more>>
sscheper 6/6/2008 | 0 (0) | 99 | 8 | 0 | English
Analytical model used by the Newport Venture Group, LLC ... more>>
robandlarac 4/25/2008 | 0 (0) | 178 | 10 | 0 | English
Preferrred Stock Valuation - Computing The Price Preferred Stock Par Value Call or Sale Value Annual Dividend Percentage Dividend Payments Per Year Years To Maturity or Holding Period Required Rate Of Return Current Price Preferrred Stock Valuation - Computing The Yield To Maturity Preferred Stock Par Value Call or Sale Value Annual Dividend Percen ... more>>
robandlarac 4/25/2008 | 0 (0) | 111 | 3 | 0 | English
Bond Valuation - Computing The Price Of A Bond Coupon Bonds Par Value Call or Sale Value Annual Coupon Rate Coupon Periods Per Year Years To Maturity or Holding Period Required Rate Of Return Current Price Discount Bonds Par, Call, or Sale Value Years To Maturity Required Rate Of Return Current Price Perpetuity Bonds Par Value Annual Coupon Rate Re ... more>>
robandlarac 4/25/2008 | 0 (0) | 166 | 14 | 0 | English
Stock Valuation - Zero or Constant Dividend Growth Current Dividend (Do) Dividend Growth Rate Required Rate of Return Stock Price $0.00 0.00% 0.00% #DIV/0!
Stock Valuation - Nonconstant Dividend Growth Current Dividend (Do) $0.00 Required Rate of Return 0.00% Constant Growth Rate 0.00% Super-Normal Growth Year Growth Rate Dividend Present Value of ... more>>
robandlarac 4/25/2008 | 0 (0) | 107 | 10 | 0 | English
Valuation Of Convertible Bonds Par Value Of Bond Call or Sale Value of Bond Annual Coupon Rate Coupon Periods Per Year Years To Maturity Required Rate Of Return Conversion Price Market Value Of Firm's Common Stock Current Market Price Of Convertible Bond Stock/Bond Conversion Ratio Conversion Value Straight Bond Value Minimum Market Value Of Conver ... more>>
anonymous 4/25/2008 | 0 (0) | 114 | 5 | 0 | English
Preferrred Stock Valuation - Computing The Price Preferred Stock Par Value Call or Sale Value Annual Dividend Percentage Dividend Payments Per Year Years To Maturity or Holding Period Required Rate Of Return Current Price Preferrred Stock Valuation - Computing The Yield To Maturity Preferred Stock Par Value Call or Sale Value Annual Dividend Percen ... more>>
anonymous 4/25/2008 | 0 (0) | 122 | 5 | 0 | English
Bond Valuation - Computing The Price Of A Bond Coupon Bonds Par Value Call or Sale Value Annual Coupon Rate Coupon Periods Per Year Years To Maturity or Holding Period Required Rate Of Return Current Price Discount Bonds Par, Call, or Sale Value Years To Maturity Required Rate Of Return Current Price Perpetuity Bonds Par Value Annual Coupon Rate Re ... more>>
wms702 4/17/2008 | 0 (0) | 970 | 27 | 0 | English
Actual Max sales Sales Cost of Goods Sold (VC) SG&A EBIT $ 82,235,294 $ 33% 15% 2006 Income Statement 69,900,000.00 23,100,000.00 3,465,000.00 43,335,000.00 Assumptions for forecasting 29% 67% 67% 13% carry over from 2006 for first pass
Interest Earnings Before Taxes Taxes Net income Dividends Addition to Retained Earnings
7% 34% $ 15% $
2,520.0 ... more>>
wms702 4/17/2008 | 0 (0) | 158 | 5 | 0 | English
Cost Structure and Operating Leverage Input data for green cells only
Sales Variable expenses Contribution margin Fixed expenses Net income Breakeven sales Margin of safety $ Margin of safety % Operating leverage % increase in sales % increase in income Proof of income increase: Sales $ Variable expenses Contribution margin Fixed expenses Net incom ... more>>
wms702 4/17/2008 | 0 (0) | 198 | 6 | 0 | English
Bond Valuation Inputs Rate Convention: 1 = EAR, 0 = APR Annual Coupon Rate (CR) Yield to maturity (Annualized) (y) Number of Payments / year (NOP) Number of Periods to maturity (T) Face Value (F)
Basic
0 (EX: 9% + .067= 9.067) 10.10% Add Float Rate to coupon rate for # 11.90% 1 18 $1,000
Outputs Discount Rate / Period (r.) Coupon Payment (C ) 11 ... more>>
wms702 4/17/2008 | 0 (0) | 328 | 5 | 0 | English
Return on Equity
Expected dividend next year $9.72 last years dividends 36.58 9.29
0.331641134
current market value $
$
0.33
Practice Problem 3--Finding the Cost of Retained Earnings Baseball Bats & Bags Corporation's common stock currently sells for $50 per share. The firm will pay a dividend of $2.00 per share Solution Sounds tough, but it r ... more>>
wms702 4/17/2008 | 0 (0) | 268 | 13 | 0 | English
A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
B
C
D
E
F
G 8/23/2004
H
Chapter 9. Tool Kit for the Cost of Capital
The cost of capital is a vital element in the capital budgeting process. For a project to be accepted, it must provide a return that e ... more>>
sammyc2007 3/1/2008 | 0 (0) | 302 | 12 | 0 | English
Model Choice CHOOSING THE RIGHT VALUATION MODEL This program is designed to help in choosing the right model to use for any occassion. Page 1 Model Choice Inputs to the model Level of Earnings (in currency) Are your earnings positive ? Yes (Yes or No) If the earnings are positive and normal, please enter the following: What is the expected inflatio ... more>>
sammyc2007 3/1/2008 | 0 (0) | 372 | 1 | 0 | English
FREE CASH FLOW VS. CASH FLOWS TO SHAREHOLDERS DATA Cost of debt 10% EBIT 6.00 Tax rate 40% Investment 12.00 Cost of equity 12% Amount borrowed 4.00 CASH FLOWS TO SHAREHOLDERS Year 0 1 2 3 Goes on forever EBIT 6.00 6.00 6.00 Less interest (0.40) (0.40) (0.40) Earnings before taxes 5.60 5.60 5.60 Taxes (2.24) (2.24) (2.24) Net income 3.36 3.36 3.36 I ... more>>
|