The right agent will provide a pro forma breakdown on every property they look at, have repair costs estimated, CapEx, etc...

Some lenders are individual investors; some lenders are syndicates or have joined individual investors together to form a lending institution.

Are there any resources available and recommended that would be better suited for creating a pro forma for new (spec) construction?

Since pro forma's are a projection they are as good as their assumptions, as an investor, you need to agree with the underlying assumptions. 

They key is to realize their pro forma numbers is perfect case scenario.

Keep in mind that some of these C class areas in Columbus your pro forma will look better but you should be running a higher expense ratio. 

Many borrowers file this form as an exclusion to their US federal taxes as they may have been taxed by the country where they are earning the income.Required Documentation for Foreign IncomeWhen it comes to processing foreign income for a loan, documents required may include:» Most recent personal tax returns» History of receipt» Proof of continuance of foreign income earnings» Conversion of the income from the foreign currency to US dollarsThese documents must be translated or completed in English so that a loan reviewer can properly evaluate the information provided.Fannie Mae & Freddie Mac GuidelinesIncome from Foreign SourceIncome from foreign sources must be reported on the borrower’s most recent U.S. individual federal income tax returns.

Despite my explanation that I had the funding for smaller deals, 10-20 units they doubled down on me needing to find investors to partner with or to form a syndicate.

any pro forma that shows you 'cash flow' on day 1 or in month 1 or even year 1 is a joke.here's the bottom line. 

Also, I'm looking to form a power team in each of the states mentioned.