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 replies to "Loan amortization"

    • admin

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

    • Mansoor Sajid

      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.

    • BenneTan

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

    • Mansoor Sajid

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

    • Mansoor Sajid

      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

    • admin
    • BenneTan

      @ 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