This spreadsheet puts Shannons Therom, Free space path loss and thremal noise formula together to work out the theoretical maximum channel capacity (bits per scond) that can be got through a communication channel given Frequency, Distance, Channel bandwith and transmit power. You can also enter total (transmit + receive) antenna gain.

Enter data in the green cells