Investment Banking Nerd

Hello Everyone ! I started learning Python the coding language in June 2025 and here are the following code that I leaned. My First Code :  print("Hello World") It was amazing, I haven't dowloaded Python, I'm doing this on online python.com  it is amazing without much hustle.  Then I learned :  If condition Basically if 5 is less than 6 it will print this but if I put 7 it will not.  Then :  Define Function that is "def" It was easy but I still don't understand the f before Hello.  Then this :  print("challenge 1") # Message for the user message = "This is the message" note = "please proceed" print(message) # perform math result = 2*3 print(result) print("challenge complete") And got the result  Challenge 1  This is the message  6 Challenge Complete Then Class function :  class puppy():     def __init__(self, name, favourite_toy):         self.name = name          self.fav...

COUNT :  Counts the number of cells within a range that contains number .  COUNTA :  Counts the number of cells within a range that don't contains number .  COUNTIF :  Count things that satisfy one or more conditions . That is select the range, then write the criteria and we are good to go. COUNTIFS :  Count things that satisfy one or more conditions and criteria . That is select the range, then write the criteria, repeat then again as many times as you want and we are good to go. --------------------------------------------------------------------------------- Learn THE Most important excel tips to be a pro : Click Click !! ------------------------------------------------------------------------------------------- AVERAGE :  Simply having a average of the selected range of a row or coloumn.  AVERAGEIF :  It's a average of numbers which satisfy a certian criteria, select the range, write the criteria and then select the numbers whose range i...

1. How to create dynamic names in Excel? What if I want to write P&L : Company name and when I change the company name the P&L : remains same but th company name changes ? This is required because we use a single model for many companies and situation so rather than manually doing this everytime, why not create a automatic formula.  The formula is ="P&L:"&"cell reference of the company name". 2. What are the Custom formatting means ? 1. Positive Numbers  2. Negative Numbers  3. How to display 0s 4. How to display text  For example : # #; [Red](# #); - So in this what will happen the positive number will be having space in thousands, then the second which we separated by ";" will show in red and brackets with space in thousands, then the third in place of 0 "-" will show and for the last we left it as nothing because we were working on numbers.  3. Creating a Dropdown or List in excel ! Creating a dropdown is easy just go on Data t...

Half Mapped  What's better than understanding the real concepts of Financial Modelling from someone who has actual real time experience. Blog Dedicated to Ritik Prasad , thanks for teaching this.  Concept 1 Can you find out the Repayment amount ?  The first thing I learned is you have to create a system rather than just a working financials which needs to be manually changed by going on different cells. To do that we have to create a system of things here's the Example :  So the Given data as a excercise was that we have a Loan of ₹ 500 and Interest of 10% where we have to repay ₹ 40 per year , as calculated 500/40=12.5, and moratorium is of 2 years.  But we will calculate first without moratorium.  After the 2nd year I have just dragged the formula, if you have question why I have taken 15 yrs ? Because 12.5 yrs was coming as per my calculation above + 2yrs of Moratorium comes 14.5 = ~15.  Now with Moratorium :  Calculation :  I have dragge...

I want to start learing Python for Data Science and AI experiment.   Resources :  1.  Jupyter  2. Colab Right know I'm starting with these two platforms.  Special thanks to Thu Vu a youtuber to help me begin thru her videos. How to start ?  Learning Python Basics Basic Packages Remember to check Code Crafter Why I want to learn this language, what's my benefit ?

I'm learning this from youtube videos. Two methods of taking forecast :  1. Through Formula  In this we use =forecast(Xs,knownYs,knowYs) Eg : In this we will already had data till 2024, we had put in the formula =forecast(2025,Revenue (2019:2024), Year (2019:2024)) 2. Forecast on the Data Tab ! We have taken the same data as the 1st formula ! These are for one line data and provide very accurate answers, but for more and better data one need to understand the technicality of growth and it's rate. 

AI is no less than an extended arm to my daily work, although the sensitive information always need to be covered up and not disclosed.  My No. 1 AI is :  A. NoteBookLM  It's a Google Product and gives you very accurate answer by reading the Web Link and PDF as source to it. Even you can go and recheck the answer by sources and it specifically mark it for you.  It helps a lot specifically for Rules and Regulations that are 200-500 pgs long and it take a lot of effort to do it all together by yourself.  It almost cut short time by half.  B. ChatGPT  It is very common but very few of us understand how to use it ? The chatGPT works with very clear goals defined and the reason you need the result and then provide a good resource to it if  possible and it will give you really perfect answer.  My tip is that always make GPT remember your last conversation in the same context and it will give you more better result.  C. Perplexity  It is i...

Unmapped  Energy Core Area of Work (28/02/25) India  National Power Portal :  It will Provide day to day, month to month and years of report on Installed Capacity and Generation, whether that state has achieved the target which was set or not.  Yes Solar is not very much highlighted and is difficult to find, but hydro, thermal and RES is well Defined.  Central Electricity Authority :  The Reports are old but it will help a lot for yearly data rather than the latest.  The Dashboard is yet another best thing to understand the data. Vidyut PRAVAH : For daily demand and price of electricity in different states of India, and it's per unit price.  Global Global Energy Monitor :  It's Google sheet and easy to track, it's basically a overview not detailed perpective. But it really helps when you are working on different countries. 

Mapped Equity Research for a Private Company which is unlisted requires following beginning steps to understand and move on to the NEXT Steps ! 1. Deep Understanding of  the Sector which majorily requires the Product and Services offered  2. Parent Company and the origin  3. Financials & Clients list  4. The Projects or Work currenlty being executed ; with future plans & start of its execution. How will the above four points will help you to almost execute the whole research and Complete you Mandate ? Step 1. Deep Understanding of the Sector ! The Valuation of the Private Co. for Equity research is done through Market Comparable of the company in the sector providing the same product and services while having it's Revenue and PAT nearby to the Private Co. we are doing research for. How will you do the Market Comparable ?  If you are LAZY !! Then just take the P/E of the 5 most matching company as explained above and average the P/E in excel the formu...

Do's and Don't of Networking  Do's  1. Send greetings "Hi Sir, How are you" and have a constant contact with them until you get referrence.  2. Regularly post something, that is written by you and not by AI 3.  Don't 1. Don't ignore anyone's message just because they are not of your use right now !!