Monopole excitations in 4He, 12C and 24Mg in a collective model description