Loading...
HomeMy WebLinkAbout18 Atta 1 DWR SRF Loan Amortization SchedulerRUCKEE DONNER PUBLIC UTILITY DISTRICT Department of Water Resources-SRF Loan Schedule TERM: 20 years Semiannual Payments RATE 2.3400% .. > r Closing Date: I 2Za TOTAL LOAN 12,732,965�,� 2 `' Pmt Y# Date Semiannual Payment Interest Princi al Principal Balance Princi al Reduction Factor Monthiv Int Accrual 12,732,965.00 "' 1 7/1 /06 400,426.15 148,975.69 251,450.46 12,481,514.54 1.974799% "' ' " ;' 24,829.28 2 1/1107 400,426.15 146,033.72 254,392.43 12,227,122.11 1.997904% 24,338.95 3 7/1/07 400,426.15 143,057.33 257,368.82 11,969,753.29 2.021280% 23,842.89 4 1/1/08 400,426.15 140,046.11 260,380.04 11,709,373.25 2.044929% 23,341.02 5 7/1/08 400,426.15 136,999.67 263,426.48 11,445,946.77 2.068854% 22.833.28 s 1 1/1/09 400,426.15 133,917.58 266,508.57 11,179,438.20 2,093060% 22,319.60 7 7/1/09 400,426.15 130,799.43 269,626.72 10,909,811.48 2.117549% 21,799.91 8 1/1/10 400,426.15 127.644.79 272,781.36 10,637,030.12 2.142324°J 21,274.13 9 7/1/10 400,426.15 124,453.25 275,972.90 10,361,057.22 2.167389% 20,742.21 10 1/1111 400,426.15 121,224.37 279,201.78 10,081,855.44 2.192748% 20,204.06 11 7/1/11 400,426.15 117,957.71 282,468.44 9,799,387.00 2.218403% 19,659.62 12 1/1/12` --400,426.15 114,652.83 285,773.32 9,513,613.68 2.244358% 19,108.81 13 7/1/12 400,426.15 111,309.28 289,116.87 9,224,496.81 2.270617% 18,551.55 14 1/1/13 400,426.15 107,926.61 292,499.54 8,931,997.27 2.297183% 17,987.77 15 7/1/13 400.426.15 104,504.37 295,921.78 8,636,075.49 2.324060% 17,417.40 16 1/1/14 400,426.15 101,042.08 299,384.07 8,336,691.42 2.351252% 16,840.35 17 7/1/14 400,426.15 97,539.29 302,886.86 8,033,804.56 2.378761%' ` .: _ ! 15,256.55 :18 1/1/15 400,426.15 93,995.51 306,430.64 7,727,373.92 2.406593%' 15,665.92 19 7/1/15 400,426.15 90,410.27 310,015.88 7,417,358.04 2.434750% 15,068.38 20 1/1/16 400,426.15 86,783.09 313,643.06 7,103,714.98 2.463237% 14,463.85 21 7/1/16 400,426.15 83,113.47 317,312.68 6,786,402.30 2.492056%:. 13,852.25 22 1/1/17 400,426.15 79,400.91 321,025.24 6,455,377.06 2.521214% 13,233.49 23 7/1/17 400,426.15 75,644.91 324,781.24 6,140,595.82 2.550712% 12,607.49 24 111/18 400,426.15 71,844.97 328,581.18 5,812,014.64 2.580555%'' 11,974.16 25 7/1/18 400,426.15 68,000.57 332,425.58 5,479,589.06 2.610748% 11,333.43 26 1/1/19 400,426.15 64,111.19 336,314.96 5,143,274.10 2.641293% 10,685.20 27 7/1/19 400,426.15 60,176.31 340,249.84 4,803,024.26 2.672196% 10,029.39 28 1/1/20 400,426.15 56,195.38 344,230.77 4,458,793.49 2.703461% 9,365.90 29 7/1/20 400,426.15 52,167.88 348,258.27 4,110,535.2 2.735092% 8,694.65 30 1/1/21 400,426.15 48,093.26 352,332.89 3,758,202.33 2.767092% 8,015.54 31 7/1/21 400,426.15 43,970.97 356,455.18 3,401,747.15 2.799467% 7,328.50 32 1/1/22 400,426.15 39,800.44 360,625.71 3,041,121.44 2.832221%'' 6,633.41 33 7/1/22 400,426.15 35,581.12 364,845.03 2,676,276.41 2.865358% 5,930.19 34 1/1/23 400,426.15 31,312.43 369,113.72 2,307,162.69 2.898883% 5,218.74 35 7/1/23 400,42615 26,993.80 373,432.35 1,933,730.34 2.932800% 4,498.97 36 1/1/24 400.426.15 22,624.64 377,801.51 1,555,928.83 2.967113% 3,770.77 37 7/1/24 400,426.15 18,204.37 382,221.78 1,173,707.05 3.001829%: 3,034.06 38 1/1/25 400,426.15 13,732.37 386,693.78 787,013.27 3.036950% 2,288.73 39 7/1/25 400,426.15 9,208.06 391,218.09 395,795.18 3.072482% 1,534.68 40 1/1/26 400,425.98 4,630.80 395,795.18 0.00 3.108429% 771.80 16,017,045.83 3,284,080.83 12,732,965.00 SRF amortization Page 1 6/6/2005