Nifty 17401.65 (1.37%)
Sensex 58461.29 (1.35%)
Nifty Bank 36508.25 (0.39%)
Nifty IT 36157.85 (2.06%)
Nifty Financial Services 17982.9 (1.26%)
Adani Ports 739.10 (4.40%)
Asian Paints 3180.60 (1.35%)
Axis Bank 676.10 (-0.52%)
B P C L 378.85 (2.74%)
Bajaj Auto 3328.40 (2.43%)
Bajaj Finance 7180.50 (2.01%)
Bajaj Finserv 17758.15 (2.16%)
Bharti Airtel 732.55 (1.43%)
Britannia Inds. 3578.50 (1.22%)
Cipla 921.25 (-0.74%)
Coal India 159.30 (2.41%)
Divis Lab. 4777.30 (0.53%)
Dr Reddys Labs 4662.75 (1.22%)
Eicher Motors 2451.55 (0.54%)
Grasim Inds 1723.85 (2.63%)
H D F C 2807.80 (3.85%)
HCL Technologies 1184.70 (2.42%)
HDFC Bank 1525.75 (1.40%)
HDFC Life Insur. 705.30 (1.65%)
Hero Motocorp 2472.70 (1.00%)
Hind. Unilever 2383.30 (1.64%)
Hindalco Inds. 432.10 (1.69%)
I O C L 120.65 (2.51%)
ICICI Bank 722.40 (-0.73%)
IndusInd Bank 945.55 (1.27%)
Infosys 1748.25 (1.94%)
ITC 225.45 (1.60%)
JSW Steel 646.75 (1.50%)
Kotak Mah. Bank 1964.25 (0.56%)
Larsen & Toubro 1789.20 (0.18%)
M & M 849.55 (1.78%)
Maruti Suzuki 7324.95 (0.71%)
Nestle India 19503.20 (0.54%)
NTPC 128.70 (0.78%)
O N G C 144.00 (1.23%)
Power Grid Corpn 214.50 (3.52%)
Reliance Industr 2482.85 (0.64%)
SBI Life Insuran 1188.05 (1.99%)
Shree Cement 26289.80 (0.76%)
St Bk of India 477.00 (0.36%)
Sun Pharma.Inds. 766.25 (2.80%)
Tata Consumer 773.25 (0.06%)
Tata Motors 479.10 (0.81%)
Tata Steel 1112.40 (2.76%)
TCS 3642.90 (1.82%)
Tech Mahindra 1629.65 (2.65%)
Titan Company 2386.50 (1.11%)
UltraTech Cem. 7323.20 (0.01%)
UPL 698.20 (1.12%)
Wipro 646.80 (1.89%)

Computation of the actual rate of return on SIP of mutual funds!

Computation of the actual rate of return on SIP of mutual funds!
by 5paisa Research Team 02/11/2021

People prefer SIP as they can invest in small amounts and also, get the benefit of rupee cost averaging.

Presently every investor is getting aware of the fact that personal finance has become a crucial aspect of an individual’s life and which needs to be planned with appropriate understanding. A mutual fund is an ideal option for those investors, who are embarking on their journey in the equity market as it is managed professionally and has lower risk as compared to direct equity.

Investment in a mutual fund can be done in two ways i.e., via lumpsum and SIP. Generally, people prefer to invest via SIP as they can invest in small amounts and also, get the benefit of rupee cost averaging. So, now, the question arises as to how can we calculate the actual return on our SIP investments? The answer to this question is – by using the XIRR function in excel.


XIRR or extended internal rate of return is the function that can be used to calculate your real investment return. Calculation of returns in the case of SIP becomes quite difficult as you make multiple investments at distinct times. Calculating return on lumpsum investment is quite simpler than SIP as there are no complications related to a distinct time. Besides, multiple amounts of investments can be done regularly.

 
Let’s look at the illustration of how XIRR is calculated:

Illustration:

Suppose, you are going to make 12 monthly instalments of Rs 5,000 and the maturity amount stands at Rs 65,000. The start date of SIP is January 1, 2020, and the date of redemption is December 31, 2020, then what rate of return will you receive? 


Following are the steps to calculate actual investment return on investment:   

Step 1: Open the MS Excel sheet and enter the dates of your investment and investment amounts.    

Step 2: Use the XIRR function. The formula of XIRR in MS Excel is = XIRR (values, dates, guess).    

Step 3: Fill required fields in the XIRR formula and you will get your real investment rate.    

 
As you can see, in the above table the returns generated are 16.64% if you invest 5000 every month for 12 months. As you can see there are multiple cash flows at distinct dates that’s why we have used the XIRR function to compute the rate of return. What if in the above example the investment was done in lumpsum, what will be the rate of return if we calculate using the XIRR function:

Computation of return using XIRR function

 

As we can see in the above calculation that XIRR has come out to be 16.72%. This is how actual rate of return is calculated on the SIP you do. The above calculation is for illustration purpose.

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order
Next Article

These Low-Priced stocks are locked in the upper circuit on Tuesday, November 02

These Low-Priced stocks are locked in the upper circuit on Tuesday, November 02
by 5paisa Research Team 02/11/2021

Some of the low-price shares were seen outperforming the markets in Tuesday's trading session.

The markets are trading flat with mixed cues. BSE Sensex has contracted 85.26 points and is trading 0.14% lower at 60,053.20 level.

Despite the flat trend noticed in Tuesday's trading session, Maruti Suzuki is the top BSE Sensex gainer up by more than 3.4% while Sun Pharmaceuticals is the top BSE Sensex loser on Tuesday. The sales numbers of the coming festive season is an important factor to watch for Maruti Suzuki.

Along with Maruti Suzuki, NTPC, Titan, Bajaj Finance, Bajaj Auto and Larsen & Toubro are among the other BSE Sensex gainers. The broader market is seen trading positively above the frontline indices in the Tuesday trading session with both BSE Midcap and BSE Smallcap trading 0.36% and 1.01% up, respectively.

Allcargo Logistics, Purvankara, Tube Investments of India, TCI Express and Ind-swift Laboratories are among the top BSE Smallcap index gainers on Tuesday.

RBL Bank, Aditya Birla Capital, Shriram Transport Finance, Godrej Industries and Tata Power are the top-performing BSE Midcap index constituents. PI Industries is experiencing the highest drag in the BSE Midcap stocks pack on Tuesday.

BSE Realty, BSE Utilities, BSE Auto and BSE Power are the top-performing sectoral indices for Tuesday’s trading session.

The price-volume breakout is seen in some of the low-priced stocks on Tuesday with several stocks being locked in the upper circuit.

Following is the list of low-priced stocks that are locked in the upper circuit in the Tuesday trading session:

Sr No   

Stock   

LTP   

Price Gain (%)   

1  

3i Infotech   

43.45  

4.95  

2  

Nandan Denim   

87.3  

4.99  

3  

VIP Clothing   

18  

4.96  

4  

RattanIndia Infra   

43.15  

4.99  

5  

Digicontent   

15.5  

4.73  

6  

Ind-Swift Labs   

67.15  

9.99  

7  

DB Realty   

39.5  

4.91  

8  

Digjam   

32.05  

9.95  

9  

Rohit Ferro Tech   

19.65  

4.8  

10  

Hindustan Motors   

12.2  

4. 

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order
Next Article

Godrej Properties Q2 profit jumps fivefold as sales, bookings revive

by 5paisa Research Team 02/11/2021

Godrej Properties Ltd Tuesday reported a fivefold increase in consolidated net profit for the second quarter, helped by higher sales and better inventory management.

Net profit for the quarter through September rose to Rs 35.7 crore from Rs 7.10 crore a year earlier, the Godrej Group company said.

Revenue from operations climbed 44% to Rs 129.32 crore from Rs 89.5 crore in the same period last year.

While revenue jumped 44%, its total expenses rose barely 7.8% to Rs 231.8 crore. This was thanks to a sharp drop in cost of materials consumed to around Rs 236 crore in the second quarter from Rs 1,773 crore a year earlier.

In addition, inventory stood at a negative Rs 177 crore compared with a negative Rs 1,772 crore last year.

The developer’s operational performance also showed significant improvement, with total booking value in the second quarter more than doubling to Rs 2,574 crore from Rs 1,074 crore a year earlier. Total booking volume stood at 3.61 million sq ft, compared with 1.73 million sq ft in July-September last year.

Godrej Properties Q2: Other highlights

1) Total income rose 22% from a year earlier to Rs 290 crore for July-September 2021.

2) EBITDA increased 36% to Rs 105 crore from Rs 77 crore registered a year earlier.

3) Profit before tax jumped 158% to Rs 58 crore; PBT margin grew to 20.1% from 9.5%.

4) Net profit margin expanded to 12.3% from 3% in Q2 last year.

5) Net debt dropped to just Rs 16 crore as of September 30, 2021, from Rs 2,733 crore a year earlier.

6) Average borrowing cost fell to 6.5% from 7.55% a year earlier and 6.65% in June.

Godrej Properties management commentary

Pirojsha Godrej, executive chairman at Godrej Properties, said that the real estate sector rebounded strongly in the second quarter after a weak first quarter.

He also said that Godrej Properties recorded one of its best ever quarters for bookings with a strong response to new launches across India.

“We have a robust launch pipeline in the second half of the financial year and expect to build on the current momentum,” he added.

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order
Next Article

Performance ranker: How did the Indian equity market perform against global markets in October 2021?

Performance ranker: How did the Indian equity market perform against global markets in October 2021?
by 5paisa Research Team 02/11/2021

Among major global markets, it was only the Japanese and Brazilian equity markets that performed worse than the Indian equity market.

The Indian equity market remained quite volatile in October 2021. In the first 12 days of trading, Nifty 50 gained as much as 6%. From the 17500 mark, it scaled the highs of 18600 in a matter of just 12 trading sessions. Nevertheless, after October 19, the market started to fall and in a few trading sessions, all the gain made in the first half of October was lost. Nifty was again trading at the 17600 mark.

Nevertheless, such a fall was not due to any global cues, it was a purely over-stretched valuation that might have played down.

Among major global markets, it was only the Japanese and Brazilian equity markets that performed worse than the Indian equity market.

The best performing market was tech-heavy Nasdaq, which gained 7.27% in October followed by S&P 500 and Dow Jones Industrial Index. So, it was the US equity market that remained the best-performing equity market in October 2021.

The following table shows the performance of the major global equity market in October 2021.

Stat  

S&P 500  

DAX  

FTSE  

Nikkei 225  

Nifty  

CAC 40  

DJIA  

Hang Seng  

NASDAQ  

Bovespa  

Total Return  

6.91%  

2.81%  

2.13%  

-1.90%  

0.30%  

4.76%  

5.84%  

3.26%  

7.27%  

-6.74%  

Max Drawdown  

-1.12%  

-1.46%  

-1.15%  

-3.22%  

-4.36%  

-1.26%  

-1.09%  

-2.90%  

-1.28%  

-9.72%  

                          

Maximum drawdown, which is defined as the peak-to-trough decline of an investment during a specific period, shows that in the month of October, the Indian equity market saw a max decline of 4.36%. Indian equity market was second only to the Brazilian market that dropped almost 10% in the month of October 2021.

The Indian equity market has recovered from its 50-day moving average and Nifty is trading close to the 18,000 mark that remains a strong resistance of now.

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order
Next Article

Technical Analysis: Grasim Industries gives a breakout

Technical Analysis: Grasim Industries gives a breakout
by 5paisa Research Team 02/11/2021

Grasim Industries has given a breakout from the flag chart pattern. Read on to find out more. 

Post making a low of 380.45 in March 2020, Grasim Industries continued to remain in a good uptrend making higher highs and higher lows. However, after making a higher high of 1,798.4 on October 18, 2021, the stock moved into a small consolidation making a series of lower high and lower lows on the lower time frame chart. But on daily charts, the stock made a higher low of 1,669.15 on October 25, 2021. And on November 1, 2021, the stock finally breached the flag like chart pattern with increased volumes.

The immediate resistance that the stock might face is placed at 1798.4, while its immediate support zone is 1,694.3-1,669.15. The stock presently is trading above its 9-Day, 20-Day and 50-Day Exponential Moving Average (EMA). Moreover, you can consider 50-Day EMA to be its trailing support level. The Bollinger band does suggest a potential pullback from current levels as the price is currently trading near the upper band.

The 14-Day Relative Strength Index (RSI) is inching high and is presently trading at 65 which is above its 20-Day EMA of 62. Moving Average Convergence Divergence (MACD) is showing positive crossover on the breakout and is trading in the positive territory. In the shorter time frames, the price is trading below its Parabolic SAR. This suggests a possible pullback from present levels. Even the Commodity Channel Index (CCI) is presently hovering above the 100 level, suggesting an overbought situation.

Grasim Industries is likely to release its Q2 FY22 earnings by November 11, 2021. It would be interesting to see how the price reacts. However, from the present analysis, it seems that the uptrend is likely to continue as there are no signs of a trend reversal. However, the technical indicators such as Bollinger band, Parabolic SAR and CCI is suggesting a potential pullback from current levels.

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order
Next Article

Multibagger Alert: This top multibagger from the finance sector gained 208% in one year

Multibagger Alert: This top multibagger from the finance sector gained 208% in one year
by 5paisa Research Team 02/11/2021

Bajaj Finserve is one of the leading players in the NBFC space.

Bajaj Finserve Ltd has been one of the trending companies in the past year. It has more than tripled its shareholder's wealth in the trailing twelve months. Strong financial position and the recovery in the economy post-second wave have boosted the spirits of the shareholders. 

In October 2021, the stock witnessed a great bull rally and peaked on the BSE. With this, the multibagger stock entered into the Rs 3 trillion market cap club. It had then become the 18th Indian company to cross that mark.

The quarter ended September 2021 results witnessed strong growth momentum. The consolidated revenues were Rs 18,008 crore, up by 20% on a YoY basis. The company reported a growth of 12% in consolidated profit after tax which stood at Rs 1,122 crore. Its surplus funds excluding group investments stood at Rs 15 billion as of September 30, 2021.

Bajaj Finserv is a holding company for the businesses engaged in various financial services of the Bajaj Group. And thus, its majority holding is in Bajaj Finance Limited (BFL) in which it holds a 52.65% stake. Bajaj Finance Ltd has also been a multibagger, generating a return of 117%. In the insurance segment, it has holdings in Bajaj Allianz General Insurance Co Ltd (BAGIC) and Bajaj Allianz Life Insurance Co Ltd. (BALIC). For the first half of FY22, BFL contributed 67% to Bajaj Finserv’s profitability, while BAGIC and BALIC contributed 32% and 11% respectively.

On November 2, 2021, the multibagger was trading flat at Rs 17,592 at 12:05 pm on the BSE. It has a 52-week high of Rs 19,319.95 and a 52-week low of Rs 5,563.45.

Open Demat Account

Enter First Name & Last Name
Enter Mobile Number
Enter correct otp
Please enter referal code
Start investing in just 5 mins
Free Demat account, No conditions apply
  • 0%* Brokerage
  • Flat ₹20 per order