Financial Modeling and Analysis of 50 Flats Housing Project in Gurgaon, Haryana, India

Abstract

Project finance is the financial analysis of the complete life cycle of a project. Typically, a cost-benefit analysis is used to determine whether the economic benefits of a project are greater than the economic costs. An analysis is particularly important for long-term CAPEX growth projects. Project Finance was a completely new concept that I learned at this stage. I learned the difference between corporate finance and project finance. The internship's learning was immense, starting from the basic theoretical concepts of the first task to learn how to build a model in the 4th task. It gave a general understanding of the term project finance, both in theory and in practice. The initial understanding of how the financial model works, looking at Excel spreadsheets and then creating financial models on my own, helped me learn a lot that can be used in the future and in my professional career. It helped me to understand the basic terminologies, assumptions, and the financial projections on which the attractiveness of a project is decided. Financial modeling is used in various projects ranging from power generation to residential development projects. It helped in developing an understanding of the business models of various sectors. On completing the final task of the internship, the learnings are now well established in my mind. I can now understand the terms and calculations used in a financial model and develop one on my own. The report contains information about the company and the services offered by it. It also contains detailed analysis of the fianancial model which is the title of the project. The report contains an industry overview of the consulting industry. It also includes learnings and findings of the entire internship period and also the corporate skill development program which was part of the internship.