FinPy

 Sectoral Analysis || FMCG Sector || Report Economic Overview Fast Moving Consumer Goods sector is one of the fastest-growing sectors in the Indian economy. The FMCG sector is the fourth largest sector in India with household and personal care accounting for 50% of FMCG sales in India. The urban sector contributes about 55% of the total revenue generated by the FMCG sector. However, in the last few years, the trend has changed. FMCG has grown faster in rural areas as compared to urban areas. In India, the retail market is estimated to reach US$1.1 Trillion by 2020 from US$840 Billion in 2017 with trade expected to grow at 20.25% per annum, which will boost the revenue of FMCG company’s risers in rural consumption will drive the growth in the FMCG sector. It contributes about 36% to the overall FMCG spending.  This sector is stiffly influenced by multinational companies’ existence and a strong distribution channel. The trend for this sector is also changing as these products ar...

 I have completed this DCF Model for the company listed on the DAX index Bayerische Motoren Werke Aktiengesellschaft (BMW). The market risk premium in Germany at that point of time was 5.70% which is 5.80% at present. The yearly risk-free rate in Germany at that time was 1.10% which is 0.6% at present according to Statista The formula for calculating Free Cash Flow (FCF) : FCF = EBIT*(1-Tax Rate) + Depreciation & Amortization - Net Capex - Increase in Working Captial Here you can download the DCF Model  - DCF Model BMW.xlsx

  A 3 statement model is a complex financial model which combines the three critical  financial statements  like  income statement ,  balance sheet , and  cash flow statement  and integrates all the three into a single financial model. This model acts as the base for further critical models like  DCF valuation , merger and acquisition models, etc. It is also used for scenario and  sensitivity analysis .  Here I have built a 3 statement integrated financial model from scratch using the Income statement and Balance sheet of a company. Here is the link to the Excel file for the Integrated 3 statement financial model.  Integrated 3 Statement Financial Model.xlsx

(Description)   I am a student of B.com H Financial Markets (BSE) and in my academics, I’ve been taught how to invest in stock markets and analysis. I’m a third-year student and by the time I have a good knowledge of stocks and Mutual funds. Me and one of my friends have decided to invest some of our funds in the market but we don’t want an existing portfolio to invest in instead, we want to create our own portfolio and do the same, for we have decided that I will do all the analysis stuff and he will allocate the funds. I am using Python for the analysis part. How I did the analysis and stock selection will be described in this document.          I have to create my own portfolio so for that I have to select some stocks and I’m going to select only large cap stocks because large cap stocks are stable and mature investments, large cap stocks have lower volatility, greater analyst coverage, and perhaps a steady dividend stream.   I have selected stock...