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

Поделиться
HTML-код
  • Опубликовано: 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 месяца назад

      ruclips.net/video/e0TsESsXBjk/видео.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