SWP calculation explained in MS Excel

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

КОМЕНТАРІ • 98

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

    Pankaj Sir Very good video 🙏
    Always my favourite pankaj Sir 🙏 Best swp video 🙏
    👍👍👍👍👍👍👍👍👍👍👍👍👍👍

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

    Good video. Thanks for upload.

  • @kdavidkoch-raj7339
    @kdavidkoch-raj7339 2 місяці тому

    Superb... Sir, thanks

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

    very helpful

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

    Great sir ji...lekin agar balance fund me ya largcap me minimum 10% ka returns mile or 1cr ka fund hone ke baad usme se 50k ya 60 k har mahine le to baki bacha hua 4-5% to grow karega lagbhag 10 year tak le regular to 10 yer ke bad withdrawal amount 60lk or bacha hua 1.67cr bachega bhi ab mutual fund se 10 saal me 10% to aspect kar hi sakte hai jabki diya to 15-18-20 or 25 bhi hai...

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

    You are great man in India

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

    As always great sir 🙏🙏🙏🙏🙏🙏🙏

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

    Great work sir❤😊

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

    Sir very nice explanation 👍

  • @vijjoyyprasad369
    @vijjoyyprasad369 4 місяці тому

    Thanks for the formula

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

    Very nice thanks 🙏

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

    Very nicely explained Sir

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

    Nice information.

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

    informative good sir

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

    Nice presentation 😌

  • @basantchoubey5137
    @basantchoubey5137 11 місяців тому

    Explanation is very complicated.. These days there ate lots of tools available which can give much better visibility on SIP or SWP with all possible scenarios..

  • @pan.sushant
    @pan.sushant 4 місяці тому +1

    thank you sir!

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

    Great 👍

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

    Very nice sir

  • @RAJKUMAR-fl4cs
    @RAJKUMAR-fl4cs Рік тому

    Nice video sir

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

    Sir swp me time period ko bda sakte hai kya reply me

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

    Nice video. Explained beautifully. Please explain how fund grows. Whom to contact if we want to do SWP

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

      Fund wl grow in 2 ways - start SWP after 5 or 10 years of investment and then SWP to be done @5% in a Fund in which annual return is 15%

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

    Very informative. Thank you Sir!

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

    Sir age ham bis sal ke liye plan lete h or bis sal bas priceple amount nikalte h man lijiye das lac ka plan h to kya bis sal bad hme das lac hi return milega ya kuch intrest bhi milega

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

    Sir where to invest?

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

    बहुत क्लियर बताये सर

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

    Excellant explanatn

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

    Sir Umesh Kumar sir namaskar sir I invest 7 laks SWP in 2016 but don't withdraw intrest

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

    Is SWP income is taxable?

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

    Age : 36, Investible Surplus : Lump sum : 10 lac. Can we invest in Conservative Hybrid fund and do SWP. The SWP on monthly basis is then park in Equity fund for long term. Any saving should be parked in Conservative Hybrid and do SWP and invest SWP in Equity fund. Are there any shortcomings in above logic ?

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

    Very good .

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

    Dear sir अगर मै 12 लाख इन्वेस्ट करू दस साल के लिए ( swp ) और एक साल बाद 10 हजार लेना शुरू कर दू (nippon) sir फंड suggest करे थैंक्स

  • @JoydeepDas-mo8un
    @JoydeepDas-mo8un 2 роки тому +6

    Sir, I invested around Rs 3 crore in mostly equity mutual funds(20 different funds). I require around Rs 2 lakh per month. How much is the probability of surviving 30 years with this investment.

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

      Lifelong

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

      Your money wl grow@ 12% to 15% and your money wl continue to grow as your withdrawal is only 12% annual. You wl also get annual Rs 1 lakh capital gains exemption

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

    Nice gide

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

    How to invest in Swp by ourself?

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

    We're nice

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

    Good

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

    This video was confusing to me too many subjects included
    What is the tax implications on withdrawal as swp

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

    Nameste Pankaj ji. Please tellme about 80CCF For exemption in Infrastructure of Govt. And Corporate Sector. Is it Sure that 20000₹ are exempted under Chapter VIA in every Financial Yrar.? Thanks.

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

      Age 62 Year.

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

      The deduction u/s 80CCF was withdrawn in Union Budget 2012 and it is not available any more starting from FY 2012-2023 and the subsequent financial years.

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

    I wanted to invest rs 500000 at a time in swp scale how much i wanted to per month

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

    THANKSSSS

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

    Sir, latest calculated kore dekhai

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

    Please add English subtitles

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

    Hasband expire huwy hai kuch aisa plan batawo ke mahiny ko 6 hazar rupees aye

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

    Sir I want plan for my retirement which is in July 2023..So I need your guidance.. Plz tell me how to contact with you.. Thanks

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

    Sir swp me profit ko he only kyse with draw nikalna h

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

    Sir , with due respect ,sir may na 5 lake ka SWP my investment kit ho, SBI EQUITY FUND my,five years ka lea, to lay 5 years ka bad mara 5 lake rupees pure withdrawal ho jayga,7% sa may monthly mode may rupees may withdrawal late par? Please app betsy ke mara principl la kay hoga? Please please help

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

      Agar aap 7% per annum ke rate par withdraw karte hain aur scheme par return 7% per annum ya usse jyada milta hai to 5 saal ke baad 5 lakh ya usse adhik bacha rahega lekin yadi return 7% per annum se kam milta hai aur aur aap 7% per annum ke rate par withdraw karte hain to aapka capital Kam ho jayega.

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

    Mutual fund main investment karo but monthly chahiye to Better hai fd ya government main karo amount to safe rahega

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

    Which type of Fund will the best & suitable Sir for SWP?

    • @pankajmathpal
      @pankajmathpal  2 роки тому +4

      I'll answer this in my next video.

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

      Please make it immediately sir

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

      @@pankajmathpal Is This video available now ? Please share the link boss

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

      @@aman12391 which one you are asking for?

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

      ​@@pankajmathpal yr video on which type of a fund is good for SWP

  • @Oooo-qq6ir
    @Oooo-qq6ir 2 роки тому

    SIR MAINE AXIS BANK SE HOME LONE LIA HAI.PAR HOME MERE MATA JI KE NAM PER HAI.MERI MATA JI KI DEATH HO GAI HAI MARCH 2022 MAIN. KYA MATA JI KE NAME PER INSURANCE HOGI KI NAHI .BANK MANA KER HAI

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

    Sir I invest in stock market but now I get a job in Nijeria. My salary will deposit in rupees in my Indian bank account. My nvest in stock market continue. Now some friend will ask me not to invest in stock market because my income from abroad. So I do not know the Indian govt rule and regulation. So kindly make a video in this matter. We are the lower middle class employee. Coming from india to income some amount, so kindly make a video for if we give income tax or not of our indian rule.

  • @Lakshmi-xd4se
    @Lakshmi-xd4se Рік тому

    Put video in English also sir.

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

    5 year ke bad Kaya hoga ?????

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

    Sir , apne bola 1 crore rupees rakhne ke baad pahele mahina mey 25 thousand nikal lene ke baad 9 crores .... something keise rahega? A baat sochke bataana chahietha.Thanks.

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

      Manoj ji, vedio ek baar phir dekhiye. Aaapko jaroor samajh aayega ki maine kya kaha hai. Yadi fir bhi na samjhe to mujhe bataiye mai explain karunga.

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

      Hi

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

    Can we connect with you over mail or phone? Please share

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

    Sir my age is 60 i want to invest Rs 10 00000 can you sugget me best mutal fund

  • @BeHappy-lp8tg
    @BeHappy-lp8tg 2 роки тому

    Sir ji can I make u my financial adviser ?

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

    सर, मेरा प्रश्न का जवाब फिर भी नहीं दिया आपने, मैं इतना कैलकुलेशन नहीं जानता....
    मैंने 5 लाख एकमुश्त Canara Robeco flexi cap में इन्वेस्ट किया है मई, 22 में जिसे एक साल बाद जून/जुलाई,23 से मैं swp करके हर महीने रूपये पाना चाहता हूँ, कृपया बतायें कि मुझे कितने रूपये अधिकतम हर माह रकम withdraw करना चाहिए जिससे मूल रकम भी ठीकठाक बढ़ती रहे...?
    Akash Tripathi

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

    👍❤🙏sir

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

    Swp नहीं करनी चाहिए मार्केट ५०/गिर जाय तो आधा पैसा तो ऐसे ही डूब जायेगा इसका जवाब दे

    • @Official--KingOfGames
      @Official--KingOfGames 10 місяців тому

      Bhai... Maan lo aapney 1 lakh invest Kiya... Ab usko time do aur Kam sey kam 3 times grow honey do... Ab half percent total amount ka every month SWP karo... Aapka invested amount kabhi bhi khatam nahi hoga

    • @MadanSingh-eg5we
      @MadanSingh-eg5we 5 місяців тому

      आप जैसे समझदार लोगो के लिए SWP और SIP नही है।क्योंकि आप इनके विशेषज्ञ है।

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

    Are you explaining or complicating?

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

    P. K. Varma 62Years.

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

    Corr plus kaha gaya

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

    For retiree, SWP should not be suitable.

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

      I respect your opinion but my opinion is is that SWP is one of the best choices for managing regular cash flow after retirement. One needs to plan well.

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

    2:37: ye to kind of IDCW ho gaya

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

    How to calculate LTCG tax on SWP?

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

      It will be on First in first out basis. The units which complete 1 year at the time of redemption will qualify for long term capital gain tax and which don't will be considered for short term capital gain tax.

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

    🙏🙏👌👌👋👋

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

    🖐

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

    Simple bolna chahiye

  • @adv.sanjay.1037
    @adv.sanjay.1037 2 роки тому

    Sir please don't use word if..if..again n again..Please tell the assured amount what the invester get because if we invest such a huge amount like 30L we need assured amount monthly or annually...Sir very confusing calculation 🙏🙏

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

      I apreciate your comment but as you know that Mutual funds don't offer guarenteed returns and hence I can't tell you the assured amount.

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

      Sirf death of any human can be assured

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

    Pl send me thanks 🙏

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

    सब बकवास स्कीम है 12% रिटर्न नही आया तीन साल हों गए हमे

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

    Very confusing video

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

    Useless vedio. Many SWP calculator is much more simple.

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

    Leanty video not usefull

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

    Sir plz send u r email