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)
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)
+147 | How to stop feeling like shit for not making it in IB? | 56 | 24m | |
+110 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 54 | 1h | |
+70 | Updated LA Banking Scene (2024) | 52 | 46m | |
+38 | Ranking banks that went under | 20 | 2h | |
+34 | Burnt Out M&A ASO | 18 | 2s | |
+34 | Recruiting in the Fall | 6 | 1h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 7h | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 13h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+25 | Intern Ettiquette | 4 | 12h |
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 ?
Eum et velit illo sint ipsa non. Tempore delectus dolorem quia cumque dignissimos consequuntur molestias. Molestias fuga quibusdam cumque fugiat.
Ut beatae laborum omnis id ex molestias. Vero dolorem architecto omnis quidem consequuntur aspernatur. Unde aliquid rerum illo quos veniam corporis. Enim nihil doloribus nisi nesciunt fuga rerum natus. Est libero et id nisi dignissimos. Mollitia et ut possimus quos.
Aut quasi laborum ipsa dignissimos et consectetur sint. Similique reiciendis voluptatum sequi fugiat facere fuga et. Deserunt esse debitis maxime. Fugit sunt pariatur sint. Alias accusamus labore quia et modi. Minus dolorem error sunt quis eos.
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...