Two new aroylhydrazones viz 4-nitro-N′-(1-(pyridin-2-yl)ethylidene)benzohydrazide, NPHY (4) and 4-nitro-N′-(1-(thiophen-2-yl)ethylidene)benzohydrazide, NPHT (5) have been prepared and characterized by 1H NMR, 13C NMR, FT-IR, UV–Visible spectroscopy and mass spectrometry. All quantum calculations were performed at DFT level of theory using B3LYP functional and 6-31G (d,p) as basis set. TD-DFT calculated electronic transitions are found to be in good agreement with experimental findings. The assignments for normal vibrational modes have been done by computing Potential Energy Distribution (PED) using Gar2ped. HOMO-LUMO analysis was performed and reactivity descriptors were also computed. Global electrophilicity index (ω) of 6.12–6.26 eV shows these aroylhydrazones to be strong electrophiles. Intramolecular interactions were analyzed by ‘Atoms in molecule’ (AIM) approach. Also, the computed first static hyperpolarizabilities (β0) of these hydrazones indicate their future application as an attractive non-linear optical (NLO) material. Cytotoxicity evaluated by MTT assay, suggested that the synthesized aroylhydrazones significantly reduce the cell viability of breast cancer cell lines (MCF7) and human prostate adenocarcinoma (DU145) in a dose dependent manner. Cytotoxic potencies (IC50) of these hydrazones against MCF7 and DU145 cell lines were found in range of 54.67–85.67 μM. The result of ROS activity provides supportive data for molecular mechanism of these hydrazones, which is related to apoptotic cellular death. Nuclear condensation assay performed by DAPI staining shows fragmented and condensed nuclei in MCF7 cells, suggesting cell death by apoptosis.