EMI Calculator in Excel

EMI - (Equated Monthly Installment): 
The Amount payable to the bank until the loan amount is fully paid off. It includes interest and part of principle amount. Even your monthly EMI payment never change the proportion of the principle and Interest will change with each payment.

In Below excel sheet change values in B1:B3 and get EMI and other details based on it.

Above EMI calculator is Based on PMT function. it calculates the payment for a loan based on constant payments and a constant interest rate.

Syntax:

 

=PMT(rate, nper, pv, [fv], [type])

• Rate: Interest rate for the loan.
• Nper: Number of months of payments.
• Pv: Loan Amount/ Principle value.
• Fv: Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
• Type: Optional. The number 0 (zero)(at the end or the period) or 1(at the beginning of the period) and indicates when payments are due.

To download calculator click on excel file symbol as mentioned below.

Please use comment section to provide your feedback or to ask questions.

Write First VBA Macro in Excel

VBA (Visual Basic for Application) Macro in Excel.

Let’s write your first macro, it’s very useful feature of Excel by using it you can automate reports or any repetitive work done in excel. Before writing macro need to check if you have Developer tab enabled or not if no then right click on excel ribbon and select customize the Ribbon… then check in Developer tab option and click ‘Ok’ now you will be able to see developer tab in your ribbon. 

 

 

After you add Developer tab you can explore the new world of excel. Automate daily reports, all repeat tasks and save your valuable time.

You don’t know VBA language?
Don’t worry Excel will write code (VBA module) for you. Yes by using ‘Record Macro’ option you can record the steps and use it whenever you want.

Here is the example write numbers in column A and the result in Column C as shown below. Once this is done activate Macro Recorder (make sure you will avoid unnecessary clicks and moves as it will record each and every click and activity you do while recording) Name macro as Calculate.

Write all formulas in column D as mentioned below after that stop recording. As shown in below.

Sum	=Sum(A2:A11)
Average	=AVERAGE(A2:A11)
Count	=COUNT(A2:A11)
Max	=MAX(A2:A11)
Min	=MIN(A2:A11)

 

Your first code…

When you click on record macro from that step excel will create new module and start writing VBA coding in it.

Next step is add form button to run recorded code whenever you want.
Click on Developer tab >> insert >> form button >> assign macro

Your first VBA macro is complete.

So even if you don’t know VBA coding language you can record and use it.

Note: while saving this file select option for macro enabled file (.xlsm).

Hope you like this

Please use comment section to provide your feedback or to ask questions.