No.
The $5m increases your overall cap from $185m to $190m (and likewise, reduces the other team's cap from $185m to $180m.)
Current season only.
It should be noted that cash in trades is the source of all evil in HBD, and anyone asking for that should be donkey punched.