Resources - Freshers Job Portal

    • Resources

    Here, I'll keep update this page with my own Reports, Analysis, presentations and financial models & Analysis. You can download the Integrated financial models, PowerPoint Presentations, Research Reports, etc. on this resource page. Please note that this is for educational purpose only. We are not charging anything from you for these resources. 


    You are free to use these resources in your studies for educational purpose only. If you are facing any difficulties and any suggestion then feel free to reach out to us at portalfresherjob@gmail.com


    Free Download Resources : 


    Sales Dashboard Excel File



    Interactive Sales Dashboard with using Microsoft Excel. Data Visualization is always fun for all. I have take this data from google and tried to prepare the Dashboard using Advance Excel Functions.
    During this learning, I got to know about Slicer Function, Pivot Tables, Data Visualization, Data Quality Assessment, etc.


    I would like to invite industry experts to review this work & let me know about your views for further improvements.


    Kotak Mahindra Bank Ltd- Concept of Investment - Presentation - 03 July 2021

    In this presentation, I've picked up Kotak Mahindra Bank to highlight their key elements in which investors must be interested to know.


    - Various type of Investors
    - Key Elements of Investors pitch
    - About Kotak Mahindra Bank
    - Market Position of Kotak Mahindra Bank
    - Financial Analysis ( Key Ratios)
    - How to Invest and important documents before investing

    This analysis has been done only for educational purpose. I would request industry experts to give their valuable feedback on the investment topic. 

    Author: Aayush Aggarwal

     

    Click below button to Download:  

      

    Hindalco Industries Financial Model

    Financial Modeling is a tool that operates on spreadsheets, preferably MS Excel. This tool is the best way to track an entity's revenue and expenditure over a period of time. It broadly refers to the various financial statements of an entity like Profit & Loss Statement, Balance Sheet, Income & Expenditure Statement, Cash Flow Statement, etc. 

    I'm very delighted to share with you all my first attempt at #financialmodelling on . I was doing research projects on Hindalco Industries for 6 months as a part of my PGDM program. So I thought of doing valuation of #Hindalco, as its stock price was looking overvalued, so to find out the true intrinsic value of the stock.

    Note: This model is only for academic purposes.
    Feedback and suggestions regarding the model will be highly appreciated.

    Hindalco Industries - Research Report Pdf 

    Here, I've prepared the complete research report on above financial model of Hindalco Industries Ltd.

    You just have to click on pdf download button and your report will be downloaded from there. 

    Happy Learning !!

     Pin on Quiz

    UltraTech Cement Ltd - Financial Analysis

    "Financial Statement Analysis - UltraTech Cement Ltd"

    It includes data from FY16 to FY20
    1. Balance Sheet
    2. Revenue Statement
    3. Ratio Analysis
    4. Interactive Charts Analysis

    - We all know Data Visualization is the need of hour today and we should at least know how to visualize the data in excel. Data Visualization helps us to prepare clear and easy-to-understand graphs. Please give your inputs on charts also.

    - The financial statements data taken from official annual reports only and summarized after that in presentable manner.

    Note: This analysis has been done only for educational purpose. I would request industry experts to give their valuable feedback on the same. 

     

    Research Report Presentation Video with PPT: 

    This is the final Research Report Presentation of both companies. For the last couple of months, I've been working upon two major companies i.e. Hindalco Industries Limited & Kotak Mahindra Bank for my research reports. Finally, I've summarized all three reports which I'd prepared in the last 6 months in my 1st Year of PGDM in this video presentation.

    - I've studied the effect of the change of WACC & Terminal Growth on the share Price and Enterprise Value of the company.
    - And their Ratio Analysis from FY2014 - FY2027 (Projected)

    - To study the customer behavior and preferences about banks.
    - To study the satisfaction level of customers for products & services provided by Kotak Mahindra Bank & other banks.

    Author: Aayush Aggarwal