How can I tell my son that we cannot afford his dream university

Not everyone is destined for college. He screwed up his grades. If he really wants to get in, let him fix it. Life is a competition and it is time he stepped up to the plate.