This is the basic ETC for photometry in multiband images.
Choose your telescope aperture, exposure time, and magnitude.

Given an aperture and magnitude (AB in all bands), choose the exposure time that reaches your desired S/N. To obtain limiting magnitudes given exposure time, set that time and then tune the magnitude to reach your desired limiting S/N.