I-1 - Finance Plan Tiffin 2021A Refunding

Attachment 1 – Preliminary Refunding Analysis Existing Date Total P+I D/S Net New D/S Old Net D/S S avings 06/01/2021 - 373,757.50 370,460.00 373,757.50 3,297.50 06/01/2022 396,210.24 - 396,210.24 419,265.00 23,054.76 06/01/2023 396,432.50 - 396,432.50 415,425.00 18,992.50 06/01/2024 392,917.50 - 392,917.50 415,765.00 22,847.50 06/01/2025 394,217.50 - 394,217.50 415,115.00 20,897.50 06/01/2026 400,280.00 - 400,280.00 418,800.00 18,520.00 06/01/2027 395,660.00 - 395,660.00 416,640.00 20,980.00 06/01/2028 395,655.00 - 395,655.00 418,770.00 23,115.00 Total $2,771,372.74 $373,757.50 $3,141,832.74 $3,293,537.50 $151,704.76 PV Analysis S ummary (Net to Net) Gross PV Debt Service Savings..................... 141,658.02 Net PV Cashflow Savings @ 1.207%(Bond Yield)..... 141,658.02 Contingency or Rounding Amount.................... 3,297.50 Net Present Value Benefit $144,955.52 Net PV Benefit / $2,776,658.02 PV Refunded Debt Service 5.221% Net PV Benefit / $2,580,000 Refunded Principal... 5.618% Net PV Benefit / $2,635,000 Refunding Principal.. 5.501% Northland Securities, Inc. Page 4