S21C.TXT D i s c o u n t e d C a s h F l o w --------------------------------------- Prepared by | R. Martin Date prepared | 06-13-1992 Description | Discounting vs. Interest Study period | 180 months Discount rate | 8.50 percent Discount method| End-of-month ---------------------------------------------------------------------------- Project Lender Borrower Net Cash Discount Discounted Month (-) (+) Flow Factor Cash Flow ---------------------------------------------------------------------------- 0 -$200,000.00 $200,000.00 $400,000.00 1.0000 $400,000.00 1 $1,969.48 -$1,969.48 -$3,938.96 0.9930 -$3,911.26 2 $1,969.48 -$1,969.48 -$3,938.96 0.9860 -$3,883.75 3 $1,969.48 -$1,969.48 -$3,938.96 0.9790 -$3,856.43 4 $1,969.48 -$1,969.48 -$3,938.96 0.9722 -$3,829.30 5 $1,969.48 -$1,969.48 -$3,938.96 0.9653 -$3,802.37 6 $1,969.48 -$1,969.48 -$3,938.96 0.9585 -$3,775.63 7 $1,969.48 -$1,969.48 -$3,938.96 0.9518 -$3,749.07 8 $1,969.48 -$1,969.48 -$3,938.96 0.9451 -$3,722.70 9 $1,969.48 -$1,969.48 -$3,938.96 0.9385 -$3,696.52 10 $1,969.48 -$1,969.48 -$3,938.96 0.9318 -$3,670.52 11 $1,969.48 -$1,969.48 -$3,938.96 0.9253 -$3,644.70 12 $1,969.48 -$1,969.48 -$3,938.96 0.9188 -$3,619.07 13 $1,969.48 -$1,969.48 -$3,938.96 0.9123 -$3,593.61 14 $1,969.48 -$1,969.48 -$3,938.96 0.9059 -$3,568.34 15 $1,969.48 -$1,969.48 -$3,938.96 0.8995 -$3,543.24 16 $1,969.48 -$1,969.48 -$3,938.96 0.8932 -$3,518.32 17 $1,969.48 -$1,969.48 -$3,938.96 0.8869 -$3,493.57 18 $1,969.48 -$1,969.48 -$3,938.96 0.8807 -$3,469.00 19 $1,969.48 -$1,969.48 -$3,938.96 0.8745 -$3,444.60 20 $1,969.48 -$1,969.48 -$3,938.96 0.8683 -$3,420.37 21 $1,969.48 -$1,969.48 -$3,938.96 0.8622 -$3,396.32 22 $1,969.48 -$1,969.48 -$3,938.96 0.8562 -$3,372.43 23 $1,969.48 -$1,969.48 -$3,938.96 0.8502 -$3,348.71 24 $1,969.48 -$1,969.48 -$3,938.96 0.8442 -$3,325.15 25 $1,969.48 -$1,969.48 -$3,938.96 0.8382 -$3,301.77 26 $1,969.48 -$1,969.48 -$3,938.96 0.8323 -$3,278.54 27 $1,969.48 -$1,969.48 -$3,938.96 0.8265 -$3,255.48 28 $1,969.48 -$1,969.48 -$3,938.96 0.8207 -$3,232.59 29 $1,969.48 -$1,969.48 -$3,938.96 0.8149 -$3,209.85 30 $1,969.48 -$1,969.48 -$3,938.96 0.8092 -$3,187.27 31 $1,969.48 -$1,969.48 -$3,938.96 0.8035 -$3,164.86 32 $1,969.48 -$1,969.48 -$3,938.96 0.7978 -$3,142.60 33 $1,969.48 -$1,969.48 -$3,938.96 0.7922 -$3,120.49 34 $1,969.48 -$1,969.48 -$3,938.96 0.7866 -$3,098.54 35 $1,969.48 -$1,969.48 -$3,938.96 0.7811 -$3,076.75 36 $1,969.48 -$1,969.48 -$3,938.96 0.7756 -$3,055.11 37 $1,969.48 -$1,969.48 -$3,938.96 0.7702 -$3,033.62 38 $1,969.48 -$1,969.48 -$3,938.96 0.7647 -$3,012.28 39 $1,969.48 -$1,969.48 -$3,938.96 0.7594 -$2,991.10 40 $1,969.48 -$1,969.48 -$3,938.96 0.7540 -$2,970.06 41 $1,969.48 -$1,969.48 -$3,938.96 0.7487 -$2,949.17 42 $1,969.48 -$1,969.48 -$3,938.96 0.7435 -$2,928.43 43 $1,969.48 -$1,969.48 -$3,938.96 0.7382 -$2,907.83 44 $1,969.48 -$1,969.48 -$3,938.96 0.7330 -$2,887.38 45 $1,969.48 -$1,969.48 -$3,938.96 0.7279 -$2,867.07 46 $1,969.48 -$1,969.48 -$3,938.96 0.7228 -$2,846.90 47 $1,969.48 -$1,969.48 -$3,938.96 0.7177 -$2,826.88 48 $1,969.48 -$1,969.48 -$3,938.96 0.7126 -$2,807.00 49 $1,969.48 -$1,969.48 -$3,938.96 0.7076 -$2,787.25 50 $1,969.48 -$1,969.48 -$3,938.96 0.7026 -$2,767.65 51 $1,969.48 -$1,969.48 -$3,938.96 0.6977 -$2,748.18 52 $1,969.48 -$1,969.48 -$3,938.96 0.6928 -$2,728.85 53 $1,969.48 -$1,969.48 -$3,938.96 0.6879 -$2,709.66 54 $1,969.48 -$1,969.48 -$3,938.96 0.6831 -$2,690.60 55 $1,969.48 -$1,969.48 -$3,938.96 0.6783 -$2,671.68 56 $1,969.48 -$1,969.48 -$3,938.96 0.6735 -$2,652.89 57 $1,969.48 -$1,969.48 -$3,938.96 0.6688 -$2,634.23 58 $1,969.48 -$1,969.48 -$3,938.96 0.6641 -$2,615.70 59 $1,969.48 -$1,969.48 -$3,938.96 0.6594 -$2,597.30 60 $1,969.48 -$1,969.48 -$3,938.96 0.6547 -$2,579.03 61 $1,969.48 -$1,969.48 -$3,938.96 0.6501 -$2,560.89 62 $1,969.48 -$1,969.48 -$3,938.96 0.6456 -$2,542.88 63 $1,969.48 -$1,969.48 -$3,938.96 0.6410 -$2,525.00 64 $1,969.48 -$1,969.48 -$3,938.96 0.6365 -$2,507.24 65 $1,969.48 -$1,969.48 -$3,938.96 0.6320 -$2,489.60 66 $1,969.48 -$1,969.48 -$3,938.96 0.6276 -$2,472.09 67 $1,969.48 -$1,969.48 -$3,938.96 0.6232 -$2,454.70 68 $1,969.48 -$1,969.48 -$3,938.96 0.6188 -$2,437.44 69 $1,969.48 -$1,969.48 -$3,938.96 0.6145 -$2,420.30 70 $1,969.48 -$1,969.48 -$3,938.96 0.6101 -$2,403.27 71 $1,969.48 -$1,969.48 -$3,938.96 0.6058 -$2,386.37 72 $1,969.48 -$1,969.48 -$3,938.96 0.6016 -$2,369.58 73 $1,969.48 -$1,969.48 -$3,938.96 0.5973 -$2,352.92 74 $1,969.48 -$1,969.48 -$3,938.96 0.5931 -$2,336.37 75 $1,969.48 -$1,969.48 -$3,938.96 0.5890 -$2,319.94 76 $1,969.48 -$1,969.48 -$3,938.96 0.5848 -$2,303.62 77 $1,969.48 -$1,969.48 -$3,938.96 0.5807 -$2,287.42 78 $1,969.48 -$1,969.48 -$3,938.96 0.5766 -$2,271.33 79 $1,969.48 -$1,969.48 -$3,938.96 0.5726 -$2,255.35 80 $1,969.48 -$1,969.48 -$3,938.96 0.5685 -$2,239.49 81 $1,969.48 -$1,969.48 -$3,938.96 0.5645 -$2,223.74 82 $1,969.48 -$1,969.48 -$3,938.96 0.5606 -$2,208.10 83 $1,969.48 -$1,969.48 -$3,938.96 0.5566 -$2,192.57 84 $1,969.48 -$1,969.48 -$3,938.96 0.5527 -$2,177.14 85 $1,969.48 -$1,969.48 -$3,938.96 0.5488 -$2,161.83 86 $1,969.48 -$1,969.48 -$3,938.96 0.5450 -$2,146.63 87 $1,969.48 -$1,969.48 -$3,938.96 0.5411 -$2,131.53 88 $1,969.48 -$1,969.48 -$3,938.96 0.5373 -$2,116.54 89 $1,969.48 -$1,969.48 -$3,938.96 0.5336 -$2,101.65 90 $1,969.48 -$1,969.48 -$3,938.96 0.5298 -$2,086.87 91 $1,969.48 -$1,969.48 -$3,938.96 0.5261 -$2,072.19 92 $1,969.48 -$1,969.48 -$3,938.96 0.5224 -$2,057.61 93 $1,969.48 -$1,969.48 -$3,938.96 0.5187 -$2,043.14 94 $1,969.48 -$1,969.48 -$3,938.96 0.5151 -$2,028.77 95 $1,969.48 -$1,969.48 -$3,938.96 0.5114 -$2,014.50 96 $1,969.48 -$1,969.48 -$3,938.96 0.5078 -$2,000.33 97 $1,969.48 -$1,969.48 -$3,938.96 0.5043 -$1,986.26 98 $1,969.48 -$1,969.48 -$3,938.96 0.5007 -$1,972.29 99 $1,969.48 -$1,969.48 -$3,938.96 0.4972 -$1,958.42 100 $1,969.48 -$1,969.48 -$3,938.96 0.4937 -$1,944.65 101 $1,969.48 -$1,969.48 -$3,938.96 0.4902 -$1,930.97 102 $1,969.48 -$1,969.48 -$3,938.96 0.4868 -$1,917.39 103 $1,969.48 -$1,969.48 -$3,938.96 0.4834 -$1,903.90 104 $1,969.48 -$1,969.48 -$3,938.96 0.4800 -$1,890.51 105 $1,969.48 -$1,969.48 -$3,938.96 0.4766 -$1,877.21 106 $1,969.48 -$1,969.48 -$3,938.96 0.4732 -$1,864.01 107 $1,969.48 -$1,969.48 -$3,938.96 0.4699 -$1,850.90 108 $1,969.48 -$1,969.48 -$3,938.96 0.4666 -$1,837.88 109 $1,969.48 -$1,969.48 -$3,938.96 0.4633 -$1,824.95 110 $1,969.48 -$1,969.48 -$3,938.96 0.4601 -$1,812.12 111 $1,969.48 -$1,969.48 -$3,938.96 0.4568 -$1,799.37 112 $1,969.48 -$1,969.48 -$3,938.96 0.4536 -$1,786.72 113 $1,969.48 -$1,969.48 -$3,938.96 0.4504 -$1,774.15 114 $1,969.48 -$1,969.48 -$3,938.96 0.4472 -$1,761.67 115 $1,969.48 -$1,969.48 -$3,938.96 0.4441 -$1,749.28 116 $1,969.48 -$1,969.48 -$3,938.96 0.4410 -$1,736.98 117 $1,969.48 -$1,969.48 -$3,938.96 0.4379 -$1,724.76 118 $1,969.48 -$1,969.48 -$3,938.96 0.4348 -$1,712.63 119 $1,969.48 -$1,969.48 -$3,938.96 0.4317 -$1,700.58 120 $1,969.48 -$1,969.48 -$3,938.96 0.4287 -$1,688.62 121 $1,969.48 -$1,969.48 -$3,938.96 0.4257 -$1,676.75 122 $1,969.48 -$1,969.48 -$3,938.96 0.4227 -$1,664.95 123 $1,969.48 -$1,969.48 -$3,938.96 0.4197 -$1,653.24 124 $1,969.48 -$1,969.48 -$3,938.96 0.4168 -$1,641.61 125 $1,969.48 -$1,969.48 -$3,938.96 0.4138 -$1,630.07 126 $1,969.48 -$1,969.48 -$3,938.96 0.4109 -$1,618.60 127 $1,969.48 -$1,969.48 -$3,938.96 0.4080 -$1,607.22 128 $1,969.48 -$1,969.48 -$3,938.96 0.4052 -$1,595.91 129 $1,969.48 -$1,969.48 -$3,938.96 0.4023 -$1,584.69 130 $1,969.48 -$1,969.48 -$3,938.96 0.3995 -$1,573.54 131 $1,969.48 -$1,969.48 -$3,938.96 0.3967 -$1,562.47 132 $1,969.48 -$1,969.48 -$3,938.96 0.3939 -$1,551.49 133 $1,969.48 -$1,969.48 -$3,938.96 0.3911 -$1,540.57 134 $1,969.48 -$1,969.48 -$3,938.96 0.3884 -$1,529.74 135 $1,969.48 -$1,969.48 -$3,938.96 0.3856 -$1,518.98 136 $1,969.48 -$1,969.48 -$3,938.96 0.3829 -$1,508.29 137 $1,969.48 -$1,969.48 -$3,938.96 0.3802 -$1,497.69 138 $1,969.48 -$1,969.48 -$3,938.96 0.3775 -$1,487.15 139 $1,969.48 -$1,969.48 -$3,938.96 0.3749 -$1,476.69 140 $1,969.48 -$1,969.48 -$3,938.96 0.3723 -$1,466.31 141 $1,969.48 -$1,969.48 -$3,938.96 0.3696 -$1,455.99 142 $1,969.48 -$1,969.48 -$3,938.96 0.3670 -$1,445.75 143 $1,969.48 -$1,969.48 -$3,938.96 0.3645 -$1,435.58 144 $1,969.48 -$1,969.48 -$3,938.96 0.3619 -$1,425.49 145 $1,969.48 -$1,969.48 -$3,938.96 0.3593 -$1,415.46 146 $1,969.48 -$1,969.48 -$3,938.96 0.3568 -$1,405.50 147 $1,969.48 -$1,969.48 -$3,938.96 0.3543 -$1,395.62 148 $1,969.48 -$1,969.48 -$3,938.96 0.3518 -$1,385.80 149 $1,969.48 -$1,969.48 -$3,938.96 0.3493 -$1,376.05 150 $1,969.48 -$1,969.48 -$3,938.96 0.3469 -$1,366.38 151 $1,969.48 -$1,969.48 -$3,938.96 0.3444 -$1,356.77 152 $1,969.48 -$1,969.48 -$3,938.96 0.3420 -$1,347.22 153 $1,969.48 -$1,969.48 -$3,938.96 0.3396 -$1,337.75 154 $1,969.48 -$1,969.48 -$3,938.96 0.3372 -$1,328.34 155 $1,969.48 -$1,969.48 -$3,938.96 0.3349 -$1,319.00 156 $1,969.48 -$1,969.48 -$3,938.96 0.3325 -$1,309.72 157 $1,969.48 -$1,969.48 -$3,938.96 0.3302 -$1,300.51 158 $1,969.48 -$1,969.48 -$3,938.96 0.3278 -$1,291.36 159 $1,969.48 -$1,969.48 -$3,938.96 0.3255 -$1,282.28 160 $1,969.48 -$1,969.48 -$3,938.96 0.3232 -$1,273.26 161 $1,969.48 -$1,969.48 -$3,938.96 0.3210 -$1,264.30 162 $1,969.48 -$1,969.48 -$3,938.96 0.3187 -$1,255.41 163 $1,969.48 -$1,969.48 -$3,938.96 0.3165 -$1,246.58 164 $1,969.48 -$1,969.48 -$3,938.96 0.3142 -$1,237.81 165 $1,969.48 -$1,969.48 -$3,938.96 0.3120 -$1,229.11 166 $1,969.48 -$1,969.48 -$3,938.96 0.3098 -$1,220.46 167 $1,969.48 -$1,969.48 -$3,938.96 0.3077 -$1,211.88 168 $1,969.48 -$1,969.48 -$3,938.96 0.3055 -$1,203.35 169 $1,969.48 -$1,969.48 -$3,938.96 0.3034 -$1,194.89 170 $1,969.48 -$1,969.48 -$3,938.96 0.3012 -$1,186.48 171 $1,969.48 -$1,969.48 -$3,938.96 0.2991 -$1,178.14 172 $1,969.48 -$1,969.48 -$3,938.96 0.2970 -$1,169.85 173 $1,969.48 -$1,969.48 -$3,938.96 0.2949 -$1,161.62 174 $1,969.48 -$1,969.48 -$3,938.96 0.2928 -$1,153.45 175 $1,969.48 -$1,969.48 -$3,938.96 0.2908 -$1,145.34 176 $1,969.48 -$1,969.48 -$3,938.96 0.2887 -$1,137.29 177 $1,969.48 -$1,969.48 -$3,938.96 0.2867 -$1,129.29 178 $1,969.48 -$1,969.48 -$3,938.96 0.2847 -$1,121.34 179 $1,969.48 -$1,969.48 -$3,938.96 0.2827 -$1,113.46 180 $1,969.48 -$1,969.48 -$3,938.96 0.2807 -$1,105.63 ---------------------------------------------------------------------------- Total $154,506.40 -$154,506.40 -$309,012.80 102.5497 -$0.20 ---------------------------------------------------------------------------- Uniform monthly inflow without terminal value | $0.00 Internal rate of return (IRR)(outflow) | 8.50 percent IRR--discount rate differential (outflow) | 0.00 percent ---------------------------------------------------------------------------- Home Page Menu: http://members.tripod.com/~Ray_Martin/RMenu.html