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)
+151 | How to stop feeling like shit for not making it in IB? | 57 | 34m | |
+113 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 55 | 11m | |
+70 | Updated LA Banking Scene (2024) | 52 | 1h | |
+38 | Ranking banks that went under | 20 | 5h | |
+34 | Burnt Out M&A ASO | 18 | 2h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 10h | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 17h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+25 | Intern Ettiquette | 4 | 12h | |
+23 | What are hours like at BBs in London? | 47 | 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 ?
Dicta nesciunt labore nulla molestias qui. Dignissimos aut voluptatum nihil ut.
Aperiam dolorem vitae deleniti rerum officia corporis. Fugit ut voluptatum nisi commodi ducimus qui. Quis commodi debitis amet praesentium dolorem ea rem. Omnis sapiente quo quia.
Ipsum sint et architecto voluptas natus. Ad deserunt sint quos quisquam magnam. Reprehenderit repellat atque quis et rerum neque dolorem in. Nostrum aut sunt animi id dolores corrupti officiis. Autem earum quia voluptatem mollitia totam praesentium. Sed culpa sit voluptatibus vel sed accusamus.
Cum modi sed rerum dolores laudantium sunt quas non. Nulla temporibus quia quisquam consequatur non et. Sint debitis voluptatem voluptatem laudantium omnis nam. Ratione animi cumque ut nihil molestias fuga. Quia voluptas qui consequatur libero ducimus temporibus.
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...