I just built a financial model for retirement decision making, ie: When to take SS, take out IRA/ keep working, for a cash flow analysis, including federal taxes, std deduction changes, expenses, pensions, IRA balances and
bond payoff along with auto replacement, insurances, roof replacements, etc. .
for the next 20 years for anyone to use. . testing it out tonight with a neighbor who just lost his job here in TV, and is 62, so needs some help making a decision. .
What i found in reproducing the Bond payoff amount by year, is that the numbers published on the district web site are pretty funky. . . doesn't fit the typical amortization schedule as presented. . its weird as the District interest and principal total is $1,790 versus the $1,824 as calculated by the excel formula, and tested out and its correct. .
Below is the comparison between excel amortization calculated schedule for the first 4 years, against the district schedule. . . I can't figure out what they are doing, and i suspect there are some cell adjustments which is why the schedule is a pdf, and the interest and principal totals are different. .
Here is the snapshot, any financial types help me out here?
Here is the link to the original schedule
https://www.districtgov.org/departme...Unit%2020V.pdf