Loan Chart is required to be prepared in excel for each loan


It helps in providing data for
Interest to be shown in Projected Profit and loss
Closing Amount of Loans Outstanding in Balance Sheet
Calculation of DSCR (Debt Service Coverage Ratio)

Loan Chart.jpg


In case a person has number of loans,Loan Chart is to be prepared differently for different types of loans

Types of Term Loan

  1. Loans having Annual Repayement
  2. Loans having Quarterly Repayement
  3. Loans having Monthly Repayment (EMI)
  4. Loans having No Repayment (like OD/CC)

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.