Formula on excel
Hello,
I have the principle, pmt and rate. I am looking at an amortization table, how can i find the term. would this be the right formula NPER(rate,pmt,pv)
Trending Content - Investment Banking Forum
| +154 | UBS Tech layoff | 52 | 2h |
| +141 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 29 | 2h |
| +139 | Do people still want to go PE? | 40 | 3h |
| +84 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 15 | 2h |
| +57 | How do YOU manage networking requests? | 16 | 2h |
| +42 | Are target prospects getting dumber? | 18 | 52m |
| +37 | What Differentiates the Best Analysts as AI Improves? | 9 | 3d |
| +36 | Quitting After First 4 months | 12 | 8h |
| +34 | MBB Pay Raises | 26 | 8h |
| +33 | Cornell Club T10 Rankings (UPDATED 10/2026) | 19 | 1d |
Career Resources
Yeah, just make sure your payment and rate are in the same time frame. so if you have a 5.5% annual rate and a $500 payment, divide 5.5% by 12 to get your monthly rate
also if this is for a loan, make your PV( principle) a negative value.
Should i use principle paid ? as my pv? or should i use my remaining balance
I am looking for the actual number of months for the amort given in this schedule
what would u do ?
Fugiat libero quis eius est rerum accusamus enim. Quis aspernatur animi et est. Aut voluptatem voluptatum voluptatem nam possimus et dignissimos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...