Forum Discussion
Mortgage Payment Calculation
I modify my formula according to this article.
Assume the second line is :
you borrow 25000 at 0.0425 rate for 30 years,
then formula for part1-part3 are as follows:
monthly rate = [yearly rate]/12 part1 = POWER(1+[monthly rate],[years]*12)-1 part2 = [monthly rate]*POWER(1+[monthly rate],[years]*12) part3 = [part1]/[part2] Loan payment monthly = [loan amt]/[part3]Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The loan calculator is pretty close. Basically, here's what I've got (static data, no need for the sliders).
ID | Loan Amt | Years | Rate | Monthly Pymt | Interest
1 10000 5 .0375 | 150 | 20
2 25000 30 .0425 | 250 | 35
The Monthly Pymt and Interest columns are the data that I need....Thoughts?
saturation I calculated them as following. Can you please advise how did you arrive on those numbers for those two columns?
| ID | Loan Amt | Years | Rate | FV | # Months | Monthly PMT |
| 1 | 10000 | 5 | 0.0375 | $12,021.00 | 60 | $200.35 |
| 2 | 25000 | 30 | 0.0425 | $87,140.88 | 360 | $242.06 |
smpa01 They're not real, only for display only purposes....I'm just looking to see how to get them to calculate properly (the last 2 columns), whatever they may be....
saturation DAX (faster)/ M (slower) query can aboslutely cater to your need to prepare a dynamic amortization schedule, once you figure out how you can replicate excel CUMIPMT and CUMPRINC