FinPy

  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...