-
Generation Performance Dashboard

⚡ Power Generation Performance Dashboard

Popular posts from this blog

How to do Forecasting of Financials ?

-
Image
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. 
Read more

Interview Question : My Finance Interview Prep

-
Image
My Interview Preparation for Analyst (Finance)  1. Tell me about yourself What's need to covered ? The three points theory : A. A basic about your current work experince, just a slight role and organization. As I have less than 2 years of experince I need to emphasis more on my education and achivements related to that. But someone with more than 2 years of experince should emphasis more on experince and less on education.  B. Highlighting Key Skills & Experince :  Do remember what's a interviewer listens in you answer, he makes a lot of questions out of that rather than having a pre occupied mind ! Highlight the skills and experience relevant to your Job Description for which you are giving interview.  C. Connecting with the Role and Responsibilities  The more we are relevant when we tell about ourselves and it's connect with the role, we are applying for, the more we prove our relevance to the interviewer.  What would I answer ?  " Sure, I'm b...
Read more

How to Forecast 5 year Income Statement

-
Image
Let's take the assumption as :  Forecast period: 5 years YoY Revenue Growth: 10% COGS % Revenue: starting at 77%, assume declining margin to 76% SG&A % Revenue: starting at 16.5%, assume declining margin to 16% Depreciation: $787 million for 2022 and then held constant at 1.5% of revenue in each subsequent year Amortization: $82 million for 2022 and then held constant at $100 million in each subsequent year Interest exp: $25 million for 2022 and held constant over projection period Tax rate: 20% This exercise will be really simple and I'm writing this blog for my own reference as a well defined Financial Model summary helps a lot to comeback and understand the formulas and step. So that you can identify mistakes in the new forecast model you are making.  I hope it helps you all in the same way it is helping me. Based on the assumptions we will make a Income Statement Driver portion.  Revenue growth rate is already given at 10% so we will take that for constant for eac...
Read more

Cold Mails

-
Image
For Research Analyst Position  Master Mail  Respected Sir, I want to touch base with you regarding work opportunities in your organization for me.  Three core skill sets of mine :  Energy Sector Expertise : Cumulative Project Size ~1GW in Debt, Equity and Financial Advisory (incl. Solar, Wind, Hybrid, Green Ammonia, Green Hydrogen and Waste to Energy) Finance Expertise : Deep Understanding and Analysis Capability of Financial Statements, Formulation of Investment Startegy and Financial Instruments (incl. Private Credit & InvIT) Microsoft Office, Design, and Web Development Proficiency : Expert skills in Word Documentation & Designing, Preparing, Designing and Animation of PPT & Basic Financial Modelling in Excel. (these also includes preparing Pitch Deck, Information Memorandum and Flyers in Canva too ) Whereas I have deep understanding of Website Designing and Management of Content. I look forward for your guidance and referral in your organization, I...
Read more

Most used formulas of Excel

-
Image
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...
Read more