Wednesday 20 May 2020

Lessons for the Languishing Indian Logistics Industry*


For a nation of the size in terms of landscape aand economy of India, logistics plays a very crucial role in its economic development. India ranked 44 in the World bank’s Logistics Performance Indicator (LPI), 9 places lower from its 2016 rank of 35.

Albeit a critical cost driver for all products sectors, there is only sluggish growth in the sector. The logistics cost in India is estimated to be 13%-14% of the GDP compared to USA, Europe, Japan where it is 9%,10%,11% respectively. 

In Germany, it accounts for just 8% of the GDP. Germany is now the world leader in the logistics industry ranked 1 in the LPI for 3 consecutive years. The market share of Germany accounts for about 25% of the total of Europe’s logistics market.

Lessons from Germany

The main takeaways for the Indian logistics industry from Germany are:

1. Deployment of the finest transportation infrastructure. The highway network density of Germany is twice the average of Europe.

2. Germany has put in place, what are known as Freight villages that provide:
·        Support services such as cargo delivery points
·        Connectivity to the long-distance network without getting enmeshed into the local delivery points.

3. Paper-based inventory is replaced with speech-based inventory picking.

4. Radiofrequency identification reader antennae installed at strategic locations are used to track carts or trolleys, as they travel between the receiving dock and storage areas.

5. Automated image-based scanning of products at inventory centres to have better inventory control.


Bottlenecks in the Indian Logistics Industry

1. Infrastructure
The Indian logistics industry is plagued by low-quality infrastructure facilities such as fleets, storage facilities etc. While a nation like Germany, which is 9 times smaller than India and with population density half that of India spends 1.22 Lakhs Crores on logistics, the budget allocation of India for the whole of the Transport Sector in the year 2020 is just 1.69 Lakhs Crores.

2. Lack of skilled manpower
The industry needs labour with specialized skill sets such as warehouse management, quality control, truck driving etc. to name a few. Given that more than 90% of the sector is unorganized, there is barely any attention given to nurturing the skilled workforce.

3. Red-tapism
The cumbersome paper works of getting the goods transported after complying with several regulatory requirements such as E-way bills under GST etc. hampers the movement of goods. IT systems and EDI (Electronic Data Interchange) facilities are inadequate to foster the functioning of the industry.

4. Inefficient Intermodal Mix
Deploying an optimal mix of transportation mode in such a way that it could reduce the end cost of transportation to the consumers is a necessity for the development of the industry. In India, the mix is skewed with 60% of the transportation happening through roads, which has proven to be inefficient. There is a dire need for proper coordination between the central and state government in facilitating a proper inter-modal mix of transportation and this calls for a separate ministry or a body (such as Central Water Commission in the case of water resources) to administer the logistics industry.

If we break down the LPI in terms of scores of the individual parameters, the major areas where the performance lags are Infrastructure and Customs clearance process.

 If the aforesaid loopholes could be plugged, India could witness a major fillip in the overall economic development of the nation.


(*Article originally published in CAclubindia.com)

Tuesday 31 March 2020

Macro to Crack the Password of a Protected Sheet

Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Credit: http://www.excelsupersite.com/how-to-unprotect-an-excel-spreadsheet-if-you-have-lost-your-password/ 

Thursday 12 March 2020

Have You Heard About These Modern Lendors?


1.   Tachy loans

About:
Tachy loan is an online platform launched by FinMomenta Pvt Ltd that facilitates P2P lending. It was founded in the year 2016 with its headquarters at Bengaluru. The platform connects prospective lenders with credible borrowers.
Products
v Loans for School Education
v Loans for Online Training & Professional Courses
v Loans for Skill Development Courses
v Personal loans
Features:
v At Tachyloans, Education loans are available for salaried individuals and self-employed professionals/ businesspeople.
v Through Tachyloans, enders can highlight their investment preference and choose the person they wish to provide unsecured personal loans to.
v The interest rates on Tachyloans range from 11.5% to 25% depending on the FinMomenta credit rating.
v Lenders and borrowers can negotiate in a 3-day window, on loan tenure, interest rate, and principal amount.


2. Neev

About
     Neev Credit Private Limited is an NBFC with operations across six cities viz., Bengaluru, Kolkata, Mumbai, Pune, Nagpur and Hyderabad. The NBFC finances education fees for pre-schools, schools, colleges, tuition centres and other academic centres.

Features:
v The NBFC is exclusively engaged in lending for K12 education.
v The loan amount ranges from 30,000 to 200,000 per annum.
v They charge interest at a rate ranging from 3% to 5%.
v  In 2016, Neev Finance has signed an MoU with Ola Cabs to finance the school fees of the driver’s children.

 Neev has collaborated with 300+ educational institutions wherein students studying at these institutes are being financed by Neev.


Saturday 29 February 2020

Comedy Collections





😂Mummy...Daddy...help me..
😂Mummyum neeye.. daddyum neeye.. anbudane adharikum godum neeye
😂White rice velachami
😂Mummy...vaade
😂Enga...marka... marka...sollu
😂Adanga Gurkavuku porandhavane
😂Anjalai.. 5 leaves..

Saturday 22 February 2020

Small cap rescuers


Last year, major investments of LIC casted a huge sent on its investment portfolio.

Yet some small caps did wonder to save the face of LIC. Let's have a look of those north stars

1.OMDC

2. Welspun corporation

3.Granules India

4. Midhani

5. Garden reach shipbuilders

6. Birla corporation

7. Wanbury

8. Shipping corporation of India

9. RITES

Shining says K. Balasubramanian, Head of Corporate Banking, Citibank- 14.02.20


Takeaways

1. Canada, Middle East, Singapore, Japan pose a solid faith on Indian market and are credible investors

2. China + 1

Global manufacturing companies are looking for alternate investment option apart from China in the Asian region. 

They are cautious about putting all the eggs in one basket called China

3. Telecom companies, Electrical and electronic companies will see investments on account of this China + 1 strategy.

4. Because of the strong fundamentals Indian companies are welcomed and trusted more in the foreign debt markets

5. Domestic liquidity is improving.



Sunday 12 January 2020

Is SSY Your Sole Option?


SIP-s are better investment products in long term horizon, since they give good return in the long term more than in the short term. 

Don't deprive yourself the benefit of extraordinary returns by putting all your money into SSY


A Succint Recipe!!!

Guide to Mutual Fund Investment


Sectors dominating the Portfolios

1. Private banks
2. IT
3.Refinery
4. Pharma
5. NBC

Popular stocks

1.HDFC
2.ICICI
3. Reliance industries

ULIP


Investor's power to customise the portfolio composition in accordance with market scenario is an advantage with this option. 

Wider options according to the needs of investords such as liquidity, return, value etc... is another positive feature of this option

NPS- Perhaps, Your Cup of (Special) Tea


For those who look to push the 150,000 tax deduction limit through investments, NPS is a good option, as it offers an additional deduction of 50,000 apart from the regular 80C investments. 

But, beware it's a long term option. No withdrawal upto 60 Years (Unless you meet the special conditions laid) 

The investment portfolio is a combo of equity and debtand so the investors could this as a safe bet

Counting on ELSS ??!!!


Take-away

Given that the volatile equity market  is on the cards for year 2020, it is good remains wary of this investment option despite the fact ELSS posted a commendable show in the recent past

Wednesday 8 January 2020

Rahul Singh Interview to ET dt. 08.01.20


Take-away

1. Real estate and NBFC-s are not safe bets now. 

2.Strategy Suggested

%
10        - Small caps
20        - Mid caps
20-25  - Value
Rest    - Multicap and large-cap


3. Mid-caps not likely to underperform Large-caps

4. GDP growth came down in 2 phases. 
  
A. Demonetization
B. Risk aversion and Funding squeeze