Calculate loan amount based on interest rate and period in Excel

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) I want to force a page break at a certain row - how can I do that?

2) how to combine the content of two or more cells in Excel

3) Here an explanation about frames and how to control frames in Excel VBA

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

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

6) How can I find the number of working days between 2 dates using VBA?

7) 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?

8) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

9) My VLOOKUP formula returns #N/A when no match is found. Instead of #N/A, can I make it display a more meaningful text like NO MATCH FOUND ?

10) How can I find the count of records that meet a given condition in my raw data table?


Here the previous and next chapter