How To Use PV, FV, RATE & NPER Formula in Excel - Excel Financial Functions

Поділитися
Вставка
  • Опубліковано 11 вер 2024

КОМЕНТАРІ • 82

  • @HADI-UPDATE
    @HADI-UPDATE 2 роки тому +33

    Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️

  • @RohitSaccher
    @RohitSaccher 2 роки тому +1

    बेहतरीन दीपक जी

  • @shoaibmansuri810
    @shoaibmansuri810 2 роки тому +2

    Sir thank you apne meri request mani sir thank you so much sir😘

  • @sanjayparihar641
    @sanjayparihar641 2 роки тому +2

    You always Rocking sir Ji 🙏🏻🙏🏻🙏🏻🙏🏻

  • @pinusahoo9243
    @pinusahoo9243 Рік тому

    Thank u thank u thank u sir..maine cmptr class ke bad apke vdo dekhkar samjhti hun..hamare paas comptr ya laptop v nahi he..koi extra class karne ki sujog nahi he...me ese hi mobile me vdo dekhkar sikhti hun...nahi to mujhe thk se nahi ati he..again sia apko thank u..sabhi ko v thank u...aur jo v comptr ke vdo dalte hen...

  • @monicachauhan8220
    @monicachauhan8220 8 місяців тому +1

    Apka bahut bahut dhanyawad sir 🙏

  • @shivani-ur7pm
    @shivani-ur7pm Рік тому +1

    thank you very much si you are great teacher 🎉

  • @zaibkhan6834
    @zaibkhan6834 Рік тому +1

    Great Masha Allah, Allah bless you

  • @Moizfoodi
    @Moizfoodi 10 місяців тому +1

    Great sir jee… love you

  • @awadheshsrivastava5065
    @awadheshsrivastava5065 6 місяців тому

    Explained very easy & nice way.

  • @SajidKhan-wf1wr
    @SajidKhan-wf1wr Рік тому +1

    So nice explanation sir

  • @paramrwt0795
    @paramrwt0795 9 місяців тому

    You helped me always by your video 😊

  • @ghanisthsingh347
    @ghanisthsingh347 Рік тому

    Bhai itne video chhan mare ab ja k koi ye smjha pa rha h ki in formulae ko SIP calculation k liye kse use kr skta hu, mne ROI pta krne k liye video dekha vo kh rha h inflow likho phle to fir date likho, hadd h, ye best trika h bhai

  • @user-un5uu6fv6j
    @user-un5uu6fv6j 11 місяців тому +2

    Sir ji aap bahut achcha se samjha thanks sir ji aap bahut achcha se samjhte hai ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤😂

    • @ramkishoryadav9087
      @ramkishoryadav9087 3 місяці тому

      ua-cam.com/video/e0TsESsXBjk/v-deo.htmlsi=iG8fPaX-oQ7OJNaa

  • @abodisom_official
    @abodisom_official 8 місяців тому

    Nice video 👌👌👌

  • @deepakkeshari1168
    @deepakkeshari1168 Рік тому +1

    You are powerful video

  • @respect-bv4kj
    @respect-bv4kj 2 роки тому

    Thank you sir
    I am from Nepal ❣🇳🇵🇳🇵🇳🇵🇳🇵

  • @mhhasan2005
    @mhhasan2005 2 роки тому +1

    Very useful sir with Thanks

  • @azizullah775
    @azizullah775 2 місяці тому

    Great thanks

  • @rajnanera6955
    @rajnanera6955 Рік тому +1

    Thank you so much sir

  • @deepakkeshari1168
    @deepakkeshari1168 Рік тому +1

    I am proud of you

  • @Kataria05
    @Kataria05 5 місяців тому

    Amazing 🤩 ... Got it all 👍

  • @ViewOrReview
    @ViewOrReview Рік тому +1

    Just awesome 👍

  • @rheapeter9709
    @rheapeter9709 Рік тому +1

    Thank you sir!!

  • @manishsingh7930
    @manishsingh7930 2 роки тому +1

    Great sir 👏 👍

  • @arunkumarsinghark3024
    @arunkumarsinghark3024 Рік тому +2

    🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤
    🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

  • @sayanidas8675
    @sayanidas8675 2 роки тому +1

    Thank you sir😇

  • @Altaf_Alam
    @Altaf_Alam 2 роки тому +1

    Thank u sir 🔥

  • @SimarjeetSingh-zv8sc
    @SimarjeetSingh-zv8sc 9 місяців тому

    thank you sir

  • @TVSCDN
    @TVSCDN 11 місяців тому +2

    Thanks Deepak ji 🎉🎉🎉❤❤❤... Will this work in excel365 ver.??

  • @KARANKUMAR-lh5di
    @KARANKUMAR-lh5di 2 роки тому

    Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz

  • @aartijaatav8107
    @aartijaatav8107 Рік тому +1

    Very nice

  • @MegaMindTech
    @MegaMindTech 2 роки тому

    Good 👍
    Thanks for sharing

  • @historystudy1387
    @historystudy1387 2 роки тому +1

    Sir ap Sacha sa padath ho

  • @AyushiPal-hn1dn
    @AyushiPal-hn1dn 8 місяців тому

    Tq sr 😊

  • @madhusharma8557
    @madhusharma8557 2 роки тому

    Very informative

  • @rupeshmalik438
    @rupeshmalik438 Рік тому +1

    Thanks

  • @deepakkumardas4032
    @deepakkumardas4032 2 роки тому

    Very nice sir

  • @himi1509
    @himi1509 2 роки тому +1

    Sir please complete the excel series
    Only 4 uploaded till now
    Thanks Sir

  • @AyushiPal-hn1dn
    @AyushiPal-hn1dn 8 місяців тому

    Excl ki starting s video dalye pls sbhi with formulas plz😊

  • @soumensamanta8966
    @soumensamanta8966 2 роки тому

    nice sir ❤

  • @Amiralig7983
    @Amiralig7983 Рік тому

    Hello sir have you also explained more financial formulas , because after this video I couldn't find more

  • @thecodingboat9505
    @thecodingboat9505 10 місяців тому +1

    9:08 rate jo hai yealy diya hua hai us ko monthly convert karne ki jarurat hai.

  • @ramgopalchandrashekar408
    @ramgopalchandrashekar408 Місяць тому

    sir i would like to learn all financial formula's . please guide/teach us

  • @zaheerabass5419
    @zaheerabass5419 2 роки тому

    Sir ur videos are very helpful sir i hv a request to u plz make one video on e office as we see today after covid most of the works are done n through e office so plz make one video that how to send and make files online

  • @MukeshKumar-jq4vj
    @MukeshKumar-jq4vj 2 роки тому +2

    Sir school management software Excel me banana

  • @MuhammadTanveer-9797
    @MuhammadTanveer-9797 2 роки тому

    Hello sir
    Please Explain how to make an Indian calendar thanks sir

  • @RajivKumar-nr4dk
    @RajivKumar-nr4dk 2 роки тому

    Please make a video on MS publisher

  • @limsmonika5720
    @limsmonika5720 2 роки тому

    Sir Apne kounsa version use karrahe ho excell Ka??

  • @sonchiriya6872
    @sonchiriya6872 2 роки тому +1

    First views

    • @piyushsharma8563
      @piyushsharma8563 2 роки тому +1

      🏅🏅🎖️🎖️🎖️🎖️🏅🏅🏅🎖️🎖️**le bhai sare medal tu hi rakh le.. 😀😀😀

    • @sonchiriya6872
      @sonchiriya6872 2 роки тому

      Sukriya bhai Saab 😃😃

  • @khustarnoorani4917
    @khustarnoorani4917 2 роки тому

    Deepak bhai please assist me.
    Mere pass excel ka 3 work book hai lekin tino work book ka data ek hi column me lena hai vlookup ke jariye.
    Ya to fir ye samajh le ki ek hi column me do dafah vlookup use karna hai lekin first vlookup value jaise ke waise hi rahna chahiye.
    Hope you will help
    Thank you

  • @shaikvalli1414
    @shaikvalli1414 8 місяців тому +1

    Please share the calculation and formula. INR 100000 per year for 5 years and Returns at 10th years with IRR 8%

  • @TheCreatorKaran.K
    @TheCreatorKaran.K 2 роки тому +1

    Hlo sir
    Aap telegram par aapka channel hai...
    Please link de do..

  • @sangambuildway983
    @sangambuildway983 2 роки тому

    a company has three products and three warehouses i want stock inventory to be made with auto matic product and godown how possible please help and share other tips this type

  • @narendrasaini6264
    @narendrasaini6264 2 роки тому

    Sir ek video hlookup Par publish kro jisme aage kisi cell me data likhe aur piche vali cell se ans nikal ke aajaye

  • @inderrav5743
    @inderrav5743 2 роки тому

    Sir mobile me excel cell column ko lock kese kre jisse particular cell or column edit nhi ho ske baki sab editable ho
    Only mobile me

  • @theinvisiblewings11
    @theinvisiblewings11 7 місяців тому

    9.23 par jab pmt apne lagaya hai toh rate ko 12 se divide kyu nh Kiya apne aur multiply bhi nh Kiya jabki jab bhi hm pmt nikalte hai tb usme ye use krte hai batayiye aap

  • @hindisahityasargam608
    @hindisahityasargam608 Рік тому +1

    दीपक जी! FV का formula RD पर गलत कैलकूलेट कर रहा है। क्योंकि? 2700 रूपए का 7.5% के हिसाब से एक साल के RD के लिए FV formula जो कैलकूलेट कर रहा है वो अमाऊंट बन रहा है 33537.28, जबकि बैंक का कैलकूलेशन है 33738.37। तो इस formula को सही कैसे माना।जाय??

  • @jitendrasolanki3555
    @jitendrasolanki3555 8 місяців тому

    Loan kisto me de rahe hai to kaise count kare??

  • @Paintingartnrush
    @Paintingartnrush 2 роки тому +1

    Are macro records krke password lgane ke bad macro cannot work aara he but sare option enable he enable macro work book me file save he
    Or bina password ke macro kam kar rha he dimag kgrab ho gya password k sath save ku ni ho rhi file jldi reply krna bro

  • @SanjayKumar-em9yb
    @SanjayKumar-em9yb Рік тому

    Sir I have a question if PMT is 835 fv1500000 and NPER 10 so what is rate please answer me this question

  • @village_style5237
    @village_style5237 2 роки тому

    Mine is a very simple question unrelated to the above topic but related to excel. Lets say I want to enter "Sale" and "Purchase" in two consecutive rows leaving the third row blank. And I want to repeat this data for sufficiently long number of rows say till row number 5000. How do I achieve that ?

  • @hemantsaha_
    @hemantsaha_ 7 місяців тому +1

    Mera answer 99999.91

  • @amitdesai8630
    @amitdesai8630 2 роки тому

    (H3*I3)*(1-J3) Aise formule main "1" ka meaning kya hota hai?

  • @esharoy3073
    @esharoy3073 6 місяців тому

    My amount is wrong in case of pv

  • @socialsite9842
    @socialsite9842 2 роки тому +1

    Sir please hELP
    SIR MUJHE "SAME NOTICE" bhut se LOGO KO भेजना है जिसमें उनका नाम, पता,मोबाइल नम्बर,बार बार लिखना ना पड़े एक्स्ल में सब एंट्री ह,,,कैसे करना है विडियो ह तो प्लीज़ सर लिंक भेजे
    अति कृपा होगी।

  • @vishalmajhwar9250
    @vishalmajhwar9250 Рік тому +1

    Sir loan amount 110000 me mera p.v 109,999.96 rs. Aa raha hai
    Ekdam correct nhi aa raha hai

    • @esharoy3073
      @esharoy3073 6 місяців тому

      Mera bhi same problem hai

  • @BankerWriterMosharaf
    @BankerWriterMosharaf Рік тому +1

    FV formula doesn't give accurate value if payment period and compounding period are different. Say, in Bangladesh Payments are made monthly but interest is compounded yearly or at the end of the tenure of the deposit scheme.

  • @shubhamsingla7000
    @shubhamsingla7000 2 роки тому

    I have a Question ⁉️ in Excel
    When we delete any data from cell and want to get deleted data to another cell so is it possible by using formula

    • @shubhamsingla7000
      @shubhamsingla7000 2 роки тому

      Because in the list of Excel I want to seperate some entries from list

    • @village_style5237
      @village_style5237 2 роки тому

      Mine is a very simple question unrelated to the above topic but related to excel. Lets say I want to enter "Sale" and "Purchase" in two consecutive rows leaving the third row blank. And I want to repeat this data for sufficiently long number of rows say till row number 5000. How do I achieve that ?

  • @nihayatsabah2166
    @nihayatsabah2166 2 роки тому

    Thanks

  • @MuhammadTanveer-9797
    @MuhammadTanveer-9797 2 роки тому

    Hello sir
    Please Explain how to make an Indian calendar thanks sir

  • @KARANKUMAR-lh5di
    @KARANKUMAR-lh5di 2 роки тому

    Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz

  • @sangambuildway983
    @sangambuildway983 2 роки тому

    a company has three products and three warehouses i want stock inventory to be made with auto matic product and godown how possible please help and share other tips this type