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)
  1. Accounts and Finance
  2. Step 5 Preparing Projections and Budgets

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.