Scribd
Upload
51 views4 pages

Amount of Loan 200000 Rate of Interest 10% Period of Repayment 6 Periodicity Quarterly 4 Installemet Amount 11183

The document provides a loan repayment schedule showing the opening balance, interest due, installment amount, closing balance, and interest rate for each period of repayment. Over 30 periods, the borrower takes a loan of Rs. 100,000 at interest rates between 10-12% and repays it through installments of Rs. 4,300-4,326 over time, fully repaying the loan by period 30.

Uploaded by

Prerna Yadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
51 views4 pages

Amount of Loan 200000 Rate of Interest 10% Period of Repayment 6 Periodicity Quarterly 4 Installemet Amount 11183

The document provides a loan repayment schedule showing the opening balance, interest due, installment amount, closing balance, and interest rate for each period of repayment. Over 30 periods, the borrower takes a loan of Rs. 100,000 at interest rates between 10-12% and repays it through installments of Rs. 4,300-4,326 over time, fully repaying the loan by period 30.

Uploaded by

Prerna Yadav
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

QUES1

amount of loan 200000 bi montly 6


rate of interest 10% half yearly 2
period of repayment 6 monthly 12
periodicity quarterly 4 quarterly 4
installemet amount 11183 yearly 1

loan repayment schedule


period opening bal. interest due installmentclosing bal. Interest principal
1 200000 5000 11183 193817 5000 6183
2 193817 4845 11183 187479 4845 6337
3 187479 4687 11183 180983 4687 6496
4 180983 4525 11183 174325 4525 6658
5 174325 4358 11183 167500 4358 6824
6 167500 4188 11183 160505 4188 6995
7 160505 4013 11183 153335 4013 7170
8 153335 3833 11183 145985 3833 7349
9 145985 3650 11183 138452 3650 7533
10 138452 3461 11183 130730 3461 7721
11 130730 3268 11183 122815 3268 7914
12 122815 3070 11183 114702 3071 8112
13 114702 2868 11183 106387 2868 8315
14 106387 2660 11183 97864 2660 8523
15 97864 2447 11183 89128 2447 8736
16 89128 2228 11183 80173 2228 8954
17 80173 2004 11183 70994 2005 9178
18 70994 1775 11183 61586 1775 9408
19 61586 1540 11183 51943 1540 9643
20 51943 1299 11183 42059 1299 9884
21 42059 1051 11183 31927 1052 10131
22 31927 798 11183 21542 798 10384
23 21542 539 11183 10898 539 10644
24 10898 272 11183 -13 273 10910

interest 5to10 23503


principal 5 to10 43592

NAME-NISHTHA CHITARA
CLASS-BCOM HONS.1ST
ROLLNO.-2091
SUBMISSION DATE -7TH FEB 2020
QUES2 4
CLIENT IDNAME OFPRINCIPA ROI PERIODS IN YEAR
1A 400000 10% 10
2T 500000 11% 12
3G 20000 10% 15
4U 4000000 11% 20
5Q 5000000 10% 10
6R 3000000 11% 5

INTEREST INCOME
1 2 3 4 5 6 7 8 9 10
10000 9852 9700 9544 9384 9220 9052 8880 8704 8523
13750 13609 13464 13315 13161 13004 12842 12676 12505 12330
500 496 493 489 485 481 477 472 468 463
110000 109610 109210 108798 108375 107941 107495 107036 106565 106080
125000 123145 121245 119296 117299 115252 113154 111003 108799 106539
82500 79351 76115 72790 69374 65864 62257 58551 54744 50831
341750 336063 330230 324232 318078 311762 305277 298618 291785 284766

NAME-NISHTHA CHITARA
CLASS-BCOM HONS 1ST
ROLL NO.2091
SUBMISSION DATE- 7TH FEB 2020
QUES3
AMOUNT OF LOAN 1000000 bi montly 6
PERIOD OF LOAN 6 18 half yearly 2
RATE OF INTEREST 0.1 monthly 12
INITIAL PHASE quarterly 4
PERIODICITY quarterly 4 yearly 1
PERIOD 4 16
AMOUNT TO BE REPAI 0.7 700000
INSTALLMENT AMOUN 61119
IIND PHASE
PERIODICITY yearly 1
PERIOD 2 2
AMOUNT TO BE REPAI 0.3 300000
INSATLLMENT AMOUN 172857

SR.NO. OPENING BAL. INTEREST INSTALLMENTCLOSIN BAL.


1 1000000 25000 61119 963881
2 963881 24097 61119 926859
3 926859 23171 61119 888911
4 888911 22223 61119 850015
5 850015 21250 61119 810146
6 810146 20254 61119 769281
7 769281 19232 61119 727394
8 727394 18185 61119 684460
9 684460 17112 61119 640453
10 640453 16011 61119 595345
11 595345 14884 61119 549110
12 549110 13728 61119 501719
13 501719 12543 61119 453143
14 453143 11329 61119 403353
15 403353 10084 61119 352318
16 352318 8808 61119 300007
17 300007 2 172857 127152
18 127152 1 172857 -45704

NAME-NISHTHA CHITARA
CLASS- BCOM HONS.(1)
ROLL NO.2091
SUBMISSION DATE-7TH FEB 2020
QUES5 bi montly 6
amt.of loan 100000 half yearly 2
period of loan 5 monthly 12
periodicity bi montly 6 quarterly 4 10.00%
yearly 1 10.50%
Loan repayment schedule 11.00%
sr.no Opening bal. interest installmentclosing bal.rate of interest 10.25%
1 100000 1750 4313 97437 10.50% 12.00%
2 97437 1665 4289 94813 10.25%
3 94813 1580 4265 92128 10.00%
4 92128 1535 4265 89398 10.00%
5 89398 1564 4309 86653 10.50%
6 86653 1444 4267 83830 10.00%
7 83830 1397 4267 80961 10.00%
8 80961 1484 4346 78099 11.00%
9 78099 1302 4270 75131 10.00%
10 75131 1252 4270 72113 10.00%
11 72113 1202 4270 69046 10.00%
12 69046 1151 4270 65927 10.00%
13 65927 1099 4270 62757 10.00%
14 62757 1046 4270 59533 10.00%
15 59533 992 4270 56255 10.00%
16 56255 1031 4324 52962 11.00%
17 52962 971 4324 49610 11.00%
18 49610 910 4324 46196 11.00%
19 46196 847 4324 42719 11.00%
20 42719 783 4324 39179 11.00%
21 39179 686 4305 35560 10.50%
22 35560 622 4305 31877 10.50%
23 31877 558 4305 28130 10.50%
24 28130 492 4305 24318 10.50%
25 24318 426 4305 20439 10.50%
26 20439 358 4305 16492 10.50%
27 16492 289 4305 12476 10.50%
28 12476 250 4326 8400 12.00%
29 8400 168 4326 4242 12.00%
30 4242 85 4326 0 12.00%

NAME-NISHTHA CHITARA
ROLL NO.-2091
CLASS- BCOM HONS.(1ST)
SUBMISSION DATE- 7TH FEB.2020

You might also like