• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Different Interest rates ammortization schedule for same loan

S

shankar_iyer83

Member
Hi,

I have below loan ammortization sheet. Now, the interest rate on the loan has changed from original (9.75) to (9.35) in Oct 2015. Can changes be made in same sheet so that I can see ammortization schedule with varying interest rates like Principal + interest (EMI) charged with 9.75 till August 2015 and rest with 9.35
 

Attachments

  • SBI-MaxGain.xlsx
    70.8 KB · Views: 9
It uses PMT, just adjust Loan amount to the amount when rate changed.
Loan tenure to total - # of payments made when rate changed.
Recalculate with new interest rate.
 
You must log in or register to reply here.
Back
Top