How do I Loan Amortization when interest is compounded monthly, b.

S

sebastienm

Hi,not sure what it is. Are you looking for monthly payment? If so:
Say loan=$400,000 with 6% annual interest over 30 years.
The monthly payment is
=PMT(8%/12, 30*12, 400000)
For Principal part, use PPMT( ), for Interest part, use IPMT( )

Regards,
Sebastien
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable interest rate loan calculations- PLEASE HELP!!! 1
Loan amortization schedule for variable interest rates 5
Saving for College 1
PMT function question 2
Interest and Payment Calculations 6
Calculating the payment for a loan 0
FV function 2
PMT: Daily interest compounding; monthly payment 9

Top