Loading...
HomeMy WebLinkAboutResolution 2018-030Principal Accrued Interest Payable (Simple) Outstanding Loan Amounts Loan #1 155,174.54$ 34,488.13$ Loan #2 500,000.00 111,126.88 Loan #3 720,000.00 160,022.71 Total Outstanding 7/1/2019 1,375,174.54$ 305,637.71$ Maximum Payment Amount 1,592,981.00$ Less: 2012-2013 Residual RPTTF distributed (196,237.80) 1,396,743.20 Times .5 0.50 Maximum Payment Amount 698,372.00$ Date Payment Amount to Low/Mod Principal Payments Interest Payments Interest Earned Principal Balance Accumulated Interest Beginning Balance 1,375,174.54$ 305,637.71$ 7/1/2019 90,000.00$ (18,000.00)$ 72,000.00$ -$ -$ 1,303,174.54 305,637.71 10/1/2019 - - 9,854.14 1,303,174.54 315,491.86 1/1/2020 90,000.00 (18,000.00) 72,000.00 - 9,854.14 1,231,174.54 325,346.00 4/1/2020 - - 9,208.51 1,231,174.54 334,554.51 7/1/2020 115,000.00 (23,000.00) 92,000.00 - 9,208.51 1,139,174.54 343,763.02 10/1/2020 - - 8,614.03 1,139,174.54 352,377.05 1/1/2021 115,000.00 (23,000.00) 92,000.00 - 8,614.03 1,047,174.54 360,991.08 4/1/2021 - - 7,746.22 1,047,174.54 368,737.31 7/1/2021 140,000.00 (28,000.00) 112,000.00 - 7,832.29 935,174.54 376,569.60 10/1/2021 - - 7,071.46 935,174.54 383,641.06 1/1/2022 140,000.00 (28,000.00) 112,000.00 - 7,071.46 823,174.54 390,712.51 4/1/2022 - - 6,089.24 823,174.54 396,801.75 7/1/2022 165,000.00 (33,000.00) 132,000.00 - 6,156.89 691,174.54 402,958.64 10/1/2022 - - 5,226.42 691,174.54 408,185.06 1/1/2023 165,000.00 (33,000.00) 132,000.00 - 5,226.42 559,174.54 413,411.47 4/1/2023 - - 4,136.36 559,174.54 417,547.83 7/1/2023 190,000.00 (38,000.00) 152,000.00 - 4,182.32 407,174.54 421,730.15 10/1/2023 - - 3,078.91 407,174.54 424,809.06 1/1/2024 190,000.00 (38,000.00) 152,000.00 - 3,078.91 255,174.54 427,887.97 4/1/2024 - 1,908.57 255,174.54 429,796.54 7/1/2024 215,000.00 (43,000.00) 172,000.00 - 1,908.57 83,174.54 431,705.10 10/1/2024 - 628.94 83,174.54 432,334.04 1/1/2025 215,000.00 (43,000.00) 83174.54 88,825.46 628.94 - 344,137.51 4/1/2025 - - - 344,137.51 7/1/2025 215,000.00 (43,000.00) - 172,000.00 - - 172,137.51 10/1/2025 - - - 172,137.51 1/1/2026 215,171.89 (43,034.38) - 172,137.51 - - - Exhibit A SUCCESSOR AGENCY CASH FLOW FORECAST - CITY LOAN REPAYMENT SCHEDULE 3% Interest earned- simple interst calculated quarterly until principal is paid off (simple interest means no interest on outstanding interest payments) Estimated Residual RPTTF 2018