Forum Discussion
an excel formula
Is there any way to find the foreclosure value of a loan on a given period from a loan repayment table (amt varies through months) through IRR method in a single formula or a combination of formulas ( e.g.: PMT() function but this formula gives only on an equal repayment monthly. If the repayment differs, is there any other way?)
Inputs will be Principle amount, Rate %(irr),EM
You can find the PV of the paid loan installment
then see how much is left from the loan and send it to the month needed.
this would be the amount needed.
see the file
6 Replies
You can find the PV of the paid loan installment
then see how much is left from the loan and send it to the month needed.
this would be the amount needed.
see the file
Sir, Thank you the quick feedback
I am attaching an excel file . Will it be possible to find the high lighted answer through single formula or group of combination of formulas
Thanks 🙂
The answer in month 6 shouldn't always be 2350 .
It depends on the payments before
anyways the NPV at 0 or FV at month 12 should be 0
