Results of a new CNBC study of chief financial officers show there has been a dip in overall optimism about the economy.