Theoretical results for dynamical correlation functions characterizing collective excitations in liquid water reported in a previous paper are compared with molecular dynamics simulation results performed on the same system. We also examine the validity and accuracy of the approximation scheme for memory functions employed in our theory by investigating whether the assumed form for memory functions and resulting expressions for dynamical correlation functions can be used as faithful models to reproduce the "experimental" data determined from the simulation.