Mutual Funds Returns Calculator| Lumpsum vs SIP Returns Calculation | MF Returns Calculation

Mutual Funds Returns Calculator| Lumpsum vs SIP Returns Calculation | MF Returns Calculation
In this video by FinCalC TV, we will see how to calculate MF Returns or Mutual Fund Returns interest rate using Excel Calculator examples and Sensex mutual fund. We will also see how you can enjoy the benefit of rupee cost averaging with SIP (Systematic Investment Plan) vs Lumpsum Investment. We will also see Equity vs Debt Mutual Funds and their difference. MF Returns Calculator sip vs MF Returns Calculator Lumpsum. MF returns calculator taxable. MF vs PPF vs NSC interest rates.
Online SIP Calculator:
fincalc-blog.in/mutual-fund-s...
DOWNLOAD MUTUAL FUND EXCEL CALCULATOR:
fincalc-blog.in/how-to-calcul...
After watching this video following queries will be solved:
What are mutual funds?
How MF returns or mutual fund returns are calculated?
Lumpsum vs SIP mutual funds?
How to do SIP (Systematic Investment Plan)?
What is SIP?
Equity vs Debt Mutual Funds?
Which mutual funds you should choose?
How to select best mutual funds?
DOWNLOAD our FREE ANDROID APP "FinCalC":
play.google.com/store/apps/de...
A mutual fund calculator is a practical financial tool that enables an investor to calculate the returns yielded by investing in mutual funds. In broad terms, there are two ways in which one can invest in mutual funds - one time & monthly.
SIP or Systematic Investment Plan is an avenue of investing in mutual funds. In a SIP, an individual invests a small amount every month on designated schemes. One thing to remember is that the NAV of such funds changes every month and the same amount of money can purchase a variable number of units in different months.
Imagine that you invest via SIP of Rs. 1000 for 12 months. At the time of availing the SIP, the NAV of your chosen stock is Rs. 10. So, you can purchase 100 units of the stock in the first month. In the second month, the NAV increases to Rs. 20. Your 1000 rupees can now buy just 50 units of the same stock.
An online SIP calculator predicts the returns on your SIP based on specific parameters. You simply need to input the SIP amount, the duration of investment and the expected rate of return, and the calculator will wield the results in seconds.
An investment is when an individual invests a substantial amount at one go in a particular scheme. One of the primary advantages of opting for one-time investment is that the change in NAV value does not affect the number of units you can purchase.
You need to input three essential data points; namely, your investment amount, estimated ROI and the duration of your investment.
Frequently Asked Questions (FAQ)
Can there be negative returns on mutual funds?
Yes, with mutual funds, there is always a risk of negative returns. However, with some financial planning and expert assistance, such situations are quite easily avoidable.
How many mutual fund schemes are there in India?
According to data released by SEBI, there were 1,013 mutual fund schemes in India as of FY18.
#MFCalculator #MFReturns #MutualFunds #Excel #Calculator #FinCalCTV
=============================
Agar aapko video pasand aaya to LIKE kijiye aur SHARE kijiye apne dosto ke sath.
COMMENT karke batayein aapko video kaisa laga ya phir aapki koi queries ho personal finance related.
SUBSCRIBE kare taaki aapko new videos milte rahe.
Mujhe Social Media par FOLLOW kare:
Facebook : / fincalctv
Twitter : / fincalctv
BLOG: fincalc-blog.in
==========================================
PPF Interest Calculation with Examples in EXCEL:
• PPF Excel Calculator |...
Income Tax Calculation using EXCEL:
• Income Tax Excel Calcu...
Savings Account Interest Calculation using EXCEL:
• Money Tips - Savings A...
Fixed Deposits EXCEL Calculator:
• FD Interest Calculatio...
Income Tax Return Filing Step by Step Video:
• How To File ITR Online...
New PPF Rules 2020 Video:
• PPF New Rules 2020 & P...
Income Tax Calculation for Senior Citizens Video:
• Income Tax Calculation...
==========================================
Ghar ki Recipes ke Videos aapko yaha milenge:
Jhatpat Recipes:
• कृष्णा जन्माष्टमी व्रत...
The examples used are for Illustration purpose only.
Comment in comments section if you have any queries.
Thank you for watching :)
DISCLAIMER:
Examples used are for Illustration purpose only and might not cover every detail of examples shown. It is advised to seek professional help before taking any financial decisions. The owner of this channel shall not be liable in any way.
Website Credits: www.valueresearchonline.com/f...
The example mutual fund used in this video is NOT promoted by the author of this channel in any way.

[@pritimishra1482]

Very well explained through Excel. I was searching exactly this to know how mutual is calculated. Thank you so much,👏

[@fincalc]

Glad it was helpful! Please subscribe for more such videos and share with your friends. Happy New Year :)

[@vishalkumar-ex1my]

its a great video , very helpful and clearing all concepts .Thanks a lot bhaiya

[@rameshpknder123]

your explanation is right for 1 year .. but in case of long investment for more that 10+ years..Lumsum is better than SIP.

[@the_anuragsrivastava]

Awesome explaination bhai... thank you 👍👍

[@fincalc]

Welcome Bhai 👍🙂

[@reubengurung4695]

Hi sir mutual fund mein before maturity paisa nikalne se thik rahega aur quit karna chahta hun plz suggest

[@vipulbattise2685]

Awesome brother, very well explained...

[@fincalc]

Thanks brother 🙂👍

[@pankajverma-xm9qv]

Please answer...5K sip ki jagah agar har mahine jaise he negative may NAV ho aur everymonth mai 5k daal dun manually apni marzi ki date pe to yeh samajhdari hai? aur SIP ka he kaam karegi?

[@sgstradetalk9725]

Thankyou so much.Brother kis time par lumpsum mutual fund investments krna chahiye? kaise kisi bhi mutual fund ki NAV analysis kr skte hai ?

[@arunsharma2117]

Sir, can we take mutual fund's NAV and Units from my portfolio.

[@Traderstownn]

Ye knowledge koi nahi deta bhai thank u so much dill se ❤️❤️

[@fincalc]

welcome

[@ayshasiddika9287]

Excellent sir

[@devaneman1242]

Thanks you 💖 great video 🙂 for beginners

[@fincalc]

You’re welcome 😊

[@SeemaSharma-cc4nn]

Hi sir i have an doubt as per ur explanation profit on mf its on simple buying and selling value on nav but how compound interest work on it i did not understanding plz explain....

[@wealthyinformation8340]

Hello, How to calculate stocks portfolio correlation and covariance in excel sheet

[@sa-jh4hg]

Sir how we can pay tax on profit amt while resumption from mutual fund it's online or offline process

[@spaced_hideout1916]

Very informative for me thanks bhai And but there is no link card shown during the video

[@maheshgaikwad3390]

Awesome explanation, keep up the good work.

[@fincalc]

Thanks for your comment 👍🙂

[@enjoylife8042]

Appreciate very good 👍. It always recommended sip is better than lumsum

[@fincalc]

Yes you are right. Thanks 👍🙂

[@asokganai6689]

I like your videos on mutual funds and income tax return filing.

[@fincalc]

Thank you so much 👍

[@sukhchumber1313]

@@fincalc if we put some amount at 40 per. Rate what we got at the money

[@shankarbaghele5866]

Sir have made excel sheet for mf return according your sheet. My query is that after 25 year sip nav values goes to near 4000. Till date I don't seen nav price is near 4000 for any 25year old mutual fund while it's all time return shown 15℅. Return is calculate based on balance or NAV price.

[@aniruddhasingha4619]

When we invest more money(lump sum) on tha same mutual fund does it take the first time investment NAV or on the same day when we invested more money ?

[@fincalc]

The day you invested money. That day's nav will be taken

[@nakthek1611]

Thank you so much sir

[@fincalc]

Welcome 🙂👍

[@eliyazshaik8246]

Can we apply below strategy whenever NAV is low in SIP..!!? 1. Let’s say we are investing 10k every month. Now, we split 10k to 30days then it’s 333rs per day. 2. Now, daily we check NAV comparing to previous day and if it’s low then invest 333 on that day and if it’s high then we hold it.. 3. Let’s say’s NAV is high on first 3 days and low on 4th day then daily amount which was on hold 333*3=999 we invest 999 on day 4 and investing keeps go on in this format. Does this strategy gives high returns..!!? Coz, we can acquire more units on less NAV

[@tukaramborade6678]

Nice explanation sir.. thnx

[@fincalc]

Welcome 🙂👍

[@nasikastrology]

Sir you r very talented sir what is your qualification pl. Reply

[@bharatnimbolkar2033]

एक वर्षापेक्षा जास्त कालावधीच्या SIP साठी, उदा.10 वर्षे, त्यासाठी सुद्धा असंच रिटर्न काढतात का?

[@junior-10]

Mera hybrid fund me 5 lakh 5 years ke liye hai.2018 me invest kiye the through SBI.Kitne mature amount milenge

[@amitkale1284]

In lumsum investment if we found that at the end of one year NAV is less than the NAV we purchased, so is it mandatory to sell our units at that date only or we can sell it later also

[@fincalc]

We can sell whenever we want. Not mandatory to sell after 1 year only..

[@bhupathiraj8143]

@@fincalc I have continued question, how long can we keep it without selling after 19-Nov-2020 ? and, what if there is no drastic change in NAV for few months, what could be the ideal solution to get good returns ?

[@fincalc]

@@bhupathiraj8143 ideal solution is to keep tracking the mutual fund returns every 6 months to 1 year and see how it is performing. If not performing well than we can switch to another good fund. Regarding for how long we can keep, ther is no such hard rule, we can keep it forever or keep for a day as well. But it is recommended to sell the units once your goal is achieved. If welath creation is the goal than keep it forever and see how your money grows. Hope this helps 🙂

[@SRINIVAS7609i]

Very well explained bro

[@fincalc]

Thanks bro. Please SUBSCRIBE and share with your contacts 👍🙂

[@mruganggaikwad9711]

Very well explained

[@fincalc]

thanks :)

[@sandipnbadeliya5172]

Nice and true explanation

[@fincalc]

Thanks 🙂👍

[@rajachouhan1283]

Bahut badiya bhai

[@fincalc]

Thanks Bhai

[@Manmohansingh-hk8if]

Agar hum mutual fund me 1 lakh one time invest karte h 5 years tk ke liye aur beech me hi loss jada ho gya to kya mera jo principal amount hai wo safe mil payega ya wo bhi loss me chala jayega...??

[@Haq_se_logical]

bahut badhia...

[@fincalc]

Dhanyavaad 🙂👍

[@bhavikshah5736]

You r really good bro , the way u r understanding is really simple and awesone ..

[@fincalc]

Thank you. Please subscribe for more videos and share with friends 🙂👍

[@poojarajbhar9892]

P

[@akashkumarsh5164382]

Sir,if we withdraw the profit from the mutual funds,will it effect the Nav or no. of units?

[@fincalc]

The units corresponding to withdrawal amount will be reduced

[@avinashlakra1997]

Sir main 3 saal ke liye 5,00,000 fixed kiya tha wo maturity date ke kitne din ke bad Account me aata hai ya us paise ko nikalne ke liye kya karna hota.

[@NishantKumar-yh5cb]

Wah sir ... Thanks... Sip ka percentage bhi nikalna bata dijiye...

[@fincalc]

theek hai video banate hai

[@subhashisdas1784]

How to get NAV value of current date?

[@chandansrivastava8242]

Thanks bro👌👌👌👌

[@fincalc]

Welcome

[@akhilsahu7973]

Sir in SIP investment .. we have to invest money for every month or only at one time?

[@fincalc]

SIP is Every month. One time investment is called lump-sum investment

[@kaushalkishor5504]

Thank you

[@fincalc]

Welcome

[@sourav_789]

thanks

[@fincalc]

Welcome 🙂👍

[@asokganai6689]

Have you done a video in respect of how to prepare compilation sheet for sale values and purchase values of units of number of mutual funds and arrive at capital gains figures? If you have made it, kindly inform me. I need to prepare compilation sheet. For filing income tax return form 2. Thanks.

[@fincalc]

Yes there is a video on income tax on sip with examples. Check here kzbin.info/www/bejne/a4HHlX1ri8-ZhqM

[@manjunathdeepa730]

Badiya samajaya sir

[@fincalc]

thanks

[@manindermann8164]

how to check the withdral terms, what is liquid funds, Tax benefits of MF explain in detail what type of funds are Tax free

[@MishtiMoments]

What about exit load calculation??

[@dhanujoshi1]

Sir, m ek pensioner hu, m ITR 1 fill krti hu. mra tds fd pr cut hua hai or form AIS m sbi mutual fund s 116000 ka amount show ho rha h. Jism 100000 mera principal amt tha or 16000 interest mila h. Sir ap muje btaye muje 16000 muje show krna pdega kya jo interest amt h.. Ya na kru

[@akashsinha3172]

Please calculate percentage of profit.

[@kevinmanis]

Sir i understand cost averaging due SIP. But please tell that when market are low, at that lumpsum investment then continue with SIP, is that a good option?

[@fincalc]

yes additional funds can be invested via lump sum along with existing SIP. it's a good strategy in long term

[@indiansongvideo6784]

Thank ❤

[@fincalc]

You're welcome 😊

[@sskk1503]

Please make video on LIC Pension Plan [Saral or Other] Calculator.

[@fincalc]

Ok sure. Stay tuned 🙂👍

[@shankarbaghele5866]

If return is 15℅ all time and 25year old fund its have near 4000 nav price but I didn't found Please reply

[@souvikghosh5087]

NICE.

[@fincalc]

Thanks 👍🙂

[@princeKumar-cu4fo]

Sip me har mahine investment jaruri h kha

[@solidshravan]

Ye equity mutual fund hai ya debt?

[@karangawade3946]

thanks for the guidance 👍😊

[@fincalc]

Welcome 🙂👍

[@pankajmahra3819]

Great explanation bro, but if you Calculate lump sum and SIP for the same amount if you have invested in March 2020 rather than NOV 2019, then you will get higher returns in lump sum.

[@fincalc]

Yes some lump-sum investments might give more returns than sip but we cannot time the market to get more returns right? I have explained the comparison of both, depends on people which way they want to invest but your observation is correct 🙂👍 Mostly it is recommended to have a combination of Sip and lump-sum, to buy more when market goes down and continue with SIPs. I think even you'll agree?

[@jaydipbariya2184]

Units monthly vase kese jane .

[@8m405]

If I have invested in lumpsump, I've to wait for one year to get returns or I can withdraw returns early?

[@fincalc]

you can withdraw anytime you want. Just check the exit load criteria of the mutual fund. Also you pay tax based on short term of long term gains if you withdraw. Check this video: kzbin.info/www/bejne/mGSxmmWQf9-joac

[@divyanshubansal14]

Lumpsum me additional purchase. Kane pr average nav kaise calculate hoti h?

[@random_dopamine88]

awsome

[@fincalc]

thanks

[@debjeet2832]

Market all time high hoga to short term may sip loss or lumpsum profit hoga.

[@rushikeshgavande5414]

Superb bro

[@fincalc]

Thanks 🤗

[@zangoz_2693]

Bhai, isme interest kaha laga? ye to nav x units ho gya.. isme compounding kaha hui?

[@koushikborah2081]

In lumpsum 1 lakh was deposited but in sip 1lakh 20 thousand was deposited .so both are not same .

[@alltimesentertainmentbyuda9134]

Bhaiya maine sbi sip mutual fund mah 1 saal ke liye paisa invest kiya tha... Next month 1 saal ho jayega.... Kya mera paisa automatically reedem ho ke account mah aa jeyega??? Yah phir khud ko reedom karna parega??

[@fincalc]

Khud redeem karna padega bhai

[@Factzforfunn]

Bhai 1 year ka return kitna milega 1000 investment mai

[@varshasahu2925]

Nav grafh kaise milega sir ?

[@baskuchpal4u]

good sir bahut acha bataya aapne.. sir plz mujhe ye bataiye ki atleast minimum 12% interest per year k liye kaha invest kare

[@fincalc]

ache mutual funds ko identify karke invest kar sakte ho. Lekin long term ke liye invest karo, for like 5-7 years at least

[@baskuchpal4u]

@@fincalc sir 2 years hain mere paas.. kuch mutual funds suggest kar dejiye

[@AmanVerma-wq8ud]

Nice video

[@fincalc]

Thanks

[@devendraph2565]

What mutual funds do with customer's money if customer pays in lump sum and wait for 10 yrs.

[@fincalc]

they invest in the stocks mentioned in mutual fund's portfolio section to give you better returns

[@krishanpandey6721]

Lumpsump wala v same as sip amount add karke dikhana chahiye tha na

[@darshilview314]

I already started one sip in mutual fund..is it poosible to addd more money such as every two days or one week

[@fincalc]

SIP is usually monthly

[@rishabhkumarT]

1st sip se 365 days count hote hai ya it increases for each sip

[@fincalc]

365 days counted from all sip amounts separately

[@Khushal_deshpande2]

Sir mera wala meri family ne kya vi risk wala nhi h bank wale ne khud kra vo phchan k the to unone kr k liya 3 lakh invest kre. So abi 4 lakh ho gye 2 sal phle kya tha

[@MukeshKumar-nh9gd]

Sir Khali Nivesh karne padta hai ki Kuchh share bhi kharidne padta hai sip mein please reply sir

[@fincalc]

Sirf nivesh karna hai

[@manojkumarjha2344]

Sir ji If I don't close MF after 01 year , then, will the profit calculated be added in my invested amount on yearly basis?

[@fincalc]

the units get accumulated in your mutual funds account. If you do't sell them, their value will increase with time

[@lakhangade2870]

Bhai 1 return kitne ruppe ka hota he reaply

[@swetashrama5178]

You have not talked about internet or compaund interest calculated for this

[@rakeshchandra504]

Thank you for the tutorial. How much TAX is charged on the mutual funds while redeeming ?

[@fincalc]

10% in case of ltcg

[@devendraph2565]

@@fincalc What is ITCG?

[@smartstudy5468]

Sir toh yeh keh sakte hai ki jab market crash ho tab hi lumpsum invest karna chaiye....... Aur jab market me nav high pe ho tab hi usko redeem karna chaiye??

[@fincalc]

Right. Lekin Hume Apne goals ke hisab se invest aur redeem Karna Chahiye. Market ke conditions pe based nahi

[@gajendrashah7463]

Sir ji mera naam Gajendra Singh Shah hai sir mene 15saal ke leye 2000/-rupees par months sbi ke sip blue-chip me lagaye hai to sir aap mujhe bateye ki 15 saal me mujhe kitna paisa milega

[@shardasahu3118]

Stop kaise krte hai video bnayiye na aur todte kaise hai kfinkart se video bnayiye

[@nageshhosamani9854]

please make video on Expence ratio and exot load.!

[@fincalc]

Ok please share your queries to include in video

[@nageshhosamani9854]

@@fincalc how the expense ratio amount and exit load amount will be deducted with example.

[@fincalc]

@@nageshhosamani9854 ok added in list.. stay tuned 👍

[@vasudevadole5583]

Agar maine 5 lakh invest kiya to muzhe monthly kitna % return milega

[@cb321babu4]

Plz short a time use bro

[@shabbirali1221]

How much percentage plz Add option how calculate

[@fincalc]

Use SIP calculator here fincalc-blog.in/mutual-fund-sip-calculator-systematic-investment-plan/

[@samiransaha9835]

Return % kitna hoga?

[@yapiridebbarma2450]

Sip ka return keise milegi sir!

[@nitinpimpale9134]

I m retire person, i want monthly income for exp. I want my invest should be safe in mf, please give me advice how to invest 🙏

[@darshilpatel81]

Sip me intrast kitne time me milata he ??

[@fincalc]

Jab redeem karoge tab profits mil sakta hai depending on market value

[@KaushikBala333]

Is expense ratio including

[@fincalc]

Yes

[@devikumar183]

अगर nva हर महीने बढ़ते जाएगा तो कौन सा sip or lumsum अधिक होगा?

[@fincalc]

Aapke goals per depend karta hai.. lambe samay ke liye lump sum ache returns dete hai lekin SIP karna preferable hai

[@sherloksarker7258]

Bro i am beginner.I want to invest 5000.Can i invest one time or SIP

[@fincalc]

If you mean investing every month than go for sip. If you want to invest one time than invest lump-sum

[@statusmaster3317]

Chart kis chiz ka dekhna hai...? us MF ka ya kiska..?🤔

[@fincalc]

MF Nav values ka

[@priyanshipatel9192]

Sir 364.651 kese a raha hain? 🤔

[@BholaRam-wj2uz]

Nav 400 se km hota agr hm na sail kre to kya hoga btaye plsss

[@Satish_Surve]

What if we invested 120000 lump sum ? We could have got 134743

[@fincalc]

yes right but it is risky as well right?

[@karanverma1174]

Bhai sip me intrest konse month me lgta h

[@fincalc]

Bhai depend karta hai sip date pe. Ye video dekho kzbin.info/www/bejne/n33QdqJ9e8mkY8k Kuch aur query hai to zarur puchna 🙂👍