Lump sum Investment Calculator in Excel | Mutual Fund returns Calculation скачать в хорошем качестве

Lump sum Investment Calculator in Excel | Mutual Fund returns Calculation

Lump sum Investment Calculator in Excel | Mutual Fund returns Calculation In this video by FinCalC TV we will see how to make Lump sum Investment Calculator in excel. Lump sum investments can be used to invest in mutual funds along with SIP investments to maximize your returns. All Excel Calculators Playlist:    • Excel Tutorial   Lump sum Calculator online: https://fincalc-blog.in/mutual-fund-l... Download Lump sum calculator in excel: https://fincalc-blog.in/sip-and-lump-... JOIN Telegram Group: https://t.me/fincalc_tv_channel WHAT IS MUTUAL FUND LUMP SUM CALCULATOR? Lump sum calculator is a calculator that helps you know how much profit you can expect from mutual funds based on your deposit and expected rate of return. This helps you in defining and planning for your goals according to the amount of deposit you can afford to contribute as lump sum investment. WHICH MUTUAL FUND IS BEST FOR 5 YEARS? There are many mutual funds that you can invest in. It is important to understand what are the factors you should see while selecting best mutual funds if your goal is for 5 years or more. Some of the factors include: Expense Ratio: this is the fees taken by AMC (Asset Management Company) in order to manage your funds. This is yearly fees and should be as low as possible while selecting mutual fund AUM: This is Assets under Management, which means, total amount of money being invested by people in the mutual fund. More money being invested by people, means more trust on this mutual fund. But this is not the case always as some already popular AMC tries to sell specific mutual funds to people who are not aware about mutual fund factors to consider while increasing it’s AUM. Past Returns: Although, past returns does not guarantee future returns of a mutual fund, but it is important to check this stat while selecting best mutual fund for SIP for 5 years. Stocks Portfolio: Another important factor to check is the list of stocks present in mutual fund portfolio. Every mutual fund has a fund manager associated to it who selects list of stocks in order to maximize returns on your investments. If you invest in stocks or have idea about stock investing or fundamental analysis, you should definitely see the list of stocks present in mutual fund’s stock portfolio. ARE MUTUAL FUND RETURNS TAX FREE? The returns you get after investing in mutual funds is not tax free. You have to pay income tax based on whether the mutual funds you invested in are equity mutual funds or debt mutual funds. In case of equity mutual funds, LTCG or long term capital gains (gains made after 1 year of holding period) are taxed at 10% on profits above Rs. 1 Lac. Whereas, STCG or short term capital gains (gains made before 1 year of holding period) are taxed at 15%. SIP VS LUMP SUM WHICH IS BETTER Best strategy is to invest via combination of both. Start SIP in a regular way, and invest lump sum amount if you have gathered, in order to take advantage of fallen market to buy more mutual fund units, while investing for at least 5 years or forever! #MutualFunds #Investing #Returns #fincalc ============================ LIKE | SHARE | COMMENT | SUBSCRIBE Mujhe Social Media par FOLLOW kare: Facebook :   / fincalctv   Twitter :   / fincalctv   BLOG: https://fincalc-blog.in Telegram: https://t.me/fincalc_tv_channel Instagram:   / fincalc_tv   ============================ MORE VIDEOS: SIP Returns Calculation:    • SIP Returns Calculation Examples - ₹2000 f...   Income Tax Calculator:    • Income Tax Calculation Examples between ₹4...   Loan EMI Calculator:    • Home Loan EMI Calculator Excel with Princi...   Loan EMI Prepayment Calculator:    • Home Loan EMI Prepayment | How to Save Hom...   ============================ DISCLAIMER: Examples and demo used are for Illustration purpose only and might not cover every detail of examples shown.