Thank you.
lambizzee 3 weeks ago
Another method I prefer which may result in a very quick answer (if you can remember it) is,
Firstly the loan amount is 400k (Since we put 100k as downpayment)
N->30, I/Y -> 5.5 PV-> 400k CPT-> PMT, you will get -27,522.16 something
Then all you have to do is change N and CPT->PV to get the remaining principal.
For example, if we made 2 year worth of payments, N left is 30 - 2, so put N->28 and CPT -> PV (388,651.2)
DecipherCipher 7 months ago
life savior!
jonjonperico 11 months ago
Thank you.
lambizzee 3 weeks ago
Another method I prefer which may result in a very quick answer (if you can remember it) is,
Firstly the loan amount is 400k (Since we put 100k as downpayment)
N->30, I/Y -> 5.5 PV-> 400k CPT-> PMT, you will get -27,522.16 something
Then all you have to do is change N and CPT->PV to get the remaining principal.
For example, if we made 2 year worth of payments, N left is 30 - 2, so put N->28 and CPT -> PV (388,651.2)
DecipherCipher 7 months ago
life savior!
jonjonperico 11 months ago