My tenant's lease expired June 1, refuses to sign my lease. 

Again, final payment will all depend on taxes and insurance expenses for the exact property, but gives you an idea of what a lender would be able to do.Keep in mind that a Lender can only use what you have listed on your taxes (Schedule E). 

Sometimes having the cash in hand "liquid reserves" is a lot stronger of a position than having an open end liability aka HELOC. 

Each transaction is categorized and summed for each year and so all I need to do is copy the number from my spreadsheets when filling out my Schedule E at year-end.

@Katia E CarmonaI think you are pretty stuck...

Honestly, my plan will be to liquidate real estate portfolio and invest elsewhere for retirement. 

I already have a couple of 401k's, I was looking for something more liquid.

HiNot a wholeseller, just looking at ways to find owners of distressed properties I come across on my travels or phoning up expired listings without having to get in touch with the prior listing agentI use the free versions of white pages, tru people. most of time the numbers are not working/oldAnything better you might recommend, I dot mind pay for a service but wanted to get the input from those out thereThanks in advance

For me, at the beach today, wiring funds and e-signing on my phone.

All activity of the property is reported on the schedule E of your tax return.If that's the case then you and your LLC are interchangeable as far as the 1031 goes.