Assumed a portfolio of loans been disbursed with % distribution of tenure (on amount), interest rate and overall disbursal as follows : Overall portfolio disbursal 100,000 Annualized Interest rate 15% Monthly interest rate 1.25% Assume all loans are disbursed at the above interest rate only, interest is applied monthly on declining balance method Tenure % Distribution 1 5.00% 2 5.00% 3 10.00% 4 2.00% 5 5.00% 6 25.00% 7 2.00% 8 2.00% 9 15.00% 10 2.00% 11 2.00% 12 25.00% Answer the following question (complete the empty table) 1 what will be the balance outstanding of the whole portfolio at the end of every month 2 What is the payment received every month 3 What is the principal paid and interest paid every month write steps to build a amortization table in Excel

Question 2 Instead of 1 loan been disbursed, assumed a portfolio of loans been disbursed with \% distribution of tenure (on amount), interest rate and overall disbursal as follows : Overall portfolio disbursal Annualized Interest rate Monthly interest rate 100,000 15% Assume all loans are disbursed at the above interest rate only, interest is applied monthly on declining balance method (same as in question 1) \begin{tabular}{|c|c|} \hline & \\ \hline Tenure \% & Distribution \\ \hline 1 & 5.00% \\ \hline 2 & 5.00% \\ \hline 3 & 10.00% \\ \hline 4 & 2.00% \\ \hline 5 & 5.00% \\ \hline 6 & 25.00% \\ 7 & 2.00% \\ \hline 8 & 2.00% \\ \hline 9 & 15.00% \\ \hline 10 & 2.00% \\ \hline 11 & 2.00% \\ \hline 12 & 25.00% \\ \hline \end{tabular} 1 what will be the balance outstanding of the whole portfolio at the end of every month 2 What is the payment received every month 3 What is the principal paid and interest paid every month Question 2 Instead of 1 loan been disbursed, assumed a portfolio of loans been disbursed with \% distribution of tenure (on amount), interest rate and overall disbursal as follows : Overall portfolio disbursal Annualized Interest rate Monthly interest rate 100,000 15% Assume all loans are disbursed at the above interest rate only, interest is applied monthly on declining balance method (same as in question 1) \begin{tabular}{|c|c|} \hline & \\ \hline Tenure \% & Distribution \\ \hline 1 & 5.00% \\ \hline 2 & 5.00% \\ \hline 3 & 10.00% \\ \hline 4 & 2.00% \\ \hline 5 & 5.00% \\ \hline 6 & 25.00% \\ 7 & 2.00% \\ \hline 8 & 2.00% \\ \hline 9 & 15.00% \\ \hline 10 & 2.00% \\ \hline 11 & 2.00% \\ \hline 12 & 25.00% \\ \hline \end{tabular} 1 what will be the balance outstanding of the whole portfolio at the end of every month 2 What is the payment received every month 3 What is the principal paid and interest paid every month