Loan Amortization Formula
Good Day All:
I need some help with my Loan Amortization Formula. I am trying to subtract out the Escrow from the Principal that is included in my payment.
Current Formula Yields $1,771.06 which is incorrect. The correct amount is $322.85 if he Escrow is $1,448.21 per month
=IF(Interest7 = "", "", Payment7 - Interest7 + [Additional Payment]7)
I can share the sheet if it will be easier.
Thanks Smartsheet Community
Help Article Resources
Check out the Formula Handbook template!