Hello and welcome to our new video. In this video we are
going to learn about PMT formula which means payment
formula.
We often go for shopping. We buy mobile phone from amazon,
flipkart and flipkart and amazon platform gives us option
of EMI.
In this video we are going to learn how to calculate EMI in
excel.
First of all I will take you to amazon website. Here is a
phone Samsung Galaxy S23 Ultra 5G Green.
The cost of this phone is Rs.1,24,999. If we go to EMI
option, we get two offers.
Let's go to first offer. Here is a detail of EMI plan.
If you take 28X3X6 month, you will get Rs.1,24,999.
If you take 9 month, you will get Rs.13,889.
If you take 24% interest rate, you will get Rs.11,820 x 12
month.
Let's see how to calculate EMI in excel.