I am having car trouble!??

My car's plate got suspended, so I borrowed my mom's 1991 Plymouth Acclaim. Well I think the transmission just went out. How much to fix something like that? Is it even worth it?