Here is the link to the extended warranty Honda gives out to bad transmission.
http://www.usatoday.com/money/autos/...warranty_x.htm
Do not let the dealers trick you into paying tons of money. Many dealers do not honor this warranty, but they have to. It is the law. If they do not honor it, they are breaking the contract with Honda USA.