WAVEPOOLCASE.xlsx
Sheet1
| LOAN AMOUNT | ANNUAL PRINCIPAL | ANNUAL INTEREST | INTEREST+ PRIN | OPERATING AND MAINT | OM+PRIN+INT | BOND RESERVE | TOTAL $$ PAID |
| | | 8% |
| 6,000,000 | 600,000 | 480000 | 1,080,000 | 375,000 | 1,455,000 | 363,750 | 1,818,750 |
| 5,400,000 | 600,000 | 432000 | 1,032,000 | 375,000 | 1,407,000 | 363,750 | 1,770,750 |
| 4,800,000 | 600,000 | 384000 | 984,000 | 375,000 | 1,359,000 | 363,750 | 1,722,750 |
| 4,200,000 | 600,000 | 336000 | 936,000 | 375,000 | 1,311,000 | 363,750 | 1,674,750 |
| 3,600,000 | 600,000 | 288000 | 888,000 | 375,000 | 1,263,000 | | 1,263,000 |
| 3,000,000 | 600,000 | 240000 | 840,000 | 375,000 | 1,215,000 | | 1,215,000 |
| 2,400,000 | 600,000 | 192000 | 792,000 | 375,000 | 1,167,000 | | 1,167,000 |
| 1,800,000 | 600,000 | 144000 | 744,000 | 375,000 | 1,119,000 | | 1,119,000 |
| 1,200,000 | 600,000 | 96000 | 696,000 | 375,000 | 1,071,000 | | 1,071,000 |
| 600,000 | 600,000 | 48000 | 648,000 | 375,000 | 1,023,000 | | 1,023,000 |
| 0 | 6,000,000 | 2640000 |
Bigjayq8
