Check sibling questions

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)
Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.