Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 Instead of 1 loan been disbursed, assumed a portfolio of loans been disbursed with % distribution of tenure (on amount), interest rate and
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 | 1,00,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 (same as in question 1) | |||||
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 | ||||
Balance outstanding at start of period | Payment received (EMI amount) | Principal paid | Interest paid | Balance outstanding at end of period | |
1 | 1,00,000 | ||||
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 | |||||
11 | |||||
12 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started