comparing data in two columns

Question

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.

daupdike · Answer

Did I submit this question correctly and to the right discussion group?&nbsp; Please help. Thanks&nbsp;&nbsp;daupdike&nbsp;

daupdike · Answer

PeterBartholomew1 I saw that you recently solved someone's problem, so I was hoping you might be able to help me.&nbsp; Thanks&nbsp;

daupdike · Answer

here is the spreadsheet&nbsp;

peterbartholomew1 · Answer

daupdike&nbsp;I do not have a finance background but I enclose some exploration.&nbsp; I did try goal seek but with discrete payments goal seek did not converge.

Forum Discussion

comparing data in two columns

4 Replies

Resources