NPV and Amortisation
I am running into a problem using the NPV calculation and a subsequent amortization calculation.
Please see attached:
I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473)
When i develop an amortization schedule including interest cost uisng the cash flow as the payment schedule, the end balance is not zero.
I attached the results as well as the formula used..
I am not sure where i made the mistake?
Thank you in advance