S05L1.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L1 - Sign Change Demonstration Study period : 12 months Discount rate : 12.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$50.00 -$50.00 0.9901 -$49.50 2 $0.00 -$50.00 -$50.00 0.9803 -$49.01 3 $20,000.00 -$50.00 -$20,050.00 0.9706 -$19,460.33 4 $0.00 $150.00 $150.00 0.9610 $144.15 5 $0.00 $150.00 $150.00 0.9515 $142.72 6 $0.00 $150.00 $150.00 0.9420 $141.31 7 $1,000.00 $150.00 -$850.00 0.9327 -$792.81 8 $0.00 $160.00 $160.00 0.9235 $147.76 9 -$3,000.00 $160.00 $3,160.00 0.9143 $2,889.31 10 $0.00 $130.00 $130.00 0.9053 $117.69 11 $0.00 $130.00 $130.00 0.8963 $116.52 12 -$13,000.00 $130.00 $13,130.00 0.8874 $11,652.21 ---------------------------------------------------------------------------- Total $0.00 $1,160.00 $1,160.00 12.2551 $0.02 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 4) : 12.00 percent IRR--discount rate differential : 0.00 percent ---------------------------------------------------------------------------- S05L2.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L2 - Sign Change Demonstration Study period : 12 months Discount rate :120.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$500.00 -$500.00 0.9091 -$454.55 2 $0.00 -$500.00 -$500.00 0.8264 -$413.22 3 $20,000.00 -$500.00 -$20,500.00 0.7513 -$15,401.95 4 $0.00 $1,500.00 $1,500.00 0.6830 $1,024.52 5 $0.00 $1,500.00 $1,500.00 0.6209 $931.38 6 $0.00 $1,500.00 $1,500.00 0.5645 $846.71 7 $1,000.00 $1,500.00 $500.00 0.5132 $256.58 8 $0.00 $1,600.00 $1,600.00 0.4665 $746.41 9 -$3,000.00 $1,600.00 $4,600.00 0.4241 $1,950.85 10 $0.00 $1,300.00 $1,300.00 0.3855 $501.21 11 $0.00 $1,300.00 $1,300.00 0.3505 $455.64 12 -$13,000.00 $1,300.00 $14,300.00 0.3186 $4,556.42 ---------------------------------------------------------------------------- Total $0.00 $11,600.00 $11,600.00 7.8137 $0.00 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 120.00 percent IRR--discount rate differential : 0.00 percent ---------------------------------------------------------------------------- S05L3.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L3 - Sign Change Demonstration Study period : 12 months Discount rate :240.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$1,000.00 -$1,000.00 0.8333 -$833.33 2 $0.00 -$1,000.00 -$1,000.00 0.6944 -$694.44 3 $20,000.00 -$1,000.00 -$21,000.00 0.5787 -$12,152.78 4 $0.00 $3,000.00 $3,000.00 0.4823 $1,446.76 5 $0.00 $3,000.00 $3,000.00 0.4019 $1,205.63 6 $0.00 $3,000.00 $3,000.00 0.3349 $1,004.69 7 $1,000.00 $3,000.00 $2,000.00 0.2791 $558.16 8 $0.00 $3,200.00 $3,200.00 0.2326 $744.22 9 -$3,000.00 $3,200.00 $6,200.00 0.1938 $1,201.60 10 $0.00 $2,600.00 $2,600.00 0.1615 $419.91 11 $0.00 $2,600.00 $2,600.00 0.1346 $349.93 12 -$13,000.00 $2,600.00 $15,600.00 0.1122 $1,749.64 ---------------------------------------------------------------------------- Total $0.00 $23,200.00 $23,200.00 5.4392 -$0.01 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 240.00 percent IRR--discount rate differential : 0.00 percent ---------------------------------------------------------------------------- S05L4.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L4 - Sign Change Demonstration Study period : 12 months Discount rate :480.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$2,000.00 -$2,000.00 0.7143 -$1,428.57 2 $0.00 -$2,000.00 -$2,000.00 0.5102 -$1,020.41 3 $20,000.00 -$2,000.00 -$22,000.00 0.3644 -$8,017.49 4 $0.00 $6,000.00 $6,000.00 0.2603 $1,561.85 5 $0.00 $6,000.00 $6,000.00 0.1859 $1,115.61 6 $0.00 $6,000.00 $6,000.00 0.1328 $796.86 7 $1,000.00 $6,000.00 $5,000.00 0.0949 $474.32 8 $0.00 $6,400.00 $6,400.00 0.0678 $433.67 9 -$3,000.00 $6,400.00 $9,400.00 0.0484 $454.96 10 $0.00 $5,200.00 $5,200.00 0.0346 $179.77 11 $0.00 $5,200.00 $5,200.00 0.0247 $128.41 12 -$13,000.00 $5,200.00 $18,200.00 0.0176 $321.02 ---------------------------------------------------------------------------- Total $0.00 $46,400.00 $46,400.00 3.4559 $0.00 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 480.00 percent IRR--discount rate differential : 0.00 percent ---------------------------------------------------------------------------- S05L5.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L5 - Sign Change Demonstration Study period : 12 months Discount rate :840.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$3,500.00 -$3,500.00 0.5882 -$2,058.82 2 $0.00 -$3,500.00 -$3,500.00 0.3460 -$1,211.07 3 $20,000.00 -$3,500.00 -$23,500.00 0.2035 -$4,783.23 4 $0.00 $10,500.00 $10,500.00 0.1197 $1,257.17 5 $0.00 $10,500.00 $10,500.00 0.0704 $739.51 6 $0.00 $10,500.00 $10,500.00 0.0414 $435.01 7 $1,000.00 $10,500.00 $9,500.00 0.0244 $231.52 8 $0.00 $11,200.00 $11,200.00 0.0143 $160.56 9 -$3,000.00 $11,200.00 $14,200.00 0.0084 $119.74 10 $0.00 $9,100.00 $9,100.00 0.0050 $45.14 11 $0.00 $9,100.00 $9,100.00 0.0029 $26.55 12 -$13,000.00 $9,100.00 $22,100.00 0.0017 $37.93 ---------------------------------------------------------------------------- Total $0.00 $81,200.00 $81,200.00 2.4261 $0.01 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 697.50 percent IRR--discount rate differential (outflow) : 142.50 percent ---------------------------------------------------------------------------- S05L6.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L6 - Sign Change Demonstration Study period : 12 months Discount rate :960.00 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$4,000.00 -$4,000.00 0.5556 -$2,222.22 2 $0.00 -$4,000.00 -$4,000.00 0.3086 -$1,234.57 3 $20,000.00 -$4,000.00 -$24,000.00 0.1715 -$4,115.23 4 $0.00 $12,000.00 $12,000.00 0.0953 $1,143.12 5 $0.00 $12,000.00 $12,000.00 0.0529 $635.07 6 $0.00 $12,000.00 $12,000.00 0.0294 $352.81 7 $1,000.00 $12,000.00 $11,000.00 0.0163 $179.67 8 $0.00 $12,800.00 $12,800.00 0.0091 $116.15 9 -$3,000.00 $12,800.00 $15,800.00 0.0050 $79.65 10 $0.00 $10,400.00 $10,400.00 0.0028 $29.13 11 $0.00 $10,400.00 $10,400.00 0.0016 $16.18 12 -$13,000.00 $10,400.00 $23,400.00 0.0009 $20.23 ---------------------------------------------------------------------------- Total $0.00 $92,800.00 $92,800.00 2.2489 -$0.01 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 697.03 percent IRR--discount rate differential (outflow) : 262.97 percent ---------------------------------------------------------------------------- S05L7.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by : Ray Martin Date prepared : 05-10-1997 Description : S05L7 - Sign Change Demonstration Study period : 12 months Discount rate :697.14 percent Discount method: End-of-month ---------------------------------------------------------------------------- Project Borrow/Pay Interest Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$5,000.00 $0.00 $5,000.00 1.0000 $5,000.00 1 $0.00 -$4,000.00 -$4,000.00 0.6325 -$2,530.12 2 $0.00 -$4,000.00 -$4,000.00 0.4001 -$1,600.38 3 $20,000.00 -$4,000.00 -$24,000.00 0.2531 -$6,073.75 4 $0.00 $12,000.00 $12,000.00 0.1601 $1,920.92 5 $0.00 $12,000.00 $12,000.00 0.1013 $1,215.04 6 $0.00 $12,000.00 $12,000.00 0.0640 $768.55 7 $1,000.00 $12,000.00 $11,000.00 0.0405 $445.62 8 $0.00 $12,800.00 $12,800.00 0.0256 $327.99 9 -$3,000.00 $12,800.00 $15,800.00 0.0162 $256.09 10 $0.00 $10,400.00 $10,400.00 0.0103 $106.62 11 $0.00 $10,400.00 $10,400.00 0.0065 $67.44 12 -$13,000.00 $10,400.00 $23,400.00 0.0041 $95.98 ---------------------------------------------------------------------------- Total $0.00 $92,800.00 $92,800.00 2.7143 $0.00 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value : $0.00 Internal rate of return (IRR)(Sign +/-: 2) : 697.03 percent IRR--discount rate differential (outflow) : 0.11 percent ---------------------------------------------------------------------------- Home Page: http://www.texas.net/~rmartin/RMenu.html