# solutions wanted Amortization schedule

## Recommended Posts

any one have a simple file that creates a simple amortization schedule?

Thanks

##### Share on other sites

Script (i.e. actual records) or calc?

##### Share on other sites

yes script creates actual records kind of like the excel spread sheet worksheet..

##### Share on other sites

I see that JMO has only old pre-7 files; try this one:

AmortizationTableGen.fp7.zip

##### Share on other sites

Awesome thanks for the link :

:qwery:

er, attachment :

##### Share on other sites

Ok thinking thru the actual requirements that I am trying to compute:

the applicant is to only pay interest only during the time they are in school (say 15 months) and the interest for that term is capitalized so it becomes part of the loan amount. (adj balance)

then after graduation the loan is fully amortized from that point thru the remaining payments ( 120 term - 15 ioTerm = 105)

The minimum interest only portion is 1% of the total loan plus original fee, however that is a guideline and the minimum can be manually adjusted for the initial period based on several factors, an adjustment should be reflected in the amortization schedule.

s

##### Share on other sites

While they pay interest only, the balance remains the same. When this is over, the "real" loan begins with the original balance and the remaining number of periods.

If they pay less or more than interest only, then the balance needs to be adjusted each month by the difference. The following month you compute the interest on the current principal, and adjust the balance again. Everything else stays the same.

The 1% minimum rule seems rather arbitrary. Take a loan of \$100k, with an annual rate of 4% and 120 payments:

• The monthly payment should be \$1,012.45.

• Interest only is \$333.33 a month.

• The 1% minimum is \$1,000.00 - almost the same amount as what the borrower would pay without getting any breaks.

##### Share on other sites

Ok i figured out why it wasn't working the field for interest rate was put in as a whole number.

##### Share on other sites

What is the traditional rules regarding rounding or truncating, when dealing with amortization schedules?

##### Share on other sites

I don't know that there are any standards. I round for display only, and carry over with full precision. I don't think the error can be significant, because the monthly payment is fixed and accurate to the nearest cent. The maximum rounding error here is half a cent, and the maximum gain/loss of a party to a loan at an annual rate of 5%, payable in 120 installments is about \$0.78.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

×
×
• Create New...