The XIRR() fn works fine in the existing examples from the accompanying spreadsheet. 

The best way to find investors for syndication you first have to determine if you will need 506b investors or 506c506b can be anyone you have an existing relationship family, friends , business partners or 506c are accredited investors only and don’t require a relationship You then should join local network group chamber of commerce Local real estate investor group BNIStart building relationships with people and educate them on your prospective or prior deals that you done.

For example, on Duke Energy's Warsaw site, collectively 87.5 MW, the developer built a new substation off Penny Branch Rd. since the generation facilities exceeded the existing distribution capacities.

I will give you that those conditions don’t really exist right now in the market since prices and rates spiked.  

They may focus more on the property’s income and your assets rather than your personal DTI.Negotiate with Existing Lenders: It’s always worth a shot to negotiate with the lenders who pre-approved you.

Transfer of Leases and Tenant Information•Review the existing leases to ensure compliance with local laws and assess any terms that may need to be adjusted.

The only problem I now see is that I got sidetracked from my plan and now I'd like to pivot and adjust my routine to my interests and become the investor friendly agent, helping new and existing investors get their first or next investment.

If a renter wants to extend for a few months their stay beyond the initial lease term, will I be a) required to extend and b) at the same rate as their existing rate?

That is probably cheaper to do and if the existing laundry are just hookups in a basement an upgrade that might give you a similar result in terms of tenant experience. 

You are looking for financing that doesn't exist in the current market.