So in this scenario, we have the principal amount, we have the repayment amount that we are paying
at the end of each year, and then we have the number of items for which we have to pay this repayment
amount to settle our loan.
Now, the only thing missing here is the rate of interest, but you can find it of interest by using
these three parameters to find rate of interest, you have to use rate formula of Excel.
So just write great.
And then as a first parameter, we have to give a number of items, which in this case is five.
Then we have to give BMT or the repayment amount we are paying in each item, which is this number,
and notice that we are using this number with.
So if you are repaying, you have to mention the negative sign.
If you are taking a loan or if you are adding money, then you have to mention a positive sign.
So always use signs accordingly.
Then we have to give the principal amount that we have taken.
So principal amount is this and if we hit enter with the rate of interest.
So rate of interest in this scenario is around eleven point four one percent.
So if you have principal repayment amount and number of items, you can easily find out rate of interest
by just using Uhtred formula.
Now, in the next scenario, we have to find out the number of repayment terms, if we have the principal
on the repayment amount and the rate of interest.
So the formula to find out a number of terms is and but just straight and are.
And here first, we have to give the rate of interest.
Then the repayment amount, which we are paying at the end of each term, which is this.
And then the total principal amount that we have taken, again, make sure that the signs are correct,
inflow is positive and outflow is negative.
So we are paying 60000 in Eastham.
That's what we are writing, minus 60000.
Just hit enter and you will find the number of pyrates, so here you can see that the number of fatalities
is 5.5.
So for firing off here, you have to repay with this payment structure.
So that's all.
Again, if you have any three of the four parameters, principal amount, repayment amount, rate of
interest and Peter or you can find the missing parameter.
And this is how you can compare different loans if they are not giving you all the information.