Question: answer Questions 3 in Excel. I need an Excel formula too. Instead of 1 loan been disbursed, assumed a portfolio of loans been disbursed with

answer Questions 3 in Excel. I need an Excel formula too. 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 disbursal1,00,000Annualized Interest rate15%Monthly interest rate1.25%

Assume all loans are disbursed at the above interest rate only, interest is applied monthly on declining balance method.

TenureDistribution15.00%25.00%310.00%42.00%55.00%625.00%72.00%82.00%915.00%102.00%112.00%1225.00%

The above details are exactly same as question 2 but now assume that some loans also get foreclosed and the coincidental foreclosure curve is as follows:

123456789101112Foreclosure Curve - POS4.44%2.58%2.47%2.35%2.32%2.36%2.17%2.22%2.26%2.17%2.33%2.72%

Answer the following question (complete the empty table)

what will be the balance outstanding of the whole portfolio at the end of every month What is the payment received every month What is the principal paid and interest paid every month

Balance outstanding at start of periodPayment received (EMI amount)Principal paidInterest paid11,00,000 2 3 4 5 6 7 8 9 10 11 12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Only answer Question 3 in Excel. I need an Excel formula too. Don't copy from previous answers . I have downvoted all Question 1 WIth the above loan details, calculate the EMI amount and create the...

Only answer Question 3 in Excel. I need an Excel formula too. Question 1 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table...

Only answer Questions 2 & 3 in Excel. I need an Excel formula too. Question 1 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table...

Only answer Questions 1 & 2 in Excel. I need an Excel formula too. Question 1 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table...

Only answer in Excel. I need an Excel formula too. Question 1 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table Assumptions :...

Only answer Question 2 in Excel. I need an Excel formula too. Question 1 WIth the above loan details, calculate the EMI amount and create the EMI schedule for the loan to fill the below table...

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...

Only answer Question 2 in Excel. I need an Excel formula too. Don't copy from previous answers . I have downvoted all Question 1 WIth the above loan details, calculate the EMI amount and create the...

As Jacob walked back to his office after the weekly financial meeting, he reviewed his notes and saw that he had written down two operating income numbers: $110,000 and $50,000. He knew that the...

1. To fully appreciate the role of marketing research, it is helpful to understand its role in and relationship to marketing. Discuss the role of marketing research and its role in and relationship...

which of the following showed the greatest variance between the hickey and gorby studies a . percetag of accomplices b . percentage of males strangling thier victims c . percentae using firearms d ....

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".