
09-21-2023, 07:07 AM
|
Member
|
Join Date: Nov 2019
Posts: 71
Thanks: 166
Thanked 111 Times in 42 Posts
|
|
Quote:
Originally Posted by CoachKandSportsguy
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
|
Former accountant here-
I believe the interest rate given is the APR, which would have included the amortization of fees. On the original bond.
If you back into the rate by dividing the interest vs. the balance you get something closer to 4.1308, which is much closer.
|