1
00:00:00,360 --> 00:00:06,900
So in this scenario, we have the principal amount, we have the repayment amount that we are paying

2
00:00:07,140 --> 00:00:14,730
at the end of each year, and then we have the number of items for which we have to pay this repayment

3
00:00:14,730 --> 00:00:16,380
amount to settle our loan.

4
00:00:18,800 --> 00:00:24,980
Now, the only thing missing here is the rate of interest, but you can find it of interest by using

5
00:00:24,980 --> 00:00:32,430
these three parameters to find rate of interest, you have to use rate formula of Excel.

6
00:00:32,630 --> 00:00:34,280
So just write great.

7
00:00:35,620 --> 00:00:43,270
And then as a first parameter, we have to give a number of items, which in this case is five.

8
00:00:45,810 --> 00:00:52,560
Then we have to give BMT or the repayment amount we are paying in each item, which is this number,

9
00:00:53,400 --> 00:00:55,680
and notice that we are using this number with.

10
00:00:56,550 --> 00:01:00,200
So if you are repaying, you have to mention the negative sign.

11
00:01:00,330 --> 00:01:05,210
If you are taking a loan or if you are adding money, then you have to mention a positive sign.

12
00:01:05,910 --> 00:01:08,970
So always use signs accordingly.

13
00:01:10,950 --> 00:01:15,170
Then we have to give the principal amount that we have taken.

14
00:01:15,180 --> 00:01:22,500
So principal amount is this and if we hit enter with the rate of interest.

15
00:01:23,130 --> 00:01:28,440
So rate of interest in this scenario is around eleven point four one percent.

16
00:01:29,660 --> 00:01:36,320
So if you have principal repayment amount and number of items, you can easily find out rate of interest

17
00:01:36,440 --> 00:01:38,720
by just using Uhtred formula.

18
00:01:40,740 --> 00:01:48,060
Now, in the next scenario, we have to find out the number of repayment terms, if we have the principal

19
00:01:48,180 --> 00:01:52,370
on the repayment amount and the rate of interest.

20
00:01:54,930 --> 00:02:03,360
So the formula to find out a number of terms is and but just straight and are.

21
00:02:04,910 --> 00:02:08,390
And here first, we have to give the rate of interest.

22
00:02:10,550 --> 00:02:17,510
Then the repayment amount, which we are paying at the end of each term, which is this.

23
00:02:18,510 --> 00:02:26,700
And then the total principal amount that we have taken, again, make sure that the signs are correct,

24
00:02:27,570 --> 00:02:30,800
inflow is positive and outflow is negative.

25
00:02:30,810 --> 00:02:33,260
So we are paying 60000 in Eastham.

26
00:02:33,270 --> 00:02:35,880
That's what we are writing, minus 60000.

27
00:02:37,620 --> 00:02:44,910
Just hit enter and you will find the number of pyrates, so here you can see that the number of fatalities

28
00:02:44,910 --> 00:02:45,980
is 5.5.

29
00:02:46,110 --> 00:02:50,940
So for firing off here, you have to repay with this payment structure.

30
00:02:54,130 --> 00:02:55,200
So that's all.

31
00:02:56,670 --> 00:03:03,630
Again, if you have any three of the four parameters, principal amount, repayment amount, rate of

32
00:03:03,630 --> 00:03:08,670
interest and Peter or you can find the missing parameter.

33
00:03:10,430 --> 00:03:16,360
And this is how you can compare different loans if they are not giving you all the information.