How to calculate EMI for a loan amount using PMT formula in MS Excel

With the help of PMT formula you can calculate EMI of a reducing balance method loan. Reducing balance method loan calculates outstanding principle amount at the end of a period. Example Home loan is a reducing balance method loan