Forum Discussion
an excel formula
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
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
Thanks for the quick reply
My question was also the same
If the Monthly repayment is irregular (i.e 1st Month 500, 2nd Month, 475, 3rd Month 300....) what will be the F.A for the 7th Months
From the table , since the repayment is constant (i.e 428/-) the F.A was arrived to 2531 for the 7th month.
How would we calculate with a formula or series of formulas to arrive in a single cell , if the repayment is not constant.
Regards
Thanks