calculate loan amount based on interest rate and period in Excel

Q25. In Excel, how do I calculate monthly payment given Loan amount, Rate of Interest and period?

To do it in Excel, here is the answer:

a) Enter the formula =PMT(D3/12,D4*12,-D2) where D2 corresponds to "Debt Amount", D3 corresponds to Rate of Interest per annum and D4 corresponds to the period in years.

excel calculate loan amount based on interest rate and period

 

You can find similar Excel Questions and Answer hereunder

1) How do I get the principal part of loan payment for the year given Loan amount, Rate of Interest and period?

2) How can I update a listbox based on data in a list using VBA?

3) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

4) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

5) How can I change the Marker size and Marker line color for all the series in a chart?

6) How do I enter a formula in a cell using VBA (using Relative Reference)?

7) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

8) How can I calculate depreciation of assets using Excel?

9) How can I ensure that important files always appear on the recent Excel workbooks list?

10) How can I prevent edits on my worksheet by protecting it with a Password ?

11) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

12) How do i put double quotes in a string in vba in Excel

13) How can I set FreezePanes in a certain range using VBA?

14) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

15) How can I enter a cent symbol in a cell?