Sep 22 2020 09:43 AM
I am sure this will be easy for this community.
I have 3 sheets (names in bold), sheet one is for my Data input, sheet two is an amortization schedule for a borrower’s Current Loan and sheet three is an amortization schedule for a borrower’s proposed Refinance Loan.
I want to determine the Payment Date for when the Ending Balance of the Refinance Loan is equal to or lower than the Loan Balance after Payment of the Current Loan.
Sep 23 2020 05:17 AM
Did I submit this question correctly and to the right discussion group? Please help. Thanks @daupdike
Sep 23 2020 05:26 AM
@Peter Bartholomew I saw that you recently solved someone's problem, so I was hoping you might be able to help me. Thanks
Sep 23 2020 02:28 PM
I do not have a finance background but I enclose some exploration. I did try goal seek but with discrete payments goal seek did not converge.