• 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.

Calculate number of years

Thomas Kuriakose

Active Member
Respected Sirs,

We have loan amount for which we need to know how to calculate the number of years if the monthly payment is increased.

The initial monthly payment was 1000. Now the wasn't to increase to 1500, in this case when the monthly payment has increased, how calculate the number of years which should be less.

Thank you very much,

with regards,
thomas
 

Attachments

  • No of Years Calculation.xlsx
    10.1 KB · Views: 3
Respected Sir,

Thank you very much for the solution provided.

Sir, is it possible to enter the monthly value in B10 and get the number of years in B5 without the table.

Thank you very much once again,

with regards,
thomas
 
Back
Top