Talk of The Villages Florida - View Single Post - District Bond Amortization schedule is very weird, doesn't match normal calcs
View Single Post
 
Old 09-20-2023, 09:33 AM
CoachKandSportsguy CoachKandSportsguy is offline
Sage
Join Date: Jan 2019
Location: Marsh Bend
Posts: 3,707
Thanks: 653
Thanked 2,702 Times in 1,318 Posts
Default District Bond Amortization schedule is very weird, doesn't match normal calcs

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
Attached Thumbnails
The Villages Florida: Click image for larger version

Name:	TV_Bond_Amortization.jpg
Views:	4034
Size:	91.1 KB
ID:	100253  

Last edited by CoachKandSportsguy; 09-20-2023 at 09:41 AM.