Hello and welcome to our new video
In this video we will talk about
How to make changes in PMT formula
What is the meaning of changes?
Means how to use it with a specific purpose or specific goal
Like I don't have a budget to fill EMI of 25,000 every month
I have a budget to fill EMI of 15,000 and I have to fill
EMI of 6 months so just tell me that how much amount
I can buy by filling EMI of 15,000 so basically we are
going to do this so let's open excel after opening excel
the first amount is written here so I have to calculate EMI
here that I have to fill
EMI of 10,000 or 12,000 so that I can know that how much
amount I can buy so let's see how to do this so for this
you have to select this cell and you have to go to data so
when you go here you will get this option what if analysis
go to what if analysis and go to goal seek means with a
specific goal that I don't have to spend
EMI of 15,000 or 12,000 for 6 months so if you select goal
seek it will show you options like it has selected this
cell automatically if it will not select then you can
select this cell so you have to tell in two value that how
much specific amount like I have written 12,000 after that
it will tell by changing cell so how much value you can buy
how much amount you can buy so you select that and click ok
so it shows 89,546 so it shows that if you give 12,000 for
6 months so you with 100%
you can buy 89,546 so you can do things like this by
changing PMT formula by using goal seek so I hope you
understood if you have any doubt then play this video again
and see
I will meet you in next video till then practice