Jump to content
Sign in to follow this  
Ocean West

Amortization schedule

Recommended Posts

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

Thanks

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Awesome thanks for the link :

Share this post


Link to post
Share on other sites

er, attachment :

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    2 members have viewed this topic:
    muzz  James Wong 
×

Important Information

By using this site, you agree to our Terms of Use.