I mentioned the formula used to calculate an EMI, but putting values in the formula and calculating it is a cumbersome task. So I did some research in Microsoft Excel and found out that it can done quite easily in excel.
EMI calculation in Excel
Step 1: Open the excel sheet and locate the fx button
Step 2: In the pop-up menu, click on Financial Catergory
Step 3: In the Function Name click 'PMT'
Step 4: A box will appear as shown, fill in the values mentioned and you get the EMI.
No comments:
Post a Comment