Sample DCF Output(Printer or ASCII File)

D i s c o u n t e d C a s h F l o w

---------------------------------------

Prepared by | R. Martin

Date prepared | 08-05-1993

Description | Sample DCF File

Study period | 8 quarters

Discount rate | 10.47 percent (geometric mean of positive rates)

Discount method| Continuous

----------------------------------------------------------------------------

Project Expenditures Revenues Net Cash Discount Discounted

Quarter (-) (+) Flow Rate Factor Cash Flow

----------------------------------------------------------------------------

0 $1,000.00 $0.00 -$1,000.00 0.00 1.0000 -$1,000.00

1 $0.00 $500.00 $500.00 10.00 0.9876 $493.80

2 $0.00 $500.00 $500.00 10.00 0.9632 $481.61

3 $0.00 $500.00 $500.00 10.00 0.9394 $469.72

4 $0.00 -$500.00 -$500.00 10.00 0.9162 -$458.12

5 $0.00 $500.00 $500.00 10.00 0.8936 $446.81

6 $0.00 -$500.00 -$500.00 10.00 0.8716 -$435.78

7 $0.00 $500.00 $500.00 12.00 0.8229 $411.43

8 $0.00 -$500.00 -$500.00 12.00 0.7985 -$399.27

----------------------------------------------------------------------------

Tot $1,000.00 $1,000.00 $0.00 8.1931 $10.20

----------------------------------------------------------------------------

Number of quarters to payback [discounted] | 3.0 [ 3.1]

Uniform quarterly inflow without terminal value | $1.24

Terminal value (undiscounted) | $1,000.00

Discounted terminal value | $789.41

Total discounted cash flow with terminal value | $799.61

Uniform quarterly inflow with terminal value | $97.60

Internal rate of return (IRR)(Sign +/-: 7) | 116.96 percent

IRR--discount rate differential | 106.50 percent

----------------------------------------------------------------------------

Copyright © 1991-1997, Ray Martin

Previous slide

Next slide

Back to first slide

View graphic version