1995 Chevy Corsica Muffler repair?

I own a 1995 chevy corsica and the muffler is extremly loud. I dont know what is wrong with it. i did spot 1 hole about the size of the tip of a pencil. but, i dont think that would cause so much noise. any suggestions?