Study of financial modelling in Excel, with reference to with Reference to Param Dairy Limited Company

Abstract

This project titled “Study of Financial Modelling in Excel with Reference to Param Dairy Limited” focuses on understanding how Excel-based financial tools are used in real business environments to enhance financial accuracy and decision-making. In today’s data-driven business world, financial modelling has become essential for analyzing performance, forecasting growth, and supporting strategic decisions. The objective of this project is to study the practical applications of Excel in financial analysis, specifically in transaction reconciliation, reporting, and performance evaluation at Param Dairy Limited. The project was planned and executed during my internship as a Finance Intern at Param Dairy Limited. The work involved collecting and analyzing data from various digital E- Commerce platforms. The tasks included reconciling net Profit and building structured Excel models, and preparing financial summaries using pivot tables and formulas. The project planning also included identifying key areas where financial modelling could improve accuracy and efficiency in the company’s financial reporting system. Data were gathered from company records, online transaction reports, and payout summaries, while the analysis was conducted using Excel-based techniques such as pivot tables, VLOOKUP, and conditional formulas. These tools helped in organizing large sets of transactional data, identifying discrepancies, and generating accurate reconciliations for financial reporting. Through this project, I learned the importance of data accuracy, structured financial analysis, and the role of Excel as a practical modelling tool in real business operations. It also helped me develop skills in problem-solving, time management, and data interpretation while working with real-time e-commerce financial data. The findings of the study reveal that Excel-based financial modelling significantly enhances the accuracy and efficiency of financial operations at Param Dairy Limited. It simplifies reconciliation processes, reduces manual errors, and provides management with timely insights for decision-making. The study also highlights that such models are not limited to forecasting iii or investment purposes but have great value in day-to-day financial control and reporting. In conclusion, the project demonstrates that Excel-based financial modelling is an effective tool for modern financial management, especially in companies dealing with high transaction volumes through online platforms. It supports better data-driven decisions, ensures transparency in financial records, and strengthens the overall operational and reporting efficiency of the organization. The study will follow a descriptive and analytical design. It will first describe the financial processes of Param Dairy Limited related to sales, returns, and payouts across e-commerce platforms, and then apply Excel-based financial modelling techniques to analyze, reconcile, and evaluate the accuracy and efficiency of these processes.