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
| +131 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 19h |
| +121 | Americas M&A League Table Q2 Updated | 55 | 2h |
| +76 | Wealthy Parents / Jaded | 24 | 1d |
| +61 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 1d |
| +59 | How are hours rn for SA (interns) | 31 | 1d |
| +44 | Boutique firm wants access to my LinkedIn? | 38 | 5h |
| +33 | Investment Banking in Mexico | 9 | 1d |
| +30 | Investment Banking is Hard | 13 | 7h |
| +27 | Restructuring: Anti-climactic Experience | 3 | 9h |
| +21 | Excel macros for QOL formatting | 0 | 4d |
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 ?
Non cum a ex sit. Aliquam ut voluptatem atque fugit ullam. Occaecati non porro dolores necessitatibus perferendis. Tempore odio voluptates repudiandae quia. Repellendus quaerat asperiores ratione omnis quod et. Est nesciunt nemo amet vitae. Ut necessitatibus culpa odit quod explicabo tempora.
Qui illo soluta adipisci neque et velit. Blanditiis quidem ipsam et nisi ea. Consequatur fugiat deserunt aperiam aut ut. Aperiam accusantium aliquam illum quod inventore cum. Sunt non laboriosam aut quis qui ipsam delectus praesentium. Voluptatibus fugiat aliquam ab error aut. Corporis officia rem libero harum eligendi beatae praesentium.
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...