Qhov wikiHow no qhia koj yuav xam li cas Tus Nqi Tam Sim No (NPV) ntawm kev nqis peev uas siv Microsoft Excel. Koj tuaj yeem ua qhov no ntawm ob lub Windows thiab Mac versions ntawm Excel.
Cov kauj ruam
Kauj Ruam 1. Nco ntsoov tias koj muaj cov ntaub ntawv peev txheej muaj
Txhawm rau xam NPV, koj yuav tsum paub tus nqi luv nqi txhua xyoo (piv txwv li, 1 feem pua), thawj qhov peev nyiaj nqis peev, thiab tsawg kawg ib xyoos ntawm kev nqis peev rov qab.
Muaj peb lossis ntau xyoo ntawm kev nqis peev rov qab yog qhov zoo tshaj, tab sis tsis tsim nyog
Kauj ruam 2. Qhib Microsoft Excel
Nws lub cim app zoo ib yam li lub thawv ntsuab nrog dawb "X" ntawm nws.
Kauj Ruam 3. Nyem Phau ntawv ua haujlwm dawb paug
Nws yog nyob rau sab saud sab laug ntawm lub qhov rais Excel.
Kauj Ruam 4. Nkag mus rau koj cov peev nyiaj tus nqi luv nqi
Xaiv ib lub xovtooj (xws li, A2), tom qab ntawd ntaus tus lej sib npaug ntawm koj qhov peev txheej txo nqi txhua xyoo.
Piv txwv li, yog tias tus nqi luv nqi yog 1 feem pua, koj yuav nkag mus rau 0.01 ntawm no
Kauj Ruam 5. Nkag mus rau qhov peev txheej pib
Xaiv ib lub xov tooj uas tsis muaj dab tsi (xws li, A3) thiab ntaus tus nqi uas koj pib nqis peev.
Kauj Ruam 6. Sau txhua xyoo tus nqi xa rov qab
Xaiv ib lub xov tooj uas tsis muaj dab tsi (xws li, A4), sau thawj xyoo cov nyiaj rov qab, thiab rov ua dua rau txhua xyoo tom ntej uas koj muaj tus lej rov qab.
Kauj Ruam 7. Xaiv lub cell
Nyem rau ntawm tes uas koj xav laij NPV.
Kauj Ruam 8. Nkag mus rau NPV tus qauv pib
Type in = NPV () here. Koj cov ntaub ntawv peev nyiaj yuav nyob nruab nrab ntawm cov npe.
Kauj Ruam 9. Ntxiv qhov tseem ceeb rau tus qauv NPV
Sab hauv ntawm kab ntawv, koj yuav tsum tau ntxiv cov lej ntawm tes uas muaj tus nqi luv nqi, peev nyiaj peev, thiab tsawg kawg ib tus nqi rov qab.
Piv txwv li, yog tias koj tus nqi luv nqi yog nyob ntawm tes A2, peev nyiaj nqis peev yog nyob hauv A3, thiab tus nqi xa rov qab yog nyob hauv A4, koj cov mis yuav nyeem = NPV (A2, A3, A4).
Kauj Ruam 10. Nias ↵ Enter
Qhov no yuav ua kom Excel suav qhov NPV thiab tso tawm nws hauv cov cell xaiv.