Loan amortization


March 29th, 2013 by Mansoor Sajid Mansoor Sajid

I need a loan amortization table where loan tenure,initial grace period (during which no payment is made), interest rate, repayment-terms(monthly, quarterlr, semi-annual, or annual) are flexible to change. Maximum tenure will not be more than 15 years excluding initial 2 years grace period, however, I should be able to play around these numbers depending upon free cash flow.

Thanks
Mansoor
Cell:+966 50 300 1714

7 Responses to “Loan amortization”

  1. admin admin Says:

    You have to send us your layout first before we can help you input the formulas into the correct location.

  2. Mansoor Sajid Says:

    Layout would be as follows:-
    In Column A (Loan Tenure)row 2 to 20 are linked to formulas. If loan tenure is 9 years and initial grace period is 2 years then row 2 and 3 will show grace period during which no payments (principal & interest)are made. Row 4 to 12 would show year-1 to year-9 assuming repayments would be made annually. However if repayment terms are quaterly or semi-annually then column A would expand further.
    Like wise principal repayments and accrued interest would be linked to each row under column A.

  3. BenneTan BenneTan Says:

    hi Mansoor. uploading a sample Excel file will enable us to help you better. ideally, it should contain your desired results

  4. Mansoor Sajid Says:

    Thanks Benne, howevr, I don’t find the Excel file for upload.

  5. Mansoor Sajid Says:

    Thank you Benne. I still can not access the test file. Would it be possible for you to email the sample excel file as an attachment on my email address: msajid@alhamrani.net

  6. admin admin Says:

    Does this template help? I got it from Microsoft website – http://office.microsoft.com/en-sg/templates/results.aspx?qu=mortgage%20loan&ex=2&av=all#ai:TC102802352|

  7. BenneTan BenneTan Says:

    @ Mansoor:
    if the above link doesn’t work for you, you can email me your current template & we can help you to upload it here. ensure there are no confidential data & share with us the results you want to see.
    benne.tan@everydayexcel.com.sg

Leave a Reply

You must be logged in to post a comment.

s2Member®