Basically you need to do this in SQL terms:
select job , lender , loan closing date , loan amount from table
select job , lender ,projected loan closing date , -1 * loan amount from table
And the use this source in same worksheet that you have attached.
Basically in tableau you need to union same file twice (once with loan closing date and other with projected date with negative value of loan amount)
Let me know if you want me to design the worksheet for you.
Nice! it looks like I was able to achieve the same result just by creating a union of my one sheet in Tableau without custom SQL.